The sleps you will follow for this project are as follows: 1) Review the student handous. (The handout is an overview of the entire project and has links to all of the tutorial vidoos.) 2) Download the Excel data fle. (Afer you download the filo, YOU NEED TO \"SAVE\" YOUR ASSICNMENT EY CLICKING THE SAVE BUTTON IN THE UPPER RIGHT HAND CORNER BEFORE YOU EXIT. If you do not savo your assignment, the next time you enter, you may see a different company and dashboard.) 3) Pertorm the requirements by following along with the video andior the scrioles PDF for Windows and MAC and using the comolex formulas for Windows and MAC. 4) You do not need to submit your Excel file, histead you will use the Extel file to answer the six multiple choice questions below. (You will have to scroll down to see all of the questions.) Resources A) Information on how to ypdate Excel and Ocfice 365. (You must use Excel for Windows or Excel for Mac for this assignment; Excel Online will not work for this dashboard. B) If you do not have Office 365 , click here to leam how to get if for free C) information on data column headirgs. D) Troubleshooting FAQ This project only has one attempt. Review the dashboard you created for TopTech Supplios before answering the quessions. What is total Electronics revenue in 2021 ? A. \\( \\$ 597.720 \\) B. \\( \\$ 766,590 \\) C. \\( \\$ 1,212,260 \\) D. 5614,540 A. \\( \\$ 158,740 \\) B. \\( \\$ 802,740 \\) C. \\( \\$ 766,590 \\) D. \\( \\$ 1,569,330 \\) What was the \\% change from the prior year for Sales revenue from Books in the South region? A. \78.62 B. \15.56 C. \18.69 D. \0.15 What is the sales revenue from the prior year for Electronics in the South region? A. \\( \\$ 125,380 \\) B. \\( \\$ 114,970 \\) C. \\( \\$ 154,200 \\) D. \\( \\$ 121,190 \\) What is the Books sales revenue for the West division in the current year? A. \\( \\$ 52,310 \\) B. \\( \\$ 4,660 \\) C. \\( \\$ 10,310 \\) D. \\( \\$ 5,650 \\) When recording a sales transaction, would TopTech Supplies use the 'Sales revenue' field or the 'Total invoice' field for total revenue? A. Sales revenue field B. The answer depends on state law C. Neither the sales revenue or the total invoice field would be used D. Total invoice field What would be total sales revenue for TopTech Supplies in 2021 ? (You will need to add some numbers on the dashboard to get this total.) A. \\( \\$ 158,740 \\) B. \\( \\$ 802,740 \\) C. \\( \\$ 766,590 \\) The sleps you will follow for this project are as follows: 1) Review the student handous. (The handout is an overview of the entire project and has links to all of the tutorial vidoos.) 2) Download the Excel data fle. (Afer you download the filo, YOU NEED TO \"SAVE\" YOUR ASSICNMENT EY CLICKING THE SAVE BUTTON IN THE UPPER RIGHT HAND CORNER BEFORE YOU EXIT. If you do not savo your assignment, the next time you enter, you may see a different company and dashboard.) 3) Pertorm the requirements by following along with the video andior the scrioles PDF for Windows and MAC and using the comolex formulas for Windows and MAC. 4) You do not need to submit your Excel file, histead you will use the Extel file to answer the six multiple choice questions below. (You will have to scroll down to see all of the questions.) Resources A) Information on how to ypdate Excel and Ocfice 365. (You must use Excel for Windows or Excel for Mac for this assignment; Excel Online will not work for this dashboard. B) If you do not have Office 365 , click here to leam how to get if for free C) information on data column headirgs. D) Troubleshooting FAQ This project only has one attempt. Review the dashboard you created for TopTech Supplios before answering the quessions. What is total Electronics revenue in 2021 ? A. \\( \\$ 597.720 \\) B. \\( \\$ 766,590 \\) C. \\( \\$ 1,212,260 \\) D. 5614,540 A. \\( \\$ 158,740 \\) B. \\( \\$ 802,740 \\) C. \\( \\$ 766,590 \\) D. \\( \\$ 1,569,330 \\) What was the \\% change from the prior year for Sales revenue from Books in the South region? A. \78.62 B. \15.56 C. \18.69 D. \0.15 What is the sales revenue from the prior year for Electronics in the South region? A. \\( \\$ 125,380 \\) B. \\( \\$ 114,970 \\) C. \\( \\$ 154,200 \\) D. \\( \\$ 121,190 \\) What is the Books sales revenue for the West division in the current year? A. \\( \\$ 52,310 \\) B. \\( \\$ 4,660 \\) C. \\( \\$ 10,310 \\) D. \\( \\$ 5,650 \\) When recording a sales transaction, would TopTech Supplies use the 'Sales revenue' field or the 'Total invoice' field for total revenue? A. Sales revenue field B. The answer depends on state law C. Neither the sales revenue or the total invoice field would be used D. Total invoice field What would be total sales revenue for TopTech Supplies in 2021 ? (You will need to add some numbers on the dashboard to get this total.) A. \\( \\$ 158,740 \\) B. \\( \\$ 802,740 \\) C. \\( \\$ 766,590 \\)
