excel class

Let's say you want to test to see if the value in cell D1 is less than 26. If it is, the IF function will place the number 100 in cell D2. If the value in D1 isn't less than 26, the IF function will place the number 200 in cell D2. With this scenario, what would you type in the Value_if_true box of the Function Arguments dialog box for the IF function?

100.

How many months would a loan with a term of 15 years last?

180 months.

Using the Stats file you created in this lesson, insert a third column labeled Version 3 with these numbers from your five participants: 8, 10, 7, 4, 7. What is your standard deviation?

2.17.

Suppose you typed the number 5 in cell A1. Suppose further that you moved the pointer to that cell, grabbed the pointer's copy handle with your mouse, and dragged the copy handle to cell B1. What value would appear in cell B1?

5.

Suppose you typed the number 0.83 into a cell that had no formatting. Then, you clicked the Percent Style button. How would the number look after you clicked the Percent Style button?

83%.

Suppose you typed the formula =$B5*25% in cell C5. How would the formula look if you were to copy the formula across one column to cell D5?

=$B5*25%.

How would you write a formula asking Excel to first add 7 to the value in cell A1 and then, once an answer is obtained, multiply that answer by 5?

=(7+A1)*5.

Which function would ask Excel to average the values contained in cells C5, C6, C7, and C8?

=AVERAGE(C5:C8).

Suppose you typed the formula =B1+$C$1 in cell D1. How would the formula look if you were to copy it down one row to cell D2?

=B2+$C$1.

With the scenario described in the previous question, after completing the Function Arguments dialog box for the IF function, what formula would appear in your formula bar?

=IF(D1<26,100,200).

Which is the correct way to write a formula that adds the value of cell B2 on Sheet1, Sheet2, and Sheet3?

=Sheet1!B2 + Sheet2!B2 + Sheet3!B2.

Which operator can you use to represent the phrase greater than or equal to in the Logical_test box of the Function Arguments dialog box for an IF function?

>=.

In order to copy a cell, you must first move the pointer to the cell and then position your mouse over the pointer's copy handle. Before you can drag the copy handle to duplicate the contents of the cell, what must the on-screen representation of your mouse look like?

A black cross.

What is the intersection of any column with any row referred to as?

A cell.

Which is a TRUE statement about macros?

A macro can be used to automate almost any task you perform in Excel.

Which type of cell reference will always change when you copy it to another cell?

A relative reference.

What is an Excel worksheet that has an initial row consisting of labels known as?

A table.

Which type of cell reference will never change, even if it's copied or moved?

Absolute

The Sort dialog box includes a group of buttons just above the original row of drop-down lists. Which button will present you with a new row of drop-down lists, just below your original row, so you can perform a second sort?

Add Level.

What should you be careful to select when you're using your mouse to highlight values for a chart?

An equal amount of numbers and labels.

What character would you use to separate the sheet name from the cell address in a formula containing a sheet reference?

An exclamation point.

What is the name of the time-saving Excel feature that will automatically fill rows and columns of your worksheet with months of the year, days of the week, financial quarters, or other custom lists of words or numbers?

Auto Fill

Which statistical function is also known as the arithmetic mean?

Average.

If you change your mind about a chart after it has been created, how do you switch to another type of chart?

By clicking the Change Chart Type button in the Type group of the Design tab.

The formula =(A1+$B$1+C$1)/AA101 contains four cell references. Which reference would be considered a mixed reference?

C$1.

Which keyboard shortcut will always take you immediately to the top-left corner of your worksheet, no matter where your cell pointer happens to be located?

CTRL + HOME.

Which keyboard shortcut is available to be used for a macro?

CTRL + J.

Why are charts useful?

Charts help visualize or illustrate quickly.

How do you change from one chart type or subtype to another after the fact?

Click once on your chart; click the Design tab; click the Change Chart Type button in the Type group; select any chart type or subtype that strikes your fancy.

How would you go about moving from worksheet to worksheet within a single workbook?

Click the sheet tabs at the bottom of your workbook.

If the Currency Style, Comma Style, and Percent Style buttons can't meet your formatting needs, how can you access a larger selection of other formats?

