MS Excel MCQ with Answers

MS Excel MCQ with Answers

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

Answer is:

client

217) How can you update the values of formula cells if Auto Calculate mode of Excel is disabled

Answer is:

F9

218) 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

Answer is:

Custom List

219) Where can you change automatic or manual calculation mode in Excel?

Answer is:

Go to Tools >> Options >> Calculation and mark the corresponding radio button

220) How can you show or hide the gridlines in Excel Worksheet?

Answer is:

Go to Tools >> Options >> View tab and mark or remove the check box named Grid line and Click Grid line tool on Forms toolbar

41
42
43
44
45
46
47