1.
In Excel, which one denoted a range from A1 through D15
2.
In MS-Excel which of the following is an absolute cell reference?
3.
In MS-Excel which functions will calculate the number of workdays between 6/9/2021 and 8/12/2021
4.
The Greater Than sign (>) is an example of _____ operator.
5.
Excel files have a default extension of
6.
A features that displays only the data in column's according to specified criteria
7.
In Excel, Columns are labelled as-
8.
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.
9.
The process of arrenging the items of a column in some sequence or order is known as-
10.
Which of the following will not cut information?
11.
Comments can be added to cells using
12.
The ____ feature of MS Excel quickly completes a series of data.
13.
In Excel, Rows are labelled as ____
14.
In MS-Excel which elements of worksheet can be protected from accidental modification?
15.
= TODAY () Returns the
16.
Merge and center option merge all selected cells into a single cell retaining only the contents of the:
17.
Which function in Excel checks whether a condition is true or not ?
18.
Which of the following options is not located in the Page Setup dialog box?
19.
Which of the following is true for ‘Hide worksheets’ feature?
20.
The syntax of SUMIF is-
Your quiz time is about to finish. Few seconds left.
