Questions from MSExcel 4 IBPS Exams

1. The number of rows in a worksheet is

a. 36500

b. 65536
c. 256
d. 64536

An worksheet consists 256 columns and 65536 rows.

2. When a formatted number does not fit within a cell, it displays

a. #####

b. #DIV/0
c. #DIV@
d. None of these

3.Data can be arranged in ascending or descending order by using

a. Sort command from Table menu
b. Sort command from Data menu
c. Sort command from Tools menu
d. None of these

4. Which of the following is concantenating operator?

a. Apostrophe (‘)
b. Exclamation (!)
c. Ampersand (&)
d. Hash (#)

5.Red triangle at the top right corner of a cell indicates

a. There is an error in the cell
b. There is a comment associated with the cell
c. The font color of the text in cell is red
d. The cell can’t accept formula

6. To select multiple non-adjecent cells in a worksheet you will click them holding

a. CTRL key
b. ALT key
c. Shift Key
d. Ctrl+Shift key

7. How many sheets are there in Excel Workbook by default?

a. 2

b. 3
c. 4
d. 5

8. To move to the previous worksheet press

a. Ctrl+PgUp

b. Ctrl+PgDn

c. Shift+Tab

d. Ctrl+Tab

9. The process of identifying specific rows and columns so that so that certain columns and rows are always visible on the screen is called

a. freezing

b. locking

c. selecting

d. fixing

10. To keep specific rows and columns from scrolling off the screen you first must position the cell pointer
a. to the right of the column you want to remain on the screen
b. below the row you want to remain on the screen
c. on the row you want to remain on the screen
d. both below and right of the row and column you want to remain on the screen