Deck 17: Getting Started With Excel Essentials

Question 1

A worksheet is always stored in a workbook.

Answer 1

True

Question 2

When you add a new row, the data shifts up a row.

Answer 2

False

Question 3

You can only have one Excel workbook open at a time.

Answer 3

False

Question 4

Computer software engineer is one of the fastest growing occupations.

Question 5

When you insert or delete a row or a column in Excel, it affects the entire worksheet.

Question 6

____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.

A) Columns
B) Rows
C) Cells
D) Headings

Question 7

A1 and B4 are examples of ____.

A) column headings
B) row headings
C) cell references
D) ranges

Question 8

Excel refers to a spreadsheet as a ____.

A) spreadsheet
B) worksheet
C) workbook
D) range

Question 9

When a cell is selected, the column and row headings for the selected cell are highlighted.

Question 10

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

Question 11

Using AutoFill is not as fast as copying and pasting.

Question 12

The row heading is the letter at the left of the row.

Question 13

The Name box shows the ____.

A) cell contents
B) active cell
C) status bar
D) formula bar

Question 14

The Fill command can only be used when the destination cells are adjacent to the original cell.

Question 15

The arrow keys move the insertion point one cell in any direction.

Question 16

Usually the top row of a worksheet is used for explanatory text or column headings that identify the type of data in each column.

Question 17

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

Question 18

Copying data saves you from having to enter the same data into another location.

Question 19

When a cell is selected, it is called the ____.

A) worksheet
B) range
C) active cell
D) cell reference

Question 20

By default, Excel shows approximately six characters in each cell.

Question 21

Which view hides the Ribbon, the formula bar, and the status bar?

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

Question 22

Where are the sizing buttons that control the application and worksheet windows?

A) Lower left corner of the status bar
B) Lower right corner of the status bar
C) Upper left corner of the window
D) Upper right corner of the window

Question 23

Where are the zoom controls located?

A) Quick Access Toolbar
B) Upper right corner of the document window
C) Formula bar
D) status bar

Question 24

Which view separates the column and row labels from the worksheet cells?

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

Question 25

Case 17-1 Kristin is new to spreadsheets. She was asked to create a worksheet for her business club's fundraiser. Kristin is entering data in cells. Why does she see ### in some of the cells?

A) She entered more numbers than can fit in the cell
B) She entered text instead of numbers in the cell
C) She entered eight numbers in the cell
D) She entered too few numbers in the cell

Question 26

FIGURE 17-2 What is the arrow pointing to in Figure 17-2 above?

A) Cancel, Enter, and Insert Function buttons
B) Quick Access Toolbar
C) Status bar
D) Formula bar

Question 27

The ____ shows the cell contents.

A) status bar
B) Name box
C) cell reference
D) formula bar

Question 28

When using the AutoComplete feature, you can press ____ to accept a proposed entry.

A) Home
B) Delete
C) Enter
D) Tab

Question 29

The Undo and Redo commands are available on the ____.

A) status bar
B) Quick Access Toolbar
C) formula bar
D) Data tab

Question 30

Case 17-2 Lino is creating a project schedule for the construction company where he works. He needs to list the tasks that need to be completed each day and show which employees will complete the work. Which feature can Lino use to quickly fill in a series of dates?

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

Question 31

If you enter hte , which feature will automatically change the text to the ?

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

Question 32

A1:D4 is an example of a ____.

A) cell reference
B) range
C) column heading
D) row heading

Question 33

The Ribbon, tabs, and command groups are part of the ____.

A) Quick Access Toolbar
B) Excel document window
C) Microsoft Office Fluent user interface
D) formula bar

Question 34

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

Question 35

Press the ____ key to move the insertion point to the first cell in a row.

A) Page Up
B) Home
C) Page Down
D) Tab

Question 36

Case 17-1 Kristin is new to spreadsheets. She was asked to create a worksheet for her business club's fundraiser. Kristin wants to insert three new columns. What should she do before executing the Insert Sheet Columns command?

A) Select one column
B) Select two columns
C) Select three columns
D) She doesn't need to select any columns

Question 37

Case 17-2 Lino is creating a project schedule for the construction company where he works. He needs to list the tasks that need to be completed each day and show which employees will complete the work. What should Lino click to select an entire column so that he can change its formatting?

A) Row heading
B) Column heading
C) Range
D) Formula bar

Question 38

When you enter text in a cell, it also appears in the ____.

A) status bar
B) formula bar
C) row heading
D) name box

Question 39

A ____ is identified by the cell in the upper-left corner and the cell in the lower-right corner, separated by a colon.

A) worksheet
B) cell reference
C) value
D) range

Question 40

FIGURE 17-1 The arrows in Figure 17-1 above are pointing to ____.

A) active cells
B) cell references
C) Ribbon tabs
D) worksheet tabs

Question 42

Text or numbers in the active cell are often referred to as a(n) ____________________.

Question 43

What are the advantages of an electronic spreadsheet over a paper spreadsheet? Do you think it would be helpful to use a pencil and paper to plan an electronic spreadsheet? List at least two reasons why or why not.

Question 44

The intersection of a single row and a single column is called a(n) ____________________.

Question 45

You can drag a column ____________________ to change the column width.

Question 46

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