In MS Access, which data type stores a calculated value that depends on other fields? MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, which data type stores a calculated value that depends on other fields?

A. AutoNumber

B. Number

C. Memo

D. Calculated

Answer: Option D

Solution (By JKSSB Mock Tests)

Calculated data type creates a field whose value is computed.

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 chart type shows the proportion of each data series relative to the total using nested rings?

A. Pie

B. Treemap

C. Doughnut

D. Sunburst

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Doughnut chart is like a pie with a hole, can show multiple series. Sunburst shows hierarchical rings.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, the function =IFERROR(A1/B1, "Error") returns "Error" if:

A. If A1 is blank

B. Only if #DIV/0!

C. A1/B1 results in any error value

D. If B1 is zero

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
IFERROR catches all error types and returns specified value.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Word, which of the following is used to add a caption to a figure?

A. Review > Caption

B. References > Insert Caption

C. Insert > Caption

D. View > Caption

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Caption is under References.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs