In Excel, the formula =ROUND(3.14159, 2) returns: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the formula =ROUND(3.14159, 2) returns:

A. 3.15

B. 3.1

C. 3.142

D. 3.14

Answer: Option D

Solution (By JKSSB Mock Tests)

ROUND to 2 decimal places rounds 3.14159 to 3.14.

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 MS Word, which of the following is an example of a font style or character decoration attribute?

A. 12 pt

B. Calibri

C. Strikethrough

D. Margins

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Strikethrough is an explicitly selectable character effect attribute, whereas Calibri is a font family, and 12 pt represents font size metric sizing.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the shortcut to replace a specific word in an MS Word document?

A. Ctrl + R

B. Ctrl + F

C. F7

D. Ctrl + H

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+H replace.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, what does the 'Flash Fill' feature do?

A. Fills a range with random numbers

B. Automatically fills values by detecting patterns

C. Fills cells with a series like AutoFill

D. Copies formatting from adjacent cells

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Flash Fill (Ctrl+E) extracts, combines, or formats data based on examples.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs