Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Jan R. Williams, Susan F. Haka, Mark S. Bettner, Joseph V. Carcello

12th Edition

0071116796, 978-0071116794

More Books

Students also viewed these Accounting questions

Question

Th e person I wanted to complain about might have lost her job.

Answered: 1 week ago

Question

Th ey would have been rude to me.

Answered: 1 week ago

Question

Who knows? Th ey might have spit in my food in the kitchen.

Answered: 1 week ago