Imagine this spreadsheet is to be presented to your future bosss boss on printed paper....
80.2K
Verified Solution
Link Copied!
Question
Accounting
Imagine this spreadsheet is to be presented to your future bosss boss on printed paper. Title your spreadsheet as is this document colon your name colon the current date in YYYY-MM-DD format in 18pt bold font. All other fonts should be in 12pt font. The data of the spreadsheet is as follows: Kristin Truman has 27 apples, 38 oranges, 55 limes, and 121 lemons. Marie X. Kayhill has 91 apples, 90 oranges, 19 limes, and 18 lemons. Jonathan S. Brown has 66 apples, 15 oranges, 47 limes, and 27 lemons. Caleigh Balestra has 67 apples, 70 oranges, 16 limes, and 2 lemons. Franklin D. Isler has 70 apples, 108 oranges, 35 limes, and 120 lemons. Elizabeth T. Montrairro has 0 apples, 24 oranges, 50 limes, and 46 lemons. Veronica J. Kennedy has 0 apples, 52 oranges, 135 limes, and 109 lemons. Magdalena Dvalishvili has 133 apples, 94 oranges, 117 limes, and 87 lemons. Ronald Sorenson has 137 apples, 15 oranges, 118 limes, and 87 lemons. Frederick P. Roosevelt has 132 apples, 15 oranges, 5 limes, and 65 lemons. Ariel E. Lincoln has 34 apples, 25 oranges, 4 limes, and 21 lemons. Accurately enter the above data in an Excel spreadsheet with first name and middle initial in the first cell and the last name in the second cell accompanied by that person's respective fruit data. Order/sort by last name without mixing the names or respective fruit data. Properly label the columns, in bold, above the data. Above these column labels, add the prices for each fruit in the respective column. Each fruit costs: $1.07 for apples, $2.13 for oranges, $1.13 for limes, $2.82 for lemons. Add a total/sum at the end of each row for each person and appropriately label that column. Add a total cost at the end of each row for each person and appropriately calculate the total cost of fruit for each person. Add a total/sum, a minimum, maximum, an average/mean, and standard deviation, both latter shown to one decimal place, at the end of each numerical column for each fruit, and label those rows appropriately. Make all totals bold and highlight (fill color) the fruit totals in pink, highlight the minimum in cyan, the maximum in lime green, the average/mean and std.dev. calculations with yellow highlight and in italics.
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!