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.14

B. 3.1

C. 3.142

D. 3.15

Answer: Option A

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

What is the maximum number of rows supported natively by an MS Excel worksheet worksheet file since Excel 2007 (.xlsx onwards)?

A. 65,536

B. 524,288

C. 16,384

D. 1,048,576

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Modern versions of MS Excel support exactly 1,048,576 rows and 16,384 columns per worksheet.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, the 'Ctrl + Alt + D' shortcut inserts:

A. A footnote

B. A document property

C. An endnote

D. A date

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+Alt+D inserts endnote.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS Access, which query is used to find duplicate records in a table?

A. Find Duplicates Query Wizard

B. Crosstab query

C. Both A and B

D. Select query with GROUP BY and HAVING COUNT(*)>1

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Both the wizard and a totals query can identify duplicates.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs