Spreadsheet Basics: Excel Functions, Navigation, and Formatting

What is the main bar of commands in Excel called?

The Ribbon or Menu Ribbon

What is the purpose of the Quick Access Toolbar in Excel?

It allows you to manually add frequently used commands.

What is the Menu Bar - App Menu in Excel?

A bar that contains frequently used commands, specific to Apple devices.

What are the differences between Excel on a MAC and a PC?

Limitations in Quick Access Toolbar, less robust Pivot Table Charts, and fewer data import options on MAC.

What should you always remember to do with your Excel files?

Always save your file and know where you saved it.

What are the three calculation settings in Excel?

Automatic, Automatic Except Data Tables, and Manual.

Why is formatting important in Excel?

It helps in presenting results and can significantly impact decision-making.

What is the purpose of freezing rows and columns in Excel?

To keep row or column names visible while scrolling through large datasets.

What does the formulatext function do?

It displays the formula in a cell without needing to edit the cell.

What is the difference between relative and absolute cell references?

Relative references change when copied, while absolute references remain fixed.

What symbol indicates an absolute reference in Excel?

The dollar sign ($) before the row and/or column.

What is the operator for addition in Excel?

The plus sign (+) or the sum function.

What does PEMDAS stand for in Excel calculations?

Parentheses, Exponentiation, Multiplication, Division, Addition, Subtraction.

How does Excel handle operator precedence?

It follows the order of operations defined by PEMDAS.

What is the syntax for opening a function in Excel?

Type = followed by the function name.

What is the function of the Insert Function button in Excel?

It opens a dialog box for inputting the necessary parameters for a function.

What is the significance of using parentheses in complex formulas?

They clarify the order of operations and help ensure correct calculations.

What is the command to take a screenshot on a MAC?

Shift + Command + 4

What happens if you do not save your Excel file?

You may lose all your work and not have any answers in the submitted file.

What is the default calculation setting in Excel?

Automatic

What is the purpose of the 'Show Formulas' function in Excel?

It displays all formulas in the worksheet instead of their results.

What is a mixed cell reference in Excel?

A reference where either the row or the column is fixed, but not both.

What is the operator for division in Excel?

The forward slash (/) or the quotient function.

What is the significance of visualizations in Excel?

They can enhance presentations and aid in decision-making.

What is the function of the formula syntax displayed in blue below a function?

It shows the required inputs for that function.

What should you do if you want to understand a formula without editing the cell?

Use the formulatext function.