| A | B |
|---|
| When you insert a cell in a column, you force the other cells in the same column to move __________. | Down |
| When you insert a cell in a row, you force the other cells in the same row to the __________. | right |
| What happens when you right-click on a cell? | the shortcut menu displays |
| Use the __________ button in the Cells group on the Home tab to add new cells | Insert |
| Which of the following options are available when you click the Insert command arrow in the Cells group on the Home tab? | insert cells, Insert worksheet rows, insert worhksheet columns, & insert new worksheet |
| When you delete cells in a worksheet, you force other cells to move up or to the __________. | left |
| Which button in the Cells group on the Home tab do you use to remove cells? | Delete |
| Which of the following options are available when you click the Delete command arrow in the Cells group on the Home tab? | delete a cell, delete a row, delete a colum, delete entire worksheet |
| Use the __________ key on the keyboard to keep the cell and remove its contents | delete |
| To __________ means to arrange and align or bring into alignment. | align |
| Which of the following options are available in horizontal alignment? | leftt, right, and center |
| Which of the following options are available in vertical alignment? | top, middle, & Bottom |
| On which of the following locations can you access the Alignment commands? | format cells dialog box & alignment group on the Home tab |
| You must __________ a cell or range of cells before applying formatting. | select |
| To which side of the cell are alphabetic characters or alphabetic characters combined with numbers or symbols aligned by default? | left |
| When you input numbers, they are __________ by default. | right aligned |
| How do you display the shortcut menu that allows you to access the alignment options outside the ribbon? | right click the cell |
| Which command spreads text evenly throughout the cell? | Justify |
| Which command spreads text evenly between the top of the cell and the bottom, separated by blank space? | Distributed |
| On the Home tab in the Alignment group, which button do you click to move the text to the right? | Increase Indent |
| Which keyboard combination can be used to increase indent? | Alt+H+6 |
| Which alignment option allows you to fit long columns or row headings into a small space without changing the font size or column width? | Orientation |
| A __________ is a set of text properties that affect the type face, size, and other stylistic aspects of text. | font |
| On the __________ tab in the Font menu in the Font group, select the desired font to change the selected cells. | Home |
| Which options in the Font group on the Home tab allow you to increase or decrease points? | Font size, Decrease Font Size, & Increase Font Size |
| __________ refer to the measurement of the height of characters in a cell | Points |
| What must you select on the File tab to change the default font used in all new workbooks? | Options |
| Which toolbar is a formatting tool that displays above or below the shortcut menu when you right-click a cell? | Mini |
| Which of the following best describes the use of the Font Color menu? | Color Text |
| Which of the following are special character attributes found in the Font group? | Underline, Bold & Italic |
| To apply highlighting or a background fill color to cells in a worksheet, you would choose __________. | Fill Color |
| Use the tools in the __________ group on the Home tab to apply a wide variety of number formats to the selected cells. | Number |
| In order to apply number formats, just __________ a cell or range of cells and select Format Cells from the shortcut menu. | right-click |
| Which number format displays the default currency symbol with two decimal places? | Currency |
| Which of the following number formats are available in the Number Format menu? | General, Accounting, & Fraction |
| Use the __________ Text button to display text on multiple lines in a cell. | Wrap |
| Combining two or more cells into a single cell is referred to as what? | Merging |
| Which command on the Merge & Center menu do you select to reverse the merging of cells? | Unmerge cells |
| In order to add custom lines around selected cells, which option in the Font group on the Home tab do you select? | Borders |
| You can use the Format Painter to copy and paste which of the following attributes from one cell to another? | font, font color, bolding, & borders |
| Which of the following describes the appearance of the mouse pointer when Format Painter is active? | white plus with paint brush |
| In order to give you special options when you paste cells, Excel displays the __________ Options button on the worksheet by default. | Paste |
| In which group can you find the Paste Special command on the Home tab? | Clipboard |
| Which option on the Paste Special menu pastes only the result of a formula and not the formula itself? | Values |
| In order to quickly enhance your worksheets, you can use the gallery of preset cell __________. | Styles |
| In order to apply a style to the active cell or range, click __________ Styles in the styles group on the Home tab, then choose the style you want. | Cell |
| Which is true when applying styles to different cells within the worksheet? | You can combine styles to achieve the desired effect |
| To create your own custom style, you open the Cell Styles menu and select which of the following options? | New cell style |
| You cannot delete the __________ cell style | Normal |
| Insert a __________ to create a mouse shortcut that takes you to a webpage or a location in another file. | Hyperlink |
| Which of the following provide access to the Hyperlink command? | Insert Tab, Shortcut menu |
| Which command on the shortcut menu can you use to delete a hyperlink from the selected cell? | Remove Hyperlink |
| The Conditional Formatting menu is located in which group on the Home tab? | Styles |
| Use the Excel __________ to have greater control over conditional formatting rules. | Rules Manager |
| Which option on the Conditional Formatting menu provides access to the Conditional Formatting Rules Manager dialog box? | Manage Rules |
| Which option on the Home tab in the Editing group must you click to access and select Clear Formats? | Clear |
| You want to insert a cell into your worksheet. Which command so you use? | The Insert command in the Cells group on the HOME tab |
| You want to format a cell so the text is spread evenly throughout the cell, wrapping automatically and adjusting the row height, if necessary. Which alignment option do you choose? | Justify |
| You want to fit a long column heading into a small space without changing the font size or column width. Which of the following is the best choice | Adjust text orientation. |
| How do you display the Mini toolbar | right click the cell |
| Which of the following can you not copy using Format Painter | Cell Content |
| Which Paste Special option pastes only the result of a formula rather than the formula itself | Values |
| You don’t like the cell style you just applied. Which of the following is the least effective way to remove or replace the style | Clear the cell’s content |
| How do you remove a hyperlink | Right-click the cell and select Remove Hyperlink |
| In which group on the HOME tab is the Clear Formats command located? | In the Editing group |
| Which of the following is not useful for changing the font size? | Orientation button |
| When you delete cells in a worksheet, you remove one or more cells, forcing other cells to move down or to the right | FALSE |
| When selecting a font color, you can choose a themed color but not a standard color from the palette | FALSE |
| When you point to defined styles in the Cell Styles gallery, you can see the formatting that will be used when you apply each style | TRUE |
| Underlining a cell’s content is the same as adding a border. | FALSE |
| You can apply multiple conditional formatting criteria or rules to the same set of data. | TRUE |
| Deleting a cell is the same as clearing a cell’s content | FALSE |
| A hyperlink enables you to navigate to a web page, another file, or to a specific location in another file | TRUE |
| Style attributes include fonts and font sizes, number formats, and borders and shading | TRUE |
| You cannot split a single worksheet cell that has not been merged | TRUE |
| After you select a color and apply it to a cell’s background, the Fill Color button takes on that color. | TRUE |
