Apply the date number format to the selected cells to display dates in the format similar to 14-Mar.
Edit the formula in cell B9 so the references to ce
... [Show More] ll E2 will update when the formula is copied, and the reference to cell B8 will remain constant. Use AutoFill to copy the formula to cells B10:B12.
Use Format Painter to copy the formatting from cell E1 and apply it to cell F1.
Apply conditional formatting to the selected cells using the blue solid fill data bar.
Apply conditional formatting to the selected cells using the Three Symbols (Circled) icon set (the first icon set in the Indicators section).
Replace all instances of the word Spa Pool in this worksheet with Pool. Do not replace them one at a time. Close the dialog when you are finished.
In cell C12, enter a formula using a counting function to count the number of items in the Item column (cells C2:C11).
In cell G12, enter a formula using a counting function to count the number of blank cells in the Received column (cells G2:G11).
Edit the Bonuses named range so it refers to cells B2:B5 on the Bonus worksheet. Close the Name Manager when you are finished.
Enter a formula in cell C2 to return a value of yes if the value in cell E8 is greater than or equal to the value in B2 or no if it is not.
Using cell references, enter a formula in cell B7 to calculate monthly payments for the loan described in this worksheet. Use a negative value for the Pv argument.
Enter a formula in cell B2 using the VLOOKUP function to find the total sales for the date in cell B1. Use the name DailySales for the lookup table. The total sales are located in column 5 of the lookup table. Be sure to require an exact match.
Enter a formula in cell C3 using the SUMPRODUCT function to calculate the total value of the current leases by multiplying the current monthly rents by the remaining months on each lease. Use the range names SpecialPrice and MembershipsSold.
Enter a formula in cell E2 using SUMIFS to calculate the total price (use the named range JunePrices) where the value in the JunePOs named range is equal to the value in cell D1 and the value in the JuneCompanies named range is equal to "Salon Supplies".
Enter a formula in cell C1 to calculate the standard deviation of the values in cells C5:C13.
Enter a formula in cell C1 to find the rank of the value in cell C9 compared to the values in cells C5:C13.
In cell D6, enter a formula using OR to display TRUE if the daily sales (cell C6) is greater than the overall average (cell C3) or the daily sales (cell C6) is greater than the employee's average (cell C4). Use cell references and enter the arguments exactly as described in this question.
In cell D6, enter a formula using AND to display TRUE if the daily sales (cell C6) is greater than the overall average (cell C3) and the daily sales (cell C6) is greater than the employee's average (cell C4). Use cell references and enter the arguments exactly as described in this question.
In cell B5, enter a formula using the function for the Declining balance depreciation method. Use the cell names Purchase, Sale, and Life for the function arguments. Use a relative reference to cell A5 for the Per argument. Enter a partial year of 4 months in the Month argument. [Show Less]