1.
Which of the following will not cut information?
2.
What is the name of intersection of a column and a row on a worksheet?
3.
In MS-Excel what does SUMIF function do?
4.
The Greater Than sign (>) is an example of _____ operator.
5.
In MS-Excel which functions will calculate the number of workdays between 6/9/2021 and 8/12/2021
6.
In Excel, Rows are labelled as ____
7.
Formulas in MS Excel must begin with-
8.
Statistical calculations and preparation of tables and graphs can be done using
9.
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.
10.
In Excel, which one denoted a range from A1 through D15
11.
In MS-Excel which functions will calculate the number of workdays between 6/9/2021 and 8/12/2021
12.
Where you can find the name box in excel?
13.
In MS-Excel what does SUMIF function do?
14.
Which Excel feature allows you to format cells based on certain conditions?
15.
How many sheets are there, by default, when we create a new Excel file ?
16.
What type of chart will you use to compare performance of two employees in the year 2021 ?
17.
Which of the following is used to freeze rows and columns in Excel?
18.
Merge and center option merge all selected cells into a single cell retaining only the contents of the:
19.
Excel files have a default extension of
20.
How do you select an entire column?