In MS Excel, which chart type is best suited for showing trends over time? MCQ with Answer and Explanation

Question

Share Report Error

In MS Excel, which chart type is best suited for showing trends over time?

A. Column Chart

B. Bar Chart

C. Pie Chart

D. Line Chart

Answer: Option D

Solution (By JKSSB Mock Tests)

Line charts are ideal for displaying trends over time or categories. Pie charts show proportions, bar and column compare categories.

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 MS Word, what is the purpose of the 'Style' feature?

A. To apply consistent formatting to headings and other elements

B. To change the document's font

C. To create a table of contents

D. To add a watermark

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Styles are sets of formatting attributes that can be applied to text for consistency and to enable features like Table of Contents.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, the 'Validation Text' property is used to:

A. Set the default value

B. Display a custom error message when the validation rule is violated

C. Define the input mask

D. Format the field

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Validation Text provides a message.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, what field property constraint must be activated to ensure that users cannot leave a specific field blank when entering a new data record?

A. Required

B. Validation Rule

C. Input Mask properties

D. Indexed field size

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Setting the 'Required' field property to 'Yes' enforces a data validation constraint that prevents a record from being saved if that specific field is left blank or null.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs