Excel Spreadsheet Fun (2nd)

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