MS Excel - 08

01. Which of the following series type is not valid for Fill Series dialog box?

  • 1Linear
  • 2Growth
  • 3Autofill
  • 4Time
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

02. Which of the following option is not available in Paste Special dialog box?

  • 1Add
  • 2Subtract
  • 3Divide
  • 4SQRT
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

03. What happens when you press Ctrl + X after selecting some cells in Excel?

  • 1The cell content of selected cells disappear from cell and stored in clipboard
  • 2The cells selected are marked for cutting
  • 3The selected cells are deleted and the cells are shifted left
  • 4The selected cells are deleted and cells are shifted up
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

04. Which of the following Excel screen components can NOT be turned on or off?

  • 1Formula Bar
  • 2Status Bar
  • 3Tool Bar
  • 4None of above
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

05. How can you show or hide the gridlines in Excel Worksheet?

  • 1Go to Tools >> Options >> View tab and mark or remove the check box named Gridline
  • 2Click Gridline tool on Forms toolbar
  • 3Both of above
  • 4None of above
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

06. 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?

  • 1Custom List
  • 2Auto Fill Options
  • 3Fill Across Worksheet
  • 4Fill Series
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

07. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

  • 1F8
  • 2F9
  • 3F10
  • 4F11
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

08. You can merge the main document with data source in Excel. In mail merge operation, Word is usually

  • 1server
  • 2source
  • 3client
  • 4none
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

09. Which of the following is not the correct method of editing the cell content?

  • 1Press the Alt key
  • 2Press the F2 key
  • 3Click the formula bar
  • 4Double click the cell
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

10. The Name box on to the left of formula bar

  • 1shows the name of workbook currently working on
  • 2shows the name of worksheet currently working on
  • 3shows the name of cell or range currently working on
  • 4None of above
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

Page 1 Of 2
Test
Classes
E-Book