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

C. Memo

D. Number

Answer: Option B

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

In PowerPoint, to insert a screenshot, go to:

A. Insert -> Screenshot

B. Design -> Screenshot

C. Home -> Screenshot

D. View -> Screenshot

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Screenshot is in Insert tab.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, the 'Format' property for a Yes/No field can display:

A. True/False, Yes/No, or On/Off

B. 0/1 only

C. Checked/Unchecked

D. Both A and C

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Format property controls display.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, the error '#DIV/0!' occurs when:

A. A formula divides by zero or an empty cell

B. Invalid reference

C. Name not recognized

D. Value not available

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
#DIV/0! division by zero.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs