Excel Lessons B and C Quiz 1

1.          After entering labels into a worksheet, enter data, or __________, used in calculations.

a.     text

b.      values

c.      formulas

d.      none of the above

2.          Which of the following values would Excel include in a calculation?

a.     234

b.      '323-3432

c.      3423 Round Street

d.      all of the above

3.          To select a range of cells, click the first cell and __________ to the last cell you want to include.

a.     paste

b.      drag

c.      copy

d.      none of the above

4.          B6:C6 is an example of a(n)

a.     label.

b.      insertion point.

c.      range.

d.      formula.

5.          Excel recognizes the entry, =B4/B2*C4, as a

a.     label.

b.      value.

c.      formula.

d.      function.

6.          All Excel formulas begin with __________.

a.     *

b.      +

c.      /

d.      =

7.          The correct formula to multiply cell D5 by cell B2 is

a.     B2*D5.

b.      =D5*B2.

c.      D5*B2.

d.      (D5*B2).

8.          In the calculation =1200/23-600+75/45, which mathematical operation is performed first?

a.     subtraction

b.      multiplication

c.      division

d.      addition

9.          Which operation is performed last in a calculation?

a.     exponentiation

b.      subtraction

c.      division

d.      multiplication

10.       The order of precedence in Excel formulas can be changed by using

a.     quotation marks.

b.      parentheses.

c.      colons.

d.      question marks.

11.       $A$1 is an example of a(n)

a.     formula.

b.      absolute cell reference.

c.      calculation.

d.      none of the above.

12.       Cells and ranges in a worksheet can be formatted

a.     before data is entered.

b.      after data is entered.

c.      before or after data is entered.

d.      at the same time data is entered.

13.       A cell's format can be "copied" into other cells using the

a.     Clipboard.

b.      Format Painter button.

c.      Paste Function button.

d.      none of the above.

14.       Attributes are font styling features such as

a.     bold.

b.      italics.

c.      underlining.

d.      all of the above.

15.       Which of the following can you insert into or delete from your worksheet?

a.     rows

b.      columns

c.      both a and b

d.      none of the above

16.       When you add or delete a row or column within a range used in a formula,

a.     you must re-enter the formula.

b.      you must change to a new formula.

c.      Excel automatically adjusts the formula.

d.      none of the above.

17.       Single underline, double underline, and outline are examples of __________ buttons.

a.     border

b.      attribute

c.      pattern

d.      font

18.       Formatting affects how information appears in cells and does not alter the data in any way.

a.     true

b.      false