wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

quiz on excel

Total questions: 25

Worksheet time: 13mins

Name
Class
Date
1.

The default MS Excel file extension is:

a)

.XLR

b)

.XEXL

c)

.XLS

d)

.EXE

2.

the intersection of a row and column is called:

a)

box

b)

cell

c)

grid

d)

row

3.

An excel worksheet can have a minimum of _______ number of rows

a)

1048576

b)

90908

c)

10875

d)

1000

4.

the collection of worksheets is called:

a)

workbook

b)

excel sheets

c)

work sheets

d)

my notebook

5.

in excel each sheet in a workbook is displayed as:

a)

Tab

b)

Marker

c)

Arrow point

d)

Window

6.

Ctrl+Pg will take you to:

a)

last used cell

b)

previous sheet

c)

next sheet

d)

last cell in a row

7.

Ctrl+O is equivalent to :

a)

saving a file

b)

delete a file

c)

open a new file

d)

open an existing file

8.

which command in excel is used to close a window of excel?

a)

Alt+F4

b)

Ctrl+R

c)

Ctrl+W

d)

Alt+f7

9.

which one is the shortcut key to save:

a)

F2

b)

F1

c)

Ctrl+S

d)

Ctrl+R

10.

which one is the shortcut key to go to option in Excel:

a)

F9

b)

F7

c)

F8

d)

F5

11.

Which is the shortcut key to cut a object:

a)

Ctrl+X

b)

Ctrl+R

c)

Ctrl+v

d)

Ctrl+o

12.

which shortcut key is used to reach the next worksheet:

a)

page down

b)

Ctrl + ->

c)

page up

d)

tab

13.

which shortcut command is used to insert the current time:

a)

Alt+T

b)

Alt+Shift+T

c)

Ctrl+:

d)

Shift + T

14.

which command is used to calculate the total characters in a cell:

a)

len

b)

length

c)

mid

d)

sid

15.

which key is used for HELP in excel:

a)

F1

b)

F2

c)

F3

d)

None of These

16.

Ctrl+l is used for:

a)

formatting cell

b)

auto fill

c)

change the contents of a cell to italic

d)

go to options

17.

by which command we can attach another package file in excel:

a)

name

b)

comment

c)

object

d)

hyperlink

18.

by which option we can show and print the grislines:

a)

page setup

b)

auto format

c)

style

d)

format

19.

which sign is used to enter formulae:

a)

/

b)

.

c)

=

d)

+

20.

how many chart types are available in excel:

a)

24

b)

14

c)

18

d)

39

21.

which function in excel tells how many numeric entries are there

a)

num

b)

Auto Sum

c)

count

d)

avg

22.

what type of chart will you use to compare performance of 2 employees in a year:

a)

column chart

b)

line chart

c)

pie chart

d)

dot chart

23.

which one is not a function in Excel:

a)

sum

b)

Avg

c)

max

d)

min

24.

functions in MS excel must begin with:

a)

An() Sign

b)

An Equal Sign

c)

A plus sign

d)

A > sign

25.

the process of arranging the items of a column in some sequence or order is called:

a)

Arranging

b)

auto fill

c)

filtering

d)

sorting