Free ICDL-EXCEL Exam Braindumps (page: 5)

Page 4 of 23

Use the Replace tool to replace all occurrences of the name Jane Harris with Tim Snow.

  1. Edit -> select replace -> type Jane Harris in the find what -> type Tom Snow in replace with -> click replace all

Answer(s): A



Automatically sort this list so that the highest mark displays at the top of the list.

  1. Click the sort descending tool from the standard tool bar

Answer(s): A



Insert a new worksheet into this workbook.

  1. Right click on the sales worksheet -> select insert -> ok

Answer(s): A



Move the entire Annuals worksheet into the Contracts workbook, so that it displays after the other worksheet.

  1. Right click on the Annuals worksheet -> select move or copy -> select Contracts from to book -> select move to end from before sheet -> ok

Answer(s): A






Post your Comments and Discuss ICDL ICDL-EXCEL exam with other Community members:

ICDL-EXCEL Exam Discussions & Posts