You are working on an excel table and realize that

This preview shows page 13 - 15 out of 17 pages.

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. What is 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 your table 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. What is 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, from smallest 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 Custom Sort 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 Sort option to sort from smallest to largest.9.Award: 10 out of 10.00 pointsShow correct answerSolving for the UnknownThis lesson will help you review how to solve for unknown quantities in a problem. The unit will also expose you to some basic financial equations that you will see later in your course. Brushingup on these concepts now will help you tackle your finance coursework later. Press play to watch the first presentation below. Click on the numbers to navigate through the lesson, and then complete the Concept Check at the end to cement your skills and receive credit.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture