Exp19_Excel_Ch09_CapAssessment_Tips

98% Marked

Please Use your file

Start Excel. Download and open the file named Exp19_Excel_Ch09_Cap_Assessment_Tips.xlsx. Grader has automatically added your last name to the beginning of the filename.

The Excel workbook contains circular references. When you open the file, an error message displays. This error will be resolved as part of the project

The Tip Left column in the Friday worksheet contains a fill color and number formatting. You want to fill these formats to the other daily worksheets.

Group the Friday through Monday worksheets, staring with the Friday worksheet. Fill the format only for the range E5:E24.

Now you want to insert column totals for the five worksheets simultaneously.

With the worksheets still grouped, insert SUM functions in the range B25:E25 and apply the Totals cell style. Ungroup the worksheets.

The Week worksheet is designed to be a summary sheet. You want to insert a hyperlink to the Total heading in the Monday worksheet.

On the Week worksheet, in cell A5, insert a hyperlink to cell A25 in the Monday worksheet with the ScreenTip text Monday’s Totals. Test the hyperlink to ensure it works correctly.

In cell A6 on the Week worksheet, insert a hyperlink to cell A25 in the Tuesday worksheet with the ScreenTip text Tuesday’s Totals. Test the hyperlink to ensure it works correctly.

In cell A7, insert a hyperlink to cell A25 in the Wednesday worksheet with the ScreenTip text Wednesday’s Totals. Test the hyperlink to ensure it works correctly.

In cell A8, insert a hyperlink to cell A25 in the Thursday worksheet with the ScreenTip text Thursday’s Totals. Test the hyperlink to ensure it works correctly.

In cell A9, insert a hyperlink to cell A25 in the Friday worksheet with the ScreenTip text Friday’s Totals. Test the hyperlink to ensure it works correctly.

Now, you are ready to insert references to cells in the individual worksheets. First, you will insert a reference to Monday’s Food Total.

In cell B5 on the Week worksheet, insert a formula with a 3-D reference to cell B25 in the Monday worksheet. Copy the formula to the range C5:E5.

The next formula will display the totals for Tuesday.

In cell B6, insert a formula with a 3-D reference to cell B25 in the Tuesday worksheet. Copy the formula to the range C6:E6.

In cell B7, insert a formula with a 3-D reference to cell B25 in the Wednesday worksheet. Copy the formula to the range C7:E7.

In cell B8, insert a formula with a 3-D reference to cell B25 in the Thursday worksheet. Copy the formula to the range C8:E8.

In cell B9, insert a formula with a 3-D reference to cell B25 in the Friday worksheet. Copy the formula to the range C9:E9.

Now you want to use a function with a 3-D reference to calculate the totals.

In cell B10 on the Week worksheet, insert the SUM function with a 3-D reference to calculate the total Food purchases (cell B25) for the five days. Copy the function to the range C10:E10.

The servers are required to share a portion of their tips with the Beverage Worker and Assistants. The rates are stored in another file.

Open the Exp_Excel_Ch09_Cap_Assessment_Rates.xlsx workbook. Go back to the Exp_Excel_Ch09_Cap_Assessment_Tips.xlsx workbook. In cell F5 of the Week worksheet, insert a link to the Beverage Worker Tip Rate (cell C4 in the Rates workbook) and multiply the rate by the Monday Drinks (cell C5). Copy the formula to the range F6:F9.

Next, you will calculate the tips for the assistant.

In cell G5 in the Tips workbook, insert a link to the Assistant Tip Rate (cell C5 in the Rates workbook) and multiply the rate by the Monday Subtotal (cell D5). Copy the formula to the range G6:G9. Close the Rates workbook.

Note: The tip is a monetary value in the Week worksheet. It should be formatted for Accounting Number Format.

You noticed a circular error when you first opened the Tips workbook. Now you will find and correct it.

On the Week worksheet, check for errors and correct the formula with the circular reference.

You want to create a validation rule to prevent the user from accidentally entering a negative value. For now, you will create a validation in the Friday worksheet.

Select the range E5:E24 in the Friday worksheet, create a validation rule to allow a decimal value greater than or equal to zero. Enter the input message title Tip and the input message Enter the amount of tip. (including the period). Use the Stop alert with the error alert title Invalid Number and the error alert message The tip must be zero or more. (including the period). Test the data validation by attempting to enter -20 in cell E5 and then cancel the change.

Now you will copy the validation settings to the other daily worksheets.

Copy the range E5:E24 in the Friday worksheet. Group the Monday through Thursday worksheets, select the range E5:E24, and use Paste Special Validation to copy the validation settings.

You want to unlock data-entry cells so that the user can change the tips in the daily worksheets.

Group the Monday through Friday worksheets. Select the ranges E5:E24 and unlock these cells.

Create footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of all worksheets.

Now that you unlocked data-entry cells, you are ready to protect the worksheets to prevent users from changing data in other cells. Individually, protect each sheet using the default allowances without a password.

Mark the workbook as final.

Note: Mark as Final is not available in Excel for Mac. Instead, use Always Open Read-Only on the Review tab.

Save and close Exp19_Excel_Ch09_Cap_Assessment_Tips.xlsx. Exit Excel. Submit the file as directed.

Strenghts Finder 2

This paper will allow you to examine your strengths and develop a plan for moving forward.

I. What Do You Do Best?

· Of all the things you do well, which two do you do best and why?

· Which activities do you seem to pick up quickly and why?

· Which activities bring you the greatest satisfaction and why?

II. STRENGTHSFINDER Results

· What are your top five Signature Themes as identified by the Clifton STRENGTHSFINDER? Which theme resonates with you the most and why?

· Based on your Signature Themes, what should a manager/supervisor know about working with you and why?

· Based on your Signature Themes, what should a co-worker know about working with you and why?

· How can a manager/supervisor help you with your strengths more within your current role and why?

III. Celebrating Successes

· What was your most significant accomplishment in the past 12 months?

· When do you feel the most pride about your work?

· How do you like to be supported in your work?

IV. Applying Talents to the Role

· What things distract you from being positive, productive, or accurate?

· Which talents do you have that could benefit the team if you had better opportunities to use them?

· What steps could be taken to ensure you have an opportunity to apply your natural talents to your role?

· Submit a 5-page paper double spaced

· Include a cover page and a reference page (not to be included in the 5 pages of paper content)

· Use the questions and bullets above as the framework and outline of your paper.

· Please provide at least four (4) scholarly references to support your paper in addition to the STRENGTHSFINDER text.

· All references should be used as in-text citations.

dv wk 4

There are various languages, some are better for data visualization than others. Please review the basics of Python, SAS, R, and SQL. What are the qualities of each language regarding data visualization (select at least two to compare and contrast)? What are the pros and cons of each regarding data visualization (select at least two to compare and contrast)?

presentation of 15 slides and final paper that is 4-5 pages

The project must be a presentation of 15 slides and final paper that is 5 pages (double-spaced) on a cybersecurity topic with APA citations.

Following are the topics:

Network Access Control and Cloud Security

Transport-Level Security

Wireless Network Security

IP Security

Key Distribution and User Authentication

Exp19_Excel_Ch09_CapAssessment_Tips

Exp19_Excel_Ch09_CapAssessment_Tips

Exp19 Excel Ch09 CapAssessment Tips

Excel Chapter 9 Capstone Assessment – Tips

Project Description:

Your friend Kimo is a server at a restaurant. He downloaded data for his customers’ food and beverage purchases for the week. You will complete the workbook by applying consistent formatting across the worksheets and finalizing the weekly summary. The restaurant requires tip sharing, so you will calculate how much he will share with the beverage worker and the assistant.

Start Excel. Download and open the file named Exp19_Excel_Ch09_Cap_Assessment_Tips.xlsx. Grader has automatically added your last name to the beginning of the filename.

The Excel workbook contains circular references. When you open the file, an error message displays. This error will be resolved as part of the project

The Tip Left column in the Friday worksheet contains a fill color and number formatting. You want to fill these formats to the other daily worksheets.

Group the Friday through Monday worksheets, staring with the Friday worksheet. Fill the format only for the range E5:E24.

Now you want to insert column totals for the five worksheets simultaneously.

With the worksheets still grouped, insert SUM functions in the range B25:E25 and apply the Totals cell style. Ungroup the worksheets.

The Week worksheet is designed to be a summary sheet. You want to insert a hyperlink to the Total heading in the Monday worksheet.

On the Week worksheet, in cell A5, insert a hyperlink to cell A25 in the Monday worksheet with the ScreenTip text Monday’s Totals. Test the hyperlink to ensure it works correctly.

In cell A6 on the Week worksheet, insert a hyperlink to cell A25 in the Tuesday worksheet with the ScreenTip text Tuesday’s Totals. Test the hyperlink to ensure it works correctly.

In cell A7, insert a hyperlink to cell A25 in the Wednesday worksheet with the ScreenTip text Wednesday’s Totals. Test the hyperlink to ensure it works correctly.

In cell A8, insert a hyperlink to cell A25 in the Thursday worksheet with the ScreenTip text Thursday’s Totals. Test the hyperlink to ensure it works correctly.

In cell A9, insert a hyperlink to cell A25 in the Friday worksheet with the ScreenTip text Friday’s Totals. Test the hyperlink to ensure it works correctly.

Now, you are ready to insert references to cells in the individual worksheets. First, you will insert a reference to Monday’s Food Total.

In cell B5 on the Week worksheet, insert a formula with a 3-D reference to cell B25 in the Monday worksheet. Copy the formula to the range C5:E5.

The next formula will display the totals for Tuesday.

In cell B6, insert a formula with a 3-D reference to cell B25 in the Tuesday worksheet. Copy the formula to the range C6:E6.

In cell B7, insert a formula with a 3-D reference to cell B25 in the Wednesday worksheet. Copy the formula to the range C7:E7.

In cell B8, insert a formula with a 3-D reference to cell B25 in the Thursday worksheet. Copy the formula to the range C8:E8.

In cell B9, insert a formula with a 3-D reference to cell B25 in the Friday worksheet. Copy the formula to the range C9:E9.

Now you want to use a function with a 3-D reference to calculate the totals.

In cell B10 on the Week worksheet, insert the SUM function with a 3-D reference to calculate the total Food purchases (cell B25) for the five days. Copy the function to the range C10:E10.

The servers are required to share a portion of their tips with the Beverage Worker and Assistants. The rates are stored in another file.

Next, you will calculate the tips for the assistant.

Note: The tip is a monetary value in the Week worksheet. It should be formatted for Accounting Number Format.

You noticed a circular error when you first opened the Tips workbook. Now you will find and correct it.

On the Week worksheet, check for errors and correct the formula with the circular reference.

You want to create a validation rule to prevent the user from accidentally entering a negative value. For now, you will create a validation in the Friday worksheet.

Select the range E5:E24 in the Friday worksheet, create a validation rule to allow a decimal value greater than or equal to zero. Enter the input message title Tip and the input message Enter the amount of tip. (including the period). Use the Stop alert with the error alert title Invalid Number and the error alert message The tip must be zero or more. (including the period). Test the data validation by attempting to enter -20 in cell E5 and then cancel the change.

Now you will copy the validation settings to the other daily worksheets.

Copy the range E5:E24 in the Friday worksheet. Group the Monday through Thursday worksheets, select the range E5:E24, and use Paste Special Validation to copy the validation settings.

You want to unlock data-entry cells so that the user can change the tips in the daily worksheets.

Group the Monday through Friday worksheets. Select the ranges E5:E24 and unlock these cells.

Create footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of all worksheets.

Mark the workbook as final.

Note: Mark as Final is not available in Excel for Mac. Instead, use Always Open Read-Only on the Review tab.

Save and close Exp19_Excel_Ch09_Cap_Assessment_Tips.xlsx. Exit Excel. Submit the file as directed.

Workbook assignments

Workbook assignments. All assignments are compiled in the provided document.

Additional files are in a zip that I will provide seperately.

Please read the document before replying.

