Create the Worksheet shown above in Sheet1 and Rename it Coral.

Set the columns A,B:9; Columns C&D:11.

Set the height of Row 2 as 40.

Align all columns labels horizontally and vertically center.

After entering data, insert a new row between rows 2&3.

Format column F to include $ sign and 2 decimal places.

Center the worksheet vertically and holizontally on the page.

Save the file with the name EXCEL1 in the KNECEXAM folder.

Open a spreadsheet program and key in the data as it appears. Save the workbook as hospital data in the KNECEXAM folder.

Using appropriate function and cell address only, determine the total frequency.

Using appropriate function and cell address only, determine the percentage frequency for each cause.

Copy the contents of Sheet1 to Sheet2 in cell range A1:D8.

Rename Sheet2 as Total.

Sort the data in the Sheet named Totals by the column titled Cause in Descending order and then by Frequency in ascending order.

Insert two rows above Row1 in sheet named totals.

Insert a picture of a doctor in sheet named Totals in cell range B1:C2.

Use an appropriate feature to lock cells C2:D9 with the password “doctor” in sheet named totals.

Insert an embedded bar chart showing the percentage frequency against the cause in sheet1. Label the chart appropriately.

Save the changes to print out later sheet1 and Totals.

Open a spreadsheet program and key in the information shown in figure below as it appears. Save the workbook as Budget in the KNECEXAM folder to print out later.

Copy the content of sheet 1 to sheet 2.

Perform the following tasks to the details in sheet2: Insert two rows above row 2, Merge and center the cells A2:E2, Type the following text in the range A2:E2; MOTORCAR SHOW ROOM.

Using cell addresses only, compute the Balances for each Vehicle.

Using the filter feature, extract the vehicles which have a balance of above kshs 200,000.

Create a 3D column chart on a new sheet showing the vehicle and the respective Balance. Label the chart appropriately.

Save the changes to print later: Sheet 1, Sheet 2, Chart sheet.

Enter the information in the spreadsheet below. Be sure that the information is entered in the same cells as given, or the formulas below will not work.

Enter the formula below into cell G5 and copy it into cells G6 to G8. This demonstrates the use of a "relative reference" (e.g., C5) that points to the contents of a cell.

Enter the information below in the cell indicated.

Enter the formulas below in the cells indicated. These formulas demonstrate three methods for calculating averages for a column of data.

Enter the information below in the cells indicated. This will establish the weight each exam is given in a student's final average.

Enter the formula below into cell G5 and then copy it into cells G6 to G8. This demonstrates the use of an "absolute reference" (e.g., $C$12) that points to a specific cell in a spreadsheet.

Make the changes to the cell contents indicated below and notice how the final averages change.

Just when you thought you were finished calculating final grades, you realize that you forgot someone. You know that quiet student that always sits in the back of the room. Anyhow, you can start all over or simply insert a new row for the forgotten student.

Now that an additional student has been added to your grade book, the formulas used to calculate the averages for Exams #1 and #2 are incorrect. To correct this, copy the formula in cell E11 to cells C11 and D11.

Enter the information below in the identified cells.

Notice that the exam averages change when the new student's grades are entered but a final average is not automatically calculated for him. This is because the formula was not copied into that new row. Copy the formula in cell G5 into cell G6.

IF statements can be used to automatically assign letter grades to each student. Enter the following formula.

Copy the formula in cell H5 to cells H6 through H9.

Create the worksheet shown above and rename it as NTU.

Format Column F to percentage type.

Find Price Increase (%), depending on the type.

Find Sale Price, where Sale Price = unit Price * Price Increase + Unit Price.

Find Warranty. If Unit Price greater than 10, then YES and NO, if it is not.

Find Total Price which is equal is equal to Quantity * Sales Price.

Calculate the TOTAL, AVERAGE, HIGHEST and LOWEST values as shown above.

Draw a pie chart between Type and Sales Price.

In cell G18, find how many items which are cheaper than 100.

In cell G19, find Total quantities which are greater than 20.

Save the file with the name EXCEL3 in the KNECEXAM folder.

Create the worksheet shown above and rename it as Grades.

Find Grade which is equal to Midterm1 + Midterm2 + Project + Final.

Find Status for each student with a grade better than or equal to 80 as “Distinct”, and all others as “Fulfilled”.

Create a Column chart based on the columns Student Name, Final and Grade.

Save the file with the name Excel 4 in the KNECEXAM folder.

Open a spreadsheet program and key in the data as it appears in sheet1. Save the workbook as juicesupplied in the KNECEXAM folder.

Copy the content in sheet1 to sheet2.

Insert a blank row above the column headers.

Type the title “EDY’S JUICE COMPANY” in the inserted row.

Merge and centre the title to cover the cells A1 to E1.

Apply font size 17 to the title.

Use a formula with cell references only to compute; Selling price, given that that the selling price is the buying price increased by 20%.

The value of the juice not sold based on the buying price.

Create a bar chart with appropriate labels to compare the number of bottles of mango and orange juices supplied.

Save the changes to print out later.

Open a spreadsheet program and create the document as it appears. Save the workbook as uniformdistributers in the KNECEXAM folder.

Copy the data in sheet1 to sheet2 and rename sheet2 as modified.

On sheet2, use a formula with cell references to: Determine the total cost of each item bought by each customer.

Determine the new cost of each item bought given that a discount of 10% is awarded on each item bought.

Create a column chart that compares the quality of ties bought by Karigi and Top Hill distributors. Label the chart appropriately.

Save the changes to print out later.

Open a spreadsheet program and create the worksheet as it appears below. Save the workbook as theconia in the KNEXEXAM folder to print out later.

Copy the content of sheet1 to sheet2.

Rename sheet2 as earnings.

Insert a blank row above Row1.

Merge and center cells A1:G1.

Key in the following text “Theconia Driver Earnings” in the merged cells in the row inserted.

Using cell references only, insert a formula to calculate the grand totals for quarterly earnings.

Compute the commission earned by each driver if the commission payable is based on the criteria below.

Create a clustered bar chart for driver name, car number against the quarter. Save it as chart1 in its sheet.

Display formulas instead of values in sheet earnings.

Print the chart.

Open a spreadsheet program and key in the following data as it appears below. Save the workbook as contributions in the KNEXEXAM folder to print out later.

Insert a row above R1, merge the cells A1:E1 and: Insert the title as “SELF HELP GROUP MONTHLY CONTRUBUTION”;

Format the title to font Elephant of size 18.

Using cell addresses and appropriate function, determine the Amount contributed by each member.

Format the data in column C to have the thousand separate with zero decimal points.

Using appropriate function, determine the total amount contributed.

Using IF function and cell addresses, determine the status for each member as “Step up” if the members monthly contribution is below 100, otherwise “Keep it up”.

Create a pie chart in a new sheet to show the Members and Amount contributed. Label the chart appropriately.

Save the changes to print out later: Sheet1 showing formula instead of values.

The chart.

Use a spreadsheet to manipulate the data provided.

Use a spreadsheet program to capture the data in Table above and save it as marks in the KNECEXAM folder to print out later.

Rename the sheet containing marks as mark1.

Copy the data in mark1 to sheet2. Rename the sheet as mark2.

Find the total marks for each subject.

Find the total marks in each subject for; Stream K; Stream H.

Determine the mean mark for each student to two decimal place.

Determine the best mark in every subject.

Use a function to rank the student in descending order of their mean marks.

Create a well labeled column chart on a different sheet to show the mean mark of each student. Save the chart as mark3.

Print mark1, mark2, mark3.