Excel Module 5

What is a formula in MS Excel?

• A representation of data in a cell

• A mathematical equation that performs calculations on values in a worksheet

• A type of chart used for data visualization

• A tool for formatting text

What can a value in Excel represent?

• Only numbers

• Only text

• A number, cell address, date, text, or range of cells

• Only dates

What is a constant in the context of a cell?

• A formula used to calculate values

• A number or text value entered directly into a cell

• A reference to another cell

• A function that performs a specific task

What does an operator do in calculations?

• It stores data in a cell

• It specifies the type of calculation to take place

• It formats the text in a cell

• It deletes data from a cell

What is a function in Excel?

• A pre-built command that performs mathematical operations

• A tool for creating charts and graphs

• A feature for formatting text

• A method for sorting data alphabetically

What is the order of operations?

• A method to solve algebraic equations

• A standard mathematical process to determine which operator to calculate first

• A way to organize data in a spreadsheet

• A technique for graphing functions

What does a cell reference identify?

• The color of a cell in a worksheet

• The formula used in a cell

• A cell’s location within a worksheet

• The size of a cell in a worksheet

What is a relative cell reference in a formula?

• A reference that changes based on the relation to the cell containing the formula

• A reference that always points to the same cell

• A reference that is used only in charts

• A reference that is used for formatting

What is an absolute cell reference in a formula?

• A reference that changes based on the relation to the cell containing the formula

• A reference that refers to a specific cell or range regardless

• A reference that is used only in charts

• A reference that is used for formatting

What is a mixed cell reference in Excel?

• A cell or range that uses both a relative and absolute reference

• A cell that only uses a relative reference

• A cell that only uses an absolute reference

• A cell with no reference