Excel Exam 1-8

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: Number, 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 7, Control 8, Control 9, Control 0

Back

Control 0

Front

Back

A1

Front

Which of the following is displayed in the image? Options: Pick from List, Flash Fill, Auto Fill, AutoComplete

Back

Auto Fill

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