Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please walk me through steps 2-7 1. Lindsey Sawyer is the director of recruiting and business development for Raybridge Recruiting in Washington, D.C. She has

Please walk me through steps 2-7 image text in transcribed
1. Lindsey Sawyer is the director of recruiting and business development for Raybridge Recruiting in Washington, D.C. She has been analyzing sales and commissions for recruiters in an Excel workbook and has asked you to help her complete the analysis. Go to the Sales worksheet. Rename the Sales worksheet as Sales and Dividends, which is a more accurate name. 2. Unfreeze column A so it is not displayed when you scroll horizontally. 3. Middle-align the contents of the merged cell A1 to improve the appearance of the worksheet title. 4. In cell B3, insert a formula that uses the NOW function to display today's date. 5. Fill the range C6:G10 with the formatting from the range B6:B10 to use a consistent number format for the sales data. 6. Lindsey wants to show the sales trend for each position and month from January to June. Provide this information as follows: a. In cell H6, insert a Line sparkline based on the data in the range B6:G6. b. Use the Fill Handle to fill the range H7:H1O without formatting based on the contents of cell H6. c. Change the color of the sparklines in the range H:H10 to Dark Purple, Text 2 (4th column, 1st row of the Theme Colors palette) to emphasize them. d. Show a High Point and a Low Point in the sparklines to make those values easy to identify. 7. Copy the formula in cell 16 and paste it in the range 17:110, pasting only the formula and

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

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Sham Navathe

4th Edition

0321122267, 978-0321122261

More Books

Students also viewed these Databases questions

Question

Question What is a Roth 403 (b) plan?

Answered: 1 week ago