ICT1

What symbol is used in an Excel formula to indicate an absolute cell reference?

• # (e.g., #A1)

• @ (e.g., @A1)

• $ (e.g., $A$1)

• & (e.g., &A1)

Which key can be used to edit the contents of a cell in Microsoft Excel?

• F1

• F2

• Enter

• Esc

What does the AutoFill function do in Microsoft Excel?

• Fills cells with random numbers

• Copies the content of one cell to others while modifying data according to a pattern

• Clears data in the selected range of cells

• Sorts the table alphabetically

Which symbol is used to start any formula in Microsoft Excel?

• +

• *

• /

• =

Which function in Microsoft Excel is used to calculate the sum of a range of cells?

• AVERAGE

• SUM

• COUNT

• MAX

How can you insert a new row in an Excel table?

• Select a row, right-click, and choose "Insert"

• Use the keyboard shortcut Ctrl + N

• Double-click a cell and press Enter

• Manually enter a new row

What data format does Microsoft Excel automatically set when entering a date?

• Text

• Number

• Date

• General

Which function should be used in Microsoft Excel to count the number of non-empty cells in a range?

• COUNT

• COUNTIF

• COUNTA

• SUM

What happens when you press Ctrl + Z in Microsoft Excel?

• Repeats the last action

• Deletes the selected text

• Undoes the last action

• Pastes from the clipboard

Which tab in Microsoft Excel allows you to insert charts?

• Home

• Insert

• Formulas

• Data