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

excel training support pack

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

ResolvedVersion 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:

Quick Absolute Cell References

When entering cell references in a formula you probably click the cell, or you may type in the cell reference. If you require any of the 4 variations, press the F4 key now before you press Enter to toggle around the relative and absolute entries ($signs).

Note that the F4 key outside of editing a formula is the Repeat key to repeat a previous action.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.