Excel Review 1

Excel follows the ____________ and first finds the value inside of the parentheses.

• Order of Operations

• Formula Guidelines

Answer explanation

Excel follows PEMDAS:

Parentheses

Exponents

Multiplication

Division

Addition

Subtraction

3*5+2=17

3*(5+2)=21

By default, all cell references are __________ references.

• Absolute

• Relative

Answer explanation

Shows the column letter and row number of the cell- C4 or D10. Relative cell references change when they are copied.

Unlike _______ references, ________ references DO NOT change when they are copied.

• relative, absolute

• absolute, relative

• book, movie

Answer explanation

Absolute references have the $ before the column letter and the row number- $A$3.

Cell references should be used when possible to avoid having to make multiple updates when one key value changes.

• True

• False

Answer explanation

Using cell references is easier because now we can change the characters wage or hours and the total pay will automatically update.

Which response best completes the sentence: A formula is used to

• perform calculations or other actions.

• find averages.

• confuse students.

Answer explanation

Formulas are used to perform calculations, lookup values, combine data, compare data, or do other useful actions. Some basic functions are the MIN, MAX, AVERAGE, SUM, and IF.

Which function would you use to add up a list of numbers?

• =SUM(C4:C15)

• =ADD(C4:C15)

• =TOTAL(C4:C15)

• =MAX(C4:C15)

Answer explanation

Instead of typing =C4+C5+...+C16 you use the SUM function. You can add a range of numbers like C4:C6 or you would separate each cell reference with a comma SUM(C4,D4,F4).

Which of the following has a function?

• =IF(C4="Percussion",E4*1.15,E4)

• =C4*D4*1.15

• Undo

• SUM(4+9)=

Answer explanation

The IF function uses a logical test and returns a value if it is true, and another value if it is false. An example would be IF grade is greater than 96% or less than 100%, then grade is A+, else grade is F (IF(96<grade<100,"A+","F").

To activate a cell, you

• just click it or use the arrow keys to move to it.

• hover over the cell border until it makes a double sided arrow.

• tell the computer which cell you want.

• Go to the Home tab, select Highlight from the Edit group, and type the cell you want to edit.

Answer explanation

All you need to do to activate a cell is click on it or use the arrow keys to move to it.

To activate a continuous range of cells you

• click on the first cell and drag to the ending cell/ click on the first cell, hold down the Shift key, and use the arrow keys/ click the first cell, hold down the Shift key, and click the last cell.

• click each cell, one at a time, until you get it right.

• tell the computer what cells are being used using the microphone.

• Go to the Draw tab, in the Drawing Tools group, click on the highlighter and enter the cells you want to highlight

Answer explanation

Using the Shift key will highlight everything between the active cell and the cell you click. To highlight A1 to D4, activate cell A1, hold down the Shift key, and click cell D4.

To activate cells that are not next to each other you

• click the first cell, hold down the Ctrl key, and then click (or click and drag) to the other cells you want to activate

• click around until Excel learns what you want.

• Go to the Data tab, Data Tools group, and select Manage Data Model.

• can't do that- this is a trick question.

Answer explanation

To highlight the cells, activate A1:A2, hold down the Ctrl key and select B3:B4, C1:C2, and then D3:D4.