1.
In the formula = A14 / B14 + C5 – D6*8 which calculation is performed first?
2.
In MS-Excel what does SUMIF function do?
3.
What type of chart will you use to compare performance of two employees in the year 2021 ?
4.
Comments can be added to cells using
5.
In MS-Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ______ menu
6.
In Excel, which one denoted a range from A1 through D15
7.
In MS-Excel which functions will calculate the number of workdays between 6/9/2021 and 8/12/2021
8.
Which command open Microsoft Excel?
9.
Where you can find the name box in excel?
10.
Excel files have a default extension of
11.
By default, MS Excel shows ______ characters in a column
12.
The syntax of SUMIF is-
13.
How do you select an entire column?
14.
= TODAY () Returns the
15.
Formulas in MS Excel must begin with-
16.
The ____ feature of MS Excel quickly completes a series of data.
17.
Which of the following will not cut information?
18.
Merge and center option merge all selected cells into a single cell retaining only the contents of the:
19.
The Greater Than sign (>) is an example of _____ operator.
20.
Which function in Excel checks whether a condition is true or not ?
Your quiz time is about to finish. Few seconds left.