Filters
Question type

Study Flashcards

When you move the mouse pointer over the cells in the worksheet window, the mouse pointer changes to (a) n ____.


A) one-sided arrow
B) double-sided arrow
C) white plus sign
D) I-beam

Correct Answer

verifed

verified

All cells in a range share all or part of their borders.

Correct Answer

verifed

verified

Excel simplifies the organization and maintenance of your data.

Correct Answer

verifed

verified

True

Press the down arrow to move to the next screen in a spreadsheet.

Correct Answer

verifed

verified

Rows in a worksheet appear vertically and are identified by letters. ____________________

Correct Answer

verifed

verified

The Enter and Cancel buttons appear in the formula bar even if you are not entering data.

Correct Answer

verifed

verified

Grant is modifying the structure of his worksheet. Grant presses F8 to enable ____ mode.


A) Edit
B) Insert
C) Select
D) Delete

Correct Answer

verifed

verified

Excel refers to a spreadsheet as a ____.


A) worksheet
B) workbook
C) table
D) database

Correct Answer

verifed

verified

A

____ view displays the column and row labels separated from the worksheet cells.


A) Normal
B) Page Layout
C) Full Screen Reading
D) Page Break Preview

Correct Answer

verifed

verified

1A is an example of a cell reference.

Correct Answer

verifed

verified

To select an entire row, click the row heading.

Correct Answer

verifed

verified

The Ribbon in Excel is similar to the Ribbon used in Word.

Correct Answer

verifed

verified

To enter data in a cell, you must first make the cell active.

Correct Answer

verifed

verified

You can minimize the Ribbon by triple-clicking any of the Ribbon tabs.

Correct Answer

verifed

verified

A(n) ____________________ is the intersection of a single row and a single column.

Correct Answer

verifed

verified

The AutoComplete feature in Excel corrects misspellings as you enter data. ____________________

Correct Answer

verifed

verified

Which of the following is NOT true about copying and moving data?


A) You can move or copy multiple cells of data at the same time.
B) When you paste data to a spreadsheet cell that already contains data, the existing data moves to make room for the new data.
C) The Clipboard is used to copy and paste data.
D) All of the above are true.

Correct Answer

verifed

verified

Identify the letter of the choice that best matches the phrase or definition.

Premises
Moves the insertion point to the previous row
Moves the insertion point to the right one cell
Moves the insertion point to the previous screen
Moves the insertion point to the left one cell
Moves the insertion point to the beginning of the worksheet
Responses
Ctrl+Home
Tab
Up arrow
Shift+Tab
Page Up

Correct Answer

Moves the insertion point to the previous row
Up arrow
Moves the insertion point to the right one cell
Tab
Moves the insertion point to the previous screen
Page Up
Moves the insertion point to the left one cell
Shift+Tab
Moves the insertion point to the beginning of the worksheet
Ctrl+Home

Amy is new to using Excel and is learning how to enter data. Amy learns that all of the following are true about using AutoFill to fill in a series EXCEPT: ____.


A) When you drag the fill handle down or to the right, the series is continued in descending order.
B) To fill a series, a pattern must be established in the initial selection of cells.
C) When you drag the fill handle, the pattern or series is continued.
D) You can modify the Fill settings in the Series dialog box.

Correct Answer

verifed

verified

A(n) ____________________ is a grid of rows and columns into which you enter text data and numerical data.

Correct Answer

verifed

verified

Showing 1 - 20 of 42

Related Exams

Show Answer