Microsoft Excel Units 1-3 Test

Front

Which option in Backstage View contains the command to change the file type of a saved file? Options: Export, Info, New, Publish

Back

Export

Front

Which group on the Home tab contains the commands to insert, delete and format cell width and height? Options: Numbers, Styles, Cells, Editing

Back

Cells

Front

Which tab on the Ribbon contains the function library?

Back

Formulas

Front

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

Back

Page Break View

Front

Which keyboard shortcut hides selected columns in a worksheet? Options: Control H, Control 9, Control X, Control 0

Back

Control 0

Front

Which of the following is a relative cell reference? A1, B$1, $C1, $D$2

Back

A1

Front

Which of the following is a temporary storage area where all cut and copied items are stored? Formula Bar, Name Box, Clipboard, Workbook

Back

Clipboard

Front

Which group on the Home tab contains the command for changing the fill color of a cell? Options: File, Font, Alignment, Editing

Back

Font

Front

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

Back

Format Painter

Front

Which group on the Home tab contains the command to insert a worksheet? Options: Cells, Font, Alignment, Number

Back

Cells