1.
Statistical calculations and preparation of tables and graphs can be done using
2.
Excel files have a default extension of
3.
Which Excel feature allows you to group and summarize data in a table format?
4.
The VLOOKUP function is used to search the _________ of a range of cells and then returns a value from any cell on the same row of the range.
5.
Which of the following will not cut information?
6.
Merge and center option merge all selected cells into a single cell retaining only the contents of the:
7.
= TODAY () Returns the
8.
In MS-Excel which of the following is an absolute cell reference?
9.
Which of the following is not a valid data type in Excel?
10.
How do you select an entire column?
11.
In MS-Excel which of the following is an absolute cell reference?
12.
What type of chart will you use to compare performance of two employees in the year 2021 ?
13.
In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ______ menu
14.
The VLOOKUP function is used to search the _________ of a range of cells and then returns a value from any cell on the same row of the range.
15.
In MS-Excel what does SUMIF function do?
16.
Which area in an excel window allows entering values and formulas?
17.
The syntax of SUMIF is-
18.
The process of arrenging the items of a column in some sequence or order is known as-
19.
By default, MS Excel shows ______ characters in a column
20.
=NOW () Returns the current time