In Excel, a cell formatted as 'Text' will: MCQ with Answer and Explanation

In Excel, a cell formatted as 'Text' will:
A. Automatically align to the right
B. Prevent any entry
C. Convert numbers to text, but formulas can still calculate
D. Display the entered data exactly as typed, not as a number/date
Answer: Option D
Solution (By JKSSB Mock Tests)
Text format treats input as literal text.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In MS Access, a 'Query' can be used to:
A. Add, delete, or update data in tables
B. Create forms
C. Generate reports
D. Create relationships

Correct Answer: Option A


Explanation:
Queries can be action queries that add, delete, update, or append data. Forms are created separately, reports separately, and relationships are defined in the Relationships window.

This question belongs to: Computer Microsoft Office
Question #2
What is the function of the keyboard shortcut Ctrl + Y in MS Word?
A. Inserts a time index stamp
B. Undoes the last action performed
C. Redoes or repeats the last action performed
D. Cuts the selected item block

Correct Answer: Option C


Explanation:
Ctrl + Y is the shortcut to Redo or repeat an action that was reversed via the Undo (Ctrl + Z) command.

This question belongs to: Computer Microsoft Office
Question #3
What type of special validation error alert is thrown by MS Excel if a formula attempts to divide a numeric value by zero or references an unpopulated empty cell as a divisor?
A. #DIV/0!
B. #VALUE!
C. #NUM!
D. #REF!

Correct Answer: Option A


Explanation:
The #DIV/0! error is thrown by Excel whenever a formula attempts to divide a number by zero or by a cell that contains no value.

This question belongs to: Computer Microsoft Office