Spreadsheet Quiz

Quiz

The name of the spreadsheet package you have been using is called:
1. Word
2. Excel
3. Access
4. Power Point
Each box on a spreadsheet is called a :
1. Row
2. Rectangle
3. Cell
4. Box
Which of the following is a correct cell reference :
1. G5
2. 2D
3. =A1+9Y
4. R5D
A spreadsheet can hold 3 types of information. These are :
1. Text
2. Records
3. Numbers/Value
4. Formula
5. Fields
Which of the following are functions in a spreadsheet :
1. Highest
2. Minimum
3. Average
4. Add
What symbol is used to divide in a formula?
1. *
2. $
3. -
4. /
=E6+F6+G6+H6+I6. A shorter way to write this would be :
1. =ADD(E6:I6)
2. (=SUM E6:I6)
3. =SUM(E6:I6)
4. =ADD(E6*I6)
=IF(A5>50,"PASS","FAIL"). If cell A5 contained the value 50, what would be displayed in the cell containing this function?
1. It would be blank
2. FAIL
3. PASS
4. ERROR
Changing the column width and adding a border in a spreadsheet is an example of :
1. Formatting
2. Altering
3. Changing
4. Editing
To stop the contents of a cell getting changed accidentally we can use :
1. Cell Blocking
2. Cell Security
3. Cell Safety
4. Cell Protection
Which of the following are reasons for putting information in a chart :
1. information is easier to see at a glance
2. it updates faster than the information on the spreadsheet
3. it is easier to make sense of what the information means
If data in a chart automatically changes when the data in the spreadsheet changes then ___________ data linkage is being used.
1. Static
2. Dynamic
The feature of a spreadsheet which involves copying and pasting is called :
1. Cloning
2. Duplication
3. Replication
4. Copying
One advantage of using manual calculation over automatic calculation is :
1. it takes less processing time
2. it updates in real time
3. it takes less storage space to store the spreadsheet