Multiple-Choice Questions or Objective Type Questions on Spreadsheet [PDF Included]

Are you looking for MCQ questions on Spreadsheet, if yes then you are in the right place? Here in this article, I will display here some Multiple Choice Questions on Spreadsheet.

In the last section, there will be a Quiz test of 10 marks on Computer Spreadsheet. Appear for the test and know how much are you prepared on this topic.

At the end of this article, you will also find a PDF downloadable button from where you can download the PDF format of this MCQ sheet. So now let’s jump into the questions.

MCQ questions or Viva Questions on Spreadsheet

Here is the MCQ on Spreadsheet

• The numbers on the left side of the spreadsheet indicate:

1. Rows
2. Columns
3. None of these

Ans: (1)

• The letters at top of cells in a spreadsheet indicate:

1. rows
2. columns
3. none of these

Ans: (2)

• E11 in a spreadsheet means:

1. Row 11 and column E
2. In row E, 11 is written
3. Row E, column 11
4. In column 11, ‘E’ is written

Ans: (1)

• E11 indicates:

1. a formula
2. a text
3. cell address
4. the row

Ans: (3)

• When you click on a spreadsheet,a rectangular box with thick outlines becomes prominant. It is called:

1. cell
2. locked cell
3. workbook
4. active cell

Ans: (4)

• What do you mean by a workbook?

1. a group of cells
2. a group of rows
3. a group of worksheets
4. none of these

Ans: (3)

• If you want to create a table, which steps should you follow?

1.  Insert ->shapes-> table
2.  Insert-> table
3.  Home-> format as table
4.  None of these

Ans: (2)

• When you want to make a big cell by combining two or three numbers cells, which steps should you follow?

1.  Home-> merge and center
2.  Insert-> wrap text -> merge
3.  page layout -> merge
4.  none of these

Ans: (1)

• If you combine F4,G4,F5 and G5 cells, you will get a big cell. What address will be reflected for this big cell?

1. F4G5
2. FG45
3. F4
4. G5

Ans: (3)

• Spreadsheet is used for

1. plotting the curves
2. mathematical calculations
3. both (1) and (2)
4. for typing the long text

Ans: (3)

• You want to make a table for the scores achieved by the students. While typing “Name of the Students”, you noticed that the text couldn’t be accommodated within a cell. In this case, for creating a proper table what should you do?

1. Wrap the text
2. Merge all the surrounding cells
3. Change the font type
4. All of the above

Ans: (1)

• How can you increase the width of a cell?

1. By dragging the rows of the cell
2. By dragging the column of the cell
3. By merging
4. By wraping

Ans: (2)

• How can you increase the depth of a cell?

1. By dragging the rows of the cell
2. By dragging the column of the cell
3. By merging
4. By wraping

Ans: (1)

• In the same spread sheet, if you want to add a new worksheet, what will you do?

1. Go to Insert and then click on table
2. Click on page layout
3. Click on review
4. Click on Insert Worksheet

Ans: (4)

• The symbol for “Insert Worksheet” is located at

1. Top left
2. Top right
3. Bottom left
4. Bottom right

Ans: (3)

• You have created a big table for recording the numbers of all the students of all classes. At the top row of the table, you have written the parameters in bold such as name of the students, subject, marks, etc. It requires more than 100 numbers rows. While you are entering the data at row number 30, you could not able to see the parameters. In this case, what should you do so that you can see which column is for marks and which column is for subjects?

1. Click on formulas
2. Click on page layout and then on Orientation
3. Click on page layout and then on print titles
4. Click on page layout and then on Size

Ans: (3)

• When you open a new spread sheet, how many rows are visible by default?

1. 25-30
2. 50-55
3. 60-65
4. 70-75

Ans: (1)

• When you open a new spread sheet, how many columns are visible by default?

1. A-BX
2. A-AX
3. A-AY
4. A-U

Ans: (4)

• When you open a new spread sheet, how many worksheets are visible by default?

1. 4
2. 3
3. 2
4. 1

Ans: (2)

• The active cell is F9. If you press the enter key, then you will reach at

1.  G9
2. F8
3. F10
4. F11

Ans: (3)

Quiz on Spreadsheet

Here is the Spreadsheet Quiz for you:

Conclusion

I hope that the Multiple-Choice Questions on Computer Spreadsheet will help you in your school examinations and in different types of competitive examinations. I will be more encouraged if I get a positive feedback from your end. Please don’t forget to give the feedback by writing in the comment box. If you find any contradictions in my answers, please let me know and give me a chance to modify and improve myself. Good Luck!