Spreadsheet

Businesses use spreadsheets for all of the following EXCEPT:

• Produce financial documents such as estimates and invoices

• Represent data in graphical format

• Produce statistical reports e.g. to compare quantities of goods

• Make presentations to an audience

In a spreadsheet document each page is called a:

• worksheet

• label

• cell

• address

Mr. Janes wants to create an a document in Excel, which icon will get him there?

• 
• 
• 
• 

The files that are created with Spreadsheet software are called

• Package

• Program

• Workbook

• Word

The bar below will allow you to insert a ......

• spreadsheet

• answer

• formula

• quizz

This section of the worksheet shows the .....

• formula

• value

• cell function

• cell address

The cells are identified by their:

• Row and column position

• row position

• column

• row

C4, F5, B7 are all examples of:

• cell reference

• column number

• row number

• cell address

The correct formula to find average is:

• average(cells)

• =avg(range of cells)

• =average(range of cells)

• average(range of cell)=

Which of these formulae will calculate the sum of a range of cells A4 to D4:

• =sum(A4 to D4)

• sum of A4 - D4 =

• Add A4 to D4 =

• =sum(A4:D4)