Performing Calculations

Question 1

What is an example of an absolute cell reference?

Revolt · Accepted Answer

$B$5

Question 2

Given the formula on the left, label the parts.

Revolt · Accepted Answer

SUM .: function name; A2:D19 .: range; E55 .: value; (A2:A19,C13,E55,19) .: argument

Question 3

✔ rangevalueformula

Revolt · Accepted Answer

✔ range

Question 4

✔ valueformularange

Revolt · Accepted Answer

✔ value

Question 5

syntaxfunction name✔ argument

Revolt · Accepted Answer

✔ argument

Question 6

What is the difference between a displayed result and a formula?

Revolt · Accepted Answer

The displayed result changes as the formula dictates it; it may not be a simple value.

Question 7

What are the components that could be used in a mathematical formula? Check all that apply.variableexpressionvalueoperatorresult

Revolt · Accepted Answer

variable; expression; operator; result

Question 8

Which symbol does a formula start with?

Revolt · Accepted Answer

=

Question 9

Where can you locate the Function Library group?

Revolt · Accepted Answer

Formulas tab of the ribbon

Question 10

What are ways to enter a formula in Excel? Check all that apply.Click on the Function Library group and select a function from the drop-down menu.Click on the Function Library group and Insert Function.Click on the File tab in the ribbon.Click on the Insert tab in the ribbon and then Equation.Type = into any cell.Click on the formula bar above the cells.

Revolt · Accepted Answer

Click on the Function Library group and select a function from the drop-down menu.; Click on the Function Library group and Insert Function.; Type = into any cell.; Click on the formula bar above the cells.

Performing Calculations Answers

More from this Course

TRY EDGENUITY HACKS