The steps you wet follow for this project are as follows: 1) Download the Excel data fie. (Aher you download the fle, YOU NEED TO "SAVE" YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE UPPER RIGHT HAND CORNER BEFORE YOU EXIT. If you do not save your assignment, the next time you entec, you may soe a different compary and set of data ) 2) Perform the teguirements on the data fie. 3) Check your work in the Excel fle with these sheck foures 4) Use your Excei fibe to answer the sa mutiple choice questions below. (You will have to screll down to see al of the quesfions ) Resources A) Information on how to update Excel and Oflice 365 B) If you do not have Offico 365 , click here to leam how to get 2 for tree C) information on data columns.and headings C) Troubleshooting FAQ Using your Excel worksheet, what is Canada's tols direct matenal for Uplown Fumiture? A. $400,891 B. $79,986 C. $1,179,433 D. $1,097,537 Using your Exeel wonsheet, what is Montana's total manulactumg ovechead for Uptown Fumine? A. $430.475 B. $125,162 The steps you will follow for this project are as follows: 1) Download the Excel data file. (After you download the file, YOU NEED TO "SAVE" YOUR ASSIGNMENT BY CLICKING THE SAVE B BEFORE YOU EXIT. If you do not save your assignment, the next time you enter, you may see a different company and set of data.) 2) Perform the requirements on the data file. 3) Check your work in the Excel file with these check figures. 4) Use your Excel 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 update Excel and Office 365. B) If you do not have Office 365 , click here to learn how to get it for free. C) Information on data columns and headings. C) Troubleshooting FAQ. Using your Excel worksheet, what is Montana's total manufacturing overhead for Uptown Furniture? A. $430,475 B. $125,162 C. $19,732 D. $1,528,786 Using your Excel worksheet, which job generated the least gross profit for Uptown Furniture? A. 4201 B. 4133 Using your Excel worksheet, which sales rep generated the most revenue for Uptown Fumiture? A. Alida Sanchez. B. Adam West C. Jose Rodriguez D. Alex Jolet Using your Excel worksheet, how much of Alicis Sanchez's revenue was generated from the Uniled States for Uptown Fumiture? A. $655,342 B. $872,040 C. $1,105,723 The steps you wet follow for this project are as follows: 1) Download the Excel data fie. (Aher you download the fle, YOU NEED TO "SAVE" YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE UPPER RIGHT HAND CORNER BEFORE YOU EXIT. If you do not save your assignment, the next time you entec, you may soe a different compary and set of data ) 2) Perform the teguirements on the data fie. 3) Check your work in the Excel fle with these sheck foures 4) Use your Excei fibe to answer the sa mutiple choice questions below. (You will have to screll down to see al of the quesfions ) Resources A) Information on how to update Excel and Oflice 365 B) If you do not have Offico 365 , click here to leam how to get 2 for tree C) information on data columns.and headings C) Troubleshooting FAQ Using your Excel worksheet, what is Canada's tols direct matenal for Uplown Fumiture? A. $400,891 B. $79,986 C. $1,179,433 D. $1,097,537 Using your Exeel wonsheet, what is Montana's total manulactumg ovechead for Uptown Fumine? A. $430.475 B. $125,162 The steps you will follow for this project are as follows: 1) Download the Excel data file. (After you download the file, YOU NEED TO "SAVE" YOUR ASSIGNMENT BY CLICKING THE SAVE B BEFORE YOU EXIT. If you do not save your assignment, the next time you enter, you may see a different company and set of data.) 2) Perform the requirements on the data file. 3) Check your work in the Excel file with these check figures. 4) Use your Excel 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 update Excel and Office 365. B) If you do not have Office 365 , click here to learn how to get it for free. C) Information on data columns and headings. C) Troubleshooting FAQ. Using your Excel worksheet, what is Montana's total manufacturing overhead for Uptown Furniture? A. $430,475 B. $125,162 C. $19,732 D. $1,528,786 Using your Excel worksheet, which job generated the least gross profit for Uptown Furniture? A. 4201 B. 4133 Using your Excel worksheet, which sales rep generated the most revenue for Uptown Fumiture? A. Alida Sanchez. B. Adam West C. Jose Rodriguez D. Alex Jolet Using your Excel worksheet, how much of Alicis Sanchez's revenue was generated from the Uniled States for Uptown Fumiture? A. $655,342 B. $872,040 C. $1,105,723
