You can quickly change the appearance of your work by choosing Auto Format from the ________ Menu.
- (A) Edit
- (B) View
- (C) Format
- (D) Tools
- (C) Format
You can edit pressing the existing Excel data by:
- (A) F1 key
- (B) F2 key
- (C) F3 key
- (D) F4 key
- (B) F2 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
- (C) 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
- (B) Right click on the spreadsheet tab and select DELETE
A function inside another function is called a _________ function.
- (A) Nested
- (B) Round
- (C) Sum
- (D) Text
- (A) Nested
To protect a worksheet, you can choose Protection and the Protect Sheet from the menu:
- (A) Edit
- (B) Format
- (C) Tools
- (D) Data
- (C) Tools
You can open the Highlight Changes dialog box by choosing Track Changes from the _________ Menu.
- (A) Edit
- (B) Insert
- (C) Format
- (D) Tools
- (D) Tools
Which of the following is not a worksheet design criterion?
- (A) Efficiency
- (B) Auditability
- (C) Description
- (D) Clarity
- (C) Description
To copy cell contents using drag and drop, press the:
- (A) End key
- (B) Shift key
- (C) Esc key
- (D) None of these
- (D) None of these
If you press ________ the cell accepts your typing as its contents.
- (A) Enter
- (B) Ctrl + Enter
- (C) TAB
- (D) Insert
- (A) Enter