FIGURE 2-3: Insert Fanction dialog box Search for a function field Senter to O Must het atung Or selecta SUM Category lista PERLINK COUNT our list of recently used functions may differ AVERAGE return the Description of die selected function FIGURE 2-4 Expanded Function Arguments dialog box unction in mula bar sert Function button 730 Argument Collapse button ST 360 ES USA 140 FIGURE 2-5. Average functions used in worksheet Garten Completed function appears in formula bar 42000 135 2002 2000 SOS 26 34. M.NL IN CULTURE Formula in cell C15 copied tills 15 and 15 v Unit 2 Discussion Discussion Tople Due April 25 at 10:00 PM Now that we've been introduced to Excel by completing Yolanda's first task, she's ready to have us work with formulas and functions to summarize expense data. But first she needs to know that you understand the difference between a complex formula and a function. Yolanda wants you to respond to the following statements so she can make sure you're a good candidate for the next task she has in mind; For your main post, Yolanda wants you to explain the following: (formula) How we add four cells together using a cell reference and the + operator. (function) How we add four cells together without using the + operator. Discuss two functions we find using the Insert function button found on the formula bar (see figure 2-3 on page 29). Describe in your own words what they do and how we would create them in a spreadsheet List the three methods we can use to create a function from chapter two, and describe which method you feel the most comfortable using and why. Your main post should be at least 250-300 words long Respond to at least two postings of others, with each response being at least 100 words. Interaction can be earned by responding to the follow up prompts, responding to a class member, and/or responding to the faculty. Topics to consider for responses to other students might include the following: . When we create a formula with multiple operators like we have to use order of A MacBook Air II FS FIO F6 F7 F8 %