Year 9 Spreadsheets

What are the small boxes on a Spreadsheet called?

• Cell

• Format

• Absolute

• Column

• Row

What is the general term for changing the layout

or look of the cells in a spreadsheet?

• Formatting

• Editting

• Inserting

• Deleting

How can I combine more than one cell together?

• Merge

• Bold

• Underline

• Edit

What does EVERY formula need at the start, to make it work?

• $ sign

• =

• SUM

• Cell Name

If I want the spreadsheet to count up all the cells with a certain

letter or value in them, which function would be useful?

• CountA

• SUM

• *

• =

Which symbol would I use to multiply cells by each other?

• *

• /

• +

• =

Which symbol would I use to Divide cells by each other?

• *

• /

• +

• =

Which function is useful for adding lots of cells together?

• SUM

• +

• Product

• =

How can I change numbers in the cells to represent money in £ or $, for example?

• Currency

• Decimal

• Accounting

• Integer

If I want to multiply lots of cells by the SAME fixed cell, how can I do this?

• Absolule cell reference

• $ in front of the cell letter and number

• $ in front of the cell letter only

• $ in front of the cell number only