Chapter 6

Question 1

Microsoft Excel

Answer 1

Spreadsheet program that allows you to store organize and analyze information

Question 2

workbook

Answer 2

A collection of worksheets in a single file

Question 3

worksheet

Answer 3

A page in a workbook that consists of a grid of rows and columns in which you can enter text values and formulas and perform calculations

Question 4

absolute reference

Answer 4

A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet

Question 5

argument

Answer 5

The parameters of a function

Question 6

AutoSum

Answer 6

Command that allows you to automatically insert the most common functions into your formula

Question 7

AVERAGE

Answer 7

This function determines the average of the values included in the argument It calculates the sum of the cells and then divides that value by the number of cells in the argument

Question 8

cell reference

Answer 8

A reference that identifies a cell’s location in the worksheet based on its cell name - column letter and row number

Question 9

chart

Answer 9

A graphical representation of numeric data in a worksheet

Question 10

COUNT

Answer 10

This function counts the number of cells with numerical data in the argument

Question 11

fill handle

Answer 11

A small square in the lower right corner of a selected cell or range of cells used mainly to copy data to adjacent cells

Question 12

formula

Answer 12

An equation that performs calculations such as addition subtraction multiplication and division on values in a worksheet

Question 13

freeze

Answer 13

To prevent portions of a worksheet from scrolling on the screen

Question 14

function

Answer 14

Predefined formula that performs calculations using specific values in a particular order

Question 15

legend

Answer 15

An explanatory list that identifies the patterns or colors assigned to the data series or categories in a chart

Question 16

MAX

Answer 16

This function determines the highest cell value included in the argument

Question 17

MIN

Answer 17

This function determines the lowest cell value included in the argument

Question 18

Order of Operations

Answer 18

The order in which a formula will calculate Parentheses Exponents Multiplication and Division Addition and Subtraction

Question 19

relative reference

Answer 19

A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows or if you copy the formula to another cell

Question 20

sort range

Answer 20

Sorts the data in a range of cells

Question 21

sort sheet

Answer 21

Organizes all of the data in your worksheet by one column

Question 22

sort

Answer 22

Organize date in ascending or descending order

Question 23

SUM

Answer 23

This function adds all of the values of the cells in the argument