Which keyboard shortcut allows an operator to insert an automatic line break inside an individual cell grid without moving the active cursor down into a new cell box in MS Excel? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Microsoft Office Questions
Question #1
Report Error
In MS Excel, what type of referencing style is used when a formula contains a cell reference formatted as B$4?
Correct Answer: Option C
Explanation:
A mixed cell reference locks down either the column or the row while leaving the other free to shift relatively during formula copy-paste procedures.
A mixed cell reference locks down either the column or the row while leaving the other free to shift relatively during formula copy-paste procedures.
This question belongs to:
Computer
Microsoft Office
Question #2
Report Error
In MS Word, which feature allows you to see the formatting applied to text?
Correct Answer: Option C
Explanation:
Reveal Formatting (Shift+F1) shows a task pane displaying all formatting of selected text. Styles show applied style but not all formatting.
Reveal Formatting (Shift+F1) shows a task pane displaying all formatting of selected text. Styles show applied style but not all formatting.
This question belongs to:
Computer
Microsoft Office
Question #3
Report Error
In Excel, what does the function =ROW() return in cell C5?
Correct Answer: Option D
Explanation:
ROW() without argument returns the row number of the cell containing the formula.
ROW() without argument returns the row number of the cell containing the formula.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!