Question
1.) The store would like to increase prices by 15%. Use a function to fill in the column Price Increase to calculate the 15% increase,
1.) The store would like to increase prices by 15%. Use a function to fill in the column "Price Increase" to calculate the 15% increase, using an absolute reference to cell B1. Ensure that your answer is in Accounting format.
2.) The store would like to adjust the increased prices so that they are rounded to the nearest whole dollar. Use the ROUND function in column "Rounded" to accomplish this.Ensure that your answer is in Accounting format.
3.) What is the minimum price of the increased, rounded prices? Use an appropriate function to determine the answer. Ensure that your answer is in Accounting format.
4.) What is the count of the items in the table? Use an appropriate function to determine the answer.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started