OMIS Quiz 2
If you wanted to reference a cell in a formula without changing that cell when
copying and pasting you would use what kind of reference? - correct answer
✔Absolute
What is the default method of referencing cells in
formulas? - correct answer ✔Relative
Which keyboard shortcut toggles through the types of reference options? -
correct answer ✔F4
Which of the following is not a category of functions:
Logical, Financial, Statistical, Graphing. - correct answer ✔Graphing
What do you use to separate arguments in a function? - correct answer
✔Comma
What is not a direct option on the AutoSum drop down menu:
Median, Sum, Count, Max - correct answer ✔Median
Which of the following is not a valid test in an =IF statement:
A4-B4, A4<B4, A4>B4, B4<=A4 - correct answer ✔A4-B4
T or F: The VLOOKUP function has four required arguments - correct answer
✔False
If you wanted to reference a cell in a formula without changing that cell when
copying and pasting you would use what kind of reference? - correct answer
✔Absolute
What is the default method of referencing cells in
formulas? - correct answer ✔Relative
Which keyboard shortcut toggles through the types of reference options? -
correct answer ✔F4
Which of the following is not a category of functions:
Logical, Financial, Statistical, Graphing. - correct answer ✔Graphing
What do you use to separate arguments in a function? - correct answer
✔Comma
What is not a direct option on the AutoSum drop down menu:
Median, Sum, Count, Max - correct answer ✔Median
Which of the following is not a valid test in an =IF statement:
A4-B4, A4<B4, A4>B4, B4<=A4 - correct answer ✔A4-B4
T or F: The VLOOKUP function has four required arguments - correct answer
✔False
