Microsoft Excel 2010 Quiz

What is a complex formula?

• A formula with one arithmetic operator

• A formula that only multiplies numbers

• A formula that uses more than one type of arithmetic operator

• A formula that only adds numbers

What does the equal sign (=) indicate in Excel?

• The start of a function

• The end of a function

• A number

• A text string

What is the purpose of the AutoComplete feature?

• To help with spelling

• To suggest function names while typing

• To format cells

• To create charts

What does a relative cell reference do?

• Keeps the cell address the same

• Always refers to the same cell

• Is used for text only

• Changes the cell reference when copied

How do you create an absolute cell reference?

• By typing the cell address in uppercase

• By using a percent sign (%)

• By placing a dollar sign ($) before the column and row

• By using parentheses

What is the ROUND function used for?

• To multiply numbers

• To round down results

• To find the maximum value

• To add numbers

What is the Fill Handle used for?

• To copy or move data

• To fill colors in cells

• To format text

• To create charts

What happens when you copy a formula with relative references?

• The formula is deleted

• The cell references change

• The formula cannot be copied

• The formula stays the same

What is a mixed reference?

• A reference that is neither relative nor absolute

• A reference that is used for text

• A reference that combines relative and absolute referencing

• A reference that only uses numbers

What does the Paste button do?

• Deletes data

• Pastes copied data

• Cuts data

• Copies data