Excel Basics Quiz

How many columns are there in an Excel worksheet?

• 65,536

• 256

• 1,048,576

• 16,384

What is the function of the Formula Bar in Excel?

• Shows data or formula stored in the cell

• Inserts new rows

• Changes cell formatting

• Applies borders to cells

What does a cell reference in Excel consist of?

• Only the row number

• Row number followed by column letter

• Only the column letter

• Column letter followed by row number

Which type of entry in Excel can be used for calculations?

• Value

• Text or label

• Date

• Formula

What does an absolute cell reference in Excel prevent from changing?

• Cell color

• Only column number

• Only row number

• Row and column number

How can you select a group of cells in Excel?

• Drag the pointer over the cells

• Use the Fill Handle

• Press Enter key

• Right-click on each cell

What is the purpose of the Merge function in Excel?

• Split a cell into more cells

• Change cell formatting

• Combine two or more cells into a single cell

• Insert new columns

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

• AVERAGE

• MAX

• SUM

• COUNT

What does the IF function in Excel test for?

• The maximum value in a range

• The sum of cells in a range

• Whether a given condition is true or false

• The average of cells in a range

What does the Transpose function in Excel allow you to do?

• Insert new rows

• Merge cells

• Apply borders to cells

• Change the orientation of copied data