wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

2nd Term Quiz Gr6

Total questions: 80

Worksheet time: 37mins

Name
Class
Date
1.

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

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

2.

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

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

3.

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

a)

Active Cell

b)

Chart

c)

Column

d)

Row

4.

In Excel, rows are identified by this

a)

Letters

b)

Numbers

5.

Which is NOT a term used in Excel?

a)

Workbook

b)

Worksheet

c)

Cell

d)

Document

6.
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
7.
What is this?
a)
active cell
b)
column
c)
cell
d)
none of the above
8.
Provides easy access to frequently used commands:
a)
group
b)
Quick Access Toolbar
c)
cell
d)
none of the above
9.
This is a:
a)
ribbon
b)
group
c)
tab
d)
none of the above
10.

Microsoft Excel is categorized as a ________________ software.

a)

Database

b)

Spreadsheet

c)

Presentation

d)

Word Processing

11.

The bar where information appears as you input data is called ______________.

a)

file bar

b)

help bar

c)

window bar

d)

formula bar

12.

This is a

a)

Wrap text

b)

Merge & Center

c)

Copy

d)

Paste

13.

This is to

a)

Wrap text

b)

Merge & Center

c)

Add border

d)

Paste

14.

This is to

a)

Wrap text

b)

Change color

c)

Add border

d)

Paste

15.

This is to change

a)

Width

b)

Height

c)

Font color

16.

This is to change

a)

Width

b)

Height

c)

Font color

17.

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

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

18.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
19.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
20.
Numbers in Excel is automatically aligned  ____.
a)
Right
b)
Left
c)
Center
d)
Justify
21.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
22.
This is a
a)
Column
b)
Row
c)
Cell
d)
Range
23.
The area within the red box is called
a)
Active Cell
b)
Fill Handle
c)
Cell
d)
Row
24.

Excel file is saved as a ____________

a)

Document

b)

workbook

c)

worksheets

d)

Presentation

25.

Name of the workbook is displayed in the ___________

a)

Menu bar

b)

Title bar or ribbon

c)

Tool bar

d)

option bar

26.

The name box or the address bar contains

a)

Formulas

b)

menu options

c)

Cell address

d)

Numbers

27.

Numbers in the worksheet represent

a)

data

b)

columns

c)

rows

d)

functions

28.

Define Cell?

a)

The dark bordered box in excel.

b)

A box in Excel that has formulas.

c)

The intersection of a column or row in a worksheet or table.

d)

Fx Bar where you input data

29.

1. What is the "Active Cell" in Excel?

a)

The Bottom cell in a worksheet. It is indicated by a dark border onscreen

b)

The current cell in a worksheet. It is indicated by a dark border onscreen.

c)

The top cell in a worksheet. It is indicated by a dark border onscreen

d)

The past cell in a worksheet. It is indicated by a dark border onscreen

30.

1) Which cell is selected in this picture?

a)

B2

b)

B3

c)

C3

d)

m3

31.

?

a)

File

b)

save

c)

clear

32.

1) A Row goes…

a)

across

b)

down

c)

cross

33.

A Column goes…

a)

across

b)

down

c)

cross

34.

?

a)

minimize

b)

maximize

c)

exit/close

35.

What is spreadsheet?

a)

The cell address

b)

The mouse pointer

c)

The grid you see on the screen

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

A computer application that displays and organizes data is called __________.

a)

PowerPoint Presentation

b)

Publisher

c)

Electronic Spreadsheet

d)

Word

38.

The rows in the spreadsheet represents the ___________.

a)

Numbers

b)

Letters

c)

Vowels

d)

Consonants

39.

The columns represent the ____________.

a)

Rows

b)

Numbers

c)

Letters

d)

Columns

40.

This is the intersection point of a column and row.

a)

Cell Address

b)

Cell Number

c)

Cell

d)

Cell Sheet

41.

An individual box which contains data.

a)

Cell Address

b)

Cell Sheet

c)

Cell

d)

