wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS EXCEL

Total questions: 20

Worksheet time: 11mins

Name
Class
Date
1.

Ribbon is a collection of_____________ tabs

a)

Ten

b)

Eight

c)

Four

d)

Five

2.

Key combination to move to the adjacent cell on the left

a)

Shift + Tab

b)

Ctrl + Home

c)

Ctrl + G

3.

Tab that provides the facility for sorting

(a)  

4.
a)

Title bar

b)

Quick acces toolbar

c)

Formula bar

5.

What is IF?

a)

Takes 3 arguments

b)

Checks a condition takes a suitable action

c)

Collection of unarranged facts

d)

Task that is performed to produce a result

6.

Evaluate condition such as x > 5 and give the result as true or false

a)

text function

b)

financial function

c)

logical function

7.

the shorthand used by Microsoft to refer to excel is

(a)  

8.

Microsoft originally marketed spreadsheet program called__________

a)

Multiplan

b)

Built in functions

c)

Arguments

9.

a formula in Excel always begins with ________symbol

a)

=

b)

+

c)

#

10.

The columns are named using the (a)  

11.

Data in a cell is a

a)

Text

b)

Symbol

c)

Number

d)

Formula

12.

Name the Element where the mouse is pointed

a)

worksheet

b)

ribbon

c)

formula bar

13.

appears at the bottom right corner of almost every command group

a)

tabs

b)

command button

c)

dialog box launcher

14.

The command that takes existing cell entries and replicates them in other cells is called__________

a)

cut

b)

paste

c)

copy

d)

redo

15.

In Excel, Rows are labelled as ______

a)

1,2,3

b)

A,B,C

c)

A1, A2

16.

The process of arranging the items of a column in some sequence or order is known as

a)

database

b)

sorting

c)

autofill

17.

Which one is not a Function in MS Excel ?

a)

SUM

b)

AVG

c)

MAX

d)

MIN

18.

What is the intersection of a column and a row on a worksheet called ?

a)

Cell

b)

Column

c)

Address

19.

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

a)

Excel

b)

Power point

c)

Word

20.

function that helps us to locate specific values in specific cells

a)

look and reference function

b)

information function

c)

database function