Basics
Navigation
Cells
Modification
Misc.
100
A(n) ____________________ is a grid of rows and columns into which you enter text data and numerical data.
What is a spreadsheet?
100
True or False You can minimize the Ribbon by triple-clicking any of the Ribbon tabs.
What is False?
100
The ____________________ cell is the cell that is selected.
What is active?
100
To move to the first cell in a row, press ____. a. Left arrow c. Home b. Ctrl+Home d. Shift+Tab
What is C?
100
When you select a group of cells, the group is called a(n) ____________________.
What is a range?
200
What does clicking the Cancel button do?
What is "delete content"?
200
The ____ view displays the column and row labels separated from the worksheet cells. a. Normal c. Full Screen Reading b. Page Layout d. Page Break Preview
What is B?
200
A(n) ____________________ is the intersection of a single row and a single column.
What is a cell?
200
When you enter more numbers than can fit in a cell, ____. a. a series of number signs is displayed in the cell b. you cannot enter any more numbers c. by default, the column automatically widens to fit the new data d. a dialog box opens
What is A?
200
The ____ view hides the Ribbon, formula bar, and status bar. a. Normal c. Full Screen b. Page Layout d. Page Break Preview
What is C
300
True or False. The Ribbon in Excel is similar to the Ribbon used in Word.
What is True?
300
The ____ feature compares the first few characters you enter in a cell with existing entries in the same column and proposes text. a. AutoFill c. AutoComplete b. AutoCorrect d. AutoFit
What is D?
300
Excel refers to a spreadsheet as a ____. a. worksheet c. table b. workbook d. database
What is A
300
Which of the following is NOT true about the AutoFill command? a.Filling data is another method for copying data in a worksheet. b.The Fill button is located in the Editing group on the Home tab. c. AutoFill is faster than copying and pasting. d.The AutoFill command can be used on nonadjacent cells.
What is C?
300
Grant presses F8 to enable the ____ mode. a. Edit c. Select b. Insert d. Delete
What is C?
400
True or False To enter data in a cell, the cell must be active.
What is True?
400
Amy learns that when you point to the fill handle, the pointer changes to a(n) ____. a. white plus sign c. double-headed arrow b. crosshair d. single-headed arrow
What is B?
400
As data is entered in the cell, the ____ bar shows the content. a. title c. status b. formula d. name
What is B?
400
What happens when the text is too long for the width of the cell if the next cell is empty?
What is spills over?
400
To enter data in a cell, what must the cell be?
What is Active?
500
True or False By default, Excel includes the Repeat command on the Quick Access Toolbar.
What is False?
500
When you move the mouse pointer over the formula bar, the mouse pointer changes to a(n) ____. a. one-sided arrow c. white plus sign b. double-sided arrow d. I-beam
What is D?
500
Grant knows that the default column width is 8.43 ____. a. points c. kilobytes b. pixels d. characters
What is D?
500
A collection of worksheets
What is a workbook?
500
The text or number you enter in a cell is often referred to as a(n) ____________________.
What is value?
M
e
n
u