Home > Computer Science> MS Excel

16 . 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

17 . 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
Auto Fill Options
C. Fill Across Worksheet
D. Fill Series

18 . Where can you change automatic or manual calculation mode in Excel?
A. Double CAL indicator on status bar
B. Go to Tools >> Options >> Calculation and mark the corresponding radio button
C. Both of above
D. None of above

19 . How can you show or hide the gridlines in Excel Worksheet?
A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
B. Click Gridline tool on Forms toolbar
C. Both of above
D. None of above

20 . 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