Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Create the following spreadsheet in Microsoft Excel. KwikView Movie Theatres Month Ticket Sales Goal Amt +/-Goal January 34777 32000 February 46732 45000 March

image text in transcribed

1. Create the following spreadsheet in Microsoft Excel. KwikView Movie Theatres Month Ticket Sales Goal Amt +/-Goal January 34777 32000 February 46732 45000 March 39876 34000 April 54765 52000 May 38965 42000 June 75345 75000 July 65433 64000 August 57544 43000 September 85467 76000 October 87666 67000 November 68999 73000 December 94678 87000 TOTAL AVERAGE HIGH LOW 1. To the 2nd, 3rd and 4th column apply ($) Dollar symbol that should appear immediately beside 2 the number. Add in borders to the table. 3. Merge and Center the Title "KwikView Movie Theatres" 4. In the 4s Column, Apply formula to find the difference between Sales and Goal. 5. Calculate TOTAL, AVERGE, HIGH and LOW for both Ticket Sales and Goal columns 6. Name the worksheet as Assignment 1 7. Name the file as Assignment 1 Your Name Student id 8. Add 2 worksheets to the workbook and name it as Classwork 1 and Classwork 2 9. Use conditional formatting and highlight the top 2 sales month 10. Add 2 decimal place to the sales and the goal.

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

Interpreting and Analyzing Financial Statements

Authors: Karen P. Schoenebeck, Mark P. Holtzman

6th edition

132746247, 978-0132746243

More Books

Students also viewed these Accounting questions

Question

Evaluate and simplify the following derivatives. d dx -(x Inx)

Answered: 1 week ago