Selected MCQ

Current Question
In MS Excel, the undo option will ____ the last action.
  • A. Replace
  • B. Change
  • C. Repeat
  • D. Recoverable
Correct Answer: B
Explanation:
Undo reverses the most recent change made in the worksheet.
Related Question 1
In Excel we added ____ before fraction for not to enter date.
  • A. S
  • B. &
  • C. Space
  • D. None of these
Correct Answer: C
Explanation:
A leading space forces Excel to treat the entry as text/fraction.
Related Question 2
Which is used for fractions, so data in MS-Excel doesn’t read it as a date?
  • A. S
  • B. @
  • C. /
  • D. Space
Correct Answer: D
Explanation:
Prefixing a fraction with a space prevents Excel from interpreting it as a date.
Related Question 3
In MS Excel 2016, one has to go to which option for setting or clearing the print area?
  • A. Insert
  • B. Page Layout
  • C. Data
  • D. Review
Correct Answer: B
Explanation:
Print Area settings are found under the Page Layout tab.
Related Question 4
In MS Excel 2016, the “Pivot Tables” option is available in the ____ menu.
  • A. Review
  • B. View
  • C. Insert
  • D. Page Layout
Correct Answer: C
Explanation:
PivotTables are inserted from the Insert tab.
Related Question 5
In MS Excel 2016, the “Conditional Formatting” option is available in the ____ menu.
  • A. Insert
  • B. Page Layout
  • C. Formulas
  • D. Home
Correct Answer: D
Explanation:
Conditional Formatting is located on the Home tab.