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