Quick exercise to establish how to enter data into the ...
Excel for P6 and 7 with a focus on learning skills for ‘Enterprise’ type activities.
Load MS Excel to look at.- Identify grid, columns, rows, cells, formula bar.
Now load the ready-made file - ‘Compilation Excel Exercise’
Open ‘Our school Shared Area’ > Pupil’s Write > P7 >
Copy the file ‘Compilation excel Exercise P67 to your ‘My Work’ folder
Now open this file from your ‘My Work’ Folder
Activity 1 Use temperature data from cities round the world
Quick exercise to establish how to enter data into the spreadsheet
• Edit data
• Highlight data and make a bar chart
• Format the chart – learn how to add titles for chart, x and y axes. Change colour of bars in a data series. Change colour of the plot area.
• Copy / paste into another document – ie MS Word
• Move / resize graphics in DTP programme. Save
Activity 2 Open the sheet ‘Fish shop’ Use this file to learn about :-
• Adding another row for eg ‘Mrs Waddell’s Seafood Surprise’
• Changing width of columns
• Calculating totals vertically and horizontally, using ‘Autosum’
• Formatting cells to show ‘£’s’ Go to Format > Cells > Currency Change to ‘£ Pounds’ and two decimal places
Activity 3 Using formulas
Use the same file as above (‘Fish shop’ ) to learn about
• Entering a ‘times’ or multiplication calculation
• Learn the fast way of copying formulae
Activity 4
Open the sheet ‘Balance Sheet’
• Revise formatting rows
• Entering formulas for ‘times’, or ‘Multiplying’
• Explore changing the contents of cells - the ‘what if’ scenario.
Activity 5
Open the sheet ‘Calc & Currency’
• Entering formulae for + -, * and /
• Change colour of background etc
• Enter formulae for converting currency . Use Scotsman cut out for Exchange rates.
Activity 6
Open the sheet ‘Birthday Cards’. Enter the formulae which will calculate the ‘best value’ of the boxes of cards.
Activity 7
Go back to Fish shop data and make charts to show Mr Waddells weekly sales
Learn how to find ‘Average’ and ‘Maximum’
Activity 8 Evacuation
Use the paper copy and finish entering the data on evacuees.
Use the method you learned above to find totals.
Answer the questions on the paper sheet.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- introduction to formulae and functions exercises
- using excel for calculation activities ks1 2
- major project 2 excel k200 microcomputer applications
- quick exercise to establish how to enter data into the
- getting started in excel
- microsoft excel
- excel tutorial
- excel proj 3 multiple choice
- orient yourself in excel
Related searches
- how to enter stock market
- how to enter password outlook
- how to enter full screen
- how to enter formulas in excel
- how to enter cot in calculator
- how to input data into r
- how to read data into r
- how to enter microliters on keyboard
- how to enter a square in excel
- excel how to enter date
- excel how to enter time
- excel how to enter an array formula