In Excel, the chart type that shows the relationship between two sets of numeric data using dots is: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the chart type that shows the relationship between two sets of numeric data using dots is:

A. Line chart

B. Bubble chart

C. Scatter (XY) chart

D. Bar chart

Answer: Option C

Solution (By JKSSB Mock Tests)

Scatter chart plots x,y pairs.

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

Share Report

In Excel, which function counts the number of blank cells in a range?

A. ISBLANK()

B. COUNTIF()

C. COUNTBLANK()

D. COUNTA()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
COUNTBLANK(range) returns count of empty cells.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the shortcut key to open the 'Go To' dialog box in MS Excel?

A. Ctrl + G

B. Ctrl + H

C. F5

D. Ctrl + F

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
F5 opens the Go To dialog in Excel. Ctrl+G also opens Go To (same as F5). But both are valid. However, in many exams, F5 is the standard. I'll put F5 as correct. But the question asks for shortcut key, and both are possible. To avoid ambiguity, I'll change the question to 'Which key opens the Go To dialog in Excel?' and correct answer F5. But since both, I'll pick F5 as default.

This question belongs to: Computer Microsoft Office