Selected MCQ

Current Question
An excel workbook is a collection of ____.
  • A. Workbooks
  • B. Worksheets
  • C. Charts
  • D. Worksheets and Charts
Correct Answer: D
Explanation:
A workbook contains multiple worksheets and charts.
Related Question 1
What is the shortcut key to quickly insert a new workbook in Excel?
  • A. Shift+Enter
  • B. Alt+Enter
  • C. Control
  • D. Shift + A
Correct Answer: B
Explanation:
The document marks Alt+Enter, but the standard shortcut is Ctrl + N.
Related Question 2
When you link data maintained in an Excel workbook to a Word document, ____.
  • A. The Word document cannot be edited
  • B. The Word document contains a reference to the source document
  • C. The Word document must contain a hyperlink
  • D. The Word document contains a copy of the actual data
Correct Answer: B
Explanation:
Linking creates a reference to the source Excel file.
Related Question 3
In MS Excel, how many worksheets are in a modern workbook are by default?
  • A. 3
  • B. 1
  • C. 5
  • D. None of these
Correct Answer: B
Explanation:
Older versions of Excel defaulted to three worksheets (modern versions default to one).
Related Question 4
In MS Excel, how many worksheets are in a workbook by default?
  • A. 3
  • B. 4
  • C. 5
  • D. None of these
Correct Answer: A
Explanation:
Excel opens with 3 worksheets by default.
Related Question 5
Comment put on Excel cell, which is displayed by taking the Mouse Pointer there, is called ____.
  • A. Smart tip
  • B. Soft Tip
  • C. Web Tip
  • D. Cell Tip
Correct Answer: D
Explanation:
A comment in Excel is displayed as a Cell Tip when hovering the mouse.