Question: Create and format the current date. Select cell G23 and insert the NOW function. Select cell G23 and click the Number drop-down list, and select

  1. Create and format the current date.
    1. Select cell G23 and insert the NOW function.
    2. Select cell G23 and click the Number drop-down list, and select More Number Formats. On the Number tab, select the Date category.
    3. Scroll the Type list to find the date that displays the month spelled out, the date, a comma, and a four-digit year (Figure 2-101).

      Figure 2-101 Date format selected

    4. Click OK. Press fn+Ctrl+Left Arrow or fn+Cmd+Left Arrow.
  2. Create and copy a VLOOKUP function to display goals for each funding source.
    1. Click the Family Day sheet tab and select cell F6.
    2. Start the VLOOKUP function and use cell E6 as the lookup_value.
    3. Click the Tables sheet tab for the table_array argument and use cells $A$6:$B$10. The data is sorted by the first column in ascending order.
    4. Use the second column as the col_index_num The range_lookup argument is empty.
    5. Copy the formula in cell F6 to cells F7:F20 without formatting to preserve the fill color.
    6. Format cells F6:F20 as Currency with no decimal places.
  3. Create and copy an IF function.
    1. Select cell H6 and start an IF
    2. Type a logical_argument to determine if cell G6 is greater than or equal to (>=) cell F6.
    3. Type Yes as the Value_if_true argument and No as the Value_if_false argument.
    4. Copy the formula in cell H6 to cells H7:H20 without formatting to maintain the fill color.
    5. Center align cells H6:H20.
    6. Press fn+Ctrl+Left Arrow or fn+Cmd+Left Arrow.
  4. Insert a new sheet at the end of the tab names and paste the range names starting in cell A1. AutoFit columns A:B and name the worksheet as Range Names.

Create and format the current date. Select cell

Create and format the current date. Select cell

Create and format the current date. Select cell

Home Insert Draw Page Layout Formulas Data Review View Tell me Share P Comments C Analysis Tools " a Connections Properties [OS A1 AY Clear Reapely Ye Advanced Flash Fill Data Validation Remove Duplicates 2 Consolidata Group El Ungroup Subtotal Gat Data Data fram Picture Stocks Ratresh All Currencies Filter Ceography 24 Sart Edit Links Text to Columns What if Analysis G20 fx A B C D E F G H I J L M 3 4 5 6 7 8 9 ID Last Name First Name Branch Commissions Bonus Rate Total Earnings 101 Lingle Bob Cameron Park $15,000 0.025 $15,375 102 McCartney Lanita Folsom $12,000 0.0225 $12,270 103 Santos Eleesha Cameron Park $5,500 0.015 $5,582.50 104 Baxter Roy Granite Bay $4,500 0.015 $4,567-50 105 Alaro Jennifer Folsom $3,000 0.015 $3,045 Tami Cameron Park $3,000 0.015 $3,045 117 Althouse Charlene Granite Bay $4.700 0.015 $4.770.50 119 Taylor Juan Granite Bay $4,000 0.015 $4,060 120 Reza Wayne Cameron Park $4,000 0.015 $4,060 125 Nevens Cheryl Cameron Park $12,000 0.0225 $12,270 10 115 Chan 11 12 13 14 15 16 17 Branch Totals 18 Cameron Park $ 40,332.50 19 Folsom $ 15,315.00 20 Granite Bay $ 13,398.00 21 Total $ 69,045.50 Commissions Family Day Tables + Ready E + 175% Home Insert Draw Page Layout Formulas Data - Review View Tell me Share Comments El Connections Analysis Tools a LO 21. Y ? clear Reapoly Advanced GI #4 Flash Fill Data Validation Text to Remove Duplicates 3. Consolidate Columns El Group Ungroup Subtotal S Properties Edit Links Cat Data Data from Picture Refresh All Stocks Currencies Geography 21 Sort Filter What-If Analysis A6 1 fx 101 A B C D E F H I J L L M N 0 Goal Reached? 5 5 Goal Amount 6 $750 $225 7 8 $725 9 10 11 115 Chan 12 ID Last Name First Name Branch Source 101 Lingle Bob Cameron Park Raffle tickets 102 McCartney Lanita Folsom Walk/run pledge 103 Santos Eleesha Cameron Park Cash donation 104 Baxter Roy Granite Bay Candy sales 105 Alaro Jennifer Folsom Pedometer sales Tami Cameron Park Raffle tickets 117 Althouse Charlene Granite Bay Walk/run pledge Juan Granite Bay Walk/run pledge 120 Reza Wayne Cameron Park Cash donation 125 Nevens Cheryl Cameron Park Candy sales 102 McCartney Lanita Folsom Candy sales 103 Santos Eleesha Cameron Park Raffle tickets 117 Althouse Charlene Granite Bay Raffle tickets 104 Baxter Roy Granite Bay Pedometer sales Jennifer Folsom Cash donation $450 $750 $275 $275 $325 $325 $215 $350 13 119 Taylor 14 15 16 17 $825 18 $900 $825 19 20 105 Alaro $1,000 21 22 23 24 25 26 27 Commissions Family Day Tables + Ready EP 163% Home Insert Draw Page Layout Formulas Data - Review View Tell me Share Comments hy Analysis Tools Connections Properties y Clear Ya Raapely Advanced Ef Flash File E Data Validation Test to FRemove Duplicates 3e Consolidate Columns IT: El Group Ungroup EH Subtotal Get Data Data from Picture Refresh All Stocks Currencies Geography Z] Sort Filter Edit Links What If Analysis A1 fx Commission A B C D E F G . H I. J K L M N 0 1 Commission $3,000 $6,000 $9,000 $12,000 $15,000 2 Bonus 1.50% 1.75% 1.90% 2.25% 2.50% 3 3 4 5 Source Goal 6 Candy sales $300 7 Cash donation $500 8 Pedometer sales $500 9 Raffle tickets $500 $250 10 Walk/run pledge 11 12 13 14 15 16 17 18 Commissions Family Day Tables + Ready 2 EP + 172% Home Insert Draw Page Layout Formulas Data Review View Tell me Share P Comments C Analysis Tools " a Connections Properties [OS A1 AY Clear Reapely Ye Advanced Flash Fill Data Validation Remove Duplicates 2 Consolidata Group El Ungroup Subtotal Gat Data Data fram Picture Stocks Ratresh All Currencies Filter Ceography 24 Sart Edit Links Text to Columns What if Analysis G20 fx A B C D E F G H I J L M 3 4 5 6 7 8 9 ID Last Name First Name Branch Commissions Bonus Rate Total Earnings 101 Lingle Bob Cameron Park $15,000 0.025 $15,375 102 McCartney Lanita Folsom $12,000 0.0225 $12,270 103 Santos Eleesha Cameron Park $5,500 0.015 $5,582.50 104 Baxter Roy Granite Bay $4,500 0.015 $4,567-50 105 Alaro Jennifer Folsom $3,000 0.015 $3,045 Tami Cameron Park $3,000 0.015 $3,045 117 Althouse Charlene Granite Bay $4.700 0.015 $4.770.50 119 Taylor Juan Granite Bay $4,000 0.015 $4,060 120 Reza Wayne Cameron Park $4,000 0.015 $4,060 125 Nevens Cheryl Cameron Park $12,000 0.0225 $12,270 10 115 Chan 11 12 13 14 15 16 17 Branch Totals 18 Cameron Park $ 40,332.50 19 Folsom $ 15,315.00 20 Granite Bay $ 13,398.00 21 Total $ 69,045.50 Commissions Family Day Tables + Ready E + 175% Home Insert Draw Page Layout Formulas Data - Review View Tell me Share Comments El Connections Analysis Tools a LO 21. Y ? clear Reapoly Advanced GI #4 Flash Fill Data Validation Text to Remove Duplicates 3. Consolidate Columns El Group Ungroup Subtotal S Properties Edit Links Cat Data Data from Picture Refresh All Stocks Currencies Geography 21 Sort Filter What-If Analysis A6 1 fx 101 A B C D E F H I J L L M N 0 Goal Reached? 5 5 Goal Amount 6 $750 $225 7 8 $725 9 10 11 115 Chan 12 ID Last Name First Name Branch Source 101 Lingle Bob Cameron Park Raffle tickets 102 McCartney Lanita Folsom Walk/run pledge 103 Santos Eleesha Cameron Park Cash donation 104 Baxter Roy Granite Bay Candy sales 105 Alaro Jennifer Folsom Pedometer sales Tami Cameron Park Raffle tickets 117 Althouse Charlene Granite Bay Walk/run pledge Juan Granite Bay Walk/run pledge 120 Reza Wayne Cameron Park Cash donation 125 Nevens Cheryl Cameron Park Candy sales 102 McCartney Lanita Folsom Candy sales 103 Santos Eleesha Cameron Park Raffle tickets 117 Althouse Charlene Granite Bay Raffle tickets 104 Baxter Roy Granite Bay Pedometer sales Jennifer Folsom Cash donation $450 $750 $275 $275 $325 $325 $215 $350 13 119 Taylor 14 15 16 17 $825 18 $900 $825 19 20 105 Alaro $1,000 21 22 23 24 25 26 27 Commissions Family Day Tables + Ready EP 163% Home Insert Draw Page Layout Formulas Data - Review View Tell me Share Comments hy Analysis Tools Connections Properties y Clear Ya Raapely Advanced Ef Flash File E Data Validation Test to FRemove Duplicates 3e Consolidate Columns IT: El Group Ungroup EH Subtotal Get Data Data from Picture Refresh All Stocks Currencies Geography Z] Sort Filter Edit Links What If Analysis A1 fx Commission A B C D E F G . H I. J K L M N 0 1 Commission $3,000 $6,000 $9,000 $12,000 $15,000 2 Bonus 1.50% 1.75% 1.90% 2.25% 2.50% 3 3 4 5 Source Goal 6 Candy sales $300 7 Cash donation $500 8 Pedometer sales $500 9 Raffle tickets $500 $250 10 Walk/run pledge 11 12 13 14 15 16 17 18 Commissions Family Day Tables + Ready 2 EP + 172%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

DIRECTIONS: DATA: FINAL RESULT SHOULD LOOK LIKE: Excel 2 Grader - Instructions Exp19_Excel_Ch09_ML1_Expenses Project Description: You carefully tracked your income and expenses for three months using...

Q:

Voice Sensitivity Editor Styles 5 Font Paragraph Excel 2019 Project Grader - Instructions Exp19_Excel_Ch09_ML1_Expenses Project Description: You carefully tracked your income and expenses for three...

Q:

COMP 1 0 0 3 In Class Module 1 2 Actionzone Cricket Camp runs events for boys and girls in grades 1 through 5 . You need to automate the registration process for this camp. Complete the following: 1...

Q:

1 N 3 Savings 4 Beginning Savings Balance Monthly Savings Added 6 Ending Savings Balance $ 300.00 100.00 5 $ 2,400.00 7 8 Income 9 Salary 10 11 Expenses 12 Rent 13 Utilities 14 Savings 15 Cell Phone...

Q:

Please help on Excel workbook. Thank you. 7. Create and copy a SUMIF function to calculate total earnings by branch office. a. Select cell E18. b. Start the SUMIF function with cells $D$5:$D$14 as...

Q:

Does anyone have the excel file of the instructions below? Office 2016 - myitlab:grader - Instructions Excel Project GO16_XL_CH04_GRADER_4G_HW - Warehouse Loan and Staf Lookup Form 1.0 Project...

Q:

Does anyone have the excel file of this document? It would be appreciated. Office 2016 - myitlab:grader - Instructions Excel Project GO16_XL_CH04_GRADER_4G_HW - Warehouse Loan and Staf Lookup Form...

Q:

Cross State Trucking Brian Eagleton is a dispatch manager at Cross State Trucking, a major Case folder included with you 2. Change the name of the Sheet worksheet using Travel Log as the name, and...

Q:

Need a lot of help figuring out this excel assignment please and thank you. Amy Zhao is a financial analyst with MedSight Instruments, a global manufacturer of medical instruments and devices. The...

Q:

the following questions by executing the required skills on the starter file listed above. Answer each question in the order it appears. Questions that are preceded with the letters KO indicate you...

Q:

For a lens of focal length f, what value of d would give an image with a magnification of one? (This is for a converging lens)

Q:

Refer to the test scores in the Exercise 4. a. Create a histogram for the test scores. b. Explain how you decided how many intervals to use for the histogram in part (a). c. Comment on the shape of...

Q:

A company's margin of safety multiplied by its contributidn margin ratio equals its Need help? Review these concept resources. Read About the Concept Rate your confidence to subenit High Medium Low...

Q:

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...