RSCIT iLearn Assessment - 9
(Microsoft Excel)

1  Which one is not a Function in MS-Excel?

A. MAX

B. AVG

C. MIN

D. SUM

2  Look at the Picture and choose the correct answer which should be displayed in cell D2 -

A. 16

B. 160

C. 26

D. none of these

3  Which of the following is not valid data type in MS-Excel?

A. Number

B. Character

C. Label

D. Date/Time

4  The highlighted drop-down handle provides options to-

A. Auto-hide Ribbon

B. Show Tabs and Commands

C. Option 1 and 2 both

D. none of these

5  Formula in Excel start with-

A. %

B.  +

C.  =

D.  -

6  Which of the following formula is not entered correctly in Excel?

A.  = 97 + 445

B.  =C8*B1

C. 97+45

D.  =C9+16

7  In Excel Columns are labelled as …………… ?

A. 1,2,3…… etc.

B. A1, A2 etc.

C. $A1, $A2 etc.

D. A,B,C…….. Etc.

8  Kintan wanted to use DSUM function in his Database file, He used that in his file. In the example depicted in the picture, what would be the result of used formula?

A. 72

B. 23

C. Delhi

D. none of these

9  Which menu option can be used to split windows into parts in MS-Office 2019?

A. Review > Window > Split

B. Page Layout > Split

C. Review > Split

D. View > Split

10  In the picture given below, in Cell A1 the worksheet title is visible but Suresh wants it to be appeared in the center from Cell A1 through to Cell F1, What should Suresh do for that?

A. Write the title in cell C1

B. Select Cell A1 to Cell F1 and then Press Merge & Center Button

C. Select Cell A1 to Cell F1 and then Center Align the title

D. Write the title in Cell C1 then Increase the Indent

11  Which function is used to count the number of cells that meet a specified condition?

A. COUNT

B. SUM

C. IF

D. COUNTIF

12  In MS Excel 2019 how do you rearrange the data is ascending or descending order?

A. DATA->FORM

B. DATA->TABLE

C. DATA->SORT

D. DATA->SUBTOTAL

13  The Excel 2019 s Start screen that appears straightaway after launching the program, contains

A. List of most recently opened workbooks

B. Thumbnails of different templates to create new workbook

C. Option 1 & 2 Both

D. None of these

14  How does the HLOOKUP function differ from the VLOOKUP function in Excel 2019 ?

A. HLOOKUP searches horizontally, while VLOOKUP searches vertically

B. HLOOKUP is used for text, and VLOOKUP is used for numbers

C. HLOOKUP always returns an exact match, while VLOOKUP can return an approximate match

D. HLOOKUP and VLOOKUP are interchangeable; they perform the same function

15  Which Excel 2019 feature is used for visually representing data through bars, lines, or pie slices?

A. Conditional Formatting

B. PivotTables

C. Charts

D. Data Validation

16  What does the Excel 2019 function COUNTA() do?

A. Counts the number of cells in a range that are not empty

B. Adds up the values in a range

C. Finds the average of a range

D. Multiplies the values in a range