Click the small arrow in the lower-right corner of the Number group.

Within which Excel tab is the Subtotal button located?

Data.

If you know the annual interest rate, how would you obtain a rough estimate of the monthly interest rate?

Divide the rate by 12.

Which operation would Excel perform first if it were presented with the formula =C3-D5/C6 + B2?

Division

In plain English, what does E5<B10 mean?

E5 is less than B10.

What characters may be used in your sheet names or cell addresses?

Either lower- or uppercase letters.

Which function can be used to calculate the future value of your investment when you know the present value, payment amount, term, and interest rate?

FV.

Which Excel option allows you to easily reveal rows in your table that meet specific criteria?

Filter.

Why would you want to format your worksheet?

Formatting can improve the appearance and readability of a worksheet.

Say you want to add a solid color, gradient, picture, or texture to your chart background with the Shape Fill button. What do you do after you select the chart?

Go to the Shape Styles group of the Format tab.

What do we call the vertical or horizontal lines you can run across the plot area of your chart?

Gridlines.

What do we call the words that describe the type of information you'll be entering into each column and row of your worksheet?

Labels.

What are columns in Excel ordinarily labeled with?

Letters of the alphabet.

What tool can you use in Excel to automate time-consuming or tedious tasks?

Macros

Which statistical function can you use to identify the most common value in a set of numbers?

Mode.

Suppose you typed Sun in cell A1. Suppose further that you moved the pointer to that cell, grabbed the pointer's copy handle with your mouse, and dragged the copy handle to cell A2. What would appear in cell A2?

Mon.

Which of the following functions could you use to determine how long it will take you to pay off a loan?

NPER

What do the letters in the NPER function represent?

Number of Periods.

Which two items need to be present in your worksheet when you create a chart?

Numbers and labels

What are rows in Excel ordinarily labeled with?

Numbers.

Which function will calculate the payment on your loan if you know the term, present value, future value, and interest rate?

PMT.

What are some of the chart types Excel can produce?

Pie, column, bar, line, and area.

What is an obvious advantage to gathering the buttons you use most frequently on the Quick Access Toolbar?

Placing buttons you frequently use on the Quick Access Toolbar makes them easier to use and faster to locate.

When you highlight two or more cells, what useful tool appears below and to the right of the copy handle?

Quick Analysis.

What is the default alignment Excel uses with numbers?

Right

Which button would you use to sort one column of numbers from large to small?

Sort Z to A.

When linking files, what should the filename to which you're linking be surrounded by?

Square brackets.

Which statistical function helps to describe how far a set of numbers diverge from one another?

Standard Deviation.

Below is a list of steps for creating a worksheet. According to the lesson, which of these is step one?

State your objective.

Which Excel feature can you use to automatically subtotal columns in your table containing numbers?

Subtotal

What do flashing, Vegas-style marquee lights surrounding your cells signify?

That you have cut or copied the cells.

Under which tab is the Chart Styles group located?

The Design tab.

Which function provides Excel with some of its decision-making powers?

The IF function of the Logical category.

Which button can you use to change the interior color of a shape you've drawn on your chart?

The Shape Fill button on the Format tab.

Which button should you select to draw on your charts?

The Shapes button on the Format tab.

When formatting the worksheet you created in this lesson, which button did we select to place a border under row 1?

The Thick Bottom Border button in the Font group.

What would most likely happen if you were to copy the formula =C$4+3 into another column?

The column letter would change, but the row number wouldn't change.

What does the function =MAX(B2:B10) tell us?

The largest value in a set of values.

How do you know if the entire string of text in an existing text box has been selected and ready to update?

The text string is highlighted after triple-clicking within the text box.

What must you make sure to do if you want to use the arrows on your numeric keypad?

Turn off the NUM LOCK feature (the light isn't glowing).

On which tab is the Macros group located?

View.

Would Excel be able to distinguish between CTRL + I and CTRL + SHIFT + I?

Yes, CTRL + I would cause the contents of a cell to be italicized, while CTRL + SHIFT + I is available for assignment to a macro.