Microsoft Excel Essentials Quiz

What is an intersection of a row and a column called?

• Cell

• Worksheet

• Chart

• Sum

Where is the fill handle located?

• There isn't a fill handle in Excel

• In the bottom-right corner of the selected cell

• In the bottom-left corner of the selected cell

• On the right side of the Home tab on the Ribbon

What is a group of cells called?

• Chart

• Multicell

• Cell range

• Cell cluster

What is the function of 'Ctrl + Z' in Excel?

• Undo the last action

• Save the document

• Copy the selected cell

• Paste the copied content

What does the 'SUM' function do in Excel?

• Adds all the numbers in a range of cells

• Subtracts all the numbers in a range of cells

• Multiplies all the numbers in a range of cells

• Divides all the numbers in a range of cells

What’s wrong with the formula shown in the image?

• It should use quotation marks instead of parentheses.

• It should use the COUNT function instead.

• There is nothing wrong with the formula.

• It should have an equals sign (=) at the beginning.

What do the tabs at the bottom of a workbook allow you to do?

• Switch between number formats

• Switch between formulas

• Switch between worksheets

• Switch between permissions

Which of the following is an absolute cell reference?

• $A$2

• A:2

• A2

• #A2

Which of the formulas below are valid?

• =5B+6B

• A3+100

• =R2*D2

• =F2+F3+F4-53

What value would Excel return for this formula? =(82-32)/5+8*2

• 92

• 36

• 26

• 24