excel training support pack

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Training Support pack Unit 2 Practice Activity

Excel Training Support pack Unit 2 Practice Activity

resolvedResolved · High Priority · Version 2003

Byron has attended:
Word Advanced course
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Outlook Introduction course
Outlook Advanced course

Excel Training Support pack Unit 2 Practice Activity

Hi

I am working through my training booklet I got last week on the intermediate course and I am currently on Unit 2 Practice Activity. Am on number 3 and am stuck.

Can't remember how to do this bit. Can you walk me through this part so I get the same numbers as in the chart in the bottom of the page.

If you can help me out that would be great.

RE: Excel Training Support pack Unit 2 Practice Activity

Hi Byron

Thanks for your question.

The figures are obtained by multiplying quantity (each region is on a separate sheet in the Practice Sales 1999-2000 workbook by the price which is contained in the Product workbook.

I have attached a solution file so you can have a look at the formulas on the Report sheet. I hope this helps.

Amanda

Attached files...

solution Practice sales 1999-2000.xls


 

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips


Server loaded in 0.08 secs.