Week One Concept Check_Math_Accounting_Review - Concept...

This preview shows page 1 - 3 out of 14 pages.

Concept Check*1. You are working on an Excel table and realize that you need to add a row to the middle of your table.What is one way to do this?Highlight the column, then click on the Insert Cells button under the Home ribbon.Highlight the cell, then click on the Insert Cells button under the Home ribbon.Highlight the row, then click on the Insert Cells button under the Data ribbon.Highlight the row, then click on the Insert Cells button under the Home ribbon.*2. You are working on an Excel table and realize that you need to add a single cell to your table. Whatis one way to do this?Highlight the cell, then click on the Insert Cells button under the Data ribbon.Highlight the cell, then click on the Insert Cells button under the Home ribbon.Highlight the column, then click on the Insert Cells button under the Home ribbon.Highlight the row, then click on the Insert Cells button under the Home ribbon.*3. You are working on an Excel table and realize that you need to delete a column in the middle of yourtable and shift the remaining data columns to the left. What is one way to do this?Highlight the cell, then click on the Delete Cells button under the Home ribbon.Highlight the column, then click on the Delete Cells button under the Home ribbon.Highlight the column, then click the Delete button on your keyboard.Highlight the column, then click on the Delete Cells button under the Data ribbon.*4. You are valuing an investment that will produce cash flows of $10,000 each year for 15 years. Whatis the quickest way to enter $10,000 into each of the 15 cells of your table?
*5. You have three tables in a worksheet in Excel. You need to sort one of the tables numerically, fromsmallest to largest values. How can you do this?Highlight the worksheet, then click on the Data ribbon and find the Sort & Filter button. Use the CustomSort to sort from smallest to largest.Highlight the table, then click on the Data ribbon and select Sort A to Z under the Sort & Filter button.Use the copy and paste functions to arrange a new table from smallest to largest values.Highlight the table, then click on the Data ribbon and find the Sort & Filter button. Use the Custom Sortoption to sort from smallest to largest.Question 2:* 1. What is the amount of gross profit to be reported on ABC Company’s 12/31/X1 income statement?
* 2. What is the amount of

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 14 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
DR.SHERMAN
Tags
Finance, Income Statement, Net Present Value, Home ribbon, Overall feedback

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture