Question 1

(TCO 5) When multiple worksheets are selected, the word _____ appears in the title bar.

• Select

• Group

• Set

• Cluster

Question 2

(TCO 5) If several worksheets are grouped and you enter a formula in cell A10 in one of the grouped sheets, _____.

• the same formula is entered into all grouped worksheets

• the formula changes by one row in each grouped worksheet

• the formula changes by one column in each grouped worksheet

• nothing happens to the other sheets

Question 3

(TCO 5) When two windows of the same workbook are opened, Excel adds _____ to the title bar of the second window.

• the letter B

• the number 2

• the letter A

• the number 1

Question 4

(TCO 5) In Excel, which of the following is not a method for splitting a worksheet?

• Drag a split box.

• Double-click a split box.

• Right-click in the active cell and click Split.

• Click Split in the Window group on the View tab.

Question 5

(TCO 5) Which of the following functions do not work with 3-D formulas?

• SUM

• VLOOKUP

• AVERAGE

• COUNT

Question 6

(TCO 5) Which formula would return the #NAME? error?

• =SUM(B6.B12)

• =MAX(B6:B12)

• =AVG(B6:B12)

• =IF(A6="Atlanta",A3,0)

Question 7

(TCO 5) If A1 contains the hourly pay rate of $10.25, A2 contains the hours worked (40), and A3 contains =A1*A2, which cell is the dependent cell(s)?

• A1

• A2

• A3

• A1 & A2

Question 8

(TCO 5) Information such as author, title, and keywords are examples of document _____.

• properties

• descriptions

• identifiers

• attributes

Question 9

(TCO 5) To delete a comment from a cell, you _____.

• double click the cell and select Delete Comment.

• right-click the cell and select Delete Comment.

• click in the comment and click Cut on the HOME tab.

• click in the comment and press Delete.

Question 10

(TCO 5) You would use the _____ command to indicate a workbook is complete and to make the file read only.

• Lock workbook

• Finalize workbook

• Mark as Final

• Mark as Completed

Question 11

(TCO 5) Which Excel options category contains editing options?

• General

• Advanced

• Formulas

• Trust Center

Question 12

(TCO 5) Where is the Share Workbook command located within Excel?

• Data tab

• Insert tab

• Review tab

• Formulas tab

Question 13

(TCO 5) Which feature is best suited to record edits made to a document over time?

• Track changes

• Compare and merge

• Comments

• Sharing

Question 14

(TCO 5) In Excel, what enables the user to create and maintain custom properties for the current workbook, such as Department, Project, and Purpose?

• General

• Summary

• Custom

• Contents

Question 15

(TCO 5) In Excel, what provides additional document details not provided in the property list?

• Properties dialg box

• Document Panel

• Automatic property

• Excel options