Spreadsheet questions | form two Information and Computer Studies

A shop owner uses a spreadsheet to calculate his profits. The following is a part of a spreadsheet

1. Give the cell reference of the cell that contains 119
2. Give the cell reference of a cell that contains text data
3. Write down the formula which should go in cell F2.
4. Write down the formula which should go in cell C8

Answer / Solution

1. C6
2. A2 (there is more than one answer)
3. =E2-D2
4. =SUM(C2:C6) or =C2+C3+C4+C5+C6

1. Create a blank workbook in MS Excel and save it as “Your Name”
2. Create a table with 7 rows and 9 columns in cell range A3:I9, as shown in the figure below. (Bold and center the heading of each column)

3. Insert a title “Anne College” and a sub-title “Mark sheet for A/L Biology-Class A”, by centering it with the table, making the text bold, and changing the font-size 16 for main title and 14 for the sub-title
4. Enter the data given under the columns, “Index No”,”Name”, “Physics”,”Chemistry”, “Biology”, and “English”.
5. Use the relevant formula to calculate the total marks of “Liyanage” and copy the formula to the relevant cells
6. Use the relevant formula to calculate the average marks of “Liyanage” and copy the formula to the relevant cells
7. Format the “Average” column with two decimal places.
8. Use the relevant formula to find the rank of “Liyanage” and copy the formula to the relevant cells
9. Use conditional formatting to change the color of the cells of which the average mark is more than 60, into green
10. Select the columns, “Index No”, “Physics”, “Chemistry”, “Biology” and “English” and draw a column chart
11. Insert the title, “Anne College”, and the sub title, “Mark sheet fr A/L Biology-Class A” to the top of the chart.
12. Set the X axis labels with the index numbers
13. Label the X axis title as Your Examination Number and Y axis as Marks
14. Label the legends for 4 subjects
15. Insert your examination number in the center of the footer
16. Save your file to your Deskop with your examination Number.

Answer / Solution

UNSOLVED

CTCL communication Ltd. is a company that sells mobile phones and accessories. The table below is an extract from sales records in five of its branches for the year ended, 2012.

1. Create the worksheet (with borders) which contain the sales records and save it as Phones and Accessories. The first month must be in cell A4.
2. Merge, center the titles, bold and apply Tan colour shading to the totals row and column.
3. Use the function to calculate the following

1. Total sales for each branch
2. Total sales for each month.
3. Minimum sale for each branch
4. Maximum sale for each branch

500. Create a three dimensional pie chart with labelled data of month`s name against sales in Arusha branch. Save it as “Arusha”.

5. To achieve the target, each branch must have at least a total of 300000 sales. Write a function that will display ‘Good season’ for target achieved or ‘Poor season’ for target not achieved.

6. Print your document.

Answer / Solution

UNSOLVED