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