Question 1

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.

Accepted Answer

Clicking the Zoom Out button or dragging the Zoom slider to the left will decrease the zoom percentage and allow you to see more cells in the work area.

Question 2

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

Accepted Answer

All the options listed are valid methods for entering new data into a cell in spreadsheet software like Microsoft Excel. Pressing the Enter key, pressing the Tab key, and clicking the Enter button on the Formula bar will all replace the cell's contents with the new data you've typed.

Question 3

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

Accepted Answer

To move down one window in an Excel spreadsheet, Donovan should press the Page Down key. The Page Up key would move him up one window, while Ctrl+End would take him to the last cell in the data range, and Ctrl+Home would take him to the first cell in the data range.

Question 4

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

Accepted Answer

Pressing Ctrl+Page Down keys allows you to navigate to the next worksheet in the workbook. The Fn key is typically used in combination with other keys to perform specific functions on a laptop keyboard, Alt key is used to access menu commands and Tab key is used to move to the next cell in a worksheet.

Question 5

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

Accepted Answer

When attempting to close a workbook that contains changes you haven't saved, a dialog box will prompt you to choose whether or not to save the file before closing it. This gives you the option to save your changes or discard them before exiting the workbook.

Question 6

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

Accepted Answer

The range reference is identified by a colon separating the cell in its upper-left corner and the cell in its lower-right corner.

Question 7

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

Accepted Answer

The answer of FIGURE EX 1-1  Referring to Figure...

Question 8

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.

Accepted Answer

The answer of A(n) ____________________ is an equation that calculates...

Question 9

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

Accepted Answer

The thick white plus sign is the pointer shape that appears in the worksheet when you have currently selected a cell or range of cells in Excel.

Question 10

Numbers that extend beyond a cell's width appear as ____ in the cell.
A) (&&&&)
B) (????)
C) (####)
D)( ++++)

Accepted Answer

Numbers that extend beyond a cell's width appear as pound signs (#) in the cell.

Question 11

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

Accepted Answer

To edit the data directly in a cell, you need to make the cell active and then press the F2 key or double-click the cell. This will put the cell into edit mode, allowing you to make changes to the data within the cell directly.

Question 12

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

Accepted Answer

The File tab on the Ribbon is where you can access various functions related to your Excel file, including saving, printing, and closing the workbook. To close the workbook, you can simply click the Close option in the navigation bar, which will prompt you to save any changes before closing the file. The other options, Home, Review, and View, do not contain the option to close the workbook.

Question 13

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

Accepted Answer

The Print tab is specifically designed for printing purposes and includes all of the necessary options for selecting a printer, number of copies, and print settings. The Selection tab is used to select specific cells or ranges within the worksheet, while the Print Now and Output tabs do not exist in Excel.

Question 14

The default magnification for a workbook is ____, which you can see on the Zoom level button.
A) 0%
B) 80%
C) 90%
D) 100%

Accepted Answer

The default magnification for a workbook is 100%, which can be seen on the Zoom level button. This is the most commonly used and recommended view for working with spreadsheets.

Question 15

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

Accepted Answer

To move to cell A1, Donovan should press the Ctrl+Home keys. This combination of keys will take him to the top left corner of the spreadsheet, which is cell A1. The Page Down key and Page Up key are used to move up and down in the spreadsheet, while the Ctrl+End keys are used to go to the last cell of the spreadsheet.

Question 16

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

Accepted Answer

The Fit selection option button will zoom the worksheet so that the selected range fills the worksheet window, which is what is specified in the question. The other options, such as Zoom selection and Magnification, may be useful in other situations, but are not the best choice based on the given scenario. Full screen may also work, but it will not necessarily zoom in on the selected range, so it is not the best choice.

Question 17

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

Accepted Answer

The Replace command is located under the Editing group on the Home tab of the Ribbon.

Question 18

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.

Accepted Answer

The answer of FIGURE EX 1-1  Referring to Figure...

Question 19

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)

Accepted Answer

The asterisk (*) is the wildcard character used to search for any number of characters in a pattern.

Question 20

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

Accepted Answer

The answer of Case EX 1-1 Nicole has not used...

Quiz 2: Microsoft Excel Basics

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.

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

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

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

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

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

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(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.

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.

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

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

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

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.

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

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

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

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

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: ____.

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.

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