MICROSOFT EXCEL

You can quickly change the appearance of your work by choosing Auto Format from the ________ Menu.

• (A) Edit
• (B) View
• (C) Format
• (D) Tools

You can edit pressing the existing Excel data by:

• (A) F1 key
• (B) F2 key
• (C) F3 key
• (D) F4 key

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is:

• (A) G1-G10
• (B) B1.G10
• (C) B1:G10
• (D) B1;G10

A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

• (A) Go to File-Save As – Save As Type- Excel worksheet
• (B) Right click on the spreadsheet tab and select DELETE
• (C) Right click on the spreadsheet and select Insert – Entire Column
• (D) None of above

A function inside another function is called a _________ function.

• (A) Nested
• (B) Round
• (C) Sum
• (D) Text

To protect a worksheet, you can choose Protection and the Protect Sheet from the menu:

• (A) Edit
• (B) Format
• (C) Tools
• (D) Data

You can open the Highlight Changes dialog box by choosing Track Changes from the _________ Menu.

• (A) Edit
• (B) Insert
• (C) Format
• (D) Tools

Which of the following is not a worksheet design criterion?

• (A) Efficiency
• (B) Auditability
• (C) Description
• (D) Clarity

To copy cell contents using drag and drop, press the:

• (A) End key
• (B) Shift key
• (C) Esc key
• (D) None of these

If you press ________ the cell accepts your typing as its contents.

• (A) Enter
• (B) Ctrl + Enter
• (C) TAB
• (D) Insert