ScienceComputer ScienceComputer SkillsChapter 2 Multiple Choice
Please enter something

Chapter 2 Multiple Choice

Heidi Butler avatar Heidi Butler
11 September 2022
4.7 (114 reviews)
10 test answers

Unlock all answers in this set

Unlock answers (6)
question
If cell E15 contains the formula =$C$5*J$15. What type of reference is J$15 in the formula?
answer
mixed reference
question
What function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5?
answer
=AVERAGE(B5:F5)
question
When you start to type =AV, what feature displays a list of functions and defined names?
answer
Formula AutoComplete
question
A formula containing the entry =$B3 is copied to a cell one column to the right and two rows down. How will the entry appear in its new location?
answer
$B5
question
Which of the following functions should be used to insert the current date and time in a cell?
answer
=NOW()
question
Which of the following is NOT an argument of the IF function?
answer
lookup_value
question
Which of the following is NOT true about the VLOOKUP function?
answer
the lookup table must be in ascending order
question
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?
answer
periodic interest rate
question
Which of the following is NOT an appropriate use of the SUM function?
answer
=SUM(D15-C15)
question
What is the keyboard shortcut to create and absolute reference?
answer
F4