Computing

Content Grids

Copy and paste the questions into your own blog. Answer the questions in the same post. Make sure you put the post into your Spreadsheet category.

Able Art Printing company use spreadsheets as part of its business.
A sample is shown below.

1. The name of the company, Able Art Printing, does not fit in the column.
   State what must be done to the column to make the name fit.
2. What cell formatting has been used in cell B3 so that both words appear?
3. A formula is used in cell D8. What is it?
4. A formula is also used in cell D10. What is it?
5. The formula for cells D4 to D7 was entered in D4. It was then replicated
   down the column.
   State what is meant by replicated.
6. State how the format of cell C7 should be changed so that it looks the same as cell C6.

Classy Computers have asked their sales team to sell as many printers as possible this week. 

To encourage the sales team, they have offered a bonus in their wages if they sell 90 or more.

The spreadsheet shown below contains the result of the promotion.

1. Write down the formula that would be used in cell F5.
   
2. The formula in cell F5 was replicated down into cells F6 to F9. Both absolute and relative referencing were used.
   Explain carefully why this was necessary.
3. Write down the formula that would be contained in the cell E5. 
4. Describe 2 types of formatting that has been applied to this spreadsheet. 

1. If you haven’t done so already, create a new blog category called “Spreadsheets”.
2. Create a new post in that category called “Spreadsheet Revision 1″.
3. Please copy and paste the following questions into your blog.

Questions

1. Name three things that can be entered into a spreadsheet cell.
2. Give 5 examples of spreadsheet functions.
3. Why would a user want to apply cell protection to a spreadsheet?
4. Describe what is meant by the term “replication”