Cell Number

42.

All of the following are the uses of MS Excel, EXCEPT:

a)

Used for Calculations

b)

Managing inventory

c)

Presenting videos and audio

d)

Collecting data from different sources

43.

This is the file where data is stored in Excel.

a)

Workbook

b)

Folder

c)

Worksheet

d)

Publisher

44.

Numeric data used in calculations is called _________.

a)

Numeric

b)

Value

c)

Text

d)

Formula

45.

What do you call the entries that have no value associated with them?

a)

Formula

b)

Text

c)

Value

d)

Art

46.

In which tab can you find the Merge and Center?

(a)  

47.

 A -------------------- is a document that stores data in a grid of horizontal rows and vertical columns.

a)

Row

b)

Spreadsheet

c)

Minus

d)

Plus

48.

Horizontal line of cells is

a)

Row

b)

Column

49.

A small box that holds data

a)

Row

b)

Column

c)

Cell

50.

 a vertical line of cells is

a)

Row

b)

Column

51.

Spreadsheet computer program such as

a)

Microsoft word

b)

Microsoft Excel

c)

Google Sheets

d)

Microsoft Access

52.

a computer program that imitates a paper worksheet

a)

Video Game

b)

Spreadsheets

c)

Typing

d)

Cell

53.

You can use the spreadsheet for:

Collect data.

a)

False

b)

True

54.

You can use the spreadsheet for:

Analyze information and produce graphs.

a)

True

b)

False

55.

The text are used to show what values is

a)

Values

b)

Labels

c)

Title

56.

The number are used in calculations

a)

Labels

b)

Values

c)

Numbers

57.

To add up the total cost of the price, You use

a)

AutoSum Function

b)

A divide Formula

58.

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

a)

Column

b)

Value

c)

Address

d)

Cell

59.

In Excel, Columns are labelled as ___

a)

A, B, C,...

b)

1,2,3,....

c)

A1, A2,....

d)

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

60.

How many sheets are there, by default, when we create a new Excel file ?

a)

1

b)

2

c)

3

d)

4

61.

If we want to copy and paste some range of cells then no need to hold the control key along with the drag and drop process.

a)

True

b)

False

62.

What happened when you press ctrl+X after selecting some cells from excel.

a)

The content of selected cells got disappeared.

b)

The cells selected are marked for cutting

c)

The selected cells are deleted and shifted left

d)

The selected cells are deleted and shifted up

63.

Which of the following cell pointer is used to select the cells ?

a)
b)
c)
d)
64.

Shortcut method for cut and paste.

a)

Ctrl+ C, Ctrl +V

b)

Ctrl+X, Ctrl+V

c)

Ctrl+F

d)

F4

65.

The name box on to the left of the formula bar.

a)

Shows the name of the workbook.

b)

Shows the name of the worksheet

c)

Shows the name of the cell

d)

None of the above

66.

A _____________ is a document that stores data in a grid of horizontal rows and vertical columns.

a)

Row

b)

Spreadsheet

c)

Minus

d)

Plus

67.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
68.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign 
69.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
70.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
71.
In Excel it means Add
a)
Plus sign
b)
sort 
c)
Forward slash 
d)
asterisk 
72.
a vertical line of cells
a)
Maximum
b)
Minimum 
c)
Column 
d)
Formulas
73.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell Address
b)
Worksheet
c)
Formula
74.
What is the Formula sign for multiply? 
a)
\
b)
*
75.

In Excel, columns are labeled by?

a)

Numbers

b)

Letters

76.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
77.
A3 is an example of a cell's address
a)
true
b)
false
78.
Which symbol must you use to begin a formula?
a)
+
b)
=
c)
/
d)
*
79.

It is an Excel tool used to combine 2 or more cells together

a)

Merge and Center

b)

Center

c)

Align Left

d)

Justify

80.

In Excel, rows are labeled by ________.

a)

Letters

b)

Numbers

c)

Alphanumeric characters

d)

Special characters