It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
Open a Blank Workbook in Excel and save this file under your First Initial and Last Name and course number (DBridgesBUSA2205).
Research three (3) functions, other than accounting, that you can use Excel or spreadsheets for. From this research, write three 100 word paragraphs and site your sources. I would recommend researching a career field that you either are wanting to go into or have interest.
You will be submitting two files. Submissions without sources included will be given a zero.
Unit 2 Module 2 Spreadsheets in the Workplace Excel I
Write a one (1) page paper, approximately 500 words, summarizing what a user can do with the ribbon in Office, and how this might assist you in accomplishing task in either your college or professional life.
There are seven topics on this page; you have to drop down each topic to gain more information.
Do not just re-write these topics. Doing so will result is an automatic zero.
Read these topics, and describe what they do and how they may help.
Unit 2 Module 3 Spreadsheets in the Workplace Excel II
Copy the data from the Excel file name “Wholesale” and paste it into the Sheet named “Product Data”
Calculate the “Retail Cost” (Column F) by multiplying “Mark-up” (Column E) times “Wholesale Cost” (Column D).
Copy and paste this formula for all the products
In cell A17 enter “Average Wholesale Fruit Cost”
In cell A18 enter “Average Wholesale Vegetable Cost”
Resize column A
In cell B17 calculate the average wholesale fruit cost (ignore the errors)
In cell B18 calculate the average wholesale vegetable cost (ignore the errors)
In cell L1 enter a label “January Sales”
Resize “January Sales” as needed
In cell L2 use the SUM Function to calculate total sales for each product in January
On “Market Sales” Worksheet, change the label “Description” to “Category”, and change “Quantity” to “Quantity Sold”
Highlight row 13, and insert a row
Copy the list of Products and Category from “Product Data” and paste into cell A2 of “Market Sales”
Resize column A and B as necessary
In the “Price” (Column C) create a 3D Cell Reference that multiplies “Mark-up” (Column E on “Product Data” sheet) times “Wholesale Cost” (Column D on “Product Data” sheet). (HINT: Make sure you use your ! and spell the sheet name correctly)
Save the Workbook as First Initial Last Name BUSA2205unit2mod4.xlsx (Example, DBridgesBUSA2205unit2mod4.xlsx)