Performing Calculations

Question 1

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 2

A2:D19 .

Revolt · Accepted Answer

range

Question 3

E55 .

Revolt · Accepted Answer

value

Question 4

(A2:A19,C13,E55,19) .

Revolt · Accepted Answer

argument

Question 5

Where can you locate the Function Library group?

Revolt · Accepted Answer

Formulas tab of the ribbon

Question 6

SUM .

Revolt · Accepted Answer

function name

Question 7

How do you activate the Formula AutoComplete function of Excel 2016?

Revolt · Accepted Answer

Click the cell, type =, and begin the formula.

Question 8

Which part of the formula references the worksheet?

Revolt · Accepted Answer

Sheet3!

Question 9

Which symbol is used to indicate that a formula may contain an error?

Revolt · Accepted Answer

green triangle in upper-left corner of cell

Performing Calculations Answers