Answered step by step
Verified Expert Solution
Link Copied!

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 3 style to B3:H3.
In D4, use a function to combine the first name in B4 with the last name in C4, separated by a space. Copy the formula to D5:D13.
In F4, use a function to show the last four digits of the social security number in E4. Copy the formula to F5:F13.
Set B3:H13 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

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Databases questions