Yr7 All Saints Exam Mon

An individual box within a worksheet is known as?

• square
• range
• reference
• cell

What is normally used to perform calculations in a spreadsheet?

• Variable
• Formula
• Conditional formating
• Macro

SUM, AVERAGE, MAX and VLOOKUP are examples of what?

• Functions
• Tables
• Formulae
• Statistical tools

When you write a formula in a spreadsheet what do you key in first?

• Subtraction sign
• Equals Sign
• Addition sign
• Division sign

Putting cells into A-Z order is called?

• Sort Ascending
• Sort Descending
• Filter Ascending
• Filter Descending

A spreadsheet is made of cells organised into horizontal rows and vertical?

• Columns
• Fields
• Records
• Blocks

I can find the lowest number in a range with the ... function

• MIN
• MAX
• AVERAGE
• COUNT

Which of the following is a valid formula?

• =sum(A1:A6)
• sum=(A1:A6)
• =sum[A1:A6]
• =sum(A1-A6)

What do you call the list of commands in Scratch? 

• Sprite
• Scripts
• Scratch
• Help

What do you call the characters in Scratch? 

• Sprites
• Script
• Scratch
• Sprite Scripts