Function What does it do/when would it be used?Source of information -HLOOKUP IN
ID: 3902654 • Letter: F
Question
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.Explanation / Answer
Answer: See the sample sheet for company inventory below:
Note: Name of this sheet is 'Inventory List'.
See the examples below to use different functions:
1. HLOOKUP: =HLOOKUP(27, 'Inventory List'!G4, 1, FALSE)
2. INDEX: =INDEX('Inventory List'!C4:L28,1,1)
3. LOOKUP: =LOOKUP(49,'Inventory List'!C4:L4)
Company Product Inventory Worksheet Inventory ID Name Description Unit Price Quantity in Stock Inventory Value Reorder Level Reorder Time in Days Quantity in Reorder Discontinued? Item01 Enter Item name here Enter Item description here $49.00 27 $1,323.00 29 13 50 Item02 Enter Item name here Enter Item description here $91.00 134 $12,194.00 231 4 50 Item03 Enter Item name here Enter Item description here $55.00 153 $8,415.00 114 11 150 Item04 Enter Item name here Enter Item description here $17.00 188 $3,196.00 158 6 50 Item05 Enter Item name here Enter Item description here $73.00 64 $4,672.00 39 12 50 Item06 Enter Item name here Enter Item description here $9.00 7 $63.00 9 13 150 Item07 Enter Item name here Enter Item description here $54.00 60 $3,240.00 109 7 100 yes Item08 Enter Item name here Enter Item description here $36.00 103 $3,708.00 162 3 100 Item09 Enter Item name here Enter Item description here $57.00 124 $7,068.00 82 3 150 Item10 Enter Item name here Enter Item description here $48.00 177 $8,496.00 283 8 150 Item11 Enter Item name here Enter Item description here $57.00 178 $10,146.00 229 1 100 Item12 Enter Item name here Enter Item description here $16.00 24 $384.00 36 12 50 Item13 Enter Item name here Enter Item description here $24.00 74 $1,776.00 102 9 100 Item14 Enter Item name here Enter Item description here $40.00 64 $2,560.00 83 2 100 Item15 Enter Item name here Enter Item description here $30.00 48 $1,440.00 23 15 50Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.