C C
1-2 QUESTIONS
(2026-2027 Updated)
Solved Exams + 100%
Verified Solutions |
Complete Q&A
100% Guarantee Pass
✓ This Exam contains: Excel
Chapter 1-2 Questions
✓ 100% Accurate Questions
and Answers
✓ 100% Guarantee Pass -
Verified by Experts
✓ Each Question Includes
Correct Answer
✓ Updated for 2025-2026
Exam Requirements
, Trusted by thousands of students and professionals
worldwide
Question 1
The COUNTBLANK function will count cells that contain formulas that compute to a
value of zero (0).
Correct Answer
False
Question 2
Which of the following is not a valid keystroke for navigating around a worksheet?
Correct Answer
Alt + Up arrow
Question 3
Right-clicking a column heading, then selecting Insert, will add a new column to the
left of the current column.
Correct Answer
True
Question 4
If you do not need a row or column any more it is best to hide it instead of deleting
it in case you change your mind.
Correct Answer
false
,Question 5
Which of the following would not produce the correct monthly payment on a loan of
$13,000 which will be paid off in 5 years with an annual interest rate of 6%?
Correct Answer
=PMT(6%,60,-13000)
Question 6
What is the best way to make sure your worksheet prints on only one page?
Correct Answer
Use the fit to option
Question 7
Functions can be selected by using the ________.
Correct Answer
Insert Function dialog box
Question 8
Where is the Show Formulas command found?
Correct Answer
Formula Auditing group on the formulas tab
, Question 9
Which of the following would not be considered text?
Correct Answer
=2*2
Question 10
All IF functions have three arguments.
Correct Answer
true
Question 11
If a cell containing the formula =$B$14 is not copy and pasted, but moved four
columns over and four rows down, what would the resultant cell reference become?
Correct Answer
=$B$14
Question 12
Using Alt + Enter is a text wrapping option. T or F
Correct Answer
True
1-2 QUESTIONS
(2026-2027 Updated)
Solved Exams + 100%
Verified Solutions |
Complete Q&A
100% Guarantee Pass
✓ This Exam contains: Excel
Chapter 1-2 Questions
✓ 100% Accurate Questions
and Answers
✓ 100% Guarantee Pass -
Verified by Experts
✓ Each Question Includes
Correct Answer
✓ Updated for 2025-2026
Exam Requirements
, Trusted by thousands of students and professionals
worldwide
Question 1
The COUNTBLANK function will count cells that contain formulas that compute to a
value of zero (0).
Correct Answer
False
Question 2
Which of the following is not a valid keystroke for navigating around a worksheet?
Correct Answer
Alt + Up arrow
Question 3
Right-clicking a column heading, then selecting Insert, will add a new column to the
left of the current column.
Correct Answer
True
Question 4
If you do not need a row or column any more it is best to hide it instead of deleting
it in case you change your mind.
Correct Answer
false
,Question 5
Which of the following would not produce the correct monthly payment on a loan of
$13,000 which will be paid off in 5 years with an annual interest rate of 6%?
Correct Answer
=PMT(6%,60,-13000)
Question 6
What is the best way to make sure your worksheet prints on only one page?
Correct Answer
Use the fit to option
Question 7
Functions can be selected by using the ________.
Correct Answer
Insert Function dialog box
Question 8
Where is the Show Formulas command found?
Correct Answer
Formula Auditing group on the formulas tab
, Question 9
Which of the following would not be considered text?
Correct Answer
=2*2
Question 10
All IF functions have three arguments.
Correct Answer
true
Question 11
If a cell containing the formula =$B$14 is not copy and pasted, but moved four
columns over and four rows down, what would the resultant cell reference become?
Correct Answer
=$B$14
Question 12
Using Alt + Enter is a text wrapping option. T or F
Correct Answer
True
