Which of the following is not a valid view in MS Excel? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is not a valid view in MS Excel?

A. Reading View

B. Page Layout

C. Normal

D. Page Break Preview

Answer: Option A

Solution (By JKSSB Mock Tests)

Excel has Normal, Page Layout, and Page Break Preview views. Reading View is not a view in Excel; it's a Word view.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

In Excel, which function is used to find the largest value that meets a condition?

A. MAX

B. LARGE

C. MAXIFS

D. MAXA

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
MAXIFS returns the maximum value based on criteria.

This question belongs to: Computer Microsoft Office

Question #2

Which Access data type would be most suitable for storing lengthy descriptive text up to about 1 GB?

A. OLE Object

B. Hyperlink

C. Text

D. Long Text (Memo)

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Long Text (formerly Memo) stores large amounts of text. Text holds up to 255 characters. OLE Object stores binary objects.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function returns the serial number of the date that is a specified number of months before or after a start date?

A. EOMONTH()

B. MONTH()

C. EDATE()

D. DATE()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
EDATE(start_date, months) shifts date by months.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs