1.
How many sheets are there, by default, when we create a new Excel file ?
2.
The syntax of SUMIF is-
3.
The Greater Than sign (>) is an example of _____ operator.
4.
Which of the following options is not located in the Page Setup dialog box?
5.
In MS-Excel which elements of worksheet can be protected from accidental modification?
6.
Formulas in MS Excel must begin with-
7.
A features that displays only the data in column's according to specified criteria
8.
How do you select an entire column?
9.
Which of the following syntax is correct regarding to SUM function in Excel ?
10.
Which of the following is true for ‘Hide worksheets’ feature?
11.
Statistical calculations and preparation of tables and graphs can be done using
12.
Which of the following will not cut information?
13.
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.
14.
Merge and center option merge all selected cells into a single cell retaining only the contents of the:
15.
Excel files have a default extension of
16.
Which area in an excel window allows entering values and formulas?
17.
In Excel, Columns are labelled as-
18.
In MS-Excel which functions will calculate the number of workdays between 6/9/2021 and 8/12/2021
19.
By default, MS Excel shows ______ characters in a column
20.
=NOW () Returns the current time
Your quiz time is about to finish. Few seconds left.
