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?

a) Highlight the column, then click on the Insert Cells button under the Home ribbon.

b) Highlight the cell, then click on the Insert Cells button under the Home ribbon.

c) Highlight the row, then click on the Insert Cells button under the Data ribbon.

d) 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?

a) Highlight the cell, then click on the Insert Cells button under the Data ribbon.

b) Highlight the cell, then click on the Insert Cells button under the Home ribbon.

c) Highlight the column, then click on the Insert Cells button under the Home ribbon.

d) 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?

a) Highlight the cell, then click on the Delete Cells button under the Home ribbon.

b) Highlight the column, then click on the Delete Cells button under the Home ribbon.

c) Highlight the column, then click the Delete button on your keyboard.

d) 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?

a) 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.

b) Type $10,000 into each of the 15 cells.

c) 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?

a) Highlight the worksheet, then click on the Data ribbon and find the Sort & Filter button. Use the Custom Sort to sort from smallest to larges.

b) Highlight the table, then click on the Data ribbon and select Sort A to Z under the Sort & Filter button.

c) Use the copy and paste functions to arrange a new table from smallest to largest values.

d) 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.