1.
Which function in Excel checks whether a condition is true or not ?
2.
The syntax of SUMIF is-
3.
Which functionin Excel tells how many numeric entries are there ?
4.
In MS-Excel which functions will calculate the number of workdays between 6/9/2021 and 8/12/2021
5.
The ____ feature of MS Excel quickly completes a series of data.
6.
A features that displays only the data in column's according to specified criteria
7.
In a worksheet you can select at a time-
8.
= TODAY () Returns the
9.
Which of the following will not cut information?
10.
In Excel, Columns are labelled as-
11.
In Excel, which one denoted a range from A1 through D15
12.
How many sheets are there, by default, when we create a new Excel file ?
13.
In MS-Excel what does SUMIF function do?
14.
What type of chart will you use to compare performance of two employees in the year 2021 ?
15.
Which area in an excel window allows entering values and formulas?
16.
In the formula = A14 / B14 + C5 – D6*8 which calculation is performed first?
17.
Which command open Microsoft Excel?
18.
In MS-Excel which of the following is an absolute cell reference?
19.
Which of the following options is not located in the Page Setup dialog box?
20.
The Greater Than sign (>) is an example of _____ operator.
Your quiz time is about to finish. Few seconds left.
