Question: A ____ is a prewritten formula that is built into Excel.

Answer: function

Question: To start a new line in a cell, press the ____ keys.

Answer: ALT+ENTER

Question: When you enter a two-digit year that is less than 30, Excel changes the year to ____.

Answer: 20xx

Question: A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Answer: indirect

Question: All of the following are valid Excel arithmetic operators EXCEPT ____.

Answer: >

Question: Which of the following calculations multiplies 23 by 0.01?

Answer: =23%

Question: When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

Answer: operations

Question: When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

Answer: 26

Question: Which of the following happens when you enter the formula =G15 into a cell?

Answer: Excel assigns the value in cell G15 to the active cell

Question: Point mode allows you to ____, as shown in the accompanying figure.

Answer: