Blog

Part One – MS Word –55 Points  Create a Folder on your D…

Part One – MS Word –55 Points  Create a Folder on your Desktop named “Exam”  Download the file below and save it in your in Exam folder SU25_Final_P1_Template.docx Rename the template file with your Last name + First initial + _P1.docx Example for John Smith:        SmithJ_P1.docx   Frontier Travel, Inc. has recently encountered issues involving ethical conduct. You have been asked to prepare a document defining the company’s ethical policies. Using your newly renamed SP25_Final_P1_template.docx file, make the following changes.   1.    Change the top and bottom margins to .9″, the left margin to 1¼”, and the right margin to .95″ for the entire document. 2.    Apply the Heading 1 style, Automatic Font Color, and Center the following headings in the document: Ethics The Borrowed Homework Assignment The Honor Code Downloading Music from the Web The Office CD The $50 Bill Sources 3.    Insert a Next Page Section Break at the beginning of the document. 4.    On the blank page before the body of the document, Insert a Table of Contents. Use the Classic format and include tab leaders of your choice. 5.    Next, two lines above the table of contents, type in the text, TABLE OF CONTENTS, then apply the Normal Style with font size 24, bold, and horizontal centering to your typed text.                          6.    Now insert another Next Page Section Break immediately before the Table of Contents text entered in the previous step, and enter the following on the new page: Frontier Travel, Inc. (use Cambria, font size 38, bold, centered) Ethics Policy (use Cambria, font size 30, bold, centered) By (use Cambria, font size 30, bold, centered) Your Name (use Cambria, font size 30, bold, centered) Insert an automatically updating date (use Cambria, font size 30, bold, centered) 7.    Vertically center your new title page AND the Table of Contents pages only. 8.    Number your pages starting with the body (page 1) of the document (with the Ethics Heading). Display the word “Page” with the numbers (ex. Page 1) and locate them at the bottom center of the document. Do not show page numbers on the title page or table of contents page. 9.      Add numbering to the three lines in the second paragraph following the second paragraph, following the text,” As with every decision, you begin by identifying the facts:”.  Alphabetize these three items in Ascending order. 10.    Apply an outside border around the entire next paragraph that begins with the text, “The decision maker can then decide… “. 11.    Add non-default bullets to the two items in the next paragraph following the text, “Perhaps the most basic tenet guiding any decision is the Golden Rule that states:”. 12.    Add a footnote after the italicized quote, “if an action is not right for everyone, it is not right for anyone”. The footnote text should be:  Immanuel Kant (1724-1804). 13.    Add another footnote after the italicized quote, “that while an action might be acceptable initially, it must be repeatable or else it should not be taken at all”.  The footnote text should be:  Rene Descartes (1596-1650). 14.    Ensure that the heading, The Borrowed Homework Assignment, and the entire paragraph that follows it appear on the same page. Do not add any additional paragraphs or a page or section break. 15.    In the second to last sentence of the document (in The $50 Bill section), use the Thesaurus to find an appropriate replacement for the word “clearly”. Highlight the word in yellow. 16.    Insert a Page Break immediately before the heading Sources. 17.    Use a ½ -inch hanging indent for the entries under Sources. Also, use italics for the entire title (only) of each book. 18.     Sort the entries so they are in alphabetical order by author and ensure there is one blank paragraph between the two citations. 19.     Make sure your Table of Contents indicates the correct page numbers. 20.    Carefully check the spelling and grammar of the text in your document. 21.   Be sure you save your file to the Exam folder on your desktop. Attach your file in the answer box below using the attachment option. Screenshot 2025-02-26 124438.png

Frontier Travel, Inc. now wants to create a presentation on…

