Excel 2016 Advanced Formulas Mastery

Which response best completes the following statement: A formula is used to 

• perform calculations or other actions.
• find averages.

Cell value references should always be used when possible to avoid having to make multiple updates when a key value changes.

• True

• False

Excel follows the ___________________ and first adds the values inside the parentheses.

• Order of Operations
• Formula Guidelines

Define Formula Bar?

• An element in Excel or Google Sheets that appears below the grid and to the left of the zoom control that shows the deleted commands.

• A button or key in your keyboard to write the formulas.

• An element in Excel or Google Sheets that appears below the Ribbon that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

What is the Sum formula?

• Sum( )

• Sum( )=

• =Sum( )

• =( )Sum

When starting a formula what is the first thing you type in the cell?

• ;

• ?

• %

• =

How would you write a cell reference formula for cell A1 subtracted from Cell C3?

• A1-C3

• A1-C3=

• =A1-C3

• =C3-A1

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Which formula gets the biggest value of a range of cells?

• MAX

• MIN

• SHORT

• SUM

Which formula gets the smallest value of a range of cells?

• MAX

• MIN

• SMALL

• SUM