Deck 19: Creating Formulas and Charting Data

Question 1

In business, upper-level management relies on charts to look for trends and oddities.

Answer 1

True

Question 2

In a 3-D reference, length and width refer to the worksheet rows and columns.

Answer 2

True

Question 3

When a chart is created on the same sheet as the data used in the chart, it is embedded .

Answer 3

True

Question 4

The MAX function formula is the most frequently used type of function formula.

Question 5

Many parts of a chart are positioned on the chart in a text box.

Question 6

To create an absolute cell reference, you insert an equal sign (=) before the column letter and/or row number of the cell reference you want to stay the same.

Question 7

Excel has more than 300 built-in formulas for performing calculations.

Question 8

Generally, values are used in formulas rather than cell references.

Question 9

Formulas containing more than one operator are called ____.

A) mixed cell references
B) complex formulas
C) absolute cell references
D) relative cell references

Question 10

Computers evaluate and assess worksheet values.

Question 11

When you edit the data in a worksheet, you must edit the data in the chart as well.

Question 12

Mathematical functions perform calculations that you could perform using a scientific calculator.

Question 13

The operator is a number or cell reference.

Question 14

A + (plus sign) is an example of an operator.

Question 15

By default, when you create formulas, the cell references are formatted as ____.

A) absolute cell references
B) mixed cell references
C) relative cell references
D) complex cell references

Question 16

AVERAGE is a statistical function.

Question 17

The operator for performing multiplication is the ____.

A) + (plus sign)
B) * (asterisk)
C) - (minus sign)
D) / (forward slash)

Question 18

A formula consists of two components: an operand and an operator.

Question 19

All Excel formulas begin with ____.

A) $
B) /
C) SUM
D) =

Question 20

The sequence used to calculate the value of a formula is called the ____.

A) cell reference
B) operand
C) order of evaluation
D) operator

Question 21

A ____ is used to separate cell references that are not adjacent.

A) colon
B) comma
C) period
D) asterisk

Question 22

FIGURE 19-1 What is the arrow pointing to in Figure 19-1 above?

A) Change Chart Type button
B) More button
C) Excel Help button
D) Error Checking button

Question 23

Case 19-2 Pablo works as an assistant at a local art gallery. He is completing a worksheet that shows sales for the previous year. Now he wants to create a chart to represent the data. Pablo decides a bar chart would illustrate the data more effectively. Which button will enable him to choose a new chart?

A) Move Charts
B) Legend
C) Data Labels
D) Change Chart Type

Question 24

A ____ is a graphic representation of your worksheet data.

A) legend
B) formula
C) function
D) chart

Question 25

____ is a mathematical function.

A) SUM
B) AVERAGE
C) MAX
D) MIN

Question 26

The formula =$A1 is an example of a(n) ____ cell reference.

A) relative
B) absolute
C) mixed
D) statistical

Question 27

A(n) ____ is a special formula that names a function instead of using operators to calculate a result.

A) argument
B) range
C) complex formula
D) function formula

Question 28

Which formula will produce a result of 48?

A) =8+4*4
B) =8*4+4
C) =(8+4)*4
D) =8/4-4

Question 29

____ are often used in summary worksheets to condense and total data from other worksheets.

A) Mixed cell references
B) Absolute cell references
C) 3-D references
D) Relative cell references

Question 30

Case 19-1 Macy is the treasurer for a professional organization, and she is compiling the financial data to present to the board members at the next meeting. Macy wants to show the organization's total dollar amount of dues collected in the cells B2 to B40. Which is the correct formula?

A) =COUNT(B2:B40)
B) =SUM(B2,B40)
C) =SUM(B2:B40)
D) =TOTAL(B2:B40)

Question 31

Case 19-2 Pablo works as an assistant at a local art gallery. He is completing a worksheet that shows sales for the previous year. Now he wants to create a chart to represent the data. Pablo wants to use only part of the data in a column chart. What should he do first?

A) Click the Column button
B) Select the data he wants to use in the chart
C) Click the Insert tab
D) Select all the data in the worksheet

Question 32

Which type of cell reference adjusts automatically when copied to another cell?

A) Relative
B) Mixed
C) Absolute
D) Complex

Question 33

If you input an incorrect formula, or if you input invalid data, the formula produces a false result--often referred to as ____.

A) an error
B) Garbage In, Garbage Out
C) a killer app
D) an argument

Question 34

A shortcut for entering cell references is to ____.

A) enter all the cell references
B) name a range of cells
C) enter a formula
D) enter the function name

Question 35

FIGURE 19-2 Which part of the function formula shown in Figure 19-2 above is the argument?

A) Equal sign (=)
B) SUM
C) (B4:B8)
D) SUM(B4:B8)

Question 36

____ are computer programs that are so necessary or desirable that they prove the core value of some larger technology, and as a result, they substantially increase the sales of the platform that they run on.

A) Windows
B) Killer apps
C) Platform computers
D) Graphical User Interfaces

Question 37

To resize a chart proportionally, drag a ____ handle.

A) corner
B) top center
C) side
D) bottom center

Question 38

Case 19-1 Macy is the treasurer for a professional organization, and she is compiling the financial data to present to the board members at the next meeting. Macy sees the error #NULL! in a cell of her worksheet. What is likely the problem?

A) The column is not wide enough
B) Negative data is entered
C) The wrong type of argument or operand is used
D) A space is used where it isn't appropriate

Question 39

The equation used to calculate values in a cell is known as a ____________________.

Question 40

Which of the following chart types does not have a horizontal and a vertical axis?

A) pie
B) column
C) bar
D) line

Question 42

A(n) ____________________ cell reference does not change when the formula is copied or moved to a new location.

Question 43

Give an example of a mathematical and a statistical function. Explain the difference between mathematical and statistical functions.

Question 44

The ____________________ is a value, a cell reference, a range, or text that acts as an operand in a function formula, and it is enclosed in parentheses after the function name.

Question 45

The 3-D reference enables you to access data from three different dimensions in the workbook: length, width, and ____________________.

Question 46

You can change the order of evaluation by using ____________________.