wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Grade 6-s2-a2-spreadsheet

Total questions: 33

Worksheet time: 19mins

Name
Class
Date
1.

Spreadsheets are made in

a)

Word

b)

Excel

c)

PowerPoint

d)

Firefox

2.

Spreadsheets are usually used to calculate numbers. To make the calculations, we write:

a)

programs

b)

applications

c)

formulas

d)

math

3.

Which will calculate an average?

a)

= A5+A6+A7

b)

= (A5 + A6 + A7) / 8

c)

= (A567 AVERAGE)

d)

= (A5 + A6 + A7) / 3

4.

A good way to show numbers in spreadsheets is to use

a)

graphs

b)

borders

c)

cells

d)

number fonts

5.

Use this spreadsheet to answer these questions.

How many people bought League of Legends?

a)

5

b)

0

c)

3

d)

none of them

6.

Use this spreadsheet to answer these questions.

How much profit does Bob get from each Minecraft sold?

a)

150.000 VND

b)

100.000 VND

c)

75.000 VND

d)

3

7.

Use this spreadsheet to answer these questions.

How much total profit does Bob get from Candy Crush?

a)

0

b)

75.000 VND

c)

150.000 VND

d)

100.000 VND

8.

Use this spreadsheet to answer these questions.

What should the formula be for cell E5?

a)

=C5*D5

b)

=sum(C5:D5)

c)

=average (C5:D5)

d)

none of them

9.

Use this spreadsheet to answer these questions.

What would the value be for the total number sold?

a)

8

b)

5

c)

3

d)

=sum(C3:C5)

10.
Spreadsheet rows are easily identified by:
a)
a. numbers.
b)
b. letters.
c)
c. Roman numerals.
d)
d. colors.
11.
Spreadsheet columns are easily identified by:
a)
a. Roman numerals.
b)
b. numbers.
c)
c. letters.
d)
d. colors.
12.
An individual box within a worksheet is known as?
a)
square
b)
range
c)
refernce
d)
cell
13.
What is normally used to perform calculations in a spreadsheet?
a)
Variable
b)
Formula
c)
Conditional formating
d)
Macro
14.

When we write formulas, which sign do we start with?

a)

Subtraction sign

b)

Equal Sign

c)

Addition sign

d)

Division sign

15.
In Excel, what do all formula begin with?
a)
!
b)
-
c)
+
d)
=
16.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
17.
What is displayed in cell A6?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
18.
What is displayed in cell B1?
a)
100
b)
Tickets Sold
c)
Day
d)
B1
19.

Which of the following operators (symbols) represent adding in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

20.

Which of the following operators (symbols) represent subtracting in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

21.

Which of the following operators (symbols) represent multiplication in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

22.

Which of the following operators (symbols) represent division in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

23.
What is the name of a computer program used for organising information in rows and columns?
a)
Spreadsheet
b)
Presentation
c)
Publisher
d)
Browser
24.
What would you format a cell as when working with amounts of money?
a)
currency
b)
percent
c)
number
d)
scientific
25.
What do you call the box where a row and column intersect?
a)
Jail
b)
Gaol
c)
Cell
d)
Box
26.
Which of the following is an absolute cell reference?
a)
A2
b)
$A$2
c)
#A#2
d)
A:2
27.
To select a group of cells, you must click each cell individually until all cells in the range are selected. 
a)
True
b)
False
28.
Portrait and Landscape are two types of what?
a)
Arrangements
b)
Orientation
c)
Margins
d)
Page Breakas
29.
Place where you can rename each worksheet.  Located at the bottom of the worksheet window.
a)
sheet tab
b)
formula
c)
Name Box
d)
Chart
30.
A single sheet contained in an excel workbook.
a)
worksheet
b)
workbook
c)
Chart
d)
sheet tab
31.
The cell in the worksheet in which you can type data.
a)
formula
b)
cell
c)
Name Box
d)
active cell
32.
 Microsoft Excel is:
a)
 A word processing program designed to create letters, documents, or reports.
b)
A program designed to create notes and presentations.
c)
A program that creates spreadsheets that combines worksheets, graphics, and data management into a single program.
33.
A group of selected cells is called the
a)
Cell Block
b)
Multi-cell
c)
Range

Similar Resources on Wayground

Quiz PHP

30 questions

Quiz PHP

quiz

Worksheet

•

11th Grade

Test Primeros

29 questions

Test Primeros

quiz

Worksheet

•

8th Grade

Ulangan Mapel Informatika Kelas 7-1

30 questions

Ulangan Mapel Informatika Kelas 7-1

quiz

Worksheet

•

7th Grade

Quiz Herramientas TIC

30 questions

Quiz Herramientas TIC

quiz

Worksheet

•

12th Grade

ĐỊNH DẠNG - TRÌNH BÀY- IN TRANG TÍNH

32 questions

ĐỊNH DẠNG - TRÌNH BÀY- IN TRANG TÍNH

quiz

Worksheet

•

7th Grade

TIN 9 ÔN TẬP CUỐI KỲ 1

28 questions

TIN 9 ÔN TẬP CUỐI KỲ 1

quiz

Worksheet

•

9th Grade - University

Latihan Informatika

28 questions

Latihan Informatika

quiz

Worksheet

•

10th Grade

OCTAVO TECNOLOGIA

30 questions

OCTAVO TECNOLOGIA

quiz

Worksheet

•

8th Grade