Yr 6 & 7 Basic Excel

A computer uses which type of program to organize and analyze data in tabular form?

• Word Processor

• Database

• Spreadsheet

• Graphics

What is the Icon for MS Excel?

• 
• 
• 
• 

A computer spreadsheet program is made up of what?

• cells

• squares

• circles

• packets

Directories in a computer are labelled with.....

• symbols

• letters

• numbers

• pictures

Rows in a computer spreadsheet program like Excel are labelled with........

• numbers

• letters

• pictures

• symbols

While working on a spreadsheet in your computer, you notice that all formulas start with.......

• *

• -

• +

• =

You are working on a spreadsheet on your computer. You need to add the values in cell A1 and A2. What formula would you use?

• =sum a1+a2

• =sum(a1+a2)

• sum(a1+a2)

• =(a1+a2)

You are working on a spreadsheet in Excel on your computer and you need to multiply two numbers. What symbol would you use to do this?

• x

• /

• *

• -

You are working on a spreadsheet in your computer's Excel program. You need to divide one cell's value by another. What symbol would you use to perform this operation?

• -

• *

• /

• =

A computer program has an Autosum button. What does this button do when used in the program?

• Adds a list of numbers

• Multiply a list of numbers

• Subtracts a list of numbers

• Divides a list of numbers