More Spreadsheets

...is the description of the task that gives you information to design a spreadsheet.

• Briefcase

• Summary design

• Design brief

• Structure brief

Your teacher wants to calculate the grades for all the students in the class, which of the following software would you recommend to him?

• Word Processing

• Spreadsheet

• Presentation

• Reference

The pages of a spreadsheet application are called ____________?

• slides

• pages

• worksheets

• tabs

What is a formula in spreadsheet software?

• A part of a larger model

• A command to be carried out

• A rule that tells the computer what to do with the data

• A thing like SUM, AVERAGE and COUNTIF

A cell can contain text, values, and what else?

• Currency

• Percentages

• Formulae

• Dates

What function is used to add up a range of cells?

• +

• =

• SUM

• AVERAGE

What is the cell reference of the active cell?

1. Check the cell references which have a label

• A4

• B4

• C5

• E5

1. Which column letter contains the individual cost of ingredients? 

• A

• B

• C

• D

1. Which row number contains the spell name? 

• 4

• 3

• 1

• 2

• 5