Exp19_PowerPoint_Ch02_HOEAssessment_Wedding

Exp19 PowerPoint Ch02 HOEAssessment Wedding

PowerPoint_Chapter_2_Hands_On_Exercise_Assessment_Wedding

Project Description:

You are asked to develop a presentation that will be used to promote La Belle Fleurs, a wedding planning service. Potential clients include prospective brides, grooms, and their families. Using accepted design principles, the presentation is developed to include shapes, animation, transitions, and video.

Start PowerPoint. Download and open the file named Exp19_PPT_Ch02_HOEAssessment_Wedding.pptx. Grader has automatically added your last name to the beginning of the filename.

Replace Student Name on Slide 1 with Mary Albert. Change the title font to Arial.

Contrast is one of the main design principles used in a presentation to direct focus and aid in readability. You adjust the formatting of the font used in the presentation so there is better contrast.

Click Slide 2, select the title, and change the font to Arial. Change the size to 72. Change the Font color to Brown, Text 1, Lighter 10%. Double-click the Format Painter button. Apply the formatting to the titles for Slide 3 through Slide 7. Press ESC.

You begin to prepare for adding objects that will enhance the presentation’s message to some of the slides by deleting a couple of placeholders. These will not be needed once the objects are added. You also adjust the formatting of the font on the slides.

Click Slide 3 and select the left content placeholder border. Change the Font color to Brown, Text 1. Repeat for Slide 5. Delete the image on Slide 5.

This slide is enhanced by using the alignment design principle to bring the email address closer to the phrase Contact us. The font formatting should be adjusted as well.

Click Slide 7. Select the email address and then click Align Right in the Paragraph group. Select Contact us at: and change the size to 44. Change the Font color to Brown, Text 1.

You add a heart shape to enhance the message of the slide. Then the heart will be filled with a picture of a wedding cake. Some additional text will be added to the slide to finish the message.

Click Slide 5 and delete the right content placeholder. Click the Insert tab. Click Shapes in the Illustration group. Click the Heart in the Basic Shapes group and then click in the right side of the slide.

Size the heart to a height of 5.5” and a width of 5.5”. Position it Horizontally at 7.45” from Top Left corner and Vertically 1.75” from Top Left Corner. Click Shape Fill in the Shape Styles group, and then click Picture. Click From a File and navigate to where you have your files stored. Click Cake.jpg and click Insert.

Click Compress Pictures in the Adjust group on the Picture Format tab. In the Compress Pictures dialog box, with Use default resolution selected, click OK.

Begin a new paragraph beneath the current paragraph and type For you to choose in the left Content placeholder on Slide 5.

Animation is added to the email address to emphasize it.

Click Slide 7, select the email address, and then click the Animations tab. Click More in the Animation group and then click Random Bars in the Entrance category.

Select the email address again and click Add Animation in the Advanced Animation group. Click Bold Reveal in the Emphasis category.

Animation is added to the new phrase on this slide to control how it appears on the slide. This helps to focus how the audience receives the message of the slide.

Click Slide 5 and select For you to choose. Click More on the Animations tab and then click More Entrance Effects. Click Expand in the Subtle category. Click OK.

You continue to add and adjust animations used on several slides in the presentation. The goal is to add interest to the presentation and keep the audience’s attention on the slides.

Click Slide 2 and select the text in the content placeholder. On the Animations tab, in the Animation group, click More, and then click More Entrance Effects. Click Fade in the Subtle category. Click OK. Change the Font color to Brown, Text 1.

Select the content placeholder on Slide 2. Click the Effect Options Dialog Box Launcher to display the Fade dialog box. Click the Animate text arrow and click By word.

Click the Timing tab. Click the Start arrow and then click After Previous. Set the Delay to 0.75 seconds and the Duration to 2 seconds (Medium). Click OK.

Click Slide 5 and select the phrase For you to choose. Set the Start to After Previous. Click the Delay arrow in the Timing group to reach 00.75.

Click Slide 7 and then click the content placeholder. Click the Animations tab. Click Animation Pane in the Advanced Animation group. Click the second Exploring2019 arrow (for Bold Reveal Emphasis). Click Start After Previous.

