Download - EXCEL Exam Questions Answers
![Page 1: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/1.jpg)
The ICDL L4 Excel ExamExam: ICDL-Excel
Demo Edition
C CCEEERRRTTT MMMAAAGGGIIICCC
ICDL-Excel
1 http://www.certmagic.com
![Page 2: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/2.jpg)
QUESTION: 1 Open the Samples.xls workbook that is in the My Documents folder.
A. File -> open -> select the samples.xls -> open Answer: A
QUESTION: 2 Create a new, blank workbook.
ICDL-Excel
2 http://www.certmagic.com
![Page 3: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/3.jpg)
A. Click new tool from the standard tool bar Answer: A QUESTION: 3 Save this workbook (which is currently a Microsoft Excel 2000 file) in a format suitable for users with a previous version of Excel. Note: Do not change the file location.
ICDL-Excel
3 http://www.certmagic.com
![Page 4: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/4.jpg)
A. File -> save as -> select Microsoft excel 5.0/95 work book from save as type -> click save Answer: A
QUESTION: 4 Use Microsoft Excel Help to access information on advanced filters.
ICDL-Excel
4 http://www.certmagic.com
![Page 5: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/5.jpg)
A. Help -> Microsoft excel help -> type advanced filters -> click search Answer: A
QUESTION: 5 Change the user name for this application to Carla Banks.
ICDL-Excel
5 http://www.certmagic.com
![Page 6: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/6.jpg)
A. Tool -> options -> select General tab -> in user name type Carla Banks Answer: A
QUESTION: 6 Enter the value 521 in cell B5. Click any other cell when you have finished.
ICDL-Excel
6 http://www.certmagic.com
![Page 7: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/7.jpg)
A. Select B5 cell -> type 521 -> click any other cell Answer: A
QUESTION: 7 Click on the location that selects all of the cells in row4.
ICDL-Excel
7 http://www.certmagic.com
![Page 8: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/8.jpg)
A. Click on the gray area of the row 4 Answer: A
QUESTION: 8 You wish to reverse the last change you have made to this worksheet. Choose the appropriate command to do this.
ICDL-Excel
8 http://www.certmagic.com
![Page 9: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/9.jpg)
A. Click on the undo tool from the standard tool bar Answer: A
QUESTION: 9 Automatically adjust the height of Row 2 to fit its tallest contents.
ICDL-Excel
9 http://www.certmagic.com
![Page 10: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/10.jpg)
A. Double click on the gray area between Row 2 and Row 3 Answer: A
QUESTION: 10 Change the contents of cell B2 to the world Cost. Press Enter when you have finished.
ICDL-Excel
10 http://www.certmagic.com
![Page 11: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/11.jpg)
A. Select cell B2 -> type Cost -> press Enter Answer: A
QUESTION: 11 Copy the selected range and paste it into cell A1 in the worksheet entitled Marketing in this workbook.
ICDL-Excel
11 http://www.certmagic.com
![Page 12: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/12.jpg)
A. Click copy from the standard tool bar -> select the Marketing worksheet -> click paste from the standard tool bar Answer: A
QUESTION: 12 Clear the contents of cell B3 without deleting the cell.
ICDL-Excel
12 http://www.certmagic.com
![Page 13: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/13.jpg)
A. Select the cell B3 -> press the delete key from the keyboard Answer: A
QUESTION: 13 Use the Replace tool to replace all occurrences of the name Jane Harris with Tim Snow.
ICDL-Excel
13 http://www.certmagic.com
![Page 14: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/14.jpg)
A. Edit -> select replace -> type Jane Harris in the find what -> type Tom Snow in replace with -> click replace all Answer: A QUESTION: 14 Automatically sort this list so that the highest mark displays at the top of the list.
ICDL-Excel
14 http://www.certmagic.com
![Page 15: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/15.jpg)
A. Click the sort descending tool from the standard tool bar Answer: A
QUESTION: 15 Insert a new worksheet into this workbook.
ICDL-Excel
15 http://www.certmagic.com
![Page 16: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/16.jpg)
A. Right click on the sales worksheet -> select insert -> ok Answer: A QUESTION: 16 Move the entire Annuals worksheet into the Contracts workbook, so that it displays after the other worksheet.
ICDL-Excel
16 http://www.certmagic.com
![Page 17: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/17.jpg)
A. Right click on the Annuals worksheet -> select move or copy -> select Contracts from to book -> select move to end from before sheet -> ok Answer: A QUESTION: 17 Which one of the following formulas would be appropriate to calculate the monthly surplus for September in this worksheet?
ICDL-Excel
17 http://www.certmagic.com
![Page 18: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/18.jpg)
A. =B5+B11 B. =SUM(B5:D5)-SUM(B11:D11) C. = B5-B11 D. =AVERAGE(B5:D5)-AVERAGE(B11:D11) Answer: C QUESTION: 18 If the Enter key was pressed to accept the formula in cell B9, which of the following would be the result:
ICDL-Excel
18 http://www.certmagic.com
![Page 19: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/19.jpg)
A. A #REF! error message B. 9.3 C. A #VALUE error message D. A #NAME? Error message Answer: D QUESTION: 19 Which formula entered into C3 would calculate the Total Cost of Barrels for the Oil Deco company and if copied down would automatically calculate the Total Cost for all the other customers.
A. =B3*C1 B. =B3*$C$1 C. =$B$3*$C$1
ICDL-Excel
19 http://www.certmagic.com
![Page 20: EXCEL Exam Questions Answers](https://reader034.vdocuments.us/reader034/viewer/2022042510/55cf9a00550346d033a01195/html5/thumbnails/20.jpg)
D. =$B$3*C1 Answer: B QUESTION: 20 Which formula entered into B5 will calculate the total cost of a Colonial style chair (including delivery) and if copied to C5 will perform a similar calculation for the Metro style chair?
A. SUM($B$2:$B$4)+B8 B. =SUM(B2:B4)+$B$8 C. =SUM(B2:B5)+$B$8 D. =SUM(C2:C4)+$C$8 Answer: B
ICDL-Excel
20 http://www.certmagic.com