Excel Flashcards by Quoc Nguyen

Q

Alt WFE

A

Sáng hàng và cột

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Alt +=

A

Tính tổng

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Alt hma

A

Gộp ô

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Alt hoa

A

Căn chỉnh hành nhanh

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Alt hoi

A

Canh chỉnh cột nhanh

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Alt AT

A

Tại nhanh bộ lọc

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Alt am

A

Xóa dữ liệu trùng lặp

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl +

A

– Ngày hiện tại

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + Shift +

A

– Giờ hiện tại

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Alt + Enter – Xuống dòng trong ô

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + Shift + “+” – Thêm hàng/cột

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + “-“ – Xóa hàng/cột

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + E – Flash Fill

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + Shift + “~” – Định dạng General

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + Shift + ! – Định dạng Number

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + Shift + % – Định dạng %

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + Shift + ^ – Định dạng Exponential

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + Shift + @ – Định dạng giờ

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + Shift + & – Tạo viền

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ctrl + Shift + _ – Xóa viền

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Alt + H + M + C – Merge & Center

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Alt + H + M + U – Unmerge

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Alt + = – Tạo hàm SUM

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

F2 – Sửa công thức

A

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Ctrl + ` – Hiện công thức

F4 – Cố định tham chiếu

Shift + F3 – Insert Function

Ctrl + Shift + A – Chèn tham số hàm

Ctrl + [ – Nhảy đến ô được tham chiếu

Ctrl + ] – Xem ô nào tham chiếu đến ô hiện tại

Ctrl + Alt + F9 – Tính lại toàn bộ workbook

F9 – Tính toàn bộ

Shift + F9 – Tính sheet hiện tại

Ctrl + ' – Copy công thức từ ô trên

Ctrl + Shift + ' – Copy giá trị ô trên

Ctrl + Shift + U – Mở/thu công thức

Ctrl + Shift + L – Bật/Tắt Filter

Alt + Down – Mở menu lọc

Alt + A + S + S – Sort A→Z

Alt + A + S + D – Sort Z→A

Alt + A + M – Remove Duplicates

Alt + A + Q – Flash Fill

Alt + A + F – Advanced Filter

Alt + A + E – Text to Columns

Alt + D + L – Data Validation

Alt + A + G – Group

Alt + Shift + → – Group nhanh

Alt + Shift + ← – Ungroup

Alt + N + V – PivotTable

Alt + J + T + I – Refresh Table

Ctrl + 0 – Ẩn cột

Ctrl + 9 – Ẩn hàng

Ctrl + Shift + 0 – Hiện cột

Ctrl + Shift + 9 – Hiện hàng

Alt + H + O + I – Autofit Column

Alt + H + O + A – Autofit Row

Alt + H + O + W – Set Column Width

Alt + H + O + H – Set Row Height

Ctrl + N – Tạo file mới

Ctrl + O – Mở file

Ctrl + S – Lưu

F12 – Save As

Ctrl + Page Up – Sheet trái

Ctrl + Page Down – Sheet phải

Shift + F11 – Tạo sheet mới

Alt + W + F + F – Freeze Panes

Alt + W + F + R – Freeze Top Row

Alt + W + F + C – Freeze First Column

Alt + W + L – Đổi giao diện xem sheet