Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Part I-All of the formulas and functions in Part I should be inserted in the spreadsheet rows below the data. Using the .csv data file
Part I-All of the formulas and functions in Part I should be inserted in the spreadsheet rows below the data. Using the .csv data file provided on Blackboard, complete the following tasks. (When creating the MAX function, find the maximum of all ticket sales in the file - not the max of one salesperson.) Do not use Excel filters or pivot tables on any assignments unless instructed to do so. \#1. Insert function to return the total tickets sold. \#2. Insert a function to return the Maximum number of tickets sold in one transaction. \#3. Insert a function to return the Minimum number of tickets sold in one transaction. \#4. Insert a function to return the Average number of tickets sold from all transactions. \#5. Insert the number of transactions using the COUNT \#6. Insert the number of transactions using the COUNTA function. \#7. Insert the count of transactions of which sold 7 tickets using the COUNTIF function. \#8. Insert the count of sales made on July, 4, 2021. \#9. Create a formula to calculate the average manually, using the values from #1 and #5. \#10. Insert the current system date using the NOW function \#11. Insert the current system date using the TODAY function. (Notice the difference between the NOW and TODAY functions.) \#12. Change the value of cell D120 (one of the Tickets Sold values) to the letter " A ". Notice the difference between the values from \#5 and \#6, the COUNT and COUNTA functions. (leave the letter as you move on to Part II) Why is the value of Count and CountA different? Part II - Copy all of the data from Part 1 and paste into a second worksheet titled "Revisions". - Use the "Find and Replace" command to change the name "Bianca" to your first name. - Use the "Find and Replace" command to change the number 5 in the ticket sales column to either 15 or 25. - Inspect the data visually for errors in data integrity and quality, highlighting any cells you think are an error in the data
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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