Font size
WorksheetsExcel Spreadsheet Fun (2nd)
Total questions: 20
Worksheet time: 11mins
What program is used to create spreadsheets?
Word/Google Doc
Publisher
Excel/Google Sheets
PowerPoint/Google Slides
What are the boxes (where we enter formula) within a spreadsheet called?
Cells
Cubes
Rectangles
Sqaures
The most useful functions of a spreadsheet are:
Lines and pictures
Fonts and borders
Formulas and graphs
Labels and envelopes
Mathematical calculations in a spreadsheet are called
Formulas
Values
Words
Functions
Which of the following is an example of an addition formula?
=B4+D7
=2+3+6=11
=F3*G7
=B9/B6
Which of the following is an example of subtraction formula?
=A-B
=£14.00 - £5.00=£9.00
=B9/B6
=C10 - B9
Which of the following is an example of a multiplication formula?
=L3 * C7
=B2 + B3/ C4
=B4 x B6
=46 x 39
Which of the following cannot be completed using spreadsheet?
Create a graph comparing class attendance
Create a brochure for the band camp
Track batting averages for the school rounders club
Keep track of field trip payments for the class trip
By default how do numeric values appear when entered in a spreadsheet?
Left aligned
Right aligned
Centered
Unaligned
Select the application for which a spreadsheet would be most appropriate:
Creating a flyer
Playing computer games
Preparing management reports
Calculating monthly income and expenditure
Which of the following is an example of division formula?
=A1-B2
=£14.00 - £5.00=£9.00
=B9/B6
=C11 - B11
Which is a financial function that calculates the payment for a loan based on a constant interest rate, the number of periods and the loan amount.
SUM
COUNT
PMT
PV
Which function allows you to add individual values, cell references or ranges or a mix of all three.
SUM
PMT
COUNT
MIN
Which image below would you select to merge and center?
Based on the image shown. Identify the direction of the text.
45 degrees
-45 degrees
0 degrees
90 degrees
Identify the type of graph represented in the picture.
Pie
Scatter
Line
Column
Identify the type of graph represented in the picture.
Pie
Scatter
Line
Column
A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.
True
False
Identify the cell reference below.
='Car Payment'!G20
='Car Payment'!C19+'Car Payment'!I19
=SUM(A1:A3)
Refer to the image shown. This picture depicts the following:
An image inserted in a cell
An image inserted over cells
