Multiple Choice Question for Microsoft Excel || 21
Read multiple choice questions for computer operator training as well as IT Training. Improve your computer skills.
201 Which of the following format you can decide to apply or not
in AutoFormat dialog box?
A. Number format
B. Border format
C. Font format
D. All of above
202 How can you remove borders
applied in cells?
A. Choose None on Border tab of Format cells
B. Open the
list on Border tool in Formatting toolbar then choose first tool (no border)
C. Both of above
D. None of above
203 Where
can you set the shedding color for a range of cells in Excel?
A. Choose
required color form Patterns tab of Format Cells dialog box
B. Choose required
color on Fill Color tool in Formatting toolbar
C. Choose required color on
Fill Color tool in Drawing toolbar
D. All of above
204 You can set Page Border in Excel from
A. From Border tab
in Format Cells dialog box
B. From Border tool in Formatting toolbar
C. From
Line Style tool in Drawing toolbar
D. You can not set page border in Excel
205 When all the numbers between 0 and 100 in a
range should be displayed in Red Color, apply
A. Use =if() function to format
the required numbers red
B. Apply Conditional Formatting command on Format
menu
C. Select the cells that contain number between 0 and 100 then click Red
color on Text Color tool
D. All of above
206
You can check the conditions against __________ when applying conditional
formatting
A. Cell value
B. Formula
C. Both of above
D. None of above
207 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
208 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
209 You can use
the formula pallette to
A. format cells containing numbers
B. create and
edit formula containing functions
C. enter assumptions data
D. copy a range
of cells
210 When a range is selected, how
can you activate the previous cell?
A. Press the Alt key
B. Press Tab
C.
Press Enter
D. None of above