Excel Quiz - Assessment

1.

Multiple Choice

30 sec

1 pt

Which functioning Excel tells how many numeric entries are there ?

NUM

COUNT

SUM

None of these

2.

Multiple Choice

30 sec

1 pt

Statistical calculations and preparation of tables and graphs can be done using?

Notepad

Power Point

Excel

Adobe Photoshop

3.

Multiple Choice

30 sec

1 pt

Which one is not a Function in MS Excel ?

SUM

MAX

MIN

AVG

4.

Multiple Choice

30 sec

1 pt

Functions in MS Excel must begin with ___

An Equal Sign

A Plus Sign

A > Sign

An () sign

5.

Multiple Choice

30 sec

1 pt

In Excel, Columns are labelled as ___

A, B, C, etc

1,2,3 etc

A1, A2, etc.

$A$1, $A$2, etc.

6.

Multiple Choice

30 sec

1 pt

Which bar show the used formula of selected active cell?

Menu bar

Ribbon

Formula bar

Scroll bar

7.

Multiple Choice

30 sec

1 pt

When all the number between 0 to 100 in a range should be displayed in Red color, Apply

Use =if() function to format the required number red.

Apply Conditional Formatting command on format Menu

Select the cell that contain number between 0 to 100 then click Red color on Text color tool

All of the above

8.

Multiple Choice

30 sec

1 pt

What function will produce results that indicate whether a student has passed or failed a course by enter the text "Pass" or "Fail"?

Count

IF

SUM

CountA

9.

Multiple Choice

30 sec

1 pt

Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array?

Lookup

VLookup

NOW

CountIF

10.

Multiple Choice

30 sec

1 pt

Which ONE of the following is not true?

Excel sheets have the extension *.doc

A new workbook is called Book 1

You can have Word and Excel open together

You can also create graph in excel sheets

11.

Multiple Choice

30 sec

1 pt

To Add up entries from D6 to D10, we use the formula?

=Add(D6:D10)

=Sum(D6:D10)

Both A & B

None of these

12.

Multiple Choice

30 sec

1 pt

The intersection of row and column is called?

Pointer

Cursor

Sheet

Cell

13.

Multiple Choice

30 sec

1 pt

Finds minimum value among a range of cell from A4, A5, A6, A7 and A8 in MS-Excel?

=MIN(A4 to A8)

=MIN(A4-A8)

=MIN(A4:A8)

All of the above

14.

Multiple Choice

30 sec

1 pt

Excel files have a default extension of?

XLW

XLS

DOC

WK1

15.

Multiple Choice

30 sec

1 pt

Which feature allows you to create specific rules?

Pivot Table

Sorting

Data Validation

None of these

Explore this activity with a free account