How do you filter the data to only display stocks and bonds in Excel?

Grader - InstructionsExcel 2019 ProjectExp19_Excel_Ch04_HOEAssessment_InvestmentsProject Description:You have been hired as a junior financial analyst at Bristol Investments. As pa

How do you filter the data to only display stocks and bonds in Excel?

Grader - InstructionsExcel 2019 ProjectExp19_Excel_Ch04_HOEAssessment_InvestmentsProject Description:You have been hired as a junior financial analyst at Bristol Investments. As part of your tasks, you will help track transactions, commodity prices, and broker efficiency. To complete the task, you will create an Excel table, use data filters, conditional formatting, and lastly you will prepare the document to print. Steps to Perform:StepInstructionsPoints Possible1Start Excel. Download and open the file named EXP19_Excel_Ch04_HOEAssessment_Investments.xlsx. Grader has automatically added your last name to the beginning of the filename. 02Create a table named Transactionsbased on the data in the Range A4:E248. 103Freeze the first row containing column headings. 54Apply White, Table Style Medium 4. 55Add a new column namedPercent Change. 46Enter a formula in the Percent Change column using unqualified

Video liên quan