1 / 9

LOG IN…. Open a NEW EXCEL Document

LOG IN…. Open a NEW EXCEL Document. COLUMN B. COLUMN A. Type a FIRST NAME that begins with EACH letter Example : Row 1 Alicia Row 2 Brendan Row 3 Courtney. Type A through Z in ALL CAPITAL LETTERS Example : Row 1 A Row 2 B Row 3 C.

judith
Download Presentation

LOG IN…. Open a NEW EXCEL Document

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. LOG IN….Open a NEW EXCEL Document COLUMN B COLUMN A Type a FIRST NAME that begins with EACH letter Example: Row 1 Alicia Row 2 Brendan Row 3 Courtney • Type A through Z in ALL CAPITAL LETTERS • Example: Row 1 A Row 2 B Row 3 C

  2. Make pretend that you are an OWNER of a RESTAURANT in your Teen Mall COLUMN D COLUMN C Create an HOURLY WAGE for each employee (don’t forget the $). $7.00-$13.25 EACH SHOULD BE DIFFERENT Example: Row 1 $7.00 Row 2 $8.40 Row 3 $11.30 • Type a JOB TITLE for EACH of your people (you WILL have to duplicate jobs!) • Example: Row 1 Cashier Row 2 Cook Row 3 Manager Row 4 Asst. Mgr. Row 5 Lobby

  3. Make pretend that you are an OWNER of a RESTAURANT in your Teen Mall COLUMN F COLUMN E Create a FORMULA that will MULTIPLY Columns D and E. Remember MULTIPLICATION SYMBOL is * Every formula BEGINS with an = • Type a NUMBER between 5 to 45 for each employee. EACH SHOULD BE DIFFERENT • Example: Row 1 3 Row 2 10 Row 3 23

  4. Make pretend that you are an OWNER of a RESTAURANT in your Teen Mall COLUMN H COLUMN G Create a FORMULA that will SUBTRACT Column G from Column F. Remember SUBTRACTION SYMBOL is - Every formula BEGINS with an = VERY IMPORTANT TO PUT COLUMN F first in the equation (otherwise your answer will be a negative number) • Create a FORMULA that will MULTIPLY Column F by .33 • Remember MULTIPLICATION SYMBOL is * • Every formula BEGINS with an =

  5. ADDING A ROW • CLICK on ROW 1 • In HOME MENU, select INSERT • In ALL CAPS and CENTERED, type the following COLUMN HEADINGS: Column A: A Thru Z Column B: FIRST NAME Column C: JOB TITLE Column D: HOURLY $ Column E: TOTAL HOURS Column F: GROSS PAY Column G: TAXES Column H: NET PAY

  6. MAKING ITEMS FIT • If your typing (words OR numbers) DO NOT FIT in the COLUMN……. DOUBLE-CLICK between the column letters and Excel will AUTOMATICALLY ADJUST for the longest line in the column!

  7. CENTERING COLUMNS Center the following columns (because they contain numbers) Column D: HOURLY $ Column E: TOTAL HOURS Column F: GROSS PAY Column G: TAXES Column H: NET PAY

  8. ADDING ANOTHER ROW • YOU need to ADD YOUR NAME to the list!!! • INSERT a ROW (so that your first name is ALPHABETICALLY placed on your list!) • Give yourself A JOB TITLE, TOTAL HOURS and CALCULATE Gross Pay, Taxes and Net Pay

  9. SAVING • Save this document in your TIES folder as YOUR LAST NAME. • Save this document in NORTON STUDENTS FOLDER (Shared Folder/Norton Students/Your Class Period/Your Last Name) • Save as NOV 14. SAVING

More Related