Which of the following is NOT a valid MS Excel chart type? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is NOT a valid MS Excel chart type?

A. Waterfall

B. PivotChart

C. Sunburst

D. Sparkline

Answer: Option D

Solution (By JKSSB Mock Tests)

Sparkline is a mini chart inside a cell, not a full chart type like the others. Sunburst, Waterfall, and PivotChart are valid chart types.

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 a 'Style Set'?

A. A predefined set of keyboard shortcuts

B. A group of templates

C. A macro that formats text

D. A collection of styles with coordinated fonts and colors that can be applied to a document

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Style Sets change the look of the whole document by applying a group of styles.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, the 'Watch Window' is used to:

A. Track changes to the workbook

B. Audit formulas

C. Monitor the values of cells in a separate window while working

D. View all open workbooks

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Watch Window (Formulas tab) keeps selected cells visible.

This question belongs to: Computer Microsoft Office

Question #3

What is the shortcut to lock a cell reference (toggle absolute/relative) while editing a formula in Excel?

A. Alt + Enter

B. Ctrl + 1

C. F2

D. F4

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
F4 cycles through reference types in formula edit mode.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs