Скачать или смотреть YO25_Excel_Ch03_Prepare_Wedding | YO25 Excel Ch03 Prepare Wedding

Whatsapp: +923177402009
Whatsapp: +923084981394
Email: [email protected]
Whatsapp link: https://wa.me/qr/ALGVOLHWN4M2K1

Instagram link: https://www.instagram.com/alim25431?i...

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English, Literature, Nursing, psychology, Statistics, Information Technology, Applied Sciences and Many more

#YO25_Excel_Ch03_Prepare_Wedding
#YO25 Excel Ch03 Prepare Wedding
#YO25ExcelCh03PrepareWedding
#YO25_Excel_Ch03
#Prepare_Wedding
#YO25_Excel
#Ch03
#Prepare
#Wedding
#yo25_excel_ch03_prepare_wedding
#yo25 excel ch03 prepare wedding
#yo25excelch03preparewedding
#yo25_excel_ch03
#prepare_wedding
#yo25_excel_ch03
#prepare
#wedding

Step Instructions Points Possible
1 Start Excel. Download and open the file named Excel_Ch03_Prepare_Wedding.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to a location where you are storing your files.

0
2 To help the spa manager design a workbook to become more efficient in planning for wedding events, you will edit the Wedding workbook.

On the GiftBaskets worksheet, in cell F9, use AutoSum to calculate the total items in Basket 1. Copy the formula in cell F9 through cell F11.
3
3 To save yourself time, you may want to consider using absolute referencing so you can copy formulas to other cells within the workbook while keeping a cell (or group of cells) reference constant.

In cell B15, type =B14-(B14*$E$3)
Copy the formula through cell range B15:E15. 3
4 In certain worksheets, mixed referencing is the most efficient way to save yourself time when creating a formula you wish to copy to other cells within the worksheet in which either the row or the column reference must stay constant.

In cell B18, type =B9*B$15
Copy the formula in cell B18 through cell B20.
Copy cell range B18:B20 through the range E18:E20. 3
5 You found an error in the worksheet. Since formulas have been created to perform calculations in the worksheet, changes to data will automatically be reflected throughout the worksheet.

In cell E14, change the price of Soothing Bath Salts to 9.99 1
6 An array formula can return multiple results and spill those results into neighboring cells.

On the Commission worksheet, in cell B21, type =A21:A24*B20:E20 2
7 The use of named ranges enables a developer to quickly develop formulas that make sense. It also increases the readability of formulas to other individuals who are using the same workbook.

On the GiftBaskets worksheet, create a named range BasketSubtotals for the cell range C23:C25.
3
8 On the GiftBaskets worksheet, click the Name Box arrow, and then click BasketsRequested.
Notice that the range selected is B24:B26. This is an incorrect range.

Edit the BasketsRequested named range so that it refers to cell range B23:B25
3
9 In cell F24, use the SUM function to add up all the values in the BasketSubtotals named range. Use the range name in the formula.
3
10 You can quickly assign named ranges in Excel.
Using the cell range A18:E20, create named ranges using the values in the left column for the range names.
2
11 With cell range F18:F20 selected, use the Apply Names feature to apply the names you created to the formulas.
2
12 The number of days spent by wedding parties at the Painted Paradise Resort & Spa had previously been calculated by using decimal values based on check-in and checkout times. You will change this data to display as whole numbers of days.

On the WeddingSummary worksheet, in cell C7, enter a formula to round the number in cell B7 down to the nearest integer. (Note: Do not use the ROUND function here.)
Copy the formula through cell range C7:C37.
Format cell range C7:C37 with zero decimal places. 4
13 The value of merchandise that was returned after the wedding took place is listed in both positive and negative values. You will correct this so all values are displayed as a positive number.

In cell E7, enter a function that returns the absolute value of the returned merchandise in cell D7.
Copy the function through cell range E7:E37.
3