Question

Basic Spreadsheet Concepts- Exercise 2 1. Type in all text and numbers shown in the spreadsheet below 2. Create formulae to display a total for each Sales Rep. 3. Create formulae to calculate the amount due to each sales rep, on the basis that each rep is reimbursed 0.1 KD per kilometer traveled 4. Format all numbers with appropriate formats. 5. Center the spreadsheet heading Travel Expenses for the Month of May across the spreadsheet. 6. Format all text as displayed in the sample below, including the rotated text labels. 7. Apply all borders and shading (color) shown in the sample below, feel free to experiment with your own color schemes. Travel Expenses For The Month Of May 150 210 105 155 95 86 135 122 3 Morrison W 4 Oliver A 5 Parker J 6 Potts D 7 Watson K 8 Weatherby 9 Wilson J 0 Woolley 11 Make Dale 120 309 125 148 152 123 164 132 142 162 133 121 153 135 108 106 145 162 205 210187 198
0 0
Add a comment Improve this question Transcribed image text
Answer #1

This is the screenshot of the spreadsheet you are looking for.

I cant upload the spreadsheet file here. Please rate if you like it.

Add a comment
Know the answer?
Add Answer to:
Type in all text and numbers shown in the spreadsheet below. Create formulae to display a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Student Name Orca Industries Assignment Instructions: Below are the two most recent balance sheets and most...

    Student Name Orca Industries Assignment Instructions: Below are the two most recent balance sheets and most recent income statement for Orca Industries. Create & complete a cash flow worksheet (NOT the actual Statement of Cash Flow)!! Type in your name in the blue highlighted area above. You MUST use cell references for your answers and format all currency as US $ with zero decimal places. There should be NO numbers simply type Use color/shading & borders to make your spreadsheet...

  • Follow the directions below to create an Excel graph for a perfectly competitive company. A company...

    Follow the directions below to create an Excel graph for a perfectly competitive company. A company has total costs of 200+ 2000 - 2.5Q++ 1/3Q'. The price per unit is $500. Use excel to create a table to solve the problem as in question 5. Add two columns for average total costs and average variable costs. Create a graph for quantities from 1 to 25 that has ATC, AVC, MC, and MR on it. . Give the graph a title...

  • Objective: Text File I/0 and Regular Expressions Note that both classes below should handle all exceptions...

    Objective: Text File I/0 and Regular Expressions Note that both classes below should handle all exceptions that might be thrown within them. 1. Create a class that does the following: a. Reads the name of a file to create as the first command line argument. (Overwrite any file with the same name). b. Reads an integer value as the second command line argument. C. The program should generate as many random numbers as are specified in the second command line...

  • This program is used to create a phonebook for storing contact information into a text file....

    This program is used to create a phonebook for storing contact information into a text file. The program begins by asking the user to provide a name for the file that will contain their phone book information. It will then ask the user to provide the names and numbers of their contacts. It should keep asking the user for contact information until they type in Done (case-sensitive). After the user types Done, store all contact information into the file name...

  • do numbers 4-8 4. Given any directory, use the Is command to display: • all files...

    do numbers 4-8 4. Given any directory, use the Is command to display: • all files and sub-directories starting with the letter "D" (note do not list anything in any sub-directory) • its immediate sub-directories (sub-directories only, and no other ordinary files) its immediate hidden sub-directories only - take a screenshot (#3-3) that clearly shows the command and the result. 5. Assume that the following files are in the working directory: $ ls intro notesb ref2 section 1 section3 section4b...

  • In this project, you will work with sales data from Top’t Corn, a popcorn company with...

    In this project, you will work with sales data from Top’t Corn, a popcorn company with an online store, multiple food trucks, and two retail stores. You will begin by inserting a new worksheet and entering sales data for the four food truck locations, formatting the data, and calculating totals. You will create a pie chart to represent the total units sold by location and a column chart to represent sales by popcorn type. You will format the charts, and...

  • please show all work in Excel CHAPTER 2: THE BASIC FINANCIAL STATEMENTS Homework for Chapter 2:...

    please show all work in Excel CHAPTER 2: THE BASIC FINANCIAL STATEMENTS Homework for Chapter 2: Problem # 1 in the text (Chapter 2) Using the data presented below for Blue Sky Inc.: 2017 2016 S7,550,000 $6,150,000 5,750,000 Sales Cost of Goods Depreciation Selling and G&A Expenses Fixed Expenses Lease Expense Interest Expense 4,550,000 120,000 100,000 820,000 730,000 200,000 200,000 150,000 150,000 350,000 300,000 Tax Rate 40.00% 40.00% Shares Outstanding Cash Marketable Securities Accounts Receivable Inventory Prepaid Expenses Plant &...

  • Java I: Create a Java program that will accept the price of an item and the...

    Java I: Create a Java program that will accept the price of an item and the quantity being purchased of that item. After accepting the input, calculate the amount of the purchase (based on the price and quantity), calculate the sales tax on the purchase, then output the product price, quantity, subtotal, sales tax, and the total sale based on the output format shown below. Structure your file name and class name on the following pattern: The first three letters...

  • Java I - Write a program that will use static methods as described in the specifications below. U...

    Java I - Write a program that will use static methods as described in the specifications below. Utilizing the if and else statements, write a program which will calculate a commission based on a two-tiered commission plan of 2% and 5% paid on amounts of $10,000 or less, or over $10,000 in monthly sales by a sales force paid on a commission basis. Use the output specifications below. --- (Please make detailed comments so I can better understand the code....

  • EA5-A2 Create a Bank Reconciliation for Tasters Club Corp. In this exercise, you will create a...

    EA5-A2 Create a Bank Reconciliation for Tasters Club Corp. In this exercise, you will create a bank reconciliation for Tasters Club Corp. for the month ended December 31, 2016. The reconciliation should be partly based on these figures: Bank Statement Balance (12/31/2016) equals $16,200; Notes Receivable equals $395; NSF Check equals $4,000; Bank Charges equals $550. During the month, the bank erroneously deposited a $505 check written to Pepper Products into the bank account of Tasters Club Corp. 1. Open...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT