Question 1

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

Accepted Answer

Upper-level management often uses charts and graphs to visually analyze data and identify patterns, trends, and anomalies. This helps executives make informed decisions and adjust strategies as needed.

Question 2

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

Accepted Answer

Length and width refer to the worksheet rows and columns in a 3-D reference.

Question 3

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

Accepted Answer

When a chart is created on the same sheet as the data used in the chart, it is embedded in the worksheet. It means that the chart is a part of the worksheet and will move and resize along with the cells.

Question 4

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

Accepted Answer

The MAX function is used to find the maximum value in a range, but it is not the most frequently used function. Functions like SUM, AVERAGE, and COUNT are more commonly used in data analysis and spreadsheet applications.

Question 5

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

Accepted Answer

Text boxes are often used in charts to position and display titles, labels, and other annotations.

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.

Accepted Answer

To create an absolute cell reference, you add a dollar 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.

Accepted Answer

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

Question 8

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

Accepted Answer

Using cell references in formulas is preferred because it allows for dynamic updates when the data in the referenced cells change, whereas using static values would require manual updates.

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

Accepted Answer

Formulas containing more than one operator are called complex formulas as they involve multiple calculations and operations. Mixed cell references, absolute cell references, and relative cell references are all types of cell references within a formula.

Question 10

Computers evaluate and assess worksheet values.

Accepted Answer

The answer of 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.

Accepted Answer

When you edit the data in a worksheet, the chart linked to that data will automatically update to reflect the changes.

Question 12

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

Accepted Answer

Mathematical functions such as addition, subtraction, multiplication, division, square root, exponentiation, logarithm, trigonometric functions, etc. can all be performed using a scientific calculator.

Question 13

The operator is a number or cell reference.

Accepted Answer

An operator is a symbol that indicates the type of calculation to perform, such as +, -, *, or /. It is not a number or cell reference.

Question 14

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

Accepted Answer

A plus sign is indeed an example of an operator in mathematics.

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

Accepted Answer

By default, cell references in formulas are formatted as relative cell references, which means that the reference changes based on the position of the formula when it is copied or moved to another cell.

Question 16

AVERAGE is a statistical function.

Accepted Answer

The average function, also known as the mean function, is a statistical function that calculates the central tendency of a set of values.

Question 17

The operator for performing multiplication is the ____.
A) + (plus sign)
B) * (asterisk)
C) - (minus sign)
D) / (forward slash)

Accepted Answer

The operator for performing multiplication is denoted by * (asterisk). It is used to multiply two or more numeric values together.

Question 18

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

Accepted Answer

This statement is true. A formula in mathematics or computer programming typically involves a calculation, which is performed on one or more operands using an operator such as addition, subtraction, multiplication, or division. For example, the formula 2 + 3 would consist of the operands 2 and 3 along with the addition operator (+).

Question 19

All Excel formulas begin with ____.
A) $
B) /
C) SUM
D) =

Accepted Answer

Excel formulas must begin with the equals sign (=) in order for Excel to recognize it as a formula, rather than a string of text.

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

Accepted Answer

The sequence used to calculate the value of a formula is called the order of evaluation. This sequence determines which operations or calculations are performed first, second, third, and so on. It is important to understand the order of evaluation in order to get accurate results from formulas. Cell references, operands, and operators are all important components of a formula, but they do not refer specifically to the sequence used to calculate the formula.

Quiz 19: Creating Formulas and Charting Data

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

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

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

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

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

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.

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

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

Formulas containing more than one operator are called ____.

Computers evaluate and assess worksheet values.

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

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

The operator is a number or cell reference.

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

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

AVERAGE is a statistical function.

The operator for performing multiplication is the ____.

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

All Excel formulas begin with ____.

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