Reference no: EM131061252

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?

• Type $10,000 into the first cell, then highlight that cell and use your cursor to drag the fill handle through the remaining 14 cells.
• Type $10,000 into each of the 15 cells.
• Type $10,000 into the first cell, then copy and paste the value individually into each of the remaining cells.

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.