NEW
Font size
Worksheets[Tutorial 4] Exploring Spreadsheet
Total questions: 22
Worksheet time: 3hrs 20mins
Identify the name of the selected cell.
C2
A5
B3
E1
The section of a spreadsheet where a single row and a single column intersect is referred to as
point
cell
What do all formulae start with in Excel?
+
/
*
=
_____________ calculates something for you using the data in the cells.
Formula
Formatting
Which mathematical operator (symbol) would you use if you want to add the values in cells together?
/
-
+
=
Which mathematical operator (symbol) would you use to multiply the values in two cells together?
/
-
*
=
If you wanted to add the values in four consecutive cells together which function would you use?
SUM
MIN
MAX
AVERAGE
This function determines the total of the range of cells
=SUM( )
=AVERAGE( )
=MAX( )
=MIN( )
Which of the following is the formula that will add cells C9 and C10?
=C9+C10
sum(c9:c10)
Format cells as ______________ when working with amounts of money.
currency
percent
number
scientific
What is the purpose of spreadsheets?
To present information on different engaging slides
To deliver a speech to a crowd
To perform basic and complex mathematical calculations in an organized way
To excel your written work
What graph is this?
Bar graph
Pie Chart
Graphs
Line graph
What chart is this?
Line Chart
Pie Chart
Bar Chart
What graph is this
Pie
Line
Bar
According to this chart, in which month produces the highest cell?
June
March
November
May
According to this chart, which band sold the most albums?
Doug and the Slugs
Gails and the Snails
Sherm and the Worms
Marva and the Larva
We use ............ to make graph and chart.
Which snack is the most favourite?
Popcorn
Cheese
Vegetable
Fruit
Which tool can you use to combine two or more cells into one large cell?
Merge & center
Combine
Join
Wrap text
Which function should be entered to calculate the total budget?
=AVERAGE(B3:B6)
=SUM(B3:B6)
=SUM(B3-B6)
=TOTAL(B3:B6)
