Microsoft Excel Quiz fully solved
& updated
Function - answer A ____ is a pre-written formula that is built into
Excel.
Relative - answer A ____ reference is an adjusted cell reference in a
copied and pasted formula.
Spreadsheet - answer An Excel ____ allows data to be summarized
and charted easily.
Addition, Subtraction, Multiplication, and Division - answer You
should be familiar with the operators that direct Excel to perform
each mathematical operation
Enter - answer Clicking the ____ box completes an entry.
PEMDAS: parentheses, exponents, multiplication, division, addition,
subtraction - answer You should be familiar with the order in which
Microsoft Excel executes mathematical operations in a formula (i.e.,
+, -, *, /, ^, etc.).
Auto correct - answer The ____ feature works behind the scenes,
fixing common typing or spelling mistakes when you complete a text
entry.
MAX - answer The ____ function displays the highest value in a
range.
Normal View - answer The default view in Excel is the ____ view.
& updated
Function - answer A ____ is a pre-written formula that is built into
Excel.
Relative - answer A ____ reference is an adjusted cell reference in a
copied and pasted formula.
Spreadsheet - answer An Excel ____ allows data to be summarized
and charted easily.
Addition, Subtraction, Multiplication, and Division - answer You
should be familiar with the operators that direct Excel to perform
each mathematical operation
Enter - answer Clicking the ____ box completes an entry.
PEMDAS: parentheses, exponents, multiplication, division, addition,
subtraction - answer You should be familiar with the order in which
Microsoft Excel executes mathematical operations in a formula (i.e.,
+, -, *, /, ^, etc.).
Auto correct - answer The ____ feature works behind the scenes,
fixing common typing or spelling mistakes when you complete a text
entry.
MAX - answer The ____ function displays the highest value in a
range.
Normal View - answer The default view in Excel is the ____ view.