I only need steps on how to complete number 4

Project Description:

You are the assistant director of Healthy Living Motorcycles, Inc. You are updating database and financial information to distribute a letter and a newsletter to select shareholders ahead of the annual meeting. You will also prepare a presentation to deliver to all shareholders at the annual meeting.

Steps to Perform:

Step	Instructions	Points Possible
1	You want to store the shareholders information in the database. Since you already have the shareholders mailing information in an Excel workbook, you import the data into the Shareholders table. You add data to some of the fields, and then use the Input Mask Wizard to standardize some fields. Start Access. Download and open the file named 02i_HealthyLiving.accdb. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.	0
2	Import the data from Sheet1 of the 02i_Shareholders.xlsx Excel file into a new table. Use the column headings from the Excel file, and let Access add the primary key. Save and name the table as Shareholders.	2
3	Change the Data Type for Phone to Short Text. Create an Input Mask for Phone using the default settings. Accept the underscore as the placeholder and store the data without the symbols in the mask. View the data in the Shareholders table in Datasheet view and adjust column widths so all data is visible. Save and close the table.	3
4	You create a query in Access to locate the Virginia shareholders and export the results of the query to an Excel file. Youll use this data later when you write a letter to select shareholders using Mail Merge. Create a query using all the fields except for ID and Phone from the Shareholders table. Use State criteria to find all shareholders living in Virginia. Sort the results in Ascending order based on Last. Name the query VA Shareholders. Run, save, and then close the query.	3
5	Export the VA Shareholders query to an Excel file. Export data with formatting and layout. Save the workbook and name it 02i_VaShareholders_LastFirst.xlsx. Do not save the export steps. Close Access.	3
6	Your executive assistant has collected enough financial data to create the income statement for the current year. You use the data to project the income data for the next five years and create a chart to better illustrate the trends. You format the worksheet to give it a more professional look. Start Excel. Download and open the file named 02i_IncomeStatement.xlsx. Save the file to the location where you are storing your files.	0
7	Enter the following formulas in the corresponding cells: In cell B8: Gross profit = Sales Cost of goods sold In cell B13: Total operating expenses = Selling expenses + Administrative expenses In cell B17: Income before taxes = Operating income Interest expense In cell B20: Net income after taxes = Income before taxes Income tax expense In cell B23: Earnings per share = Net income after taxes / Total # of outstanding shares Copy the cell contents in cells B8, B13, B17, B20, and B23 to the corresponding cells in columns C:G (Ignore the #DIV/0! error for now).	4