131. The command Edit > Fill Across Worksheet is active only when
A. One sheet is selected
B. When many sheets are selected
C. When no sheet is selected
D. None of above
✅ The correct answer is option B.
MS Excel MCQs
132. If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
A. From Edit menu choose Clear and then Formats
B. From Edit menu choose Delete
C. Click on Remove Formatting tool on Standard Toolbar
D. Double click the Format Painter and then press Esc key in keyboard
✅ The correct answer is option A.
133. Which of the following Excel screen components can NOT be turned on or off?
A. Formula Bar
B. Status Bar
C. Tool Bar
D. None of above
✅ The correct answer is option D.
134. You can check the conditions against __________ when applying conditional formatting
A. Cell value
B. Formula
C. Both of above
D. None of above
✅ The correct answer is option C.
135. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?
A. Custom List
B. Auto Fill Options
C. Fill Across Worksheet
D. Fill Series
✅ The correct answer is option A.
136. You can auto fit the width of column by
A. Double clicking on the column name on column header
B. Double click on the cell pointer in worksheet
C. Double clicking on column right border on column header
D. Double clicking on the column left border of column header
✅ The correct answer is option C.
137. Which area in an Excel window allows entering values and formulas?
A. Title Bar
B. Menu Bar
C. Formula Bar
D. Standard Tool Bar
✅ The correct answer is option C.
138. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
A. F8
B. F9
C. F10
D. F11
✅ The correct answer is option B.
139. Which function is not available in the Consolidate dialog box?
A. Pmt
B. Average
C. Max
D. Sum
✅ The correct answer is option A.
140. Tab scroll buttons are place on Excel screen
A. Towards the bottom right corner
B. Towards the bottom left corner
C. Towards the top right corner
D. Towards the top left corner
✅ The correct answer is option B.