Excel Assignment 5- Quiz on the Spreadsheet

 

Time to ensure that you understand the theory and importance of the spreadsheet. Answer the questions in the following form. Don't forget to take note of the number of marks allocated to each question and answer accordingly.

 

 

Your Name:

1. What is a cell address in a spreadsheet? (1)

 

2. Which four (4) items in the following list are  most important features of an Excel 2002 spreadsheet that make it a revolutionary tool for business?  (2) 

  1. The spreadsheet can perform mathematical calculations
  2. Different fonts are available to format the text
  3. Repetitive tasks, such as using the same formula in different cells, can be carried out
  4. Formulae recognize relative positions and update automatically when copied from one cell to another
  5. We can put headers/footers on the page
  6. Spreadsheets can have coloured backgrounds
  7. Forecasts can be made using different criteria in the spreadsheet

3. When we see a number or characters in a cell, how do we determine whether the cell contains a value or a formula? (1) 

4.  How do we insert a comment into a cell? (1) 

5. What is the problem when we see the word '#VALUE!' in a cell? (1)

6. What is the problem when we see the characters ##### in a cell? (1)

 

 

(X/7)