offlineinbox.blogg.se - Microsoft add-in development for both windows and mac

MICROSOFT ADD IN DEVELOPMENT FOR BOTH WINDOWS AND MAC PLUS
MICROSOFT ADD IN DEVELOPMENT FOR BOTH WINDOWS AND MAC MAC

Copy the formula in cell E27 to cells E28:E30.

Set the Sum_range argument to cells $E$5:$E$19.

Start the SUMIF function with cells $C$5:$C$19 as the Range.

Create and copy a SUMIF function to calculate total revenue by boat make.

Edit the criteria in each copied formula in cells D28:D30 to reflect the boat make.

Copy the formula in cell D27 to cells D28:D30.

If you type the formula, include quotation marks.

Set a Criteria argument that will select all boats in the “Beneteau” group.

Use cells $C$5:$C$19 as the Range argument.

Start the COUNTIF function from the Statistical category by clicking the More Functions button in the Function Library group.

Create and copy a COUNTIF function to count bookings by boat manufacturer.

Copy the formula in cell F5 to cells F6:F19.

Calculate average revenue per passenger by dividing the fee by the number of passengers.

Click the Bookings sheet tab and select cell F5.

Format the date to show the month spelled out, the date, and four digits for the year (January 1, 2020).

Insert the TODAY function in cell B21.

Copy the formula to cells G6:G19 without formatting and then center the data in column G.

(If you type the formula, enclose the text arguments within quotation marks.)

Use Yes for the value_if_true argument.

Create an IF function in which the logical_test argument determines if there are 8 or more seats.

Rental boats with a stove in the galley must seat 8 or more people. Click the Fleet sheet tab and select cell G5.Format cells F5:F19 as Currency and then copy cells F5:F19 to cells G5:G19.Copy the formula down column F without formatting to preserve the border.Figure 2-106 Mixed references in the new formula Click cell I5 on the Fleet sheet, and make the reference absolute for the column but not the row (Figure 2-106).Type )* for the closing parenthesis and multiplication.Select cell F4 and make it an absolute reference to the row but not the column.Click cell F5 and type =(1+ to start the formula.

Note also that the reference on the Fleet sheet ($H6) is adjusted to show the correct row. The formula is adjusted to use the percentage value in cell E4 in place of cell D4.

Select cells D5:D19 and drag the Fill pointer to copy the formulas to cells E5:E19.

Copy the formula in cell D5 to cells D6:D19 without formatting to preserve the border.

Figure 2-105 Mixed reference in the edited formula With an absolute reference to row 4 and column H on the Fleet sheet, you can copy the formula down the column (Figure 2-105).

MICROSOFT ADD IN DEVELOPMENT FOR BOTH WINDOWS AND MAC PLUS

Edit the formula in cell D5 to show D$4 instead of “D4.” The formula should multiply one plus the percentage value in cell D4 by the current rate on the Fleet sheet ($H5).Edit and copy a formula with mixed references.Click the New Prices sheet tab and review the Formula bar.Change the project file name if directed to do so by your instructor, and save it. The file will be renamed automatically to include your name.If the workbook opens in Protected View, click the Enable Editing button so you can modify it.Click the View button and check the Group Titles check box under In Ribbon, Show. NOTE: If group titles are not visible on your Ribbon in Excel for Mac, click the Excel menu and select Preferences to open the Excel Preferences dialog box. Use relative, mixed, and 3D cell references.You will complete work on these sheets, calculate projected rates for each boat, and build basic statistics about past rentals.įile Needed: SanDiegoSailing-02.xlsx (Available from the Start File link.)Ĭompleted Project File Name: -SanDiegoSailing-02.xlsx Skills Covered in This Project One of the sheets is missing a piece of data and another sheet has circular reference errors. San Diego Sailing keeps data about its fleet of rental and charter boats.

MICROSOFT ADD IN DEVELOPMENT FOR BOTH WINDOWS AND MAC MAC

These instructions are compatible with both Microsoft Windows and Mac operating systems.