A. !A!1
B. $A$1
C. #a#1
D. A1
✅ The correct answer is option B.
MS Office MCQs
In the formula, which symbol specifies the fixed columns or rows?
A. $
B. *
C. %
D. &
✅ The correct answer is option A.
Which menu option can be used to split windows into two?
A. Review > Window
B. View > Window > Split
C. Window > Split
D. View > Split
✅ The correct answer is option B.
Concatenation of text can be done using
A. Apostrophe ( ‘ )
B. Exclamation ( ! )
C. Hash ( # )
D. Ampersand ( & )
✅ The correct answer is option D.
When you insert an excel file into a word document. The data are
A. Hyperlinked placed in a word table
B. Linked
C. Embedded
D. Use the word menu bar and toolbars
✅ The correct answer is option B.
Edit > Delete command
A. Deletes the content of a cell
B. Deletes Formats of cell
C. Deletes the comment of cell
D. Deletes selected cells
✅ The correct answer is option D.
If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
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.
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.