1.
What is the extension name of MS-Excel 2021?
2.
How may rows are available in Excel?
3.
What is the executable filename of MS-Excel 2021?
4.
Which of the following is NOT a valid data type in a cell that can be used in formulas?
5.
The formula =A1 + B1 will add the values in cells A1 and B1. In which cell should this formula be entered?
6.
What is the purpose of conditional formatting in Excel?
7.
Where can we find the Comment button?
8.
Which tool lets you search the data Name wise?
9.
Where can we get the Filter button?
10.
______________tool can show the graphical representation of the data?
11.
What does the function VLOOKUP do in Excel?
12.
The IF function allows you to:
13.
What is the purpose of cell formatting in Excel?
14.
The SUM function in Excel is used to:
15.
What symbol is used to enter a formula in Excel?
16.
______________Button lets you change the zoom level?
17.
Where can we get Sort button?
18.
What happens if you enter a formula that results in an error (e.g., dividing by zero)?
19.
Write the formula of DA, which is 25% of Basic
20.
What does Ctrl+C do in Excel?
21.
To get Rename Sheet option we need ___________click on the sheet name.
22.
To find the last row press ____________Key?
23.
What is the correct way to reference a cell in another sheet within the same workbook?
24.
What key combination is used to access the SUM function in Excel?
25.
Where can we get the data validation tool?
