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

In MS Access, which data type stores a calculated value that depends on other fields?
A. AutoNumber
B. Calculated
C. Number
D. Memo
Answer: Option B
Solution (By JKSSB Mock Tests)
Calculated data type creates a field whose value is computed.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1
In MS Word, the 'Ctrl + ]' shortcut:
A. Increases line spacing
B. Applies superscript
C. Increases indent
D. Increases font size by 1 point

Correct Answer: Option D


Explanation:
Ctrl+] grows font 1 point.

This question belongs to: Computer Microsoft Office
Question #2
What is the function of the '$' sign in Excel formulas?
A. It denotes a currency format
B. It is used for concatenation
C. It creates an absolute reference
D. It indicates a named range

Correct Answer: Option C


Explanation:
The dollar sign ($) is used to create absolute references (e.g., $A$1) that do not change when the formula is copied. It can also be used for currency formatting when applied as a number format, but in formulas it's for absolute references.

This question belongs to: Computer Microsoft Office
Question #3
In MS Word, what does a red wavy underline indicate?
A. Formatting inconsistency
B. Grammar error
C. Spelling mistake
D. Repeated word

Correct Answer: Option C


Explanation:
Red wavy line is spelling.

This question belongs to: Computer Microsoft Office