ICDL The ICDL L4 excel - ICDL-EXCEL 시험문제 [2026]

문제1
Copy all of the formatting from cell B3 and automatically apply it to cell D3.

A. Option A
Click the format painter tool from the standard tool bar -> click on cell D3

정답: A

문제2
Enter the value 521 in cell B5. Click any other cell when you have finished.

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

정답: A

문제3
Save this workbook as a text file.

A. Option A
File -> save as -> in the save as type -> from the drop down list -> choose text (Tab delimited) -> save

정답: A

문제4
Apply the Percentage style to the selected cells.

A. Option A
Click on the percent style tool from the formatting tool bar

정답: A

문제5
Add a page footer with the text Confidential that will print at the botton left of all the pages in this woksheet.

A. Option A
View -> Header and footer -> click on the custom footer -> type Confidential

정답: A

문제6
Move the entire Trees worksheet from this workbook into the Contracts workbook, so that it is the first worksheet in the workbook.

A. Option A
Right click on the trees worksheet -> select move or copy -> select Contracts workbook -> ok

정답: A

문제7
Change the formatting so the selected text automatically wraps onto a second line within the cell.

A. Option A
Format -> cells -> select Alignment tab -> check the wrap text -> ok

정답: A

문제8
Change the alignment of the selected title Projected Earnings, so that it is centred horizontally over columns B, C and D.

A. Option A
Format -> cells -> Alignment -> from the drop down list of the Horizontal -> select center Across Selection

정답: A

문제9
Print just the range A2:E11 selected in this worksheet.

A. Option A
File -> print -> in print what section -> select Selection

정답: A

최신ICDL The ICDL L4 excel - ICDL-EXCEL무료샘플문제