wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Class VI

Total questions: 40

Worksheet time: 20mins

Name
Class
Date
1.

Excel is a:

a)

database application

b)

spreadsheet application

c)

word processing application

d)

none of the above

2.

The file extension for Excel:

a)

.pptx

b)

.docx

c)

.xlsx

d)

none of the above

3.

The "boxes" in Microsoft Excel are called...

a)

Griddies

b)

Boxes

c)

Cells

d)

Spreadsheets

4.

In Excel, the heading "boxes" going from left to right are called...

a)

Rows

b)

Columns

c)

Letters

d)

Headers

5.

In Excel, the heading "boxes" going from top to bottom are called...

a)

Rows

b)

Columns

c)

Numbers

d)

Headers

6.

The intersection of a row and a column is called this.

a)

Active Cell

b)

Chart

c)

Column

d)

Row

7.
Provides easy access to frequently used commands:
a)
group
b)
Quick Access Toolbar
c)
cell
d)
none of the above
8.

Microsoft Excel is categorized as a ________________ software.

a)

Database

b)

Spreadsheet

c)

Presentation

d)

Word Processing

9.

You accidentally erased a record in the sheet. What command can be used to restore it immediately?

a)

A. Insert

b)

B. Copy

c)

C. Undo

d)

D. Replace

10.

When you are typing data that is in a series, such as days of the week, you can use this tool to complete the series.

a)

A) AutoSum

b)

B) Custom Fill

c)

C)Fill Handle

d)

D)Ctrl+C

11.

A program using a table comprising of rows, columns and cells.

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

12.
Located on the left side or the entry bar, displays the active cell reference:
a)
entry bar
b)
cell reference
c)
name box
d)
none of the above
13.

1) Which cell is selected in this picture?

a)

B2

b)

B3

c)

C3

d)

m3

14.

?

a)

File

b)

save

c)

clear

15.

?

a)

minimize

b)

maximize

c)

exit/close

16.

1) A Row goes…

a)

across

b)

down

c)

cross

17.

A Column goes…

a)

across

b)

down

c)

cross

18.

What is a spreadsheet?

a)

An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.

b)

An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.

c)

An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.

d)

An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.

19.

Where is the zoom function located in Excel?

a)

Bottom right of spreadsheet document

b)

Bottom left of spreadsheet document

c)

Top right of spreadsheet document

d)

Top left of spreadsheet document

20.

What version of Excel are we using in class?

a)

Excel 2010

b)

Excel 2017

c)

Excel 2018

d)

Excel 2015

21.

What image represents Excel?

a)
b)
c)
d)
22.

What is the green bar at the top of Excel referred to as?

a)

the data bar

b)

the function bar

c)

the ribbon

d)

the row

23.

In Excel, Columns are labelled as ___

a)

A, B, C, etc

b)

1,2,3 etc

c)

A1, A2, etc

d)

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

24.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
25.
Each Excel file is called a workbook because
a)
It can contain text and data
b)
It can be modified
c)
It can contain many sheets including worksheets and chart sheets
d)
You have to work hard to create it
26.
You can edit a cell by...
a)
Clicking the formula button
b)
Double clicking the cell
c)
Selecting Edit>Edit Cell from the menu
d)
None of above
27.
A cell name contains
a)
Cell name
b)
Column numbers and row letters
c)
Column letters and row numbers
d)
Cell locator coordinates
28.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
29.
Can you format text with Excel
a)
Yes
b)
No
30.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
31.

Which of the following is a selected cell?

a)

current command

b)

default option

c)

active cell

d)

default cell

32.

2- The heading name of the selected column is

a)

E

b)

F

c)

G

33.

7- Choose the Correct Answer .

a)

Colour the background of a selected cell

b)

Change a column’s width

c)

Borders

34.

8- Choose the Correct Answer .

a)

Colour the background of a selected cell

b)

Change a column’s width

c)

Borders

35.

20- An easy way to change a column’s width is to drag the right border of the column heading.

a)

TRUE

b)

FALSE

36.

22- Each Cell has two names (e.g. B3 or 3B)

a)

TRUE

b)

FALSE

37.

26 - We cannot change the cell colour in the sheet

a)

TRUE

b)

FALSE

38.

27 - Spreadsheets (Excel) are used by Teachers to calculate marks and grades.

a)

TRUE

b)

FALSE

39.

30 - Spreadsheets (Excel) are used by Painters while drawing tables

a)

TRUE

b)

FALSE

40.

You accidentally erased a record in the sheet. What command can be used to restore it immediately?

a)

A. Insert

b)

B. Copy

c)

C. Undo

d)

D. Replace