Chapter 2
Using a KO command, complete the following statement with regards to editing data in a cell. To open an activated cell and change data that was previously entered, tap the ----- key on your keyboard.
F2
(Label each of the following as true or false with respect to adjusting column widths and row heights) Click any cell in a column or row and use the Width and Height buttons in the Page Layout tab of the Ribbon.
False
Fill Handle is?
A small square in the lower right corner of an activated cell. When the mouse pointer gets close to the Fill Handle, the white block plus sign turns into a black plus sign
Column Width tip box is the?
Box that appears when the width of a column is being adjusted using the click and drag method; displays the number of characters that will fit into the column using the Calibri 11-point font.
Borders are?
Lines that are added to a worksheet to separate the data in columns and rows
Group of commands used to combine several small locations into one larger cell location
Merge Cells
When using the Insert Sheet Columns command, a blank column will be inserted to the------ of the activated cell
left
Complete the following statement with regards to centering a title on a worksheet. The ---- & ----- command can be used to center a title over all of the columns used on a worksheet.
merge and center
When conducting a data audit, the sum of the values in a column of data can be found in the ------- after highlighting all the values in the column.
status bar
Select all items that are true with respect to formatting worksheet tabs. a. The color of a worksheet tab can be changed by opening the worksheet, clicking the Fill Color command in the Home tab of the Ribbon, and then selecting a color from the color palette. b. A worksheet tab label can be changed by selecting the Rename Sheet command after clicking the Format button in the Home tab of the Ribbon. c. The color of a worksheet tab cannot be changed. d. The label on a worksheet tab can be changed by double clicking it. e. The color of a worksheet tab can be changed by selecting Tab Color after clicking the Format button in the Home tab of the Ribbon and then selecting a color from the color palette.
b. A worksheet tab label can be changed by selecting the Rename Sheet command after clicking the Format button in the Home tab of the Ribbon. d. The label on a worksheet tab can be changed by double clicking it. e. The color of a worksheet tab can be changed by selecting Tab Color after clicking the Format button in the Home tab of the Ribbon and then selecting a color from the color palette.
Which of the following is true with regards to the Accounting Number Format? Select all that apply. a. Decimal places must be added. b. It will format values with two decimal places for cents. c. The dollar sign $ appears on the command button. d. Currency symbols are left justified in the cell. e. It will only display values in U.S. currency.
b. It will format values with two decimal places for cents. c. The dollar sign $ appears on the command button. d. Currency symbols are left justified in the cell.
Which of the following is true when working with a dataset that was provided by another person? Select all that apply. a. Use the column headings to make a "best guess" to define the data before using it for a project. b. Obtain clear definitions and identify the purpose for all columns of data in the dataset. c. Since the data came from another person, the data audit can be skipped. d. Conduct a Data Audit before working with the data.
b. Obtain clear definitions and identify the purpose for all columns of data in the dataset. d. Conduct a Data Audit before working with the data.
Which of the following will enable you to identify hidden columns in a worksheet? a. Click the Hidden Columns indicator in the Status Bar. b. Clicking the Page Layout View button in the View tab of the Ribbon shows all columns in the worksheet and shades hidden columns. c. The column letters that appear above the columns in a worksheet will be missing for hidden columns. d. The column letter appears in a tip box when the mouse pointer is moved over a hidden column.
c. The column letters that appear above the columns in a worksheet will be missing for hidden columns.
Which of the following is most accurate with respect to the Wrap Text command? a. It allows you to designate which words are placed on a second line of a cell location. b. It converts any numeric data to text data. c. It can be accessed only through the right-click menu of options. d. It reduces the need to expand the width of the columns in a worksheet.
d. It reduces the need to expand the width of the columns in a worksheet
When the mouse pointer changes to cross arrows when dragged to the edge of a highlighted range of cells, it indicates that:
the highlighted range can be moved by clicking and dragging
Command used to stack long data entries vertically in a cell?
wrap text
Complete the missing item in the statement below pertaining to data entry. The ---- command is used to vertically stack long non-numeric data entries in a cell.
wrap text
Which of the following will help make the most efficient use of horizontal space on a worksheet during the design process by maximizing the number of visible columns on one screen?
wrap text
Formula Bar is?
The area just above the column letters on a worksheet; can be used for entering data into cells as well as editing data that already exists in cells
In the image below, why has the mouse pointer changed to a black plus sign?
The mouse pointer has been placed over the Fill Handle
Indicate which of the following methods can be used to delete data in a worksheet
ALT H E C, the Fill Handle, and the DELETE key
Using a KO command, complete the following statement with regards to the Wrap Text command. Activate the desired cell and apply the Wrap Text command by tapping the -----key and then tap the --- and ---- keys on your keyboard one at a time.
ALT H W
Using a KO command, complete the following statement with regards to formatting values. To increase the decimal places shown for values entered into a range of cells, tap the---- key and then tap the ---- and ---- keys on your keyboard one at a time.
ALT H and 0
Using a KO command, complete the following statement with regards to formatting values. To reduce the decimal places shown for values entered into a range of cells, tap the ----- key and then tap the --- and ---- keys on your keyboard one at a time.
ALT H and 9
Using a KO command, complete the following statement with regards to the Center Alignment command. After the desired cell is activated, apply the Center command by tapping the ----- key and then tap the ----, ----, and ---- keys on your keyboard one at a time.
ALT H, A, and C
Using a KO command, complete the following statement with regards to the Right Align command. Activate the desired cell and then apply the Right Align command by tapping the ----- key and then tap the ---, ----, and ---- keys on your keyboard one at a time.
ALT H, A, and R
Using a KO command, complete the following statement with regards to deleting columns. After activating a cell in a desired column, the column can be deleted by tapping the ---- key and then tapping the ---, ----, and ---- keys on your keyboard.
ALT H, D, and C
Using a KO command, complete the following statement with regards to deleting rows. To delete a row, tap the ---- key and then tap the ----, ----, and ---- keys one at a time.
ALT H, D, and R
Using a KO command, complete the following statement with regards to deleting a worksheet. To delete a worksheet, tap the ---- key and then tap the ---, ----, and ---- keys one at a time.
ALT H, D, and S
Using a KO command, complete the following statement with regards to inserting rows. To insert a row, tap the---- key and then tap the ---, ----, and ---- keys one at a time.
ALT H, I, and R
Using a KO command, complete the following statement with regards to adjusting row heights. After activating a cell in a row to be adjusted, tap the ---- key and then tap the ----, ----, and ----- keys on your keyboard one at a time. Then, type the desired width in the Row Height dialog box and tap the ----- key on your keyboard.
ALT H, O, and H enter
Complete the following statement with regards to entering multiple lines of text into a cell location. If typing a mailing address into a cell location, the city, state, and zip code can be added to a second line in the cell by holding the --- key and tapping the --- key.
ALT enter
Using a KO command, complete the following statement with regards to hiding columns. After activating a cell in a desired column, the column can be hidden by holding the ----- key and tapping the number ---- on your keyboard.
CTRL 0
Using a KO command, complete the following statement with regards to formatting. To apply the bold font to an activated cell, hold the ---- key and tap the --- key on your keyboard.
CTRL B
Using a KO command, complete the following statement with regards to copying data. To copy a cell or range of cells on a worksheet, hold the -----key and tap the ----- key on your keyboard.
CTRL C
Using a KO command, complete the following statement with regards to formatting. To apply the italics font to an activated cell, hold the ---- key and tap the ---- key on your keyboard.
CTRL I
Using a KO command, complete the following statement with regards to formatting values. To format numbers in a highlighted range of cells with commas and two decimal places, hold the ---- key, hold the ----- key, and tap the number ---- key on your keyboard.
CTRL SHIFT 1
Using a KO command, complete the following statement with regards to formatting values. To format numbers in a highlighted range of cells to the U.S. currency format, hold the --- key, hold the ---- key, and tap the number ---- key on your keyboard.
CTRL SHIFT 4
Using a KO command, complete the following statement with regards to formatting. To underline data entered into an activated cell, hold the ---- key and tap the ---- key on your keyboard.
CTRL U
Using a KO command, complete the following statement with regards to pasting data. After a cell or range of cells have been copied on a worksheet, the data can be pasted by holding the ----- key and tapping the ----key on your keyboard.
CTRL V
Using a KO command, complete the following statement with regards to cutting data. After a cell or range of cells have been highlighted, to cut the data hold the ----- key and tap the -----key on your keyboard.
CTRL X
Using a KO command, complete the following statement with regards to the Undo command. The Undo command can be activated by holding the ----- key and tapping the ----- key on your keyboard.
CTRL Z
The Auto Fill is an?
Excel feature used to complete data in either a quantitative or qualitative sequence; can also be used to copy and paste data on a worksheet
If a worksheet that contains data is deleted, the Undo command can be used to restore the worksheet if necessary. True or False?
False
What is the most efficient way to center a title over six columns of data?
Highlight the six cell locations over each of the columns and click the Merge & Center button in the Home tab of the Ribbon
An Excel worksheet is being used to record employee data for a small company. The mailing address for each employee will be entered into the first five cells of each row beginning in column A. The range A1:E25 has been highlighted. Which of the following is the most appropriate command to use for this project?
Merge Across
(Label each of the following as true or false with respect to adjusting column widths and row heights) Highlight any cells in a number of columns or rows and use the Format button in the Home tab of the Ribbon.
True
(Label each of the following as true or false with respect to adjusting column widths and row heights) Place the mouse pointer between two row numbers or two column letters, then click and drag.
True
Which of the following can be use to duplicate data on a worksheet? Select all that apply. a. ALT H C C and ALT H V P b. CTRL C and CTRL V c. Auto Fill d. Copy and Paste Commands
a. ALT H C C and ALT H V P b. CTRL C and CTRL V c. Auto Fill d. Copy and Paste Commands
Which of the following statements is FALSE with respect to inserting and deleting worksheets? a. After deleting a worksheet, you can use the Undo command to bring it back. b. The Delete button in the Home tab of the Ribbon contains a command to delete worksheets from a workbook. c. The Insert button in the Home tab of the Ribbon is where you can find a command to add a new worksheet to a workbook. d. The F11 key on your keyboard can be used to add a new worksheet to a workbook.
a. After deleting a worksheet, you can use the Undo command to bring it back
Which of the following will allow you to add the Bold format to the data entered into a cell or range of cells on a worksheet? a. All of the above will work in applying the Bold format. b. Hold the CTRL key on your keyboard and tap the number 2 key. c. Tap the ALT key on your keyboard and then tap the H key followed by the number 1 key. d. Hold the CTRL key on your keyboard and tap the B key.
a. All of the above will work in applying the Bold format.
Which of the following is true with respect to inserting blank rows into a worksheet? a. Blank rows are inserted above the activated cell or cell range in a worksheet. b. When inserting blank rows into a worksheet, the Undo button is disabled. You must use the Delete button in the Home tab of the Ribbon to remove unwanted blank rows. c. The command for inserting blank rows and columns can be found by clicking the Format button in the Home tab of the Ribbon. d. Rows are always inserted in the center of a cell range. At least two or more cells in a worksheet must be highlighted before a row can be inserted.
a. Blank rows are inserted above the activated cell or cell range in a worksheet
If you wanted to enter a person's address into a cell location such that the street address is on one line and the city, state, and zip code are on a second line, you would do which of the following? a. Type the street address first. Then hold the ALT key on your keyboard and tap the ENTER key, and type the city, state, and zip code. b. None of the above. You cannot enter multiple lines of text into a cell location. c. Type the street address first, then tap the ENTER key and type the city, state, and zip code. d. Type all the data into the cell location and click the Wrap Text command in the Home tab of the Ribbon.
a. Type the street address first. Then hold the ALT key on your keyboard and tap the ENTER key, and type the city, state, and zip code
When using the Insert Sheet Rows command, a row will be inserted ----- the activated cell
above
(Label each of the following as true or false with respect to adjusting column widths and row heights) Click any cell in a row or column and access the Right-Click menu.
false
Which command is used to change the color of the cells on a worksheet?
fill color command
If you are formatting currency values on a worksheet and do NOT want to use the Accounting Number Format, what dialog box should be opened?
format cells
The column letter sequence at the top of the worksheet is as follows: A, B, D, E. This indicates that column C has been?
hidden
The row numbers along the left side of the worksheet are observed as follows: 1, 2, 3, 5, 6. This indicates that row 4 is?
hidden
sing a KO command, complete the following statement with regards to showing hidden columns. First, ----- cells on either side of the columns that are hidden. Tap the ----- key, and then tap the ---, ----, -----, and ----- keys one at a time.
highlight ALT H, O, U, and L
To hide or unhide a column or row, click the ----- tab of the Ribbon and then click the ----- button.
home format
When entering numeric data into an Excel worksheet, you should omit any symbols such as commas or dollar signs because:
it slows down the data entry process