Deck 15: Microsoft Excel Basics

Question 1

The cell in the worksheet in which you can type data is called the open cell.

Answer 1

False

Question 2

The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Ribbon, Backstage view, and the status bar.

Answer 2

True

Question 3

The column letter and row number of the active cell are shaded in red for easy identification.

Answer 3

False

Question 4

The Save As command saves an existing workbook on a disk, using its current name and save location.

Question 5

A formula is the intersection of a row and a column.

Question 6

____ appear horizontally and are identified by numbers on the left side of the worksheet window.

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

Question 7

The ____, or cell reference area located below the Ribbon, displays the cell reference of the active cell.

A) Name Space
B) Formula Bar
C) Name Pane
D) Name Box

Question 8

Saving a workbook means loading an existing workbook file from a disk into the program window.

Question 9

If a cell is not wide enough to display all the cell's contents, extra text extends into the next cells if there is room.

Question 10

When you use the Find command , new data is substituted for the data found.

Question 11

The Formula Bar appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value.

Question 12

Text is any combination of letters and numbers and symbols, such as headings, labels, or explanatory notes.

Question 13

The name of each worksheet appears in the ____ at the bottom of the worksheet window.

A) sheet box
B) sheet task bar
C) sheet dialog box
D) sheet tab

Question 14

You can also close the workbook and leave Excel open by clicking the Close Window button located below the sizing buttons in the status bar.

Question 15

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

The easiest way to change the active cell in a worksheet is to click Cell on the Ribbon and type in the cell's location.

Question 17

To clear the active cell, you can use the Ribbon, the keyboard, or the mouse.

Question 18

Microsoft Office Excel 2010 is the presentation program in Microsoft Office 2010.

Question 19

When Excel starts, the program window displays a blank workbook titled Book1 , which includes ____ blank worksheets.

A) one
B) two
C) three
D) four

Question 20

The contents of the active cell always appear in the Formula Bar.

Question 21

To use the Replace command, in the ____ group on the Home tab of the Ribbon, click the Find & Select button, and then click Replace.

A) Formulas
B) Proofing
C) Data
D) Editing

Question 22

To edit the data directly in a cell, make the cell active and then press the ____ key or double-click the cell.

A) F1
B) F2
C) F3
D) F4

Question 23

If you try to close a workbook that contains changes you haven't saved, ____.

A) a dialog box asks you whether or not you want to save the file
B) the workbook closes and your changes are lost
C) you receive an error message
D) the workbook closes and your changes are saved anyway

Question 24

FIGURE EX 1-1 Referring to Figure EX 1-1 above, if you wanted to find an entry for an employee s name which may be misspelled, and you cannot remember if you capitalized the first and last name, you would choose the following search option: ____.

A) Match case
B) Match entire cell contents
C) both a. and b.
D) neither a. nor b.

Question 25

A(n) ____________________ is an equation that calculates a new value from values currently in a worksheet, such as adding the numbers in cell A1 and A2.

Question 26

To replace cell contents, you can select the cell, type the new data, and then enter the data by ____.

A) pressing the Enter key
B) pressing the Tab key
C) clicking the Enter button on the Formula bar
D) all of the above

Question 27

Numbers that extend beyond a cell's width appear as ____ in the cell.

A) &&&&
B) ????
C) ####
D) ++++

Question 28

You can close a workbook by clicking the ____ tab on the Ribbon, and then clicking Close in the navigation bar.

A) Home
B) File
C) Review
D) View

Question 29

FIGURE EX 1-1 Referring to Figure EX 1-1 above, if you entered an incorrect value in one of the cells and wanted to find it, you would choose cell contents as your place to search in the ____ option box.

A) Look in
B) Search
C) Within
D) Replace with

Question 30

You can use wildcard characters in the Find what box to search for data that matches a particular pattern. Use ____ for two or more characters.

A) * (an asterisk)
B) ? (a question mark)
C) ! (an exclamation point)
D) # (a pound sign)

Question 31

Case EX 1-1 Nicole has not used Excel before and is getting used to the different pointer shapes that Excel shows, depending on the action you are taking. When Nicole moves the pointer to a button on the Ribbon, the pointer changes to a ____.

A) white arrow
B) thick white plus sign
C) black arrow
D) thick black plus sign

Question 32

The ____ tab enables you to select the number of copies to print, a printer, the parts of the worksheet to print, and the way the printed worksheet will look.

A) Selection
B) Print Now
C) Print
D) Output

Question 33

Case EX 1-2 Donovan is starting to use the keyboard to navigate around an Excel spreadsheet. To move to cell A1, Donovan presses the ____ .

A) Page Down key
B) Page Up key
C) Ctrl+End keys
D) Ctrl+Home keys

Question 34

Case EX 1-2 Donovan is starting to use the keyboard to navigate around an Excel spreadsheet. To move down one window, Donovan presses the ____.

A) Page Down key
B) Page Up key
C) Ctrl+End keys
D) Ctrl+Home keys

Question 35

Case EX 1-1 Nicole has not used Excel before and is getting used to the different pointer shapes that Excel shows, depending on the action you are taking. Nicole notices that the point changes shape to become a ____ when it is in the worksheet.

A) white arrow
B) thick white plus sign
C) black arrow
D) thick black plus sign

Question 36

The default magnification for a workbook is ____, which you can see on the Zoom level button.

A) 0%
B) 80%
C) 90%
D) 100%

Question 37

The range is identified by its range reference, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a ____.

A) colon
B) semicolon
C) comma
D) period

Question 38

You can change the active worksheet in a workbook to next worksheet by pressing the ____+Page Down keys.

A) Fn
B) Ctrl
C) Alt
D) Tab

Question 39

If you want to see more cells in the work area, click the Zoom Out button or drag the Zoom slider to the ____ to decrease the zoom percentage.

A) left
B) right
C) either a. or b.
D) neither a. nor b.

Question 40

In the Zoom dialog box, click the ____ option button to zoom the worksheet so the selected range fills the worksheet window.

A) Zoom selection
B) Fit selection
C) Magnification
D) Full screen

Question 42

A group of selected cells is called a(n) ____________________.

Question 43

When you press and hold down a(n) ____________________ key, the active cell shifts in that direction repeatedly and quickly.

Question 44

After you have saved the workbook, you can use the Save command in ____________________ view or the Save button on the Quick Access Toolbar to periodically save the latest version of the workbook with the same name in the same location.

Question 45

After you type data in a cell, the active cell changes, depending on how you enter the data. Please describe what happens if you click the Enter button on the Formula bar, if you press the Enter key, and if you press the Tab key. Also, give an example of when you would use each method of entering data.

Question 46

You can create a new folder in which to save a file by clicking the New folder button in the Save As ____________________. Type a name for the new folder, and then press the Enter key.