wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel MCQ Quiz

Total questions: 50

Worksheet time: 25mins

Name
Class
Date
1.

Which of the following is a spreadsheet software?

a)

MS Word

b)

MS Excel

c)

MS PowerPoint

d)

MS Access

2.

The intersection of a row and a column is called:

a)

Field

b)

Cell

c)

Box

d)

Range

3.

Every Excel formula starts with:

a)

=

b)

+

c)

–

d)

#

4.

The function used to add numbers is:

a)

COUNT

b)

SUM

c)

MAX

d)

MIN

5.

The function to get the highest value is:

a)

LARGE

b)

MAX

c)

TOP

d)

BIG

6.

A group of cells is called:

a)

Sheet

b)

Table

c)

Range

d)

Block

7.

A workbook contains:

a)

Only one worksheet

b)

One or more worksheets

c)

Only charts

d)

Only tables

8.

Shortcut for copying in Excel is:

a)

Ctrl + V

b)

Ctrl + Z

c)

Ctrl + C

d)

Ctrl + X

9.

Which function counts numeric values?

a)

COUNTA

b)

COUNT

c)

COUNTIF

d)

SUM

10.

Which chart shows data as percentages?

a)

Line Chart

b)

Pie Chart

c)

Column Chart

d)

Bar Chart

11.

Autofill handle is located at the:

a)

Top-left of the cell

b)

Bottom-right of the cell

c)

Bottom-left of the cell

d)

Top-right of the cell

12.

Ctrl + Z performs:

a)

Redo

b)

Undo

c)

Close

d)

Save

13.

To edit a cell, press:

a)

F1

b)

F2

c)

F4

d)

Esc

14.

The function used to find average is:

a)

AVG

b)

AVERAGE

c)

MEAN

d)

MEDIAN

15.

VLOOKUP searches data:

a)

Horizontally

b)

Vertically

c)

Randomly

d)

Backwards

16.

Which option removes duplicate values?

a)

Data Validation

b)

Sort

c)

Remove Duplicates

d)

Filter

17.

A formula that changes when copied is called:

a)

Absolute reference

b)

Mixed reference

c)

Relative reference

d)

Fixed reference

18.

Absolute cell reference uses:

a)

!

b)

%

c)

$

d)

&

19.

‘Sort & Filter’ is available in which tab?

a)

Insert

b)

Home

c)

View

d)

Review

20.

Default Excel file extension is:

a)

.docx

b)

.xlsx

c)

.pptx

d)

.txt

21.

Ctrl + S is used to:

a)

Copy

b)

Save

c)

Paste

d)

Print

22.

COUNTA function counts:

a)

Only blank cells

b)

Only numbers

c)

Non-empty cells

d)

Errors

23.

To freeze the top row/column, use:

a)

Split

b)

Hold

c)

Freeze Panes

d)

Lock Cells

24.

Conditional Formatting is used to:

a)

Apply colors based on conditions

b)

Create new worksheets

c)

Rename sheets

d)

Sort data

25.

Which chart is best for showing trends over time?

a)

Pie Chart

b)

Line Chart

c)

Bar Chart

d)

Donut Chart

26.

Which key moves the active cell up?

a)

Down Arrow

b)

Up Arrow

c)

Left Arrow

d)

Right Arrow

27.

What is the default row height in Excel?

a)

15

b)

12

c)

20

d)

25

28.

Which function returns the number of rows in a range?

a)

COUNT

b)

COUNTA

c)

ROWS

d)

LENGTH

29.

Which function is used to count blank cells?

a)

COUNTBLANK

b)

BLANKCOUNT

c)

COUNTIF

d)

EMPTY

30.

Which view is used to prepare page layout before printing?

a)

Normal View

b)

Page Break Preview

c)

Page Layout View

d)

Custom View

31.

A cell reference like A$1 is called:

a)

Absolute

b)

Relative

c)

Mixed

d)

Complex

32.

Which feature allows you to hide rows based on conditions?

a)

Table

b)

Filter

c)

Sort

d)

Format

33.

What does the COUNTIF function do?

a)

Counts blank cells

b)

Counts cells with numbers

c)

Counts cells based on a condition

d)

Counts all cells

34.

Shortcut to insert a new worksheet:

a)

Shift + F11

b)

F7

c)

Ctrl + W

d)

Alt + F2

35.

Which tab allows inserting charts?

a)

Home

b)

Insert

c)

Review

d)

Data

36.

Excel formulas cannot contain:

a)

Numbers

b)

Operators

c)

Text

d)

Spaces between arguments

37.

Which function gives the current date?

a)

DATE()

b)

TODAY()

c)

NOWDATE()

d)

CURRENT()

38.

Which function gives both date and time?

a)

DATE()

b)

TIME()

c)

NOW()

d)

TODAY()

39.

CONCATENATE function is used for:

a)

Adding numbers

b)

Joining text

c)

Sorting data

d)

Formatting cells

40.

Which is NOT a valid chart type in Excel?

a)

Pie

b)

Line

c)

Waterfall

d)

Radar

41.

Which bar displays the contents of the active cell?

a)

Status Bar

b)

Title Bar

c)

Formula Bar

d)

Menu Bar

42.

Excel’s default column width is:

a)

8.43

b)

10

c)

12

d)

15

43.

Which feature allows creating a summary report?

a)

Charts

b)

Pivot Table

c)

Function Wizard

d)

Filter

44.

Shortcut for paste special:

a)

Ctrl + V

b)

Ctrl + Shift + V

c)

Alt + E + S

d)

Ctrl + Alt + S

45.

How many columns are in Excel 2016 and later?

a)

16,384

b)

1,048,576

c)

10,000

d)

256

46.

How many rows are in Excel 2016 and later?

a)

100,000

b)

256

c)

1,048,576

d)

65,536

47.

Which Excel tool checks spelling?

a)

AutoCorrect

b)

Spell Check

c)

Review → Spelling

d)

Text Check

48.

Which function returns the smallest value?

a)

MIN

b)

SMALL

c)

LEAST

d)

LOWER

49.

To protect a worksheet, you use the:

a)

View tab

b)

File tab

c)

Review tab

d)

Data tab

50.

Which file format preserves formulas?

a)

.csv

b)

.txt

c)

.xlsx

d)

.pdf

Similar Resources on Wayground

Pivot Point: Master- Ch. 2 Microbiology, Infection Control, and First Aid

45 questions

Pivot Point: Master- Ch. 2 Microbiology, Infection Control, and First Aid

quiz

Worksheet

•

9th Grade - Professio...

Quiz for College ' Sangam'

50 questions

Quiz for College ' Sangam'

quiz

Worksheet

•

12th Grade - University

Severe Storm Readiness

47 questions

Severe Storm Readiness

quiz

Worksheet

•

KG - Professional Dev...