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

This video tutorial guides students through an exercise involving setting up a workbook, entering data, and creating formulas to calculate sales, expenses, and profits. It includes instructions for using the fill handle, creating advanced formulas, and practicing range selection. The exercise is designed to be continued in a future module.

What is the first step in setting up the workbook for this exercise?

• Copy the profit formula

• Create a new blank workbook

• Enter the sales data for each month

• Calculate the total expenses

In which cell should you create a formula to calculate profit?

• A1

• C3

• B2

• D2

What operation is used to calculate profit in the formula?

• Addition

• Subtraction

• Multiplication

• Division

Which row is used to create formulas for totals of sales, expenses, and profits?

• Row 4

• Row 5

• Row 6

• Row 7

What should you practice after calculating April's projected numbers?

• Creating charts

• Entering data

• Selecting ranges

• Saving the file