ICDL-EXCEL試験無料問題集（88題）「ICDL The ICDL L4 excel 認定」

出題：1

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 解答を投票する

出題：2

Which one of these combinations is used to indicate that cell C1 has an absolute reference?

A. #C#1

B. ?C?1

C. /C/1

D. $c$1

正解：D 解答を投票する

出題：3

Print the selected chart.

A. Option A
File -> select print -> ok

正解：A 解答を投票する

出題：4

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

A. Option A
Double click on the gray area between Row 2 and Row 3

正解：A 解答を投票する

出題：5

Enter a formula in cell D4 that would calculate the Pre-tax Salary for Cathy Miller. Press the Enter key when you have finished.

A. Option A
Type = B4*C4 -> press Enter

正解：A 解答を投票する

出題：6

If the Enter key was pressed to accept the formula in cell E8, what would appear in the cell?

A. #REF!

B. 6,000

C. #VALUE!

D. #NAME!

正解：C 解答を投票する

出題：7

Change the page orientation so that this worksheet will print on a page that is wider than it is tall.

A. Option A
File -> page setup -> select landscape -> ok

正解：A 解答を投票する

出題：8

Drag each X to a cell in this worksheet that contains an error.

A. Option A
Drag each X to a cell in this worksheet that contains an error.

正解：A 解答を投票する

出題：9

Dragging the fill handle down to cell A5 will fill A5 with:

A. Week 7

B. Week 5

C. Week 4

D. Week 3

正解：A 解答を投票する

ICDL-EXCEL試験無料問題集「ICDL The ICDL L4 excel 認定」