WorksheetsExcel 2016 Advanced Formulas Mastery
Total questions: 19
Worksheet time: 38mins
Cell value references should always be used when possible to avoid having to make multiple updates when a key value changes.
True
False
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
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
A _________ is a prewritten formula that is built into EXCEL.
function
problem
equation
equal sign
A combination of numbers and symbols used to express a calculation. Always begins with an "=" sign.
Cell address
Worksheet
Formula
Which of the following formulas is not entered correctly?
=10+50
=B7+B8
=B7+14
=10+50;
Which of these symbols is used to do a division on a computer?
\
*
/
|
Which operator is used to multiply in Excel?
+
x
/
*
Formulas can be copied to adjacent cells with the ____________.
Fill handle
PgDn Key
Function key F4
None of the above
To edit a formula you
A. Double-click the cell
B. Click in the formula bar
C. Press Esc
D. Both A & B
Answer =2+3*3-2
9
10
11
12
Answer =3+5*(6-2)
23
32
31
64
