Performing Calculations (Excel 2016)

What are the components that could be used in a mathematical formula? Check all that apply. variable expression value operator result

Variable, expression, operator, result

While writing a formula, what are some ways to insert a cell reference into the formula? Check all that apply. hovering the mouse pointer over the cell to reference typing the cell name, such as "B4" clicking the cell to reference zooming in on the cell to reference

typing the cell name, such as "B4" clicking the cell to reference

What is an example of an absolute cell reference? 52% D2 $B$5 !90!

$B$5

Given the formula on the left, label the parts. SUM (syntax, function name, or argument) A2:D19 (range, value, or formula) E55 (value, formula, or range) (A2:A19,C13,E55,19) (syntax, function name, or argument)

1. Function name 2. Range 3. Value 4. Argument

Place the formula components in order of precedence from highest to lowest. (If you don't know this, idk what to tell you). multiplication/division exponents addition/subtraction parentheses

1. Parentheses 2. Exponents 3. Multiplication/Division 4. Addition/Subtraction

Which symbol does a formula start with? A.) = B.) % C.) + D.) ^

A.) =

Which symbol is used to indicate that a formula may contain an error? A.) green triangle in upper-left corner of cell B.) an orange circle below the formula result C.) green triangle with question mark inside D.) a wavy purple arrow above the formula result

A.) green triangle in upper-left corner of cell

Match the function with its desired result. AVERAGE SUM MIN MAX

AVERAGE: Find the average, or mean, of the numbers SUM: Find the total of the range of numbers MIN: Find the lowest number in the range MAX: Find the highest number in the range

Match the cell reference to its definition. absolute reference mixed reference relative reference

Absolute reference: the cell remains constant when copied or moved Mixed reference: the cell has a combination of two other types of cell references Relative reference: the cell changes based on the position of rows and columns

Where can you locate the Function Library group? A.) View tab of the ribbon B.) Formulas tab of the ribbon C.) File tab of the ribbon D.) Insert tab of the ribbon

B.) Formulas tab of the ribbon

Which set of symbols can be used to determine which calculations to perform first? A.) percentages B.) parentheses C.) plus signs D.) asterisks

B.) parentheses

How do you activate the Formula AutoComplete function of Excel 2016? A.) Go to the File tab on the ribbon. B.) Type in AutoComplete in the Tell Me bar. C.) Click the cell, type =, and begin the formula. D.) Use the drop-down menu under the Formula tab.

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

What is the keyboard shortcut for copying text? A. )Ctrl+P B.) Shift+P C.) Ctrl+C D.) Ctrl+P

C.) Ctrl+C

What is the difference between a displayed result and a formula? A.) The displayed result is always the same number, but the formula changes. B.) The formula is always the same as the displayed result; it will always be a simple value. C.) The displayed result changes as the formula dictates it; it may not be a simple value. D.) The displayed result and the formula are unrelated.

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

Where should you click to edit an existing formula? A.) in a cell that is referenced in the formula B.) in the first blank cell of a worksheet C.) in the formula bar D.) in the status bar

C.) in the formula bar

Sonora wants to extend the cells to be added in her formula. What is the quickest way to add more cells? A.) Go to the Function Library group and click Insert Function. B.) Click the Insert tab in the ribbon and then Equation. C.) Type the ranges in the parentheses in the formula bar. D.) Left-click on a cell that is included and drag the cursor.

D.) Left-click on a cell that is included and drag the cursor.

When would an absolute cell reference be most helpful? A.) when there is a long list of cell references in a formula B.) when there is a need to copy a formula and have the references update based on the new location C.) when some cell references need to be removed from a formula D.) when there is a need to reference the same cell when a formula is copied

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

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.

Option 1,2,4,5

Samuel wanted to paste the value and the formula attached from cell B6 to cell F16. Which methods will work? Check all that apply. Select cell B6, copy, and the drag cursor from B6 to F16. Select cell B6, copy, and paste special into F16. Select cell B6, Ctrl+C, and Ctrl+V into F16. Select cell B6, Ctrl+F, Ctrl+C, and Ctrl+V into F16. Select cell B6, copy, and paste into F16.

Select cell B6, copy, and paste special into F16. Select cell B6, Ctrl+C, and Ctrl+V into F16. Select cell B6, copy, and paste into F16.

Which part of the formula references the worksheet? Sheet3! SUM A12 A6:A19

Sheet3!

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

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