Font size
WorksheetsYr 6 & 7 Basic Excel
Total questions: 23
Worksheet time: 12mins
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
What does this key on the computer keyboard do?
Makes the text bold
Underlines the text
Deletes the text
Blank the screen
What does this feature in our computer software do?
Allows us to insert a graph or chart into our document
Allows us to display our data results in a table format
What will clicking on the icon in the image do?
Make the text size bigger
Make the text colour red
Make the cell background colour red
Underline the text
Which format is best suited to display visually the mark you received on a test that is out of 100?
Percentage
Number
General
Currency
In Excel, the cell C3 contains the formula =A3/B3. If I copy this and paste it into the cell D5, what will the formula for cell D5 be?
=A3/B3
=C3
=A5/B5
=B5/C5
If I wanted to calculate the highest number in this data list, what command could I use?
Count
Max
Min
Look at the workbook extract, what formula should I write to add the results for JAN, FEB & MAR?
(a)
What is the cell reference for the colour black?
3C
C3
B3
3B
Excel refers to files as
Databases
Workbook
Document
If I wanted to calculate the average of this data set, what command would I use?
Count
Max
AVERAGE
SUM
What symbol is used in a spreadsheet to represent multiplication?
+
-
*
/
In Excel, how would you refer to the cell in the third column and second row?
2C
C2
3B
B3
What does the 'Save' icon in a computer program do?
Deletes the document
Saves the document
Prints the document
Opens a new document
