Computer Fundamentals - Unit 4: Excel

You can change the color of the value of a cell or the background color of the cell, but not both.

• True

• False

Which of the following can a cell contain?

• a number

• a word

• a function

• all of these

When typing in a cell, hitting Tab will bring which result?

• Save the spreadsheet

• Move to the next cell to the right

• Move to the next cell down

• Add a space in the cell

Which of these identifies the intersection of the row 16 and column D?

• the range D1 to D16

• the range A16 to D16

• the cell D16

• 16D

When entering a function or formula in a cell, which is the first character you must type?

• the equal sign (=)

• the plus sign (+)

• a comma (,)

• the letter f

A spreadsheet has some values entered: Cell A1 contains 10, cell A2 contains 14, cell A3 contains 7. You enter in cell A4 the following: "=A1+2". Which value is displayed in A4?

• 10

• 12

• 14

• 24

A spreadsheet has some values entered: Cell A1 contains 10, cell A2 contains 14, cell A3 contains 7. You enter in cell A5 the following: "=A1+A2". Which value is displayed in A5?

• 10

• 12

• 14

• 24

A spreadsheet has some values entered: Cell A1 contains 10, cell A2 contains 14, cell A3 contains 7. You enter in cell A4 the following: "=1+2". Which value is displayed in A4?

• 3

• 10

• 14

• 24

The value 8/10 in a cell refers to which of these?

• August 10th

• October 8th

• Aug-10

• all of these

Which is the easiest way to select a column?

• Double-click on a cell in that column

• Click the column label

• Click at the top of the column and drag to the bottom of the column

• Go to the Edit > select column menu