1.
In MS-Excel which functions will calculate the number of workdays between 6/9/2021 and 8/12/2021
2.
Merge and center option merge all selected cells into a single cell retaining only the contents of the:
3.
An Excel file is generally called a / an :
4.
In MS-Excel what does SUMIF function do?
5.
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.
6.
In MS-Excel which elements of worksheet can be protected from accidental modification?
7.
A features that displays only the data in column's according to specified criteria
8.
By default, MS Excel shows ______ characters in a column
9.
In Excel, Rows are labelled as ____
10.
What type of chart will you use to compare performance of two employees in the year 2021 ?
11.
In MS-Excel which of the following is an absolute cell reference?
12.
What is the name of intersection of a column and a row on a worksheet?
13.
In the formula = A14 / B14 + C5 – D6*8 which calculation is performed first?
14.
Which functionin Excel tells how many numeric entries are there ?
15.
When a workbook is marked as final it becomes read-only. This means that
16.
= TODAY () Returns the
17.
In a worksheet you can select at a time-
18.
Excel files have a default extension of
19.
How many sheets are there, by default, when we create a new Excel file ?
20.
In Excel, which one denoted a range from A1 through D15
Your quiz time is about to finish. Few seconds left.
