wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Ch- Electronic Spreadsheet -MS Excel

Total questions: 23

Worksheet time: 13mins

Name
Class
Date
1.

Example of spreadsheet software

a)

Ms access

b)

Lotus 1-2-3

c)

Powerpoint

d)

Lotus 32-4

2.

The workbook created in Ms excel 2013 has a file extension (a)   .

3.

A Worksheet contains____________ rows.

a)

1048576

b)

1058786

c)

1049786

d)

infinity

4.

A worksheet contains _____________ columns.

a)

16384

b)

15384

c)

infinity

d)

Or it was wiped up by Thanos snap, So its 0

5.

The columns are given label from ______ to _____.

a)

A

b)

B

c)

XFD

d)

ZZZ

6.

The first workbook opened in ms excel is named as __________.

a)

book 1.xlsx.

b)

Sheet 1

c)

Ironman

7.

Trivia question:-

S.H.I.E.L.D full form

a)

Strategic Homeland Intervention, Enforcement and Logistics Division

b)

Senior Homeland Intervention Secondary Recruits

c)

I don't know 

d)

It is out of the syllabus

8.

The cell address appears on the left side of the formula bar in a box that is known (a)   .

9.

The panel on the top of the excel window, just below the title bar, is known as _______.

a)

Ribbon

b)

Cell address

c)

The panel on the top of the excel window, just below the title bar, is known as my window.

10.

Shortcut key Ctrl + Page Up

is used for what?

a)

Moves to the previous page

b)

Move to next sheet

11.

Shortcut key Ctrl + Page down

is used for what?

a)

Move to the previous sheet

b)

Move to the next sheet

12.

What to do to copy a nd moving worksheet ?

a)

click on move or copy option

b)

do magic

c)

call ironman

d)

call bill gates ( correct answer )

13.

 The short cut key used to move to next cell

a)

next

b)

tab

c)

enter

d)

Say Friday ( AI) to move to the next cell

14.

How can we type special number  in cell

a)

using colon

b)

using apostrophe

c)

using caps lock

d)

type hulk the strongest avenger

15.

.Which one amongst the following is Spreadsheet based Software–

a)

MS excel

b)

Google Spreadsheet

c)

both

16.

Which symbol is used to begin any formula in excel?

(a)  

17.

The (a)   cell has thick border around it

18.

Write the  formula to find total of pencil and eraser ,if pencil price is written in C5 and eraser price in D6? Write the formula .

(a)  

19.

Which feature of excel can be used to fill the numbers automatic

(a)  

20.

Which shortcut is used to insert current date in excel.

(a)  

21.

Which shortcut is used to insert current time in excel ?

(a)  

22.

A range always ______ in shape

a)

square

b)

rectangle

c)

triangle

d)

i don't care

23.

How many types of data can be entered in ms excel?

a)

Numeric data

b)

Text data

c)

Formulae

d)

only classified data can be only entered in ms excel