In cell B20: Net income after taxes = Income before taxes − Income tax expense.In cell B17: Income before taxes = Operating income − Interest expense.In cell B13: Total operating expenses = Selling expenses + Administrative expenses.In cell B8: Gross profit = Sales − Cost of goods sold.Save the file to the location where you are storing your files.Įnter the following formulas in the corresponding cells:
#EXCEL RETROSPECT THEME DOWNLOAD#
Download and open the file named 02i_IncomeStatement.xlsx.
#EXCEL RETROSPECT THEME PROFESSIONAL#
You format the worksheet to give it a more professional look. You use the data to project the income data for the next five years and create a chart to better illustrate the trends. Your executive assistant has collected enough financial data to create the income statement for the current year. Save the workbook and name it 02i_VaShareholders_LastFirst.xlsx. Run, save, and then close the query.Įxport the VA Shareholders query to an Excel file. Sort the results in Ascending order based on Last. Use State criteria to find all shareholders living in Virginia. You’ll use this data later when you write a letter to select shareholders using Mail Merge.Ĭreate a query using all the fields except for ID and Phone from the Shareholders table. You create a query in Access to locate the Virginia shareholders and export the results of the query to an Excel file. View the data in the Shareholders table in Datasheet view and adjust column widths so all data is visible. Accept the underscore as the placeholder and store the data without the symbols in the mask.
Create an Input Mask for Phone using the default settings. Save and name the table as Shareholders.Ĭhange the Data Type for Phone to Short Text. Use the column headings from the Excel file, and let Access add the primary key. Import the data from Sheet1 of the 02i_Shareholders.xlsx Excel file into a new table. Save the file to the location where you are storing your files. Grader has automatically added your last name to the beginning of the filename. Download and open the file named 02i_HealthyLiving.accdb. You add data to some of the fields, and then use the Input Mask Wizard to standardize some fields. Since you already have the shareholders’ mailing information in an Excel workbook, you import the data into the Shareholders table. You want to store the shareholders’ information in the database. You will also prepare a presentation to deliver to all shareholders at the annual meeting. You are updating database and financial information to distribute a letter and a newsletter to select shareholders ahead of the annual meeting. You are the assistant director of Healthy Living Motorcycles, Inc.
0 kommentar(er)
