wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Midterm Test Part 1

Total questions: 35

Worksheet time: 33mins

Name
Class
Date
1.

a)

Google Spreadsheet

b)

Microsoft Excel

2.

How are cells defined in a spreadsheet?

a)

By their color

b)

By the intersection of rows and columns

c)

By the data inputted

d)

By the presence of formulas

3.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
4.
The little triangle in the top right corner of a cell means there is a ________ with that cell.
a)
formula
b)
number
c)
letter
d)
note
5.

What is a range in a spreadsheet?

a)

A selection of multiple cells

b)

A set of randomly selected cells

c)

A group of cells with the same content

d)

A range of numeric values in a column

6.

What role do sheets play in a spreadsheet application?

a)

Sorting data alphabetically

b)

Managing formulas

c)

Formatting cells

d)

Organizing and managing different sets of data

7.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
8.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
9.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
10.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format
11.

What is the name of the yellow highlighted area?

a)

Task bar

b)

Formula bar

c)

Tool bar

d)

Functions

12.

Using cell references, select the correct formula for calculating the initial cost of goldfish.

a)

=b9*c9

b)

b9*c9

c)

.25*6

d)

=.25*6

13.

THE __________ FUNCTION IS USED TO FIND THE MAXIMUM VALUE FROM A SET OF VALUES

a)

MAX( )

b)

MIN( )

14.

A ___________ IS AN EQUATION TO SOLVE A MATHMATICAL PROBLEM.

a)

FUNCTION

b)

FORMULA

c)

CELL

d)

ROW

15.

A GROUP OF CELLS IN A WORKSHEET IS CALLED A _______________

a)

COLUMN

b)

ROW

c)

RANGE

d)

FORMULA

16.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
17.
All functions and formulas begin with which symbol?
a)
#
b)
/
c)
:
d)
=
18.
Which of the following is a FORMULA that will add cells c9 and c10?
a)
=c9+c10
b)
c9+c10
c)
sum(c9:c10)
d)
=sum(c9:c10)
19.

Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

a)

COUNT

b)

COUNTA

c)

SUM

d)

AVERAGE

20.

This function in Google Sheets finds the middlemost number when arranged in an increasing or decreasing order.

a)

Mean

b)

Average

c)

Median

d)

Mode

21.

With this tool, you can easily highlight low or high values that require attention.

a)

Sparkline

b)

Conditional formatting

c)

Filter

d)

Charts

22.

Identify the name of this function

a)

conditional formatting

b)

data visualization

c)

chart

d)

sparkline

23.

Identify the name of this tool.

a)

Sort

b)

Filter

c)

Conditional formatting

d)

Sparkline

24.

What are cells in a spreadsheet?

a)

Formulas used in calculations

b)

Basic building blocks

c)

Graphs and charts

d)

Cell formatting options

25.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
26.

Text wrapping in Sheets means the text will be on more than 1 line within the same cell.

a)

True

b)

False

27.

You can have multiple sheets within the same Google Sheet document.

a)

True

b)

False

28.

It is possible to insert images in Google Sheets

a)

True

b)

False

29.

Google Sheets is used to?

a)

Add numbers.

b)

Make charts (graphs).

c)

Put information in columns and rows.

d)

Collect Data

30.

The correct formula to add cell B1 and B2 is

a)

AddB1+C1

b)

=add(b1:b2)

c)

=B1+B2

d)

=total(B1-B2)

31.
What value would you get if you put in the formula: =B1+C1
a)
2
b)
3
c)
4
d)
Error
32.

Identify the name of this tool.

a)

Filter

b)

Formulas

c)

Images

d)

Charts

33.

What does this function do?

a)

Sums up cells A1 to A4

b)

Converts A1 to to 2

c)

Converts 234 to binary number

d)

Converts 123 to Base 2 number

34.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A1+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
35.
SUM, AVERAGE, MAX and MIN are preset formulas on the _______________ menu.
a)
filter
b)
functions
c)
border
d)
fill color

Similar Resources on Wayground

ICT-Department-Grade4-November

40 questions

ICT-Department-Grade4-November

quiz

Worksheet

•

4th Grade - University

ĐỀ CƯƠNG ÔN TẬP GIỮA KỲ II TIN 6 NH 24-25

40 questions

ĐỀ CƯƠNG ÔN TẬP GIỮA KỲ II TIN 6 NH 24-25

quiz

Worksheet

•

6th Grade

Spreadsheet Basics

35 questions

Spreadsheet Basics

quiz

Worksheet

•

6th - 8th Grade

MS office 2016

40 questions

MS office 2016

quiz

Worksheet

•

1st Grade - Professio...

Components/Network Types Review 1

33 questions

Components/Network Types Review 1

quiz

Worksheet

•

6th - 8th Grade

Types of software - Class 6

30 questions

Types of software - Class 6

quiz

Worksheet

•

6th Grade

Tech Readiness Test #1

40 questions

Tech Readiness Test #1

quiz

Worksheet

•

6th - 8th Grade