Home > Computer Science> MS Excel

6 . You can check the conditions against __________ when applying conditional formatting
A. Cell value
B. Formula
Both of above
D. None of above

7 . Which of the following is not true regarding Conditional Formatting?
A. You can add more than one condition to check
B. You can set condition to look for Bold and apply Italics on them
C. You can apply Font, border and pattern formats that meets the specified conditions
D. You can delete any condition from Conditional Formatting dialog box if it is not requried

8 . Which of the following is invalid statement?
A. Sheet tabs can be colored
B. Some picture can be applied as a background of a sheet
C. You can set the column width automatically fit the amount of text
D. The width of a row and be specified manually or fit automatically

9 . You can use the formula pallette to
format cells containing numbers
B. create and edit formula containing functions
C. enter assumptions data
D. copy a range of cells

10 . When a range is selected, how can you activate the previous cell?
A. Press the Alt key B. Press Enter
C. Press Tab D. None of above