**PLEASE READ: Integrated Excel Best Practices**

- Do not cut/paste or drag and drop cells, as this can cause grading issues.
- Empty fields for normal graded cells will default to 0, drop-down fields will be empty.
- Questions autosave when any update is made in Excel.
- Excel tutorial videos are available for you in your instructor’s course. To access them, go to
**Course Content**and select**Excel Basics and Time Value of Money in Excel**.

**Graded Cell Types**

There are two types of graded cells: **Normal Graded Cells** and **Drop-down Graded Cells**.

**Normal Graded Cells**require you to enter a formula (#3 in image below).**Drop-down Graded Cells**require you to select an answer from a drop-down list (#4 in image below).

**How to Enter Answers **

See below for instructions on how to successfully enter or select answers.

**Numeric/formulas: **

- You must enter an acceptable formula to get credit.
- If a number needed for your formula is provided in a cell, you must reference that cell in your formula. Do not enter just numbers (Example: =G53+G52, not =60000+5000).
- Even if the answer is a single number, the answer entered in the cell must be a cell reference (Example: =G53, not 65000 or =65000 or =65000+5000).

- There may be an occasion where you need to use a number in your formula (Example: divide by 2 for average, divide by 365 to convert to "days", an interest rate). If the number is not provided in a cell that can be referenced within the question, use the actual number in your formula (Examples: =G52+G53/2, =G54/365, etc.).

**Drop-down answers:**

- Click the arrow and select the correct answer from the drop-down menu (#4 in image above).

**Other important notes about entering answers:**

- Do not use cut and paste or "drag and drop" to move or remove answers. Instead, delete answer in the incorrect cell and re-enter it in the correct cell. Using copy and paste to duplicate formulas is ok.
- If the question has multiple worksheet tabs, your formula answers must reference cells within the same worksheet (tab). If you reference a cell from another worksheet to arrive at the correct answer, your answer will be marked wrong.
- Using “+” instead of an “=” at the beginning of a formula will work.

**Show Formulas **

If you would like to see the formulas that you have entered, follow the steps below.

- Select the
**Formulas**tab. - Select
**Show Formulas**.