Microsoft Excel Concepts to Review

The VLOOKUP function in Excel is used to:

• Find the average of a range of cells

• Search for a value in the first column of a table and return a value in the same row from a specified column

• Sort data in ascending order

• Calculate the sum of a range of cells

What will the IF function return in Excel?

• A value if a condition is true and another value if it's false

• The sum of a range of cells

• The average of a range of cells

• The maximum value in a range of cells

What is the Name Box in Excel?

• A tool to format cells

• A box to enter formulas

• A box that displays the cell reference or name of the active cell

• A feature to sort data

The purpose of the Formula Bar in Excel is to:

• Display the contents of the active cell and allow you to create and view formulas.

• Format the cells in the worksheet.

• Insert charts and graphs into the worksheet.

• Change the worksheet's background color.

What is an Active Cell in Excel?

• A cell that is currently selected

• A cell that contains a formula

• A cell that is locked

• A cell that is hidden

List the different Number Formats available in Excel.

• General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special, Custom

• General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text

• General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific

• General, Number, Currency, Accounting, Date, Time, Percentage

True or False: Changing the number format in Excel changes the value of a cell.

• True

• False

What symbol is necessary to start a formula or function in Excel?

• The symbol necessary to start a formula or function in Excel is the equal sign (=).

• The symbol necessary to start a formula or function in Excel is the plus sign (+).

• The symbol necessary to start a formula or function in Excel is the minus sign (-).

• The symbol necessary to start a formula or function in Excel is the asterisk (*).

What is the difference between a formula and a function in Excel?

• A formula is a user-defined expression, while a function is a predefined calculation.

• A formula is a predefined calculation, while a function is a user-defined expression.

• There is no difference between a formula and a function in Excel.

• A formula is used for text data, while a function is used for numerical data.

PEMDAS in Excel stands for:

• Parentheses, Exponents, Multiplication, Division, Addition, Subtraction

• Parentheses, Exponents, Multiplication, Division, Subtraction, Addition

• Parentheses, Exponents, Division, Multiplication, Addition, Subtraction

• Parentheses, Exponents, Division, Multiplication, Subtraction, Addition