Description
Complete the excel sheet including all 6 tabs, input the correct formulas and answers for the shaded units.
Unformatted Attachment Preview
For each topic in column A go through the appropriate sheet and fill in the blue-shaded boxes using the appropriate Excel
formulas.
For each topic, if you have gone though the examples, insert Yes in the blue-shaded box in column B under “Completed ?”
on this sheet.
When you are done, save the file and submit it via the Week 1 Assignment link in Blackboard. This assignment will be graded
on a Pass/Fail basis. You must have a Yes in each box under “Completed ?” for all topics in order to get a grade of Pass.
Topic
IF, AND, OR Functions
SUM, AVERAGE, PRODUCT
COUNT, COUNTA, COUNTBLANK
COUNTIF, SUMIF, AVERAGEIF
COUNTIFS, SUMIFS, AVERAGEIFS
SUMIFS, COUNTIFS
SUMPRODUCT
Completed?
Yes
Yes
Yes
Yes
Yes
Yes
Yes
xes using the appropriate Excel
column B under “Completed ?”
rd. This assignment will be graded
order to get a grade of Pass.
Basic IF Function (Logical Category)
IF functions are very useful for performing logic, and they vary from simple to
complex. A few typical examples are illustrated here.
To enter a basic IF function:
For each prod
enough units
units of that p
Enter the formula =IF(condition,expression1,expression2), where condition is
any condition that is either true or false, expression1 is the value of the formula
if the condition is true, and expression2 is the value of the formula if the
condition is false.
A simple example is =IF(A1=15),D3
Purchase answer to see full
attachment
