MS Office & Keyboard Shortcuts — Practice

Question 1

The default file extension of an MS Excel workbook is:
(a) .docx  (b) .xlsx  (c) .pptx  (d) .txt

Accepted Answer

.xlsx (older .xls).

Answer: (b) .xlsx.

Question 2

Ctrl + Z is used to:
(a) Redo  (b) Undo  (c) Save  (d) Select all

Accepted Answer

Ctrl+Z undoes the last action (Ctrl+Y redoes).

Answer: (b) Undo.

Question 3

In MS Excel, 'B5' refers to:
(a) Row B, column 5  (b) Column B, row 5  (c) Sheet B, cell 5  (d) Block 5

Accepted Answer

Column B, row 5 — reference is column letter then row number.

Answer: (b) Column B, row 5.

Question 4

Which application is primarily used to create presentations?
(a) MS Word  (b) MS Excel  (c) MS PowerPoint  (d) MS Access

Accepted Answer

MS PowerPoint creates slide presentations.

Answer: (c) MS PowerPoint.

Question 5

Which Excel entry totals the range A1 to A10?
(a) SUM(A1-A10)  (b) =SUM(A1:A10)  (c) =TOTAL(A1:A10)  (d) =ADD(A1,A10)

Accepted Answer

=SUM(A1:A10) — a formula starts with = and uses a colon for the range.

Answer: (b) =SUM(A1:A10).

Question 6

Which shortcut closes the currently active program?
(a) Ctrl+F4  (b) Alt+F4  (c) Ctrl+W  (d) Alt+Tab

Accepted Answer

Alt+F4 closes the active program.

Answer: (b) Alt+F4.

Practice — MS Office & Keyboard Shortcuts