1.
Excel files have a default extension of
2.
In Excel, which one denoted a range from A1 through D15
3.
By default, MS Excel shows ______ characters in a column
4.
The syntax of SUMIF is-
5.
What type of chart will you use to compare performance of two employees in the year 2021 ?
6.
Which of the following will not cut information?
7.
In MS-Excel which functions will calculate the number of workdays between 6/9/2021 and 8/12/2021
8.
What is the name of intersection of a column and a row on a worksheet?
9.
How many sheets are there, by default, when we create a new Excel file ?
10.
When a workbook is marked as final it becomes read-only. This means that
11.
Comments can be added to cells using
12.
In a worksheet you can select at a time-
13.
Which command open Microsoft Excel?
14.
Which functionin Excel tells how many numeric entries are there ?
15.
In MS-Excel which of the following is an absolute cell reference?
16.
= TODAY () Returns the
17.
In MS-Excel what does SUMIF function do?
18.
Formulas in MS Excel must begin with-
19.
Statistical calculations and preparation of tables and graphs can be done using
20.
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.