Excel

Question 1

A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the merged cell:

Answer 1

Merge and Center

Question 2

An element in the Excel window that displays the value or formula contained in the active cell is the:

Answer 2

Formula Bar

Question 3

An element of the Excel window that displays the name of the selected cell, table, chart, or object is the:

Answer 3

Name Box

Question 4

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:

Answer 4

Select All Box

Question 5

A cell surrounded by a black border and ready to receive data is the:

Answer 5

Active Cell

Question 6

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is:

Answer 6

Auto Fill

Question 7

The default format that Excel applies to numbers is the:

Answer 7

General Format

Question 8

The data that displays in the Formula Bar is referred to as the:

Answer 8

Underlying Value

Question 9

The type of cell reference that refers to cells by their fixed position in a worksheet

Answer 9

Absolute

Question 10

Tiny charts embedded in a cell that give a visual trend summary alongside your data are:

Answer 10

Sparklines

Question 11

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:

Answer 11

Auto Fit

Question 12

The symbols with which you can specify the type of calculation you want to perform in an Excel formula are

Answer 12

Operators

Question 13

A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas is called:

Answer 13

Quick Analysis Tool

Question 14

The area along the bottom of a chart that identifies the categories of data is the:

Answer 14

Category Axis

Question 15

A feature that outlines cells in color to indicate which cells are used in a formula is called:

Answer 15

Range Finder

Question 16

A shaded bar that provides a visual cue about the value of a cell relative to other cells is a:

Answer 16

Data Bar

Question 17

The function that retrieves and then displays the date and time from your computer is the:

Answer 17

NOW Function

Question 18

The process of moving within a worksheet or workbook:

Answer 18

Navigate

Question 19

A series of rows and columns that contains related data and that is managed independently from other data is an Excel:

Answer 19

Table

Question 20

The process of arranging data in a specific order based on the value in each field is called:

Answer 20

Sorting

Question 21

The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called:

Answer 21

Filtering

Question 22

The Excel command that enables you to specify rows and columns to repeat on each printed page is:

Answer 22

Print Titles

Question 23

The labels along the lower border of the workbook window that identify each worksheet are the:

Answer 23

Sheet Tabs

Question 24

A worksheet where totals from other worksheets are displayed and summarized is a:

Answer 24

Summary Sheet

Question 25

The worksheets that contain the details of the information summarized on a summary sheet are called

Answer 25

Detail Sheets

Question 26

The action of placing cell contents that have been copied or moved to the Clipboard into another location is called:

Answer 26

Paste

Question 27

The Excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output is:

Answer 27

Flash Fill

Question 28

The values that an Excel function uses to perform calculations or operations are the:

Answer 28

Arguments

Question 29

The target destination for data that has been cut or copied using the Office Clipboard is the:

Answer 29

Paste Area

Question 30

The term used to describe an Excel function that is subject to change each time the workbook is opened is called:

Answer 30

Volatile