Print Preview [Link]
Chapter 2: Formulas, Functions, and Formatting: EX 2-2 Entering the Titles and Numbers into the Worksheet
Book Title: Shelly Cashman Series® Collection Microsoft® Office 365® and Office 2019
Printed By: Suzanne French (frenchsm5443@[Link])
© 2020 Cengage Learning, Cengage Learning
EX 2-2 Entering the Titles and Numbers into the Worksheet
The first step in creating the worksheet is to enter the titles and numbers into the worksheet.
The following sets of steps enter the worksheet title and subtitle and then the salary report
data shown in Table 2–1.
Table 2–1
Klapore Engineering Salary Report Data
Employee Email Dependents Hours Hourly Hire Date
Address Worked Pay Rate
Altore, Benie 3 74.50 35.25 9/5/10
Fox, Linda 1 80.00 33.10 10/17/12
Handfield, 0 71.75 28.65 2/2/13
Jermaine
Jamme, Ben 2 60.00 18.00 1/15/16
Nacht, 1 42.25 25.90 5/18/12
Savannah
Pittfield, Joel 0 75.75 21.95 5/24/13
Spalding, Jill 3 80.00 32.50 11/11/11
Tillman, Steve 2 64.50 41.02 4/29/06
Wilson, Olga 1 68.00 29.43 9/22/17
BTW
Touch Mode Differences
The Office and Windows interfaces may vary if you are using touch mode. For this
reason, you might notice that the function or appearance of your touch screen differs
slightly from this module’s presentation.
1 of 2 2/15/2025, 4:47 PM
Print Preview [Link]
Chapter 2: Formulas, Functions, and Formatting: EX 2-2 Entering the Titles and Numbers into the Worksheet
Book Title: Shelly Cashman Series® Collection Microsoft® Office 365® and Office 2019
Printed By: Suzanne French (frenchsm5443@[Link])
© 2020 Cengage Learning, Cengage Learning
© 2025 Cengage Learning Inc. All rights reserved. No part of this work may by reproduced or used in any form or by any means -
graphic, electronic, or mechanical, or in any other manner - without the written permission of the copyright holder.
2 of 2 2/15/2025, 4:47 PM