Exercise 2.1

Formatting

You have a number of friends who are going to different countries for their holidays. Each is taking £150 spending money, in the local currency. You have been asked to calculate how much local currency they will get, given the current rate of exchange (you may check the paper or look up the internet for up to date exchange rates if you wish —
try: www.x-rates.com/calculator.html).

1.      Enter the following data into your spreadsheet.

2.      Use formulas as appropriate to calculate the value of spending money in the local currencies.

3.      Row 1 – set text to size 16, bold.

4.      Row 3 – set text alignment to vertical, format font to size 14, bold and red.

5.      Column C – format figures to appropriate currency.

6.      Rows 4–7 – set text to size 14.

7.      Use custom borders and shading to further enhance as you wish.

8.      Insert an appropriate clipart image to the right of the data — format as you wish.

9.      Apply any other formatting as desired.

10.  Save your workbook with a suitable name.

Exercise 2.2

Absolute/Relative Cell referencing

Answer the following questions:

		True or False?
By default, all cell addresses are	Relative
The keyboard shortcut used to change F4 to $F$4 in a formula is	Shift [F4]
$B7 in a formula in C7 copied to cells C8:C10 will become	B8:B10
A$9 in a formula in F9, copied to cells G9:I9 becomes	B$9:D$9

Exercise 2.3

Review of Absolute/Relative cell addressing and statistical functions

Enter the following data into a new worksheet, using the following guidelines:

Cell range C6:C9 — formulas

Cell range D6:D9 — formulas

Cell range C11:C15 — functions

Format all figures appropriately (currency, percentage, integer etc)

1.      Enhance the layout by formatting as required.

2.      Use an appropriate function to display today’s date in D2

3.      Rename the worksheet Furniture Sale.

4.      Put your name and today’s date in the worksheet footer.

5.      Save your worksheet.

6.      Take a print out showing formulas, with column and row headings and gridlines displayed (adjust column widths to display complete formula if necessary).

7.      Take a print out showing data.

Exercise 2.4

Cell formatting

On a new worksheet, create a worksheet to calculate the December wages for your temporary staff data, following the guidelines given:

Data entry: Row 1:4; A5:B14; all other cells contain formulas/functions.

Format the worksheet as you wish, but ensure that:

¨       Row 3 — has the date and time formatted as shown.

¨       Column headings in row 4 are formatted to text wrap within cells.

¨       Monetary values formatted to currency with two decimal places.

¨       Borders used effectively to add emphasis.

¨       Font formatting applied and shading used.

¨       ClipArt and/or drawing tools used to add seasonal theme.

It should look similar to the one below: