{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-09-13T07:17:27-04:00", "answer_date": "2024-09-13 07:17:27", "is_docs_available": "", "is_excel_available": "", "is_pdf_available": "", "count_file_available": 0, "main_page": "student_question_view", "question_id": "10621485", "url": "\/study-help\/questions\/please-show-pictures-on-a-excel-sheet-so-i-can-10621485", "question_creation_date_js": "2024-09-13T07:17:27-04:00", "question_creation_date": "Sep 13, 2024 07:17 AM", "meta_title": "[Solved] Please show pictures on a excel sheet so | SolutionInn", "meta_description": "Answer of - Please show pictures on a excel sheet so I can copy from the image onto mine thank you(: 1) Create the following sprea | SolutionInn", "meta_keywords": "show,pictures,excel,sheet,copy,image,thank,1,create,spreadsheet,row,starter", "question_title_h1": "Please show pictures on a excel sheet so I can copy from the image onto mine thank you(: 1) Create the following spreadsheet, using your", "question_title": "Please show pictures on a excel sheet so I can copy from", "question_title_for_js_snippet": "Please show pictures on a excel sheet so I can copy from the image onto mine thank you( 1) Create the following spreadsheet, using your name instead of Your Name in Row 1 There is no Starter file , just start from a blank worksheet Hints Use proper label alignment and formatting to make your spreadsheet look like the one below For full credit, use the most efficient formulas or functions and the COPY command for all computations Use absolute cell addressing when necessary or helpful Only use it where it truly helps Formulas Total Sales Hardware Sales Software Sales Total Commission Hardware Rate Hardware Sales Software Rate Software Sales Percent of Total Commission Total Commission for one employee divided by the Total Commission for all employees Hints the lines between row 8 and 9,14 and 15 are double line borders You are to type the values in columns A, B, C (except the totals) but do not type any values in columns D,E, and F, as these are all calculated Row 8 is bold (Reminder use 'Alt' Enter to force two lines in one cell) Enter the proper function in F4 and F5 for the current date and time (not the date displayed) Cells B11 and C10 have a value of zero Save your spreadsheet as Your Name Excel Exam on your Desktop In order to score 100 , you need to use the Absolute Cell Addressing where appropriate Part two 2) Ask questions if you need to Announced email times will be made Clifton quinn gccod edu 3) Change the Hardware Rate to 6 0 (your spreadsheet numbers should change) 4) Run Spell Check to fix any errors if they occur There are miss spellings in the handout Don't worry about the spelling of any names 5) Center the heading in row one across columns A through F, increase the font to 20 points and bold this row (You may need to adjust the height of this row to see the results) 6) Do the same as 5 above for rows two and three, increasing the font size to 16 points and bolding 7) Delete Harry Carey's row, the whole row, not just the data If your formulas are correct, the totals will adjust fine 8) Skip a blank row at the bottom under the column totals and, insert a row showing the Average for each column data, not including the totals For Columns B E 9) Using Conditional Formatting, highlight in bold any value in Column F for Percent of Total Commission that is over 20 Do not do this to the total 10) Create and include in this spreadsheet a graph that shows each salesperson and displays each salesperson's Total Sales as a percentage of the Total Sales for all salespeople Pick the type of chart you think is best Give this chart an appropriate title and clearly understandable labels Insert this chart below your spreadsheet 11) Save your spreadsheet again, with the same name 12) Preview your spreadsheet in Portrait mode to ensure that it prints on one page only, including the graph 13) For full credit, you will have a properly named file For me it would be Clifton Quinn Excel Exam Then upload your file through the Assignment labeled Excel Exam 1, in Module 7 Hints At the end, your file will look 'sort of like the one on Page 1, but there will not be a row for Harry Carey AND there will be a chart, on the same page All fits on one page The hardware rate will be 6 0 This means the numbers will change in the data If you do the correct formulas, and use Absolute Cell Addressing, you will have only four formulas and will copy those formulas In order to score 100 , you need to use the Absolute Cell Addressing where appropriate", "question_description": "