Answered step by step
Verified Expert Solution
Question
1 Approved Answer
14. Go to the Client Investment Tracker worksheet, which Elena asks you to finish. The worksheet shows sample data for a fictional client to illustrate
14. Go to the Client Investment Tracker worksheet, which Elena asks you to finish. The worksheet shows sample data for a fictional client to illustrate the type of information Ballantyne Investments provides to its clients. Elena inserted the data in the range A20:C28 as a link to another worksheet. Complete the sample data and break the link as follows: a. In cell B29, use the Quick Analysis tools to insert the total investment amount from the range B21:B28, which should match the total in cell D28. b. Use the Quick Analysis tool to create a conditional formatting rule that adds Solid Fill Blue Data Bars to the range F21:F28 to help clients visualize the data. c. Break the link to the Support_EX365_2021_7a_Sample.xlsx workbook because Elena no longer needs to update the date
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