Deck 18: Getting Started With Excel Essentials

Question 1

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

Answer 1

False

Question 2

1A is an example of a cell reference.

Answer 2

False

Question 3

To enter data in a cell, the cell must be active.

Answer 3

True

Question 4

In the accompanying figure, the text A1 is located in the ____.

A) name box
B) active cell
C) title bar
D) formula bar

Question 5

To select an entire row, click the row heading.

Question 6

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

Question 7

If you choose not to keep the data you have entered, you can press Esc .

Question 8

Press the down arrow to move to the next screen.

Question 9

Which of the following is NOT true about workbooks?

A) Worksheets are always stored in workbooks.
B) You can only have one Excel workbook open at a time.
C) When working with large amounts of data, you can organize the data into multiple worksheets.
D) When you open a new blank workbook, Sheet1 appears in the worksheet window.

Question 10

All cells in a range touch each other and form a rectangle.

Question 11

Excel is an electronic spreadsheet application.

Question 12

By default, Excel includes the Repeat command on the Quick Access Toolbar.

Question 13

When you move the mouse pointer over the formula bar, the mouse pointer changes to a(n) ____.

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

Question 14

Excel refers to a spreadsheet as a ____.

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

Question 15

The AutoComplete feature in Excel corrects common mistakes as you enter data.

Question 16

The AutoComplete feature enables you to repeat the same data in a column or row.

Question 17

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

Question 18

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

Question 19

Excel 2010 uses the Microsoft Office Fluent user interface.

Question 20

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

Question 21

The ____ view hides the Ribbon, formula bar, and status bar.

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

Question 22

The ____________________ cell is the cell that is selected.

Question 23

The ____ feature compares the first few characters you enter in a cell with existing entries in the same column and proposes text.

A) AutoFill
B) AutoCorrect
C) AutoComplete
D) AutoFit

Question 24

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.

Question 25

In the accompanying figure, the space to the right of fx is called the ____.

A) name box
B) active cell
C) title bar
D) formula bar

Question 26

When you select a group of cells, the group is called a(n) ____________________.

Question 27

The text or number you enter in a cell is often referred to as a(n) ____________________.

Question 28

Amy is new to using Excel and is learning how to enter data. Amy learns that all of the following is 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.

Question 29

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

Question 30

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

Question 31

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

Question 32

To move to the first cell in a row, press ____.

A) Left arrow
B) Ctrl+Home
C) Home
D) Shift+Tab

Question 33

To move to the right one cell, press ____.

A) Right arrow
B) Tab
C) Enter
D) Either A or B

Question 34

Which of the following is NOT true about inserting and deleting rows and columns?

A) When you add a new column, the existing data shifts to the right.
B) When you insert or delete a row or column, it affects the entire worksheet.
C) To insert or delete multiple columns and rows, select the desired number of columns and rows before executing the command.
D) All of the above are true.

Question 35

Amy is new to using Excel and is learning how to enter data. Amy learns that when you point to the fill handle, the pointer changes to a(n) ____.

A) white plus sign
B) crosshair
C) double-headed arrow
D) single-headed arrow

Question 36

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.

Question 37

As data is entered in the cell, the ____ bar shows the content.

A) title
B) formula
C) status
D) name

Question 38

Grant is modifying the structure of his worksheet. Grant knows that the default column width is 8.43 ____.

A) points
B) pixels
C) kilobytes
D) characters

Question 39

The ____ 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

Question 40

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

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

Question 46

What is a value? To enter data in a cell, what must the cell be? What happens when the text is too long for the width of the cell if the next cell is empty? What happens when you enter more numbers than can fit in a cell? What does clicking the Cancel button do?