Performing Calculations

Question 1

While writing a formula, what are some ways to insert a cell reference into the formula? Check all that apply.

Revolt · Accepted Answer

typing the cell name, such as “B4”; clicking the cell to reference

Question 2

Where should you click to edit an existing formula?

Revolt · Accepted Answer

in the formula bar

Question 3

Which set of symbols can be used to determine which calculations to perform first?

Revolt · Accepted Answer

parentheses

Question 4

What is the keyboard shortcut for copying text?

Revolt · Accepted Answer

Ctrl+C

Question 5

Which outcome would be a good use for the SUM function? Check all that apply.determining the amount of supplies needed for a concession standdetermine the profits for the concession standanalyzing the average amount each concession shopper spent at the standfiguring the most products purchased by customerdetermining how much product needs to be replenished for the next saledetermining what the expenses of the concession stand were

Revolt · Accepted Answer

determining the amount of supplies needed for a concession stand; determine the profits for the concession stand; determining how much product needs to be replenished for the next sale; determining what the expenses of the concession stand were

Question 6

When would an absolute cell reference be most helpful?

Revolt · Accepted Answer

when there is a need to reference the same cell when a formula is copied

Performing Calculations Answers

More from this Course

TRY EDGENUITY HACKS