Duplicate of Excel Lesson 7, 8, and 9 Definitions

Question 1

Using the table name or a table column header in a formula to refer to data in the entire table

Accepted Answer

Structure references

Question 2

Cell address that can change in a copied formula, in relation to cell containing the formula.

Accepted Answer

Relative Reference

Question 3

To use a function as an argument within another function.

Accepted Answer

Nest

Question 4

The command used to place data from the Clipboard to a location on the worksheet.

Accepted Answer

Paste

Question 5

Data arranged in columns and specially formatted with column headers that contain commands

Accepted Answer

Excel table

Question 6

The command used to remove data from a cell or range of cells and place it on the Clipboard.

Accepted Answer

Cut

Question 7

Arrange rows in a table or list of data in a new order according to entries in one/more columns

Accepted Answer

Sort

Question 8

A built-in function calculation used to add a range of values together.

Accepted Answer

SUM Function

Question 9

A method used to rearrange data by switching the positions of columns and rows.

Accepted Answer

Transpose

Question 10

Structured reference to a table column: consists of table column header name in brackets.

Accepted Answer

Column specifer

Question 11

A command that enable s you to display the formulas in a worksheet so that you can check them.

Accepted Answer

Show Formula

Question 12

An instrument Excel uses to calculate a result.

Accepted Answer

Formula

Question 13

The values & other inputs that a function uses to calculate the result.

Accepted Answer

Arguement

Question 14

A value, some text, or expression that defines the type of content you want to see.

Accepted Answer

Criterion

Question 15

A feature that speeds up the manual entry of functions.

Accepted Answer

Formula AutoComplete

Question 16

A predefined formula that performs a specific calculation using the inputs you specify.

Accepted Answer

Function

Question 17

Symbols used in mathematical operations.

Accepted Answer

Arithmetic (mathematical) operators

Question 18

A tool that enables you to copy formatting from a cell and apply it to another cell or range.

Accepted Answer

Format Painter

Question 19

A feature that holds data or graphics you cut or copy prior to pasting to another location.

Accepted Answer

Clipboard

Question 20

Hide nonmatching rows in a table/list of data according to criteria you specify.

Accepted Answer

Filter

Question 21

Adjust the size proportionately.

Accepted Answer

Scale

Question 22

A row you display below a table to calculate data in the columns above using a function chosen

Accepted Answer

Total Row

Question 23

Position for displaying and printing text horizontally across the shorter side of a page.

Accepted Answer

Orientation

Question 24

A cell address in a formula that won't change when you copy the formula to another location.

Accepted Answer

Absolute Reference

Question 25

The order in which Excel performs the mathematical operations specific in a formula.

Accepted Answer

Order of precedence

Question 26

Temporarily performs the following calculations on a range of cells without entering a formula

Accepted Answer

AutoCalculate

Question 27

Rows and column labels that reprint on each page of a printout.

Accepted Answer

Print titles

Question 28

The command used to place a copy of data from the selected cell or range on the Clipboard.

Accepted Answer

Copy

Question 29

The name given to one of Excel's predefined formulas.

Accepted Answer

Function Name

Question 30

Move contents of range of cells by dragging the selection and dropping in another location.

Accepted Answer

Drag-and-drop

Question 31

Combination of cell color, border, shading, and other formatting attributes applied to a table

Accepted Answer

Table Style

Question 32

The shading of alternating rows or columns to make a table easier to read.

Accepted Answer

Banded rows or columns

Duplicate of Excel Lesson 7, 8, and 9 Definitions

Questions 32

Duplicate of Excel Lesson 7, 8, and 9 Definitions

Questions 32