MS Excel MCQ with Answers

Number format

Border format

Font format

All of above

Choose None on Border tab of Format cells

Open the list on Border tool in Formatting toolbar then choose first tool (no border)

Choose None on Border tab of Format cells and Open the list on Border tool in Formatting toolbar then choose first tool (no border)

None of above

Choose required color form 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 above

From Border tab in Format Cells dialog box

From Border tool in Formatting toolbar

From Line Style tool in Drawing toolbar

You can not set page border in Excel

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 above