Uncategorized

Excel challenge

Calling P345

http://www.thetoyshop.com/

You EXCEL challenge for today…

1) Open Microsoft Excel

2) Create 2 columns, 1 called TOY, the other called COST

3) Use the ‘Entertainer’ website to search for the cost of these toys:

a. A Lego set

b. A Skateboard

c. Monopoly board game

d. Art case

e. Play-doh pary pack

4) Record the TOY name and the COST in your Excel spreadsheet.

Advanced challenge

1) Use the Format Cells tool to change the COST column to CURRENCY

2) Use the AutoSum tool to find out how much the 5 toys cost in total.

"********************************************************************** This email and any files transmitted with it are privileged, confidential and subject to copyright. Any unauthorised use or disclosure of any part of this email is prohibited. If you are not the intended recipient please inform the sender immediately; you should then delete the email and remove any copies from your system. The views or opinions expressed in this communication may not necessarily be those of Scottish Borders Council. Please be advised that Scottish Borders Council's incoming and outgoing email is subject to regular monitoring and any email may require to be disclosed by the Council under the provisions of the Freedom of Information (Scotland) Act 2002 . **********************************************************************" 
%d bloggers like this: