In Chapter 15, you read about a spammed GIF that was sent to a news reporter and intended to:

What is the name of the web hosting provider that terminated its relationship with Kiwi Farms?

Randomly generated passwords are much more secure to use than re-using your same password. 

What is the term used to describe a data storage device that is portable and located outside of a computer that can be connected via USB or other means?

Some courts have viewed compelled decryption using biometric identifiers as permissible under the 5th Amendment prohibition against self-incrimination because merely exposing a physical feature to a locked electronic device does not require use of “the contents of own mind” to communicate a statement of fact.

Take the exam on MyOpenMath by clicking this link.  After taking the exam in MyOpenMath, write DONE below and CLICK SUBMIT.

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

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.

The textbook authors state that when writing a rhetorical analysis, students should consider what?

Which of the following means of persuasion appeals to reason?