Excel Intro Formulas 1

Front

In Excel, rows

Back

are horizontal and represented by a number

Answer explanation

In Excel, rows are horizontal and are represented by numbers (1, 2, 3, etc.), while columns are vertical and represented by letters (A, B, C, etc.). Therefore, the correct choice is that rows are horizontal and represented by a number.

Front

What is the active cell? Options: A10, A11, A12, A13

Back

A11

Answer explanation

The active cell is the one currently selected for data entry or editing. In this case, A11 is the active cell, meaning it is highlighted and ready for input, while A10, A12, and A13 are not.

Front

What is circled? Options: function button, name box, cell reference, formula bar

Back

formula bar

Answer explanation

The formula bar is the area where you can view and edit the contents of a selected cell. It is typically located above the spreadsheet grid, making it the correct answer for what is circled.

Front

What does the Name Box display?

Back

The active cell

Answer explanation

The Name Box displays the active cell's reference in Excel. It shows which cell is currently selected, allowing users to quickly identify and navigate to that cell.

Front

What is circled? Options: function button, name box, cell reference, formula bar

Back

function button

Answer explanation

The circled item is the function button, which is used to access various functions in spreadsheet software. It allows users to perform calculations and operations easily, distinguishing it from the other options.

Front

What is the little square at the bottom of the active cell in Excel called and used for?

Back

Fill handle, to copy patterns/formulas of adjacent cells

Answer explanation

The little square at the bottom of the active cell is called the fill handle. It is used to copy patterns or formulas from adjacent cells, allowing for quick data entry and replication.

Front

What must be entered first to make a cell calculate what is entered?

Back

=

Answer explanation

To make a cell calculate what is entered, you must start with an equals sign (=). This indicates to the spreadsheet that the following input is a formula or calculation.

Front

When you enter =SUM(B3+C7), what are B3 and C7?

Back

cell references

Answer explanation

B3 and C7 are cell references in the formula =SUM(B3+C7). They point to specific cells in a spreadsheet, allowing the formula to calculate the sum of the values contained in those cells.

Front

To change information in a cell without retyping everything, use the

Back

formula bar

Answer explanation

The formula bar allows you to edit the contents of a cell directly without retyping everything. You can click on the formula bar, make changes, and then press Enter to update the cell.

Front

What is a boundary in Excel?

Back

The bar separating columns

Answer explanation

In Excel, a boundary refers to the bar separating columns. This visual divider helps users distinguish between different columns in a spreadsheet, making it easier to read and organize data.