{ "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": "
Please show pictures on a excel sheet so I can copy from the image onto mine thank you(:
\"image <\/div>
\"image<\/div> <\/div> 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", "transcribed_text": "", "related_book": { "title": "Accounting concepts and applications", "isbn": "978-0538750196, 538745487, 538750197, 978-0538745482", "edition": "11th Edition", "authors": "Albrecht Stice, Stice Swain", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/75.jpg", "uri": "\/textbooks\/accounting-concepts-and-applications-11th-edition-75", "see_more_uri": "" }, "free_related_book": { "isbn": "", "uri": "", "name": "", "edition": "" }, "question_posted": "2024-09-13 07:17:27", "see_more_questions_link": "\/study-help\/questions\/business-economics-2023-September-08", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/study-help\/industrial-organizational-psychology-understanding-the-workplace\/2-is-positive-psychology-as-different-from-humanistic-psychology-as-2004348", "description": "2 Is positive psychology as different from humanistic psychology as it claims to be?", "stars": 0 }, { "url": "\/sleepy-hollows-general-fund-budget-for-fiscal-2013-is-based", "description": "Sleepy Hollows General Fund budget for fiscal 2013 is based on the following estimated revenues and appropriations. Is Sleepy Hollow projecting a budgetary surplus or a deficit for 2013? Prepare the...", "stars": 3 }, { "url": "\/study-help\/questions\/please-show-pictures-on-a-excel-sheet-so-i-can-10621485", "description": "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...", "stars": 3 }, { "url": "\/study-help\/questions\/please-answer-all-question-eredit-final-review-chap-78-5615121", "description": "please answer all question Eredit FINAL REVIEW (Chap 7-8) - One attempt o... Question 3 - Extra Credit FINAL REVIEW (Chap 7-8 Soved He Exercise 7-7 Percent of accounts receivable method LO P3 ed...", "stars": 3 }, { "url": "\/study-help\/questions\/you-join-nasa-as-you-announce-at-the-press-conference-5092596", "description": "You join NASA. As you announce at the press conference, you did this world already and kind of crushed it, so you're pretty psyched to get off this \"stink-planet\" and see what's out there. Your...", "stars": 3 }, { "url": "\/study-help\/questions\/use-the-following-information-to-answer-the-questions-below-on-1917924", "description": "Use the following information to answer the question(s) below. On June 30, 2014, the Able, Baker, and Charlie partnership had the following fiscal year-end balance sheet: Cash $ 8,000 Accounts...", "stars": 3 }, { "url": "\/study-help\/questions\/problem-1-analysis-of-performance-of-the-cubic-spline-7900349", "description": "Problem 1: Analysis of performance of the cubic spline. Prepare a code implementing Lagrange's interpolating polynomial P(x) for function y = f(x) on the interval [a, b] using n + 1 equally spaced...", "stars": 3 }, { "url": "\/study-help\/questions\/what-are-three-ways-you-could-use-hootsuite-streams-review-4896487", "description": "305 mg of C6H12O6 in 55.2 mL of solution whats the molarity", "stars": 3 }, { "url": "\/study-help\/questions\/think-of-an-experience-you-a-family-member-or-a-5265474", "description": "Think of an experience you, a family member, or a friend have had with healthcare. Gauge the experience against the Institute of Medicine's (IOM) six aims, and identify any opportunities for...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/on-january-1-portillo-inc-lends-a-corporate-customer-126000-10621484", "next": "\/study-help\/questions\/audit-procedures-for-manufacturing-companies-audit-procedures-for-manufacturing-companies-10621486" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Accounting", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting" }, { "name": "Please show pictures on a excel sheet so I can copy from", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/please-show-pictures-on-a-excel-sheet-so-i-can-10621485" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } }} }