Selected MCQ

Current Question
Which of the following is an absolute cell reference?
  • A. L$A1
  • B. $A$1
  • C. #A1
  • D. None of these
Correct Answer: B
Explanation:
$A$1 is the standard absolute cell reference format.
Related Question 1
A bookmark is an item or location in a document that you identify as a name for future reference. Which of the following tasks is accomplished by using bookmarks?
  • A. To mark the ending of a paragraph of a document
  • B. To add anchors to the web page
  • C. To add hyperlinks in a webpage
  • D. To quickly jump to a specific location in the document
Correct Answer: D
Explanation:
Bookmarks allow quick navigation to specific locations in a document.
Related Question 2
Which of the following functions in Microsoft Excel counts the number of cells with numerical data in the argument?
  • A. COUNT
  • B. AVERAGE
  • C. SUM
  • D. MAX
Correct Answer: A
Explanation:
COUNT tallies only numeric cells.
Related Question 3
When adding two cells in a spreadsheet, which of the following represents the correct formula?
  • A. #REF?
  • B. = A1 + A2
  • C. (A1 + A2)
  • D. SUM(A1,A2)
Correct Answer: B
Explanation:
=A1+A2 is the correct basic addition formula.
Related Question 4
If a formula references a cell that contains text instead of a numerical value, what error does Excel display?
  • A. #NUM!
  • B. #VALUE!
  • C. #REF!
  • D. #DIV/0!
Correct Answer: B
Explanation:
#VALUE! An error appears when the formula expects numbers but receives text.
Related Question 5
Which of the following is not the correct method of editing the cell content?
  • A. F2
  • B. Double-press the cell
  • C. Click the formula bar
  • D. Pressing the Alt key
Correct Answer: D
Explanation:
Alt does not activate edit mode for cell content.