y56_spreadsheets_worksheets

y56_spreadsheets_worksheets - Spreadsheets Worksheet 1...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Spreadsheets – Worksheet 1 GETTING TO KNOW EXCEL Task 1 Ÿ On worksheet 1, move the cursor to the following cells and type in the number next to  it. Cell Number to type in D7 2 G15 16 A22 7 T55 32 B24 22 Task 2  Ÿ Select Column D and make it  bold Ÿ Select Row 15 and colour it  yellow Ÿ Select Block of Cells A19 to C27, make the text  bold  and  blue , make the background  pink Task 3 Ÿ Select Cell G15 and using the function bar change the number to 26 Ÿ Select Cell B24 and without  using the function bar, change the number to 13
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Extension Task: Ÿ Copy Cell G15 and Paste to Cell K27 Ÿ Cut Cell A22 and Paste to Cell D7 Ÿ Select Block of Cells B24 to D31 and Copy to Cell K6
Background image of page 2
Spreadsheets – Worksheet 2 INPUTTING AND PRESENTING DATA Three class mates have been undertaking some research for their Science homework.  Anna, Beth and Simon have been looking at the differences between their height, weight  and shoe size.  Below are the results; Name Height Weight Shoe Size Anna 120cm 35kg 3 Beth 127cm 37kg 2 Simon 140cm 40kg 4 Task 1
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/29/2011 for the course I SYS 201 taught by Professor Meservy during the Winter '11 term at BYU.

Page1 / 8

y56_spreadsheets_worksheets - Spreadsheets Worksheet 1...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online