최신ICDL The ICDL L4 excel - ICDL-EXCEL무료샘플문제
문제1
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.
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.
정답: B
문제2
Delete row5 from this worksheet.
Delete row5 from this worksheet.
정답: A
문제3
If the Enter key was pressed to accept the formula in cell B9, which of the following would be the result:
If the Enter key was pressed to accept the formula in cell B9, which of the following would be the result:
정답: A
문제4
Save a copy of this workbook with the new name Accounts.
Save a copy of this workbook with the new name Accounts.
정답: A
문제5
Change the contents of cell B2 to the world Cost. Press Enter when you have finished.
Change the contents of cell B2 to the world Cost. Press Enter when you have finished.
정답: A
문제6
Which formula entered into C12 would calculate the number of recorded rainfall readings taken over the 3 weeks?
Which formula entered into C12 would calculate the number of recorded rainfall readings taken over the 3 weeks?
정답: C
문제7
Which one of the following formulas would be appropriate to calculate the monthly surplus for September in this worksheet?
Which one of the following formulas would be appropriate to calculate the monthly surplus for September in this worksheet?
정답: D
문제8
Change the settings for this worksheet so that the gridlines will print.
Change the settings for this worksheet so that the gridlines will print.
정답: A
문제9
Change the name of the worksheet from Sheet2 to Costs.
Change the name of the worksheet from Sheet2 to Costs.
정답: A