Excel Exam

Question 0

This area displays the formula stored within the cell (not the result).

Answer 0

Formula bar

Question 1

This area contains commands and buttons for performing actions divided into tabs and groups.

Answer 1

Ribbon

Question 2

The cell pointer changes to this when pointing at the small green square in the bottom right corner of the active cell.

Answer 2

Thin black cross, fill hanger

Question 3

This would be the formula entry to divide the contents of cell C6 by the contents in cell C12.

Answer 3

=C6/C12

Question 4

This is the term for the method used to create a formula by typing the equals sign and operator symbol while clicking reference cells between the typed symbol.

Answer 4

Pointing method

Question 5

This term is used to refer to the values identified within parentheses in the SUM function.

Answer 5

Argument

Question 6

The AutoSum button is located

In this group on the HOME tab.

Answer 6

Editing group

Question 7

Do this action if Excel suggests the wring range after you click the AutoSum button.

Answer 7

Correct the range of cells that you want to add.

Question 8

This button appears after copied cells are pasted into the destination range.

Answer 8

Paste option button.

Question 9

This is the term for the formulas entered beside or below a worksheet that are designed to verify the worksheet’s accuracy.

Answer 9

Proof formula

Question 10

This format adds a dollar sign, a comma in the thousands place, and two decimal places to each value in the selected range.

Answer 10

Accounting number format

Question 11

Click the Sort & filter button in the Editing group on the HOME tab and then click this option at the drop-down list to display the Sort dialog box.

Answer 11

Custom sort

Question 12

This keyboard shortcut will open the Excel Help window when pointing to a button.

Answer 12

F1

Question 13

Display this backstage area to change the page orientation.

Answer 13

Print

Question 14

This keyboard command displays formulas in a worksheet.

Answer 14

Ctrl+’

Question 15

Open this dialog box to type a cell reference to which you want to move the active cell.

Answer 15

Go To

Question 16

Use this feature to remove everything from a cell including text and formats.

Answer 16

Clear button

Question 17

Make a cell active anywhere in this row to insert a new row between 11 & 12.

Answer 17

12

Question 18

Make a cell active anywhere in this column to insert a new column between E & F.

Answer 18

F

Question 19

This is the term for adjusting a column width to the length of the longest entry.

Answer 19

Autofit

Question 20

This term refers to the feature that shows the result of a format option while pointing to the option in a drop-down gallery.

Answer 20

Live preview

Question 21

By default, cells Are initially set to this numerical style format.

Answer 21

General

Question 22

Clock this button in the Alignment group on the HOME tab to center cells vertically between the top and bottom cell boundaries.

Answer 22

Middle align

Question 23

Click this button in the Clipboard group on the HOME tab to copy the formats of the active cell.

Answer 23

Format painter

Question 24

This feature stores predefined format options.

Answer 24

Cell styles

Question 25

This feature stores a set of colors, fonts, and effects that can be applied to the entire worksheet.

Answer 25

Themes

Question 26

Make this cell active to freeze rows 1 through 5.

Answer 26

A5

Question 27

List two methods for changing the zoom magnification to view more cells in the current window.

Answer 27

Zoom slider | Zoom dialog box

Question 28

Click this tab and button to search for clip art at Office.com.

Answer 28

Insert | Online pictures

Question 29

Click this button in the Illustrations group to insert an image stored in a folder.

Answer 29

Pictures