Excel Basics Ch 2

How will you correctly write a formula in cell C5 for year-to-date profits that you can drag across for the next four months?

• Use =C2-C3

• Use =B2-B3

• Use =B4+C4

• Use =C4+B5

You want to get the percentage increase in profits from January to February. If you use the formula shown below, what value will be returned?

• 10

• 29

• 0.33

• 0.5

The most effective way to add up five different cells in a row is to

• type each cell location and type a plus sign in between each

• use the SUM function

• use the TOTAL function

• click on each cell and type a plus sign in between each

Date entries are numbers and by default they

• line up on the right side of the cell

• are structured as day/month/year

• include dashes

• line up on the left side of the cell

You have received a worksheet from a coworker who told you there are a number of comments you need to review. How do you first know there are comments in the worksheet?

• The cell is highlighted with a border.

• Look at the Comments sheet.

• The row or column will be highlighted.

• There is a little triangle in the upper right-hand corner of the cell.

What is the basis of using formulas in Excel?

• Formulas are usually based on functions.

• Formulas are usually based on location.

• Formulas are usually based on using an equal sign.

• Formulas are usually based on equations.

Suppose a cell contains the formula =(E3*$H$2) * E3. The variable $H$2 is a(n) _____ reference.

• bad

• mixed

• absolute

• relative

Where can you find the command for Excel to calculate the MAX value into cell G2?

• by selecting the AutoSum button (∑) at the top left of the ribbon

• by selecting the Insert function (ꝭꭓ) at the top right of the ribbon

• by right-clicking in cell G2 beneath Max in cell G1

• by selecting the arrow under the AutoSum button (∑) at the top left of the ribbon

Pat wants to copy a formula into an adjacent cell. Which action should she take?

• Right-click the mouse button.

• Hold down the left mouse button on the fill handle and drag to the right.

• Drag the fill handle and move to the right.

• Right-click the mouse button.

What is the best formula for adding together five adjacent values in a column?

• =Out()

• =Total()

• =ADD()

• =Sum()