(5/5)

Hire Me
(5/5)

Hire Me
(4/5)

Hire Me
(5/5)

Hire Me
(5/5)

# Open a new workbook and create a spreadsheet that looks like the following:

INSTRUCTIONS TO CANDIDATES
###### ANSWER ALL QUESTIONS

Excel 2007 Practice Exercise - Darts

1. Open a new workbook and create a spreadsheet that looks like the following:

2. Enter a simple formula in cell E3 to work out Marion’sfinal score.

3. Calculate final scores for all the other darts players.

4. Make the titles of the spreadsheet Bold and underlined border in Red.

5. Save the file as Darts on your network drive.

1

6. On a new row, add the name Elizabeth-Jane and scores of 11, 15 and 20.

7. Widen column A to display all names fully.

8. Calculate Elizabeth-Jane’s final score in E8.

9. Change Steve’s ‘Score 2’ to 9 and check that his final score updated automatically.

10. Change Marion’s name to Marigold.

11. Save and close the file.

Excel 2007 Practice Exercise - Shopping

1. Open a new workbook and create a spreadsheet based on the following information from your grocery shopping:

a) Worksheet title: SHOPPING

b) Column headings: Item Cost (€)Number  Final Price (€)

c) Items purchased include:

i) 10 packets of Cat food at 0.40

ii) 4 litres of Milk at 0.38

iii) 2 loaves of Bread at 0.87

iv) 1 jar of Marmalade at 1.15

v) 3 packages of Pasta at 0.56

vi) 2 Pineapples at 1.30

vii) 3 bottles of Lemonade at 0.89

2. Enter a simple formula in cell D3 to calculate the final price of Cat food.

3. Work out the final price for all other items.

4. Format the titles of the spreadsheet so that they stand out from the shopping items.

5. Save the file as Shopping on your network drive.

6. Now amend the entry in cell C2 to read Number Bought, and widen columns C and D to display the fullentries.

7. Make the following changes: Pasta costs 49 cent; replace Pineapple with Melon; and increase the number of litres of Milk bought to 6.

8. Check that the final prices are updated automatically and print a copy of the amended spreadsheet.

9. Insert an additional item between Pasta and Melon for 2 jars of Pasta Sauce at €2.50 each.

10. Add the word TOTAL in cell C11.

11. Enter a simple formula to add up the total cost of all of the items in D11.

12. Create a border with a single top line and double bottom line in Red in cell D11.

13. Save and close the file.

Excel Exercise – Quiz Night

NOTE: Joker round is worth double points.

1. Open the file Quiz.xlsx

2. Insert a formula in cell I6 that uses the SUM function to add up the points that Team 1 has scored over the 6 rounds (do not include extra Joker points.

3. Fill this formula down to cell I15.

4. Team 1 nominate round 1 to play their Joker. Insert a formula in cell J7 that enters the number of extra points

for Team 1’s Joker round (i.e. contents of cell B6 multiplied by 2).

5. Enter a similar formula into cells J7 to J15. Remember, that the teams do not all nominate the same round in which to play their Joker).

6. In cell K6 enter a formula to add up the total points and the Joker points.

7. Fill this formula down to cell K15.

8. Insert a formula in cell K17 that uses the MAX function to find the highest Grand Total.

9. Insert a formula in cell K18 that uses the MIN function to find the lowest Grand Total.

10. Insert a formula in cell B17 that uses the AVERAGE function to find the average score for Round 1.

11. Fill this formula across to cell G17.

12. Save and close the workbook.

Excel Exercises – Entering/Editing/Sorting/Copying/ Moving/Deleting

Entering, Editing and Sorting

14. Open the housebills1.xls workbook.

15. Enter the numbers ’80’ and ‘234’ in cells B6 and C9 respectively.

16. Edit the contents of cells A5, A9, B8, C10 and D6 to read ‘Mortgage’, ‘Insurance’, ‘470’, ‘880’ and ‘73’

respectively.

17. Sort the cell range A4:D10 in ascending alphabetic order based on the contents of the Expenditure column.

18. Save the housebills1.xls workbook, naming it housebills2.xls.

Copying and Moving

1. Open the budget1.xls workbook.

2. Copy the contents of cell B4 to cell D15, cell C4 to D16, cell D4 to cell D17 and cell E11 to D18.

3. Move the contents of cell H4 to D6 and cell H5 to E9.

4. Use the Fill handle to copy the months from cell B3 to E3.

5. Save the budget1.xls workbook, naming it ‘mybudget1’ and close it.

6. Open the budget2.xls and budget3.xls workbooks.

7. Copy the contents of the cell range B4:E11 in the budget2.xls workbook into the budget3.xls workbook, starting in cell B4.

8. Copy the contents of the cell range D15:D18 in the budget2.xls workbook into the budget3.xls workbook, starting in cell D15.

9. Save the budget2.xls and budget3.xls workbooks, naming them ‘mybuddget2.xls’ and ‘mybudget3.xls’

respectively.

Copying and Deleting

1. Open the budget4.xls workbook.

2. Copy the contents of the cell range A1:E18 in the House Expenses worksheet into the Expenditure worksheet, starting in cell A1.

3. Delete the contents of the cell range A24:E27 in the Expenditure worksheet. 3

4. Save the budget4.xls workbook, naming it ‘mybudget4’ and close it.

Editing and Sorting

1. Open the budget5.xls workbook.

2. Replace all occurrences of the word ‘Lowest’ with ‘Highest’.

3. Replace all occurrences of the word ‘Costs’ with ‘Expenditure’.

4. Sort the contents of the cell range A4:E11 in ascending alphabetic order based on the Items column.

5. Save the budget5.xls workbook, naming it ‘mybudget5’ and close it.

6. Practice sorting the cell range A4:E11 in ascending and descending numeric order based on the contents of the

September, October, November and December columns.

7. Close mybudget5.xls workbook without saving.

(5/5)

## Related Questions

##### . The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

##### . Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

##### . The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

##### . Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

##### . The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme