1.
A features that displays only the data in column's according to specified criteria
2.
The Greater Than sign (>) is an example of _____ operator.
3.
How do you select an entire column?
4.
In Excel, which one denoted a range from A1 through D15
5.
In Excel, Columns are labelled as-
6.
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.
7.
=NOW () Returns the current time
8.
Which function in Excel checks whether a condition is true or not ?
9.
Which command open Microsoft Excel?
10.
The syntax of SUMIF is-
11.
In MS-Excel which of the following is an absolute cell reference?
12.
Which area in an excel window allows entering values and formulas?
13.
Which of the following is true for ‘Hide worksheets’ feature?
14.
Where you can find the name box in excel?
15.
In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ______ menu
16.
What type of chart is useful for comparing values over categories ?
17.
Comments can be added to cells using
18.
In the formula = A14 / B14 + C5 – D6*8 which calculation is performed first?
19.
= TODAY () Returns the
20.
Which of the following syntax is correct regarding to SUM function in Excel ?
Your quiz time is about to finish. Few seconds left.
