Have I ever thought about... a. How much student debt will I bear by the time I graduate? What will my student loan payments be? b. How much money do I need in an interest-bearing account today so that I have at least $1,000 in savings in 3 years? C. I want to make sure I don't run out of pocket money. How much should I save each month to have at least $500 at the beginning of next year? d. Does it matter whether I deposit my savings at the beginning of each month or at the end? e.Do I prefer to use a credit card or a debit card for purchases? Does it matter which one 1 use? 1. I think I need a car to drive for my internship. If I took out a car loan, what would my loan payments be? that you've converted the store's accounting inventory. Although more items will be added later, the worksheet has enough items for you to begin your modifications. a. Start Excel, open the file EX 3-3.xlsx from the location where you store your Data Files, then save it as EX 3-Fresh To You Inventory. b. Create a formula in cell E4 that calculates the value of the items in stock based on the price paid per item in cell B4. Format the cell in the Comma Style. c. In cell F4, calculate the sale value of the items in stock using an absolute reference to the markup value shown in cell Hi. d. Copy the formulas created above into the range E5:F14; first convert any necessary cell references to absolute so that the formulas work correctly. e. Apply bold to the column labels, and italicize the inventory items in column A. f. Make sure that all columns are wide enough to display the data and labels. g. Format the values in the Sale Value column as Accounting number format with two decimal places. h. Format the values in the Price Paid column as Comma Style with two decimal places. Exc Formatting a Worksheet Have I ever thought about... a. How much student debt will I bear by the time I graduate? What will my student loan payments be? b. How much money do I need in an interest-bearing account today so that I have at least $1,000 in savings in 3 years? C. I want to make sure I don't run out of pocket money. How much should I save each month to have at least $500 at the beginning of next year? d. Does it matter whether I deposit my savings at the beginning of each month or at the end? e.Do I prefer to use a credit card or a debit card for purchases? Does it matter which one 1 use? 1. I think I need a car to drive for my internship. If I took out a car loan, what would my loan payments be? that you've converted the store's accounting inventory. Although more items will be added later, the worksheet has enough items for you to begin your modifications. a. Start Excel, open the file EX 3-3.xlsx from the location where you store your Data Files, then save it as EX 3-Fresh To You Inventory. b. Create a formula in cell E4 that calculates the value of the items in stock based on the price paid per item in cell B4. Format the cell in the Comma Style. c. In cell F4, calculate the sale value of the items in stock using an absolute reference to the markup value shown in cell Hi. d. Copy the formulas created above into the range E5:F14; first convert any necessary cell references to absolute so that the formulas work correctly. e. Apply bold to the column labels, and italicize the inventory items in column A. f. Make sure that all columns are wide enough to display the data and labels. g. Format the values in the Sale Value column as Accounting number format with two decimal places. h. Format the values in the Price Paid column as Comma Style with two decimal places. Exc Formatting a Worksheet