Excel Exam Flashcards Preview

Computer Applications > Excel Exam > Flashcards

Flashcards in Excel Exam Deck (30)
Loading flashcards...
0

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

Ribbon

1

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

Formula bar

2

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

Thin black cross, fill hanger

3

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

=C6/C12

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.

Pointing method

5

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

Argument

6

The AutoSum button is located
In this group on the HOME tab.

Editing group

7

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

Correct the range of cells that you want to add.

8

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

Paste option button.

9

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

Proof formula

10

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

Accounting number format

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.

Custom sort

12

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

F1

13

Display this backstage area to change the page orientation.

Print

14

This keyboard command displays formulas in a worksheet.

Ctrl+'

15

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

Go To

16

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

Clear button

17

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

12

18

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

F

19

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

Autofit

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.

Live preview

21

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

General

22

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

Middle align

23

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

Format painter

24

This feature stores predefined format options.

Cell styles

25

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

Themes

26

Make this cell active to freeze rows 1 through 5.

A5

27

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

Zoom slider
Zoom dialog box

28

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

Insert
Online pictures

29

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

Pictures