Which chart type is best suited to display trends over time in Excel? MCQ with Answer and Explanation

Question

Share Report Error

Which chart type is best suited to display trends over time in Excel?

A. Line chart

B. Pie chart

C. Bar chart

D. Doughnut chart

Answer: Option A

Solution (By JKSSB Mock Tests)

Line charts are ideal for showing trends across a continuous period. Pie charts show parts of a whole.

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 Access, to create a report with grouping and subtotals, use:

A. Chart Wizard

B. Label Wizard

C. Blank Report

D. Report Wizard

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Report Wizard allows grouping and summary options.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, which option is used to apply a transition to only the selected slides?

A. Set custom show

B. Select slide, choose transition; do not click Apply To All

C. Click Apply To All but then undo for others

D. Use Slide Master

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Select slides and pick a transition; it applies only to those.

This question belongs to: Computer Microsoft Office

Question #3

What is the shortcut key to open the 'Format Cells' dialog box in MS Excel?

A. Ctrl + 4

B. Ctrl + 3

C. Ctrl + 2

D. Ctrl + 1

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl + 1 opens the Format Cells dialog box. Ctrl+2 applies bold (also Ctrl+B), Ctrl+3 italic, Ctrl+4 underline.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs