Learning Objectives Excel When you have finished this assignment, you should be able to perform the following actions in Excel: Fill cells by using Auto Fill. Use simple math formulas. Apply number formats. Use absolute and relative references. Use the SUM function. Insert and format charts to visualize data. Learning Objectives Accounting When you have finished this assignment, you should be able to do the following: Calculate dollar and percentage changes (horizontal analysis.) Perform vertical analysis by preparing a common size income statement and balance sheet. Perform trend analysis for income statement items. Find needed data to answer questions about the income statement and balance sheet. In this lab, we will be performing horizontal and vertical analysis on a company's financial statements. Charts will be used to better understand the data through visualization. Then you will answer questions about your results in Connect. Instructions: A. For each cell highlighted in blue, fill in the correct numbers using formulas. In some cases, using an absolute reference will speed up the process a lot! B. When you are done, format the numbers so the dollars appear like those in the data, and the percentages are one decimal (like 53.2%.) Add lines to