1.
Which functionin Excel tells how many numeric entries are there ?
2.
By default, MS Excel shows ______ characters in a column
3.
Which of the following options is not located in the Page Setup dialog box?
4.
In the formula = A14 / B14 + C5 – D6*8 which calculation is performed first?
5.
How many sheets are there, by default, when we create a new Excel file ?
6.
The process of arrenging the items of a column in some sequence or order is known as-
7.
In Excel, Rows are labelled as ____
8.
In MS-Excel which functions will calculate the number of workdays between 6/9/2021 and 8/12/2021
9.
=NOW () Returns the current time
10.
An Excel file is generally called a / an :
11.
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.
12.
When a workbook is marked as final it becomes read-only. This means that
13.
= TODAY () Returns the
14.
In MS-Excel which of the following is an absolute cell reference?
15.
The Greater Than sign (>) is an example of _____ operator.
16.
What type of chart is useful for comparing values over categories ?
17.
In MS-Excel which elements of worksheet can be protected from accidental modification?
18.
How do you select an entire column?
19.
Statistical calculations and preparation of tables and graphs can be done using
20.
Which of the following syntax is correct regarding to SUM function in Excel ?
Your quiz time is about to finish. Few seconds left.
