EXCEL PREP Exam Questions and Answers 100% PASS

EXCEL PREP Exam Questions
and Answers 100% PASS

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? - CORRECT ANSWER-

Highlight the row, then click on the Insert Cells button under the Home

ribbon


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? - CORRECT ANSWER-

Highlight the cell, then click on the Insert Cells button under the Home

ribbon


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? - CORRECT ANSWER-Highlight the

column, then click on the Delete Cells button under the Home ribbon


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? - CORRECT ANSWER-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