Microsoft Excel Units 1-3 Test

Which of the following options in Backstage View contains the command to change the file type of a saved file?

• Export

• Info

• New

• Publish

Which of the following groups on the Home tab contains the commands to insert, delete and format cell width and height?

• Numbers

• Styles

• Cells

• Editing

Which tab on the Ribbon contains the function library?

• Home

• Insert

• Page Layout

• Formulas

Which view should be used if you want to see where page breaks will occur in a worksheet?

• Normal View

• Page Break View

• Page Layout View

• Synchronous View

Which of the following keyboard shortcuts should be pressed to hide the columns which are selected in a worksheet?

• Control H

• Control 9

• Control X

• Control 0

Which of the following is a relative cell reference?

• A1

• B$1

• $C1

• $D$2

Which of the following is a temporary storage area where all cut and copied items are stored?

• Formula Bar

• Name Box

• Clipboard

• Workbook

Which group on the Home tab contains the command for changing the fill color of a cell?

• File

• Font

• Alignment

• Editing

Joe wants to copy the formatting of cells A1 through C1 in his workbook to use in another location. Which of the following commands should he use?

• Cut Painter

• Copy Painter

• Paste Painter

• Format Painter

Which of the following groups on the Home tab contains the command to insert a worksheet?

• Cells

• Font

• Alignment

• Number