Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are an HR representative at a large box company. You're using Excel to keep track of personal data for the company's Regional Collections Supervisors.
You are an HR representative at a large box company. You're using Excel to keep track of personal data for the company's Regional Collections Supervisors. Perform the following tasks:
Apply the Heading style to B:H
In D use a function to combine the first name in B with the last name in C separated by a space. Copy the formula to D:D
In F use a function to show the last four digits of the social security number in E Copy the formula to F:F
Set B:H as a print area.
Make the width of column H automatically adjust to the size of the longest address
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started