Restore the file Central Coast Cellular and use that copy to create and print the following. Be sure to remove the date prepared, time prepared, and report basis fields where appropriate, and memorize where possible in a report group called Solutions. When memorizing, you can choose to replace the existing report if one existed or add the chapter number to the title.

a. Income Statement for the month ended 1/31/14 with a left page layout and without cents, including a % of Income column. Use the title “Income Statement” and the subtitle “January 2014,” and sort by total from largest to smallest amount.

b. Balance Sheet as of 1/31/14 with a % of Column, without cents, and with a left page layout.

c. Sales Graph by Item for the month ended 1/31/14.

d. Sales Graph by Customer for the month ended 1/31/14.

e. Income and Expense by Account graph for the month ended 1/31/14.

f. Accounts Receivable graph as of 1/31/14.

g. Accounts Payable graph as of 1/31/14.

h. Sales by Customer Summary Report for the month ended 1/31/14, sorted by total from largest to smallest amount with month columns.

i. Sales by Item Summary Report for the month ended 1/31/14, where columns display total only.

j. Accounts Receivable Aging Summary Report as of 1/31/14.

k. Accounts Payable Aging Summary Report as of 1/31/14.

l. Export item (a) to Excel, and then print the Excel worksheet with gridlines and row and column headers.