A basic knowledge of Microsoft Office applications such as MS Word, MS Excel and MS PowerPoint is often required for most jobs. Practise and prepare for your aptitude test with these frequently asked MS Office questions and answers.
The shortcut key Ctrl + R is used in Excel to
Right align the content of a cell
Remove the contents of selected cells
Fill the selection with active cells to the right
None of above
Correct answer is C
No explanation has been provided for this answer.
Ctrl + D shortcut key in Excel will
Open the font dialog box
Apply double underline for the active cell
Fill down in the selection
None of above
Correct answer is C
No explanation has been provided for this answer.
You can auto fit the width of a column in Excel by
Double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on the right border of the column header
Double clicking on the left border of the column header
Correct answer is C
You can auto fit the width of column by double clicking on the column right border on column header.
Which of the cell pointer indicates that you can fill series?
Doctor’s symbol (Big Plus)
Small thin plus icon
Mouse Pointer with anchor at the tip
None of the above
Correct answer is B
Small thin plus icon cell pointer indicates that you can fill series.
Which of the following is not true regarding Conditional Formatting?
You can add more than one condition to check
You can set condition to look for Bold and apply Italics on them
You can apply Font, border and pattern formats that meets the specified conditions
You can delete any condition from Conditional Formatting dialog box if it is not requried
Correct answer is B
No explanation has been provided for this answer.