Which of the following format you can decide to apply or not in AutoFormat dialog box?
Answer: D
Correct answer: All of above
AutoFormat's options let you switch each element on or off individually - number, border, font, patterns, alignment and width or height - so an existing font can be kept while the borders are applied.
Please log in or register to report this question.
How can you remove borders applied in cells?
Answer: C
Correct answer: Both of above
Borders are removed either by choosing None on the Border tab of Format Cells, or by picking the no-border square from the Borders button on the Formatting toolbar.
Please log in or register to report this question.
Where can you set the shading colour for a range of cells in Excel?
Answer: D
Correct answer: All of above
Shading is applied from the Patterns tab of Format Cells, from the Fill Color button on the Formatting toolbar, or from the same button on the Drawing toolbar - three routes to the same setting.
Please log in or register to report this question.
You can set Page Border in Excel from
Answer: D
Correct answer: You can not set page border in Excel
Excel has cell borders but no page border: the page setup offers margins, headers, footers and gridlines, and nothing that draws a frame round the sheet. That is a Word feature.
Please log in or register to report this question.
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
Answer: B
Correct answer: Apply Conditional Formatting command on Format menu
Conditional formatting applies a format when a condition holds, and re-evaluates it whenever the value changes. An IF function returns a value rather than a format, and formatting the cells by hand would not follow later edits.
Please log in or register to report this question.
You can check the conditions against __________ when applying conditional formatting
Answer: C
Correct answer: Both of above
A condition may test the cell's own value against a comparison, or evaluate a formula that returns TRUE or FALSE - the second allowing a cell to be formatted according to what is in some other cell.
Please log in or register to report this question.
Which of the following is not true regarding Conditional Formatting?
Answer: B
Correct answer: You can set condition to look for Bold and apply Italics on them
Conditional formatting tests values, not existing formatting, so it cannot look for cells that are already bold. It can apply font, border and pattern formats, take more than one condition, and have conditions deleted.
Please log in or register to report this question.
Which of the following is invalid statement?
Answer: D
Correct answer: The width of a row can be specified manually or fit automatically
Rows have height and columns have width. The statement mixes the two, which is what makes it the invalid one; the other three are all true of Excel.
Please log in or register to report this question.
Which of the following is not an option in the spelling dialog box?
Answer: A
Correct answer: Edit
The spelling dialog offers Ignore, Ignore All, Change, Change All, Add and AutoCorrect. There is no Edit button: the correction is typed into the suggestion box instead.
Please log in or register to report this question.
You can quickly change the appearance of your work by choosing Auto Format from the …. Menu
Answer: C
Correct answer: Format
AutoFormat changes appearance, so it is on the Format menu.
Please log in or register to report this question.
