Deck 20: Creating Formulas and Charting Data

Question 1

____ formulas perform calculations that you could perform using a scientific calculator.

A) Complex
B) Embedded
C) Statistical
D) Mathematical

Answer 1

D

Question 2

To create a minus sign in a formula, use the hyphen key.

Answer 2

True

Question 3

When creating formulas, there must be a closing parenthesis for every opening parenthesis.

Answer 3

True

Question 4

A cell reference that contains both relative and absolute references is called a(n) mixed cell reference.

Question 5

The equation used to calculate values in a cell is known as a(n) function .

Question 6

= SUM tallies the number of cells with values in the specified range.

Question 7

The COUNT and SUM functions are interchangeable.

Question 8

Charts are not objects, like clip art images or photos.

Question 9

A(n) embedded chart is created on the same sheet as the data used in the chart.

Question 10

3D references are often used in summary worksheets to condense and total data from other worksheets.

Question 11

You can create multiple sparklines at the same time.

Question 12

A shortcut to entering cell references is to name a range of cells.

Question 13

=$A1 is a formula with an absolute reference.

Question 14

A(n) ____ cell reference does not change when the formula is copied or moved.

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

Question 15

____ formulas perform calculations that describe large quantities of data.

A) Complex
B) Embedded
C) Statistical
D) Mathematical

Question 16

An error value appears if the cell is not wide enough to show the result.

Question 17

Excel has a(n) AutoComplete feature that automatically checks a formula for common keyboarding mistakes.

Question 18

All Excel formulas begin with ____.

A) the equal sign
B) a number
C) a value
D) an operand

Question 19

You can change the order of evaluation by using hyphens.

Question 20

Which of the following is NOT true about creating formulas?

A) Multiplication and division are performed before addition and subtraction.
B) When entering the cell reference, the column letters must be uppercase.
C) Calculations in parentheses are performed first.
D) Generally, cell references are used in formulas instead of the actual value.

Question 21

____ refers to the ability to connect worksheets by creating formulas that reference the same cell or range in multiple worksheets.

A) Length
B) Width
C) Depth
D) All of the above.

Question 22

Which of the following is NOT true about the contents of column F in the accompanying figure?

A) They can be used to show a trend.
B) You can use built-in formats to apply a color scheme.
C) You can customize the graphic to choose a color for high, low, first, and last values.
D) All of the above are true.

Question 23

The ____ error occurs when the column is not wide enough or a negative date is entered.

A) #VALUE!
B) #N/A
C) ####
D) #REF!

Question 24

The ____ error occurs when the wrong type of argument or operand is used.

A) #VALUE!
B) #N/A
C) ####
D) #REF!

Question 25

A(n) ____________________ is a graphic representation of your worksheet data.

Question 26

Formulas containing more than one operator are called ____________________ formulas.

Question 27

Which of the following is NOT true about creating a function?

A) Several common functions are available by clicking a button on the Ribbon.
B) You can collapse and expand the Function Arguments dialog box.
C) You can drag the fill handle to copy a formula across a column.
D) All of the above are true.

Question 28

The ____ is a value, cell reference, range, or text used in a function.

A) operator
B) argument
C) operand
D) formula

Question 29

Using the ____________________ feature, Excel scans the worksheet and identifies the most logical column or row of adjacent cells containing numbers to add.

Question 30

The accompanying figure shows ____ in column F.

A) sparklines
B) embedded charts
C) chart sheets
D) functions

Question 31

The ____ error occurs when the contents of cells referred to by other formulas are deleted.

A) #VALUE!
B) #N/A
C) ####
D) #REF!

Question 32

Tyler is teaching Eleni how to perform calculations in her Excel worksheet. Tyler tells Eleni that the * (asterisk) character is used to represent ____.

A) addition
B) subtraction
C) multiplication
D) division

Question 33

A(n) ____________________ is a symbol that indicates the mathematical operation to perform.

Question 34

The ____________________ reference enables you to access data from multiple worksheets.

Question 35

Two non-adjacent cells are distinguished in a function using a ____.

A) comma
B) colon
C) semi-colon
D) hyphen

Question 36

The ____ function multiples values in the specified cells.

A) =PRODUCT
B) =SUM
C) =COUNT
D) =MEDIAN

Question 37

Tyler is teaching Eleni how to perform calculations in her Excel worksheet. Tyler tells Eleni that ____ is an absolute cell reference.

A) A1
B) $A1
C) A$1
D) $A$1

Question 38

Rajit wants to display the data in his worksheet using graphics. Rajit decides to show snapshots of the data for each row in his worksheet. He inserts ____.

A) functions
B) sparklines
C) charts
D) graphics

Question 39

Which of the following is NOT true about charts?

A) Charts are used to draw or present conclusions about data.
B) If a chart is not set up correctly, the representation can be confusing or misleading.
C) The first step is to decide what type of chart you want to create.
D) All charts have a horizontal and vertical axis.

Question 40

Rajit wants to display the data in his worksheet using graphics. Rajit knows that all of the following is true about charts, EXCEPT: ____.

A) You cannot change the type of a chart.
B) You can resize a chart by dragging a sizing handle on the canvas.
C) To remove a chart element, select it, then press Delete.
D) An embedded chart is useful if you want to view the chart and data at the same time.

Question 41

What is the difference between a function and a formula? List two types of functions available in Excel. Describe how you would use the following functions: SUM, AVERAGE, COUNT, and MIN.