excel chapter 1 and 2

1.

1 point

When you start =AV, what displays a list of functions and defined names?

function screentip

formula autocomplete

Insert Function dialog box

Function Arguments dialog box

2.

1 point

A formula containing the entry =$B3 is copied to a cell one column to the right and two rows down. How will the entry appear in its new location?

=$C5

=$B5

=$B3

=B3

3.

1 point

What Excel interface item displays the address of the current cell?

formula bar

quick access toolbar

name box

status bar

4.

1 point

Assume that the data on a worksheet consume a whole printed page and a couple of columns on a second page. You can do all of the following except what to force the data to print all on one page?

increase the left and right margins

select a smaller range as the print area

Decrease column widths if possible.

decrease the scale value

5.

1 point

given that cells A1, A2, and A3 contain values 2, 3, and 10, respectively, and B6, C6, and D6 contain values 10, 20, and 30, respectively, what value will be returned by the function =IF(B6>A3,C6*A1,D6*A2)?

40

90

10

60

6.

1 point

Which of the following characteristics is not applicable to the Accounting Number Format?

TWO DECIMAL points

Commas to separate thousands

Zero values displayed as hyphens

Dollar sign immediately on the left side of the value

7.

1 point

Which of the following is not an acceptable range name?

Test_Weight

Goal for 2016

FICA

Target_2015 Target_2015 Target_2015 Target_2015

8.

1 point

Which of the following is a nonadjacent range?

L15:L65

A1:Z99

C15:D30

A1:A10, D1:D10

9.

1 point

You selected and copied worksheet data containing formulas. However, you want the pasted copy to contain the current formula results rather than formulas. What do you do?

Click Paste in the Clipboard group on the Home tab.

Click the Paste arrow in the Clipboard group and select Values & Source Formatting.

Display the Paste Special dialog box and select Formulas and number formats.

click the Paste arrow in the Clipboard group and select Formulas.

10.

1 point

If you want to balance a title over several columns, what do you do

Enter the data in the cell that is about midway across the spreadsheet.

Click Center to center the title horizontally over several columns.

Merge and center the data over all columns.

Use the Increase Indent command until the title looks balanced.

11.

1 point

What should you do if you see a column of pound signs (###) instead of values or results of formulas?

increase the column width

increase the zoom percentage

delete column

adjust the row height

12.

1 point

Why would you press Ctrl+` in Excel?

To undo a mistake you made

To display the print options

To enable the AutoComplete feature

to display cell formulas

13.

1 point

Given the formula =B1*B2+B3/B4^2 where B1 contains 3, B2 contains 4, B3 contains 32, and B4 contains 4, what is the result?

14

121

9216

76

14.

1 point

What function would most appropriately accomplish the same thing as =(B5+C5+D5+E5+F5)/5?

=MEDIAN(B5:F5)

=AVERAGE(B5:F5)

=SUM(B5:F5)/5

=COUNT(B5:F5)

15.

1 point

The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?

loan amount

number of payment periods

APR

Periodic interest rate

16.

1 point

What is the first step in planning an effective worksheet?

identify the input and output areas.

State the purpose of the worksheet.

Enter labels, values, and formulas.

Decide how to format the worksheet data.

17.

1 point

Cell B10 contains a date, such as 1/1/2016. Which formula will determine how many days are between that date and the current date, given that the cell containing the formula is formatted with Number Format?

=TODAY()

=CURRENT()-B10

=TODAY()-B10

=TODAY()+NOW()

18.

1 point

Given the function =VLOOKUP(C6,$D$12:$F$18,3), the entries in:

Range D12:D18 are in descending order.

Range D12:D18 are in ascending order.

Range D12:D18 contain multiple values in each cell.

the third column of the lookup table must be text only

19.

1 point

Which of the following is not an appropriate use of the SUM function?

=SUM(A8:A15,D8:D15)

=SUM(B3:B45)

=SUM(D15-C15)

=SUM(F1:G10)

20.

1 point

If cell D15 contains the formula =$C$5*D$15, what is the D15 in the formula?

relative reference

range name

circular reference

absolute reference