1.
Please explain in 10 words why you should receive an A in ICT?
2.
A tool used to organize and analyze information
A. 
B. 
C. 
D. 
3.
An
instruction to carry out operations
on the numerical data
A. 
B. 
C. 
D. 
E. 
4.
The intersection (meeting point) of a row and a column
A. 
B. 
C. 
D. 
5.
What is the correct way to start a formula?
A. 
B. 
C. 
D. 
E. 
6.
What is the correct formulae for adding 2 cells together?
A. 
B. 
C. 
D. 
E. 
7.
Put this formula in the correct order (sumA1:A5=)
A. 
B. 
C. 
D. 
E. 
8.
What is the name of the cell in column G row 20?
A. 
B. 
C. 
D. 
E. 
9.
Spreadsheets can be used to see different scenarios to see what might happen. What is this called?
A. 
B. 
C. 
D. 
E. 
10.
Which symbol is used to divide to values?
11.
Which symbol is used to multiply two values?
12.
By using the cell name, such as C4, you do not have to go back into a formula and make changes when your information is changed or updated.
13.
What is added to the formula to create an absolute reference?
A. 
B. 
C. 
D. 
14.
An example of a formula that includes and absolute reference look like?
A. 
B. 
C. 
D. 
15.
If you select a cell with a date in it and drag the fill handle down several cells, what happens is _____.
A. 
The date is copied to each cell
B. 
The date is increased by one day into each cell
C. 
The date is increased by one week into each cell
D. 
Nothing happens because the fill applies only to numbers
16.
The formula that will add the value of D4 to the value of C2 and then multiply by the value in B2 is _____.
A. 
B. 
C. 
D. 
17.
The feature that allows you to arrange rows in alphabetical order is _____.
A. 
B. 
C. 
D. 
18.
If a cell displays #######, it means that _____.
A. 
There is a formatting error
B. 
The column is too narrow to display all the digits of the number
C. 
There is an error in your formula
D. 
You need to center the text within the cell
19.
All charts use an X-axis and a Y-axis EXCEPT a _____ chart.
A. 
B. 
C. 
D. 
E. 
20.
A block of cells in an Excel worksheet is called the _____.
A. 
B. 
C. 
D. 
E. 
21.
To select Cells A3-A9 and Cells D3-D9 simultaneously, you would _____.
A. 
Hold down the CTRL key, select Cells A3-A9, select Cells D3-D9
B. 
Hold down the Shift key, select Cells A3-A9, select Cells D3-D9
C. 
Select Cells A3-A9, hold down the CTRL key, select Cells D3-D9
D. 
Select Cells A3-A9, hold down the Shift key, select Cells D3-D9
E. 
Both A and B will make the selection simultaneously
22.
In a large spreadsheet, while scrolling down, it is helpful to make column headings visible by applying the _____ feature to the spreadsheet.
A. 
B. 
C. 
D. 
23.
A format such as cell shading or font color that Excel can apply automatically if certain things are true is called _____.
A. 
B. 
C. 
D. 
24.
A Sony digital camera price is listed as $300.00 in Cell D5. The digital camera discount price is listed in Cell E5 as $20.00. You are going to insert a formula in Cell F5 to list the final price. Which formula is correct?
A. 
B. 
C. 
D. 
25.
To save an existing file using a different name, you would choose the _____ command.
A. 
B. 
C. 
D.