Exp22_Excel_Ch09_ML1_Expenses | Exp22 Excel Ch09 ML1 Expenses | @PearsonProTips

Описание: Contact Us:

WhatsApp no. : +923025441145

direct link: https://tinyurl.com/3zfyhs35

Email : [email protected]

#Exp22_Excel_Ch09_ML1_Expenses | #Exp22 Excel Ch09 ML1 #Expenses |#Excel Ch09 ML1 Expenses#Exp22_Excel_Ch09_ML1_Expenses | #Exp22 Excel Ch09 ML1 #Expenses |#Excel Ch09 ML1 Expenses @PearsonProTips

#Exp22_Excel_Ch09_ML1_Expenses
#Exp22_Excel_Ch09_ML1_Expenses

#Exp22_Excel_Ch09_ML1
#Exp22_Excel_Ch09_ML1

#Excel_Ch09_ML1
#Excel_Ch09_ML1

#Excel_Ch09_ML1
#ML1_Expenses
#ML1_Expenses

#ML1_Expenses


#Exp22
#Excel
#Ch09
#ML1
#Expenses

Project Description:
You carefully tracked your income and expenses for three months using one worksheet per month. The worksheets contain the same expense categories. You used the Miscellaneous category to include a variety of expenses, including a vacation in June. For each month, you calculated the difference between your income and expenses as you were saving for your vacation in June. Now you want to create a three-month summary to analyze your spending habits.

#Exp22_Excel_Ch09_ML1_Expenses
#Exp22_Excel_Ch09_ML1_Expenses

#Exp22_Excel_Ch09_ML1
#Exp22_Excel_Ch09_ML1

#Excel_Ch09_ML1
#Excel_Ch09_ML1

#Excel_Ch09_ML1
#ML1_Expenses
#ML1_Expenses

#ML1_Expenses


#Exp22
#Excel
#Ch09
#ML1
#Expenses
Steps to Perform:
Step Instructions Points Possible
1 Start Excel. Download and open the file named Exp22_Excel_Ch09_ML1_Expenses.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 You want to enter a title and apply a cell style to three worksheets at the same time.

#Exp22_Excel_Ch09_ML1_Expenses
#Exp22_Excel_Ch09_ML1_Expenses

#Exp22_Excel_Ch09_ML1
#Exp22_Excel_Ch09_ML1

#Excel_Ch09_ML1
#Excel_Ch09_ML1

#Excel_Ch09_ML1
#ML1_Expenses
#ML1_Expenses

#ML1_Expenses


#Exp22
#Excel
#Ch09
#ML1
#Expenses
Group the April, May, and June worksheets. Type Savings, Income, & Expenses in cell A1. Select the range A1:C1 and apply the Heading 1 cell style. 6
3 With the worksheets grouped, you want to calculate the Ending Savings Balance.

In cell C6, add the Beginning Savings Balance to the Monthly Savings Added. 6
4 With the worksheets grouped, you want to unlock a range so that it can be edited.

Unlock cell C9 and the range B12:B20 in the grouped worksheets. Then, ungroup the worksheets. 3
5 Three worksheets should have 3-D references to other worksheets.

Display the May worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the
Ending Savings Balance) in the April worksheet.

Display the June worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the
Ending Savings Balance) in the May worksheet.

#Exp22_Excel_Ch09_ML1_Expenses
#Exp22_Excel_Ch09_ML1_Expenses

#Exp22_Excel_Ch09_ML1
#Exp22_Excel_Ch09_ML1

#Excel_Ch09_ML1
#Excel_Ch09_ML1

#Excel_Ch09_ML1
#ML1_Expenses
#ML1_Expenses

#ML1_Expenses


#Exp22
#Excel
#Ch09
#ML1
#Expenses
Display the Qtr 2 worksheet. In cell C4, create a formula with a 3-D reference to cell C6 (the
Ending Savings Balance) in the June worksheet.
12
6 You are ready to build functions with 3-D references to sum data from all three months on the Qtr 2 worksheet.

With the Qtr 2 worksheet active, select cell C9 and insert the SUM function with a 3-D reference to total the salary amounts for all three months. Copy the function in cell C9 to cells C21 and C23. 9
7 Next, you want to insert a SUM function with a 3-D reference on the Qtr 2 worksheet.

Select cell B12 and insert the SUM function with a 3-D reference to total the rent amount
for all three months. Copy the function in cell B12 to the range B13:B20. 8
8 To ensure consistency among worksheets, you will group worksheets and apply formatting.

#Exp22_Excel_Ch09_ML1_Expenses
#Exp22_Excel_Ch09_ML1_Expenses

#Exp22_Excel_Ch09_ML1
#Exp22_Excel_Ch09_ML1

#Excel_Ch09_ML1
#Excel_Ch09_ML1

#Excel_Ch09_ML1
#ML1_Expenses
#ML1_Expenses

#ML1_Expenses


#Exp22
#Excel
#Ch09
#ML1
#Expenses
Display the April worksheet, group the April, May, June, and Qtr 2 worksheets. Select the range A8:C23. Fill the formats only across the grouped worksheets to copy the font formatting, indents, and number formatting. Ungroup the worksheets. 6

#Exp22_Excel_Ch09_ML1_Expenses
#Exp22_Excel_Ch09_ML1_Expenses

#Exp22_Excel_Ch09_ML1
#Exp22_Excel_Ch09_ML1

#Excel_Ch09_ML1
#Excel_Ch09_ML1

#Excel_Ch09_ML1
#ML1_Expenses
#ML1_Expenses

#ML1_Expenses


#Exp22
#Excel
#Ch09
#ML1
#Expenses

Pearson MyLabSolution

#Exp22_Excel_Ch09_ML1_Expenses
#Exp22_Excel_Ch09_ML1_Expenses

#Exp22_Excel_Ch09_ML1
#Exp22_Excel_Ch09_ML1

#Excel_Ch09_ML1
#Excel_Ch09_ML1

#Excel_Ch09_ML1
#ML1_Expenses
#ML1_Expenses

#ML1_Expenses


#Exp22
#Excel
#Ch09
#ML1