Question: I have completed the tables (part 1) I need help on part 2.. confused about how to incorporate all of these functions in one of

I have completed the tables (part 1) I need help on part 2.. confused about how to incorporate all of these functions in one of the themes outlined.  I have completed the tables (part 1) I need help on

Function What does it do/when would it be used?Source of information -HLOOKUP INDEX -LOOKUP MATCH VLOOKUP -ABS -RAND RANDBETWEEN -ROUND -ROUNDDOWN ROUNDUP SUBTOTAL -SUM -SUMIF SUMIFS Excel Function Worksheet 2 - part 2 Create and submit a workbook (may have multiple sheets) that uses at least 12 different functions this part 1 worksheet. The information must be related in some way, not just random functions place cells. The workbook needs a "theme" and focus area as well as formatting appropriate for a business spreadsheet. You may use any of the examples below or create your own: Real estate transaction worksheet Company sales team worksheet Company product inventory worksheet * The worksheet must have: A main title that clearly describes the overall purpose of the worksheet Column headings/row descriptions where appropriate Please add color shading to each cell that contains one of the required functions

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!