Question: Question 1 : cell F 2 - Use an IF function to return the value in E 2 as a positive number for a revenue

Question 1: cell F2- Use an IF function to return the value in E2 as a positive number for a revenue transaction or as a negative number in parentheses for an expense transaction
The next questions are in relation to a pivot table, please just tell me how to sort the pivot table to get the right answers. The filters are (month, customer/vender, account, amount, amount on income statement)
Question 2: What is the amount of net income that the company reported for the year?
Question 3: What is the amount of net income in the months that reported the second highest net income amount during the year?
Question 4: What is the difference in revenue between the month with the highest total revenue and the month with the total lowest revenue?
question 5: What percent is the Buford gas bill in May in relation to total utilities expense in May?
 Question 1: cell F2- Use an IF function to return the

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 Accounting Questions!