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.
You can check the conditions against _________ when applying conditional formatting in Excel.
cell value
formular
Both of the above
None of the above
Correct answer is C
No explanation has been provided for this answer.
When all the numbers between 0 and 100 in a range should be displayed in red color, apply
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of the above
Correct answer is B
No explanation has been provided for this answer.
Where can you set the shading color for a range of cells in Excel?
Choose required color from Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of the above
Correct answer is D
No explanation has been provided for this answer.
In Excel, how can you remove borders applied in cells?
Choose None on Border tab of Format cells
Open the list on Border tool in Format Cell toolbar then choose first tool (none)
Both of above
None of above
Correct answer is C
No explanation has been provided for this answer.
Table Styles
Stylish Cells
Format as Table
Cells as Table
Correct answer is C
No explanation has been provided for this answer.