Information systems

What do you use in the order of operations?

PEMDAS

What must every formula or function begin with?

An equal sign.

What does the name box represent in Excel?

The address of the cell you are currently on.

What is an 'active cell'?

A cell that is highlighted in green.

How does a cell solve formulas?

Using the order of operations, or PEMDAS.

What is a file handle in Excel?

It allows you to drag or increment to adjust values.

What does relative reference mean?

Referencing a cell that updates when copied to other columns or cells.

How would you define a function in Excel?

A predefined formula.

What is the proper syntax for writing a function in Excel?

It must start with an equal sign, followed by the function name, an open parentheses, required arguments (optional arguments may follow), and a closed parentheses.

How are arguments in an Excel function separated?

By commas.

What is a cell range and how is it defined in a formula?

A cell range is separated by a colon, e.g., =SUM(B5:D44, A15, 100).

What does CTRL + ~ do in Excel?

It will show formulas in the worksheet.

What does 'False' mean in lookup functions?

It indicates looking for an exact match.

For what type of tables are V-lookups used?

Horizontal tables.

What is the difference between relative and absolute references?

Relative references update when copied; absolute references do not change.

What does $B$5 represent in Excel?

An absolute reference; both column and row will not change.

What does $B5 represent in Excel?

A mixed reference; column will not change but the row may change.

What does B$5 represent in Excel?

A mixed reference; row will not change but the column may change.

What are logical operators in Excel?

They are operators used in logical comparisons:

What does B5 represent in terms of relative references?

Column and row will both update based on where the formula referencing B5 is copied.

How do you indicate a range of cells in a SUM function?

By using a colon to separate cell references, e.g., =SUM(B5:D44).

What do you need after the equal sign in a function syntax?

The name of the function.

What does 'look for an exact match' mean in an Excel formula?

It requires a precise value match in lookup functions.

What action does the file handle allow you to perform in Excel?

Drag or increment cell values.

What separates functional arguments in Excel?

Commas.

What is a mixed reference in Excel?

A reference where either the row or column is absolute and the other is relative.

How is the active cell represented visually in Excel?

By highlighting it in green.

What is the equal sign used for in Excel functions?

To indicate the start of a formula or function.

What does 'False' indicate when using VLOOKUP?

The function should find an exact match.

What do you need to enclose optional arguments in an Excel function?

They are within parentheses, following the required arguments.

In which scenario would you use absolute referencing in Excel?

When you want to keep a cell referenced unchanged, regardless of where the formula is copied.

What is the significance of the notation in the function =SUM(100, 1000, 10000, B5)?

It shows a sum of values where B5 is referenced as an argument.

What happens when a formula using relative references is copied to another cell?

The column and row references adjust according to their new location.

Why would you use logical operators in Excel formulas?

To perform comparisons and logical tests.