what function would be the best to use and how would you use it?

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter5: Working With Multiple Worksheets And Workbooks
Section: Chapter Questions
Problem 10AYK
icon
Related questions
Question

VIA EXCEL

5. Suppose you have a worlds beet with cash amounts you have received for a fundraiser. you need to add up all of the amounts over $100 because those will be matched by an outside company. what function would be the best to use and how would you use it? 

2. Name the three types of cell references used in Excel formulas and give an example how each is used.
3. Describe the purpose of the IF function and give an example of how it might be used in an Excel worksheet.
(Answers may vary.)
4. Explain the main difference between the VLOOKUP function and the HLOOKUP function and briefly describe
what they do.
5. Suppose you have a worksheet with cash amounts you have received for a fundraiser. You need to add up all
of the amounts over $100 because those will be matched by an outside company. What function would be the
best to use and how would you use it?
Transcribed Image Text:2. Name the three types of cell references used in Excel formulas and give an example how each is used. 3. Describe the purpose of the IF function and give an example of how it might be used in an Excel worksheet. (Answers may vary.) 4. Explain the main difference between the VLOOKUP function and the HLOOKUP function and briefly describe what they do. 5. Suppose you have a worksheet with cash amounts you have received for a fundraiser. You need to add up all of the amounts over $100 because those will be matched by an outside company. What function would be the best to use and how would you use it?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
SQL Query
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage

Expert Answers to Latest Homework Questions

Q: Define GDP and its various components in details.
Q: Image uploaded solution is not allowed please dear expert bro please
Q: 1) Because of tighter safety regulations, an improved air filtration system must be installed at a…
Q: Which planet's rings were recently (modern time) discovered from earth?    Needs Complete solution…
Q: 3. Deductive reasoning is when someone uses lots of data to make a conjecture. ○ False ○ True
Q: Needs Complete solution with 100 % accuracy don't use chat gpt or ai.
Q: Need answer step by step
Q: The actuary for the pension plan of Carla Vista Company calculated the following net gains and…
Q: Fnnjjkj
Q: The owner of a Colorado bakery is maximizing profit. K The price of a loaf of bread is $4.00, a…
Q: Problem 19-03 (algo) The following hypothetical production possibilities tables are for China and…
Q: Watch “Toward a New Understanding of Mental Illness” and “Parkinson’s, Depression, and the Switch…
Q: mi.3
Q: You drop a 0.625 kg basketball from waist height. The basketball is moving downwards at 4.5 m/s just…
Q: Heavy Metal Corporation is expected to generate the following free cash flows over the next five…
Q: The Extra Mile ✰ Joyce Meyer was quoted as saying Excellence is going the ex Let's get in some extra…
Q: The following data has been provided by Lee Company regarding its inventory purchases and sales…
Q: G= Government spending Tax revenues Real GDP $160 $100 $500 $160 $120 $600 $160 $140 $700 $160 $160…
Q: 人 Use the 2020 Federal Tax Rates for Individuals to calculate the estimated taxes for a taxable…
Q: On January 2, 2020, Headland Corporation issued $1,450,000 of 10% bonds at 97 due December 31, 2029.…
Q: The following transactions and events affected its equity during the year. Question: What is the per…