Ms Excel - Study Mode

[#1] Which of the following format you can decide to apply or not in AutoFormat dialog box?
Correct Answer

(D) All of above

Explanation

Solution: AutoFormat option in excel is a unique way of formatting data quickly, the first step is we need to select the entire data we need to format and then the second step we need to click on auto-format from the QAT and third step we need to choose the format from the different options.

[#2] How can you remove borders applied in cells?
Correct Answer

(C) Both of above

Explanation

Solution: On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button. --OR-- Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.

[#3] Where can you set the shading color for a range of cells in Excel?
Correct Answer

(D) All of above

Explanation

Solution: The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell.

[#4] You can set Page Border in Excel from
Correct Answer

(D) You can not set page border in Excel

Explanation

Solution: There is no option to set page border in Excel.

[#5] When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Correct Answer

(B) Apply Conditional Formatting command on Format menu

Explanation

Solution: A conditional format changes the appearance of cells on the basis of conditions that you specify. If the conditions are true, the cell range is formatted; if the conditions are false, the cell range is not formatted.