A. Press the Erase key
B. Press Esc
C. Press the Enter button
D. Press the Edit Formula button
✅ The correct answer is option B.
MS Excel MCQs
Which of following is Not one of Excel’s what-if function?
A. Goal seek
B. Solver
C. Scenario manager
D. Auto Outline
✅ The correct answer is option D.
What is the shortcut key to replace a data with another in sheet?
A. Ctrl + R
B. Ctrl + Shift + R
C. Ctrl + H
D. Ctrl + F
✅ The correct answer is option C.
Documentation should include
A. Destination and users of the output data
B. Source of input data
C. Information on the purpose of the workbook
D. All of the above
✅ The correct answer is option D.
Which of the following is not information you can specify using the solver?
A. Input cells
B. Constraints
C. Target cell
D. Changing cells
✅ The correct answer is option A.
When a range is selected, how can you activate the previous cell?
A. Press the Alt key
B. Press Tab
C. Press Enter
D. None of above
✅ The correct answer is option D.
A numeric value can be treated as a label value if it precedes with
A. Apostrophe (‘)
B. Exclamation (!)
C. Hash (#)
D. Ampersand (&)
✅ The correct answer is option A.
A circular reference is
A. Geometric modeling tool
B. A cell that points to a drawing object
C. A formula that either directly or indirectly depends on itself
D. Always erroneous
✅ The correct answer is option C.
Which elements of worksheet can be protected from accidental modification
A. Contents
B. Objects
C. Scenarios
D. All of above
✅ The correct answer is option D.
You can convert existing excel worksheet data an charts to an HTML document by using
A. FTP wizard
B. Internet assistant wizard
C. Intranet wizard
D. Import wizard
✅ The correct answer is option B.