WorksheetsComputer Fundamentals - Unit 4: Excel
Total questions: 17
Worksheet time: 11mins
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
