The Complete Excel Guide: Beginners to Advanced - Module 8 - Practice Exercise

The video tutorial guides students through writing basic formulas in spreadsheets. It starts with opening a file named 'Eastern Regions report' and adding formulas to calculate sums, averages, and highs. The tutorial then covers calculating totals and commissions, emphasizing the importance of using absolute values to avoid errors. Students are instructed to copy their work to the Mideast region and are provided with additional instructions in a Word document. The tutorial concludes with advice to ensure understanding before proceeding to the next module.

What is the first step in working with the Eastern Regions report file?

• Copy the formulas to the Mideast region.

• Determine the commission rates.

• Open the file and start by clicking in C-12.

• Calculate the totals in column G.

When adding up values in the spreadsheet, what should you do after calculating January?

• Calculate the totals in column G.

• Move to the next sheet.

• Determine the commission rates.

• Copy the formula across for other months.

What is essential to remember when calculating commissions in the spreadsheet?

• Use a relative value for the commission rate.

• Ensure the commission rate is an absolute value.

• Calculate the commission before totals.

• Use the average formula for commissions.

What happens if you do not use an absolute value for the commission rate?

• The spreadsheet will crash.

• You will get incorrect totals.

• The answers will be zeros.

• The commission rate will double.

After completing the calculations, where should you copy the answers?

• To a new spreadsheet.

• To the Mideast region.

• To the Western region sheet.

• To the summary page.