Microsoft Excel 2010 Fundamentals

What is the first operator applied in Excel according to the order of precedence?

• Multiplication

• Parentheses

• Addition

• Division

How is an Excel function typically started?

• By typing the function name.

• By clicking the Insert Function button.

• By typing an equal sign (=).

• By selecting a range of cells.

What is the purpose of the AutoComplete feature in Excel?

• It applies conditional formatting.

• It automatically completes a typed function or value.

• It fills cells with sequential data.

• It checks spelling errors.

What is a relative cell reference?

• A cell address that remains constant when copied.

• A reference that adjusts relative to the formula location.

• A reference with a fixed row and column.

• A cell reference used only in formulas.

Which key is used to toggle between absolute, relative, and mixed references?

• F2

• F4

• Ctrl

• Alt

What does the ROUND function do?

• Removes decimals completely.

• Rounds a value to the nearest whole number.

• Rounds a value to a specified number of decimal places.

• Converts data into percentages.

What happens when you copy a formula with an absolute cell reference?

• The formula remains unchanged.

• The cell reference adjusts based on the new location.

• Only the row changes, not the column.

• The absolute reference remains fixed.

Which feature allows you to copy formulas to adjacent cells?

• Paste Special

• Fill Handle

• AutoComplete

• Format Painter

What does formatting a cell affect?

• The data in the cell.

• The appearance of the cell's content.

• Both the data and appearance.

• Only the alignment.

What is the default font size in Excel 2010?

• 10-point Calibri

• 11-point Arial

• 11-point Calibri

• 12-point Times New Roman