Excel Basics Quiz for QQI Level 4 Computer Applications

Question 1

True or False: You can merge cells in Excel.

Accepted Answer

True

Question 2

The = symbol is used to start a formula in Excel?

Accepted Answer

True

Question 3

=COUNT counts what?

Accepted Answer

Non-empty cells

Question 4

How do you freeze panes?

Accepted Answer

View tab / Freeze

Question 5

What is the maximum number of rows in Excel?

Accepted Answer

1,048,576

Question 6

Which symbol is used to multiply in Excel?

Accepted Answer

*

Question 7

What does conditional formatting do?

Accepted Answer

Formats based on rules

Question 8

What does VLOOKUP do?

Accepted Answer

Finds values vertically

Question 9

True or False: Excel can create charts.

Accepted Answer

True

Question 10

Which function finds the maximum value?

Accepted Answer

=MAX

Question 11

What does the Fill Handle do?

Accepted Answer

Copies formulas

Question 12

Rows are identified by which?

Accepted Answer

Numbers

Question 13

Which symbol is used to select a range in Excel?

Accepted Answer

:

Question 14

=AVERAGE calculates what?

Accepted Answer

Middle value

Question 15

Columns are identified by which?

Accepted Answer

Letters

Question 16

=IF function checks what?

Accepted Answer

Conditions

Question 17

What is a cell in Excel?

Accepted Answer

Intersection of row and column

Question 18

What does =SUM do?

Accepted Answer

Adds numbers

Question 19

Which formula is used to find the sum of a range of cells in Excel?

Accepted Answer

=SUM(A1:A10)

Question 20

True or False: Excel only works with numbers.

Accepted Answer

False

Questions 20