10 ICDL Exam Questions & Answers:


Q1.Open the samples.xls workbook that is in the My Documents folder.

A. File -> open ->select the samples.xls -> open


Q2. Create a new, blank workbook

A. click new tool from the standard tool bar > Workbook


Q3. Save this workbook (which is currently a Microsoft Excel 2000 file) in a format suitable for users with a previous version of Excel.

A. File -> save as -> select from save as type (Microsoft excel 5./95 work book-> click save

Q4. Use Microsoft Excel Help to access information on advanced filter

A. Help -> Microsoft excel help -> type advanced filters -> click search

Q5.Change the user name for this application to Carla Banks

A. Tool > Options >  select General tab > in user name type Carla Banks

Q6. Enter the value 521 in cell B5
Click any other cell when you have finished

A. Select B5 cell > type 521 > click any other cell

Q7.Click on the location that selects all of the cells in row 4.

A. Click on the gray area of the row 4

Q8.Automatically adjust the height of Row 2 to fit its tallest contents.

A. Format > Row > auto fit or Double click on the gray area between Row 2 and Row 3

Q9.You wish to reverse the last change you have made to this worksheet.

A . Click on the undo tool from the standard tool bar Or from menu bar select edit > undo.

Q10. Change the contents of cell B2 to the word Cost. Press enter when you have finished.

A . Select cell b > type Cost > press enter