Frontier Travel, Inc. now wants to create a presentation on ethics for their employees. Launch PowerPoint and create a NEW PowerPoint document using the Organic Theme. If PowerPoint launches to a blank theme or does not launch to the theme selector window, select the Design Tab and select the Organic Theme.   Name the document with your last name + first initial + _Presentation + .pptx  Example for John Smith:      SmithJ_Presentation.pptx You will be reusing the $50 Bill image: $50_Bill.jpg 1.   On the Design Ribbon, select Variants, Colors, and then Aspect.  2.   As you are creating the presentation, choose the Slide Layout that best meets the requirements for each of the following slides. SLIDE ONE      Title:   Frontier Travel Ethics Information      Subtitle:         By: {Your First and Last Name}   SLIDE TWO      Title:   Ethical Issues      Bullet Statements – use first- and second-level bullets as indicated:            Honor Code            Do your own work            Report dishonest behavior Downloading Music            Pay for your downloaded copies            Do not give copies to others            Office CDs            Do not make copies            One installation per CD NOTE: modify the size of the first-level bullets to 22, and the size of the second-level bullets to 19              SLIDE THREE – use a 1-column table, 4-row table      Title:   Ethical Questions      Table Information:                              Identify the facts                              Determine the consequences                              Evaluate the courses of action                              Consider the effects of your decision upon others NOTE: Select the No-Style, Table-Grid Design Increase the Font size of the Table information to 26 points                Center all contents of the Table horizontally and vertically.      Increase the height of the entire table to exactly 3″ high.   SLIDE FOUR      Title:   The $50 Ethics Example      Bullet Statements – use first- and second-level bullets as indicated:                              You gave a clerk $5 but received change for a $50                              What actions do you take?                                          Do you keep the money?                                          Do you give it back?                                          Does the size of the store matter?                              What if it happened to the person in front of you?                                         Would you speak up?                                         Would you ignore it?                                                  NOTE: Add the $50_Bill.jpg picture to this slide and size it to exactly 1.3″ high by 3.0″ wide. Position the picture in the lower right corner, ensuring that it does not cover any text.     Additional Requirements: 3.   Put the Slide Number and the Footer text, Company Ethics on all slide footers except the Title Slide. 4.   Bold and Center the Titles on all slides. 5.   Choose one transition for your presentation and apply to all slides. 6.   Apply a Custom Animation, “Entrance” Effect to the picture on Slide Four. Have the animation Start with Previous 7.   Proofread and spell-check your document. 8.   Leave the presentation in slide sorter view. 9.   Finally, be sure you saved your file to the Exam folder on your desktop as a PowerPoint file. Attach your result PowerPoint file in the answer box below using the attachment option. 

Filename, Sort, Filter, Pivot Table, Subtotals, Data & Stati…

Filename, Sort, Filter, Pivot Table, Subtotals, Data & Statistical Functions, and Print Settings — 65 Points 1.   Create a Folder on your Desktop named Exam.   2 .  Download the following file(click on the 3 dots at the end of the line and click download), save it to your Exam folder. SU25_Excel_Template_Ex2.xlsx 3.   Use the SU25_Excel_Template_Ex2.xlsx file that you downloaded from Blackboard for this exam.  “Save As” or Rename this workbook as your last name + your first initial + _Ex2.xlsx.  Below is an example of the filename you would use if you were Sam Smith: Filename Example:         SmithS_Ex2.xlsx 4.    You are continuing your work with Experience Alaska, Inc. and they have asked you for specific information about their planned late-May through mid-July 2021 trip packages.  It is highly recommended that you save your work frequently.   5.    With your newly renamed file open in Excel, make the Packages sheet active.   6.    Using the appropriate command option, sort the list by Departure Date (oldest to newest), Trip Type (Z to A), and Package Price (smallest to largest) in order.    7.    Copy the Packages sheet to a new sheet and name the new sheet Filter.   8.    Make the Filter sheet active. Turn on Filters for all data columns. Using Number Filters for both, display the data for trips with a Trip Length of greater than 5 Nights, and a Package Price of $2,300 or more. Your Filters should account for the possibility of any future trips that may be added.   9.    Return to the Packages sheet. Management would like to further analyze their current booking information. Create a Pivot Table on a New Worksheet showing the Average of Package Price by both Trip Type (in rows) and Destination (in columns). Format the Trip Cost data as Currency with Dollar Signs and Zero Decimals. Rename your new worksheet Pivot Analysis. 10.    Management would like another booking information analysis. Copy the Packages sheet to another new sheet, and name the new sheet Subtotals. Create a Subtotal that displays the average amounts of only the Package Price at each change in Trip Type. You will first need to sort your information appropriately. 11.    Management now needs to determine how their trip prices will be affected by a proposed tax. Copy the Packages sheet to another new sheet, and name the new sheet Trip Tax. Insert a new column between column D and column E and name the new Column E, PriceWithTax. Ensuring that the Range_lookup finds an Exact Match, use the VLOOKUP function to calculate the new PriceWithTax based upon the percentages in the Proposed Tax Table that gives the DeparturePoint for each PackageNum. Apply the same formatting used in Column D, Package Price. 12. Return to the Packages sheet once again, and in cell A30 enter the text Total price of trips going to Seward on the AK RR.  In cell D30, use the appropriate conditional math function to determine that total. Format your result with Currency and zero decimals. 13. In cell A31 of the Packages sheet, enter the text Number of trips departing on July 5.  In cell D31, use the appropriate conditional statistical function to determine that number. 14. With your Packages tab/worksheet active, set the print settings to the following: a)    Landscape orientation b)   Fit to one page c)    Center both vertically and horizontally d)   Create a Custom Header with Your Name in the center section e)   Create a Custom Footer using the appropriate button to display the File (Workbook) name in the center section.                                           Three Year Forecast Activities — 35 Points 1.    Make your Three Year Forecast sheet active. Experience Alaska, Inc. would like you to continue to assist them with their forecast information. 2.    Previously, we created this forecast worksheet and determined the Award Status. Now use Conditional Formatting in the range B23:D23 to emphasize when a “Cash Bonus” is to be awarded. Show the cell contents with a Bold & Italic Dark Blue, Text 2 font (first row, fourth column), and with an Outline Border of the same color when the condition is met. Do not use more than one rule. 3.    While on the Three Year Forecast sheet, create a Scenario Summary report with the following information using cells B23:D23 as the result cells:    Scenario Name Data Specifics    Original Expense Variables Same Percentages that are currently given    Increased Advertising Use 17.50% instead of 15.00%    Decreased Salaries Per Year Use 50.00% instead of 55.00%    Hide column D (the Current Values: column) on your newly created Scenario Summary worksheet. Make sure your Scenario Summary report is easily understood by any reader. The Changing Cells and Result Cell descriptions should not display cell references. 4.    Next, make the Goal Seek sheet active. You previously used the PMT function to determine the cost of a new boat (showing a negative dollar amount), but Experience Alaska wants to pay less per month. With the Goal Seek sheet active, use the Goal Seek feature of Excel to determine the down payment that would be necessary to make the Monthly Payment equal to $500. 5.    Using the same Goal Seek sheet, create a Two-Variable Data Table for the Monthly Payment Amounts using an Annual Interest Rate Range of 3.00% to 5.00% (in increments of .25%) and Term in Years options of 2, 3, and 4. Use cell D5 as the upper-left corner of your table, and format your Monthly Payment amounts with Currency and zero decimals. Ensure that all data is visible. Apply a custom number format to make the formula reference in cell D5 appears as Monthly Payment.    Excel Chart—20 Points 1.    With your Three Year Forecast sheet active and your Scenario Summary showing the Original Expense Variables, create a Pie in 3-D chart demonstrating the Net Profit After Taxes by Forecast Year.  a)    Place your chart on a New Chart Sheet (not Object in) and name the tab “Profit Chart”.  b)   Create a title above the chart as Forecasted Net Profit After Taxes by Your Name. c)    Use Outside End Data Labels to display only Percentages with one decimal place, and Category Names. Remove the legend. d)   Apply a Pattern Fill and Explode the piece that illustrates the year with the highest forecasted Net Profit After Taxes percentage. Make sure your spelling on the chart is correct Finally—5 Points 1.    Make sure your worksheets are in the following order:  Three Year Forecast, Goal Seek, Scenario Summary, Profit Chart, Pivot Analysis, Packages, Subtotals, Filter, and Trip Tax. 2.    Ensure that there are no spelling errors on your Three Year Forecast and Goal Seek worksheets. 3.    Save your workbook one last time and exit Excel. 4.     In the answer box below , click on the attachment icon and attach your file to it. ** Make sure your file is saved and attached properly to this question, otherwise your instructor will not receive your exam to grade. Screenshot 2025-02-26 124438.png 5. Once your file is submitted, delete all exams files and empty your recycle bin.