Basic Spreadsheet Concepts, Navigation, and Functions

Comprehensive question-and-answer flashcards covering spreadsheet basics, cell navigation, interface terminology, and basic Excel formulas and functions.

What program is used to organize, calculate, and analyze data in rows and columns?

Microsoft Excel

In a spreadsheet, what are the vertical boxes called?

Column

How are rows labelled in a spreadsheet?

With numbers

How are columns labelled in a spreadsheet?

With letters

What is the intersection of a row and a column called?

A cell

Which symbol must always come first before typing a formula?

$=$, the equals sign

What is the correct way to write the cell address for Column A, Row $5$?

$$A5$$

Which bar displays the value or formula of the active cell?

Formula bar

Where is the button located that you click to select the entire worksheet?

The box where the row number and column letter meet

If you click on cell $B3$, which parts of the spreadsheet are highlighted?

Both Column $B$ and Row $3$

Which key moves the active cell down one cell?

Enter

What symbol is used to separate the cells in a range?

A colon ($:$)

What is the name of the current file you are working on in Microsoft Excel?

Workbook

Which function is used to add up a list of numbers?

$$=\text{SUM}()$$

What is the correct formula to add the values in cells $A_1$ and $A_2$?

$$=A_1+A_2$$

If cell $A_1 = 5$ and cell $A_2 = 10$, what is the result of the formula $=\text{SUM}(A_1:A_2)$?

$$15$$

Which function is used to find the highest number in a group of cells?

$$=\text{MAX}()$$

Which function is used to find the lowest number in a group of cells?

$$=\text{MIN}()$$

What is the correct formula syntax to find the sum of cells from $A_1$ to $A_5$?

$$=\text{SUM}(A_1:A_5)$$