Question 1

A ____ is used to separate cell references that are not adjacent.
A) colon
B) comma
C) period
D) asterisk

Accepted Answer

A comma is used in Excel to separate non-adjacent cell references when creating a formula or function. For example, when summing the values in cells A1, C1, and E1, the formula would be =SUM(A1,C1,E1).

Question 2

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

Accepted Answer

The answer of FIGURE 19-1  What is the arrow...

Question 3

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

Accepted Answer

The button that Pablo needs to choose a new chart is "Change Chart Type". This button allows him to select a different chart type from the one currently displayed, including a bar chart, which he believes will be a more effective way to illustrate the data. The other buttons listed (Move Charts, Legend, Data Labels) do not relate to selecting a new chart type.

Question 4

A ____ is a graphic representation of your worksheet data.
A) legend
B) formula
C) function
D) chart

Accepted Answer

A chart is a graphic representation of data in a worksheet. It can help to visually identify trends and patterns in your data. A legend is a key that explains the symbols and colors used in the chart, but it is not the overall graphic representation of the data. A formula and function are not graphic representations of data, but rather calculations used to manipulate data.

Question 5

____ is a mathematical function.
A) SUM
B) AVERAGE
C) MAX
D) MIN

Accepted Answer

The answer of ____ is a mathematical function.
A) SUM
B) AVERAGE
C)...

Question 6

The formula =$A1 is an example of a(n) ____ cell reference.
A) relative
B) absolute
C) mixed
D) statistical

Accepted Answer

The answer of The formula =$A1 is an example of...

Question 7

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

Accepted Answer

A function formula is a naming convention for a formula that specifies a function. It specifies that one or more inputs automatically produce an output defined by the formula.

Question 8

Which formula will produce a result of 48?
A) =8+4*4
B) =8*4+4
C) =(8+4)*4
D) =8/4-4

Accepted Answer

Using the order of operations (PEMDAS), we first perform the calculation inside the parentheses, which gives us 12. Then we multiply 12 by 4 to get 48.

Question 9

____ 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

Accepted Answer

3-D references allow the user to collect data from multiple worksheets and consolidate it into one summary worksheet. This is often used for condensing and totaling data. Mixed, absolute, and relative cell references are not specifically related to summarizing data from multiple worksheets.

Question 10

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)

Accepted Answer

The correct formula to find the total dollar amount of dues collected is the SUM function, which adds up all the values in the specified range. Therefore, option C =SUM(B2:B40) is the correct formula.

Question 11

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

Accepted Answer

Pablo should select the data he wants to use in the chart first before clicking on the Column button or going to the Insert tab. This will ensure that only the desired data is represented in the chart. Selecting all the data in the worksheet or jumping straight to the chart type button or Insert tab could result in irrelevant or confusing data being included in the chart.

Question 12

Which type of cell reference adjusts automatically when copied to another cell?
A) Relative
B) Mixed
C) Absolute
D) Complex

Accepted Answer

Relative cell references adjust automatically when copied to another cell based on their relative position to the new cell. For example, if a formula uses the cell reference A1 and is copied to a cell two columns over to the right, the formula in the new cell will automatically adjust to use the cell reference C1 instead.

Question 13

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

Accepted Answer

The phrase "Garbage In, Garbage Out" (GIGO) refers to the concept that incorrect or poor quality input will produce faulty or nonsensical output.

Question 14

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

Accepted Answer

Naming a range of cells allows for an easy shortcut for entering cell references as the range can be referred to by a single name rather than typing out each cell reference individually.

Question 15

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)

Accepted Answer

The argument in this formula is the range of cells (B4:B8) that the SUM function is being applied to.

Question 16

____ 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

Accepted Answer

Killer apps are computer programs that are so valuable that they drive the sales of the platform they run on. Windows and graphical user interfaces are examples of platforms, but not killer apps themselves. Platform computers are not a commonly used term.

Question 17

To resize a chart proportionally, drag a ____ handle.
A) corner
B) top center
C) side
D) bottom center

Accepted Answer

By dragging a corner handle, the chart can be resized both horizontally and vertically, maintaining its original proportions. Dragging the side or top/bottom center handles would only resize the chart in one direction and could distort the chart's proportions.

Question 18

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

Accepted Answer

The #NULL! error typically occurs when a space is used inappropriately in a formula, indicating an intersection of two areas that do not intersect.

Question 19

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

Accepted Answer

The answer of The equation used to calculate values in...

Question 20

Which of the following chart types does not have a horizontal and a vertical axis?
A) pie
B) column
C) bar
D) line

Accepted Answer

Pie charts do not have horizontal and vertical axes as they display data in a circular form, with each data point represented as a segment of the whole chart.

Quiz 19: Creating Formulas and Charting Data

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

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

A ____ is a graphic representation of your worksheet data.

____ is a mathematical function.

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

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

Which formula will produce a result of 48?

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

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?

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?

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

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

A shortcut for entering cell references is to ____.

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

____ 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.

To resize a chart proportionally, drag a ____ handle.

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?

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

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