Excel Interview Questions Part 1 [20 Questions]
Ans: Cell.
2. What is cell address?
Ans: The cross section of Row and Column and its position is called cell address like A1.
3. What is cell range?
Ans: The selection of range from start cell to end cell is called as cell range like A1:G1.
4. How many worksheets are available in Excel?
Ans: In MS Excel 2010 the default sheets are 3 but after 2013 to 2021 it is single sheet available.
5. What is cell address?
Ans : The cross section of Row and Column and its position is called cell address like A1.
6. Where I can get active cell address?
Ans: In the formula bar we can get active cell address.
7. What we call the cell comment?
Ans: The cell comment is called as cell tip.
8. What is clipboard?
Ans: After copy you can hold the value temporarily in clipboard memory (maximum 24 items).
9. What is format painter?
Ans: It helps to copy the format from different cells.
10. Where the format painter tool is available?
Ans: It is available in clipboard command group in home tab.
11. Which sign we use to show Absolute Reference?
Ans: ‘$’ dollar sign we use to denote the absolute address. A$1$.
12. What is the last bar in Excel Window?
Ans: Status bar is the last bar in Excel window.
13. Name the 28th column in Excel?
Ans: AB
14. What is the format name of 2561.239?
Ans: Fraction
15. Which function we use to show conditions?
Ans: If().
16. Which function we use to show the minimum value?
Ans: MIN().
17. Which language we use to create macro?
Ans: VBA.
18. What is will be output of 120 as scientific format?
Ans: 1.20E+02.
19. What is the first cell address?
Ans: A1.
20. What is the last cell address?
Ans: XFD1048576.
No comments:
Post a Comment