Click Slide 6. Drag the right edge of the third timeline bar in the Animation Pane to the left until the ScreenTip displays End: 8.4s. Drag the right edge of the fourth timeline bar the left until the ScreenTip displays End: 11.4s.

Note, Mac users, set the duration of the Fade animation for the third hexagon to 5.4 seconds, and the duration for the fourth hexagon to 3 seconds.

Click Slide 2 and click the content placeholder. Adjust the Delay arrow to 01.00.

You apply a transition to all the slides in the presentation to create visual interest and re-focus the audience attention as each new slide displays during the presentation.

Click the Transitions tab and click More in the Transition to This Slide group. Click Push under Subtle. Click Apply to All in the Timing group.

Select the Slide 1 thumbnail, click the Effect Options arrow in the Transitions to This Slide group, and then select From Left. Click On Mouse Click in the Timing group to deselect it. Click After and set it to 00:02.00. Click Apply to All.

Video engages the audience’s emotions and helps to reinforce the message of your presentation. This helps the audience remember the message of the presentation, so you add one on this slide.

Select Slide 3. Click the right content placeholder. Click the Insert Video icon. Navigate to where you have your file stored and insert the Violins.mp4 video.

You use the Playback and Format tabs to adjust the video’s properties.

Click Move Forward 0.25 Seconds on the Media Controls bar located beneath the video to advance the video to the frame at 1.50 seconds. Click the Poster Frame in the Adjust group on the Format tab, and then click Current Frame.

Click Video Shape in the Video Styles group and click Hexagon in the Basic Shapes category. Click Video Effects, point to Shadow, and then click Perspective: Lower Left in the Perspective category.

Select the video object, click the Playback tab, and then click Trim Video in the Editing group. Drag the red End Time marker on the slider until 00:03.000 displays in the End Time box. Click OK. Click the Start arrow in the Video Options group and select Automatically. Click the Loop until Stopped check box in the Video Options group to select it.

Note, Mac users, skip the instruction to trim the video, however, set the other options.

You check the presentation to make sure all of the changes you have made work as you designed them to work. Then you compress the media to reduce the overall file size of the presentation.

Click the Slide Show tab and click From Beginning in the Start Slide Show group. Press ESC. Click the File tab, and then click Compress Media. Select Standard (480p).

Save and close Exp_PPT_Ch02_HOEAssessment_Wedding_solution.pptx. Exit PowerPoint. Submit the file as directed.

WK9 20210629

NOTE: **** post answers in separate documents for each Question

**** Please follow the instructions to the point and pick relavant topics according to the subject

**** Follow APA7 format

cost estimation in excel spreadsheet

refer to the attached document.

Analysis Phase

In the analysis phase the teams need to:

Requirements Determination: All the requirements for the new system needs to be defined in this document
Data Flow Diagrams
Use Case Diagrams
Activity Diagram
Class Diagrams

More Info on the company you will be working on is below:

Project objective –

Develop a business intelligence dashboard to be used by the Analytics and Marketing departments to conveniently analyze data and present key insights in an easy-to-use and intuitive manner.

Justification for the project –

This project attempts to solve operational problems encountered by data analytics professionals at Swift Trade Corp. The business intelligence dashboard will facilitate the process of presenting data and other important business metrics important to the company’s performance.

InstantHomeworks

Monthly Archives: June 2023

Exp19_Excel_Ch09_CapAssessment_Tips

Exp19_Excel_Ch09_CapAssessment_Tips

Strenghts Finder 2

dv wk 4

presentation of 15 slides and final paper that is 4-5 pages

Exp19_Excel_Ch09_CapAssessment_Tips

Project Description:

Workbook assignments

Exp19_PowerPoint_Ch02_HOEAssessment_Wedding

Exp19_PowerPoint_Ch02_HOEAssessment_Wedding

Exp19 PowerPoint Ch02 HOEAssessment Wedding

Project Description:

WK9 20210629

cost estimation in excel spreadsheet

Analysis Phase

InstantHomeworks

QUICk LINKS

CONTACT

Referral Program