MICROSOFT EXCEL FLASHCARD

Front

The numbers in Excel represent the...

Back

Rows

Front

To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.

Back

=

Front

What function adds all of the numbers in a range of cells?

Back

Sum

Front

If I want to find an average of cells A1 through A25, which formula would I use? Options: =average(A1:A25), =avg(A1:A25), =average(A1-A25), =avg(A1-A25)

Back

=average(A1:A25)

Front

Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this? Options: =(A1+A2+A3)/4, A1+A2+A3/4, =A1+A2+A3^4, (A1+A2) + A3/4

Back

=(A1+A2+A3)/4

Front

To sort names in a worksheet, we can use this button.

Back

Front

The name of the cell is determined by the name of the row and the column intersecting, such as A8.

Back

Cell Address

Front

The cell in your worksheet that has been selected. It will have bolder gridlines around it.

Back

Active Cell

Front

A combination of numbers and symbols used to express a calculation.

Back

Formula

Front

The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.

Back

Cell