MS Excel Question and Answer Set-1

In This post we will discuss about the excel

1. Which function will you use to enter current time in a worksheet cell?

1. =time()
2. =nowtime()
3. =now()
4. =currenttime()

2. How many recent files you can display on File menu at top recent?

1. 10
2. 7
3. 9
4. 5

3. What will you do if you want to apply one cell format on another cell.

1. Format Painter
2. Format Setting
3. Format Showing
4. Format Checking

4. Total No. of  Work Sheet in Excel are.

1. 255
2. 200
3. 138
4. 150

5. No. of Rows in one Work Sheet in Excel are.

1. 10,00,000
2. 10,48,576
3. 10,60,576
4. 10,50,576

6. No. of Columns in one Work Sheet in Excel are.

1. 16,384
2. 17,380
3. 18,500
4. 20,384

7. Which is the last Column Name in Excel’s Workbook.

1. XFC
2. XFD
3. XFF
4. XFA

8. A Cell is made of in which order.

1. Row and Column
2. Column and Row
3. Row, Column and Text
4. Row, Column and Numbers

9. Columns are lettered and Rows are numbered (True/False).

1. True
2. False
3. May be Some cases
4. None of these

10. In a Columns the letters (A to FXD) is …………

1. Row Header
2. Column Header
3. Row and Column Header
4. Header

11. In a Row the letters (1 to 10,48, 576) is …………

1. Row Header
2. Column Header
3. Row and Column Header
4. Header

12. How many default worksheet in the workbook. 

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

13. Name box is appear at ………….. 

1. right side of formula bar
2. left side of formula bar
3. top side of formula bar
4. bottom side of formula bar

14. in Excel the intersection rows and columns is called.

1. Worksheet
2. Square
3. Cell
4. Cubical

15. What is the right combination of a cell First Column and Row.

1. A2
2. B1
3. C1
4. A1

16. Len(“University”) return.

1. 100
2. 10
3. 9
4. None of these

17. A Collection of worksheet is called.

1. Excel Sheet
2. Workbook
3. Excel Worksheet
4. None of these

18. The combination Column Letter and Row Number for a cell in an excel worksheet is called a……..

1. Cell Cross
2. Cell Identification Number
3. Cell Reference
4. Cell Identity

19. In order to tell excel that you are entering a formula in a cell, You must begin the entry which an operator such as.

1. =
2. @
3. #
4. $

20. When excel copies a formula from one cell to another, it identity the number is needs by.

1. position
2. cell address
3. cell values
4. None of these