ICDL-EXCEL無料問題集「ICDL The ICDL L4 excel」

質問 1

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

質問 2

Print the selected chart.

（A）Option A
File -> select print -> ok

正解：A 解答を投票する

質問 3

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

（A）Option A
File -> print -> in print what section -> select Selection

正解：A 解答を投票する

質問 4

Change the orientation of the text in the selected cells to vertical (90 degrees.)

（A）Option A
Format -> select cells -> select Alignment tab -> in the orientation area move the red point up to the first point

正解：A 解答を投票する

質問 5

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）=$B$3*C1

（B）=B3*$C$1

（C）=B3*C1

（D）=$B$3*$C$1

正解：B 解答を投票する

質問 6

Clear the contents of cell B3 without deleting the cell.

（A）Option A
Select the cell B3 -> press the delete key from the keyboard

正解：A 解答を投票する

質問 7

Delete row5 from this worksheet.

（A）Option A
Right click on the gray area -> select delete

正解：A 解答を投票する

質問 8

Automatically sort this list so that the highest mark displays at the top of the list.

（A）Option A
Click the sort descending tool from the standard tool bar

正解：A 解答を投票する

質問 9

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

（A）Week 3

（B）Week 5

（C）Week 4

（D）Week 7

正解：D 解答を投票する

ICDL-EXCEL 無料問題集「ICDL The ICDL L4 excel」

弊社を連絡する

関連リンク

トップ試験