Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with the equations and formulas to complete the assignment, I can provide the worksheet too, but not sure how to add it here

image text in transcribed

Need help with the equations and formulas to complete the assignment, I can provide the worksheet too, but not sure how to add it here

1 In Column C, use an appropriate function to capitalize the first letter of the first name 2 In Column D, use an appropriate function to make the last name appear in ALL CAPS. 3 In Column E, use an appropriate function to combine the first name and the last name. Make it appear in this format: LASTNAME, Firstname 4 In Column F, use an appropriate function to match the Participants' name in the Participants Worksheet with their affiliation in the Lookups Worksheet. 5 In Column G, use an appropriate function to match the Participants' name in the Participants Worksheet with their country in the Lookups Worksheet. In Column H, use an appropriate function to match the Participants' country in the Participants Worksheet with the region in the Lookups Worksheet. 6 In Column J, use an appropriate function to extract month information from Date Registered. 7 In Column K, use an appropriate function to match each month number in the Participants Worksheet with the correct month name in the Lookups Worksheet. 8 In Column L, use an appropriate function to match each month number in the Participants Worksheet with the correct registration type in the Lookups Worksheet. 9 In Column M, use an appropriate function to match each month number in the Participants Worksheet with the correct registration rate in the Lookups Worksheet. 10 In Column O, calculate Luau Ticket - Amount Paid using cell referencing. You can find Luau Ticket Price in T1. 11 In Column P, use an appropriate function to calculate Total Amount Paid. 12 Create a name range for N2:N452 and call it LuauTickets_Purchased. 13 Use the LuauTickets_Purchased name range to calculate the total number of Luau Tickets Purchased in T2. 14 Use the Conditional Formatting function to format the rows where Luau Tickets Purchased is greater than 3 . The background color of those rows should be light blue. 15 Where applicable, format information as currency with two decimal places 16 Create a name range for A1:P452 and call it Registration_Data. 17 In a new worksheet, create a Pivot Table/Chart (Clustered Column Chart) using the Registration_Data name range and the below specifications. (a) Filter = Country (b) Axis (Categories) = Registration Type (c) Values = Luau Ticket - Amount Paid and Luau Ticket(s) Purchased 18 Put Sum of Luau Ticket(s) Purchased as a line graph on a secondary axis. 19 Add chart title as well as primary and secondary vertical axis title. 20 Give chart title, primary vertical axis title, and secondary vertical axis title a proper name. 21 Make the secondary vertical axis title face toward the chart. 22 In a new worksheet, create a Pivot Table that shows the number of participants by Region and by Country

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems

Authors: Marshall B Romney, Paul J. Steinbart, Scott L. Summers, David A. Wood

15th Edition

0135572835, 9780135572832

More Books

Students also viewed these Accounting questions