Q&A Hero

Q: The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate. a. Seek b. Find c. Locate d. Search

Q: Case 2-1 Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges. a. selective b. nonadjacent c. consecutive d. specific

Q: Case 2-2 Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. Because Antoinette is familiar with conditional formatting, she can use the _____, which provides access to the most common tools for data analysis and formatting. a. Quick Tool Bar b. Quick Analysis Tool c. Quick Formatting Bar d. Conditional Analysis Tool

Q: A(n) ____________________ is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook.

Q: Ten ____________________ colorsdark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purpleare always available regardless of the workbooks theme.

Q: Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.

Q: One way to align text over several columns or rows is to ____________________, or combine, several cells into one cell.

Q: Setting the _____ to A1:L10 will print only data in those cells. a. Page Format b. Print Area c. Page Break d. Print Preview

Q: The ____________________ tab in the Format Cells dialog box in Excel provides options for how data is aligned within a cell.

Q: To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point. a. page insert b. manual page break c. print area d. selection

Q: To set a page break in Excel, select the _____. a. first cell below the row where you want to insert a page break b. first cell above the row where you want to insert a page break c. row above where you want to insert a page break d. row below where you want to insert a page break

Q: A _____ indicates a manual page break. a. dashed blue line b. solid blue line c. dashed red line d. solid red line

Q: _____ merges each of the rows in the selected range across the columns in the range. a. Merge Build b. Merge and Center c. Merge Across d. Merge Cells

Q: Calculated values too large to fit into the cell are displayed in scientific notation. _________________________

Q: In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell. a. A1!E1! b. A1 c. E1 d. A1-E1

Q: Text and numbers are displayed vertically within cells. _________________________

Q: Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab. a. Format b. Orientation c. Sorter d. Alignment

Q: A theme is a collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders. _________________________

Q: The Format Cells dialog box has six tabs, including _____. a. Decimals b. Security c. Border d. Shading

Q: A conditional format applies formatting to a cell when its value meets a specified condition. _________________________

Q: In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays. a. Number b. Font c. Alignment d. Fill

Q: A footer appears at the top of each printed page. _________________________

Q: You can open the Format Cells dialog box by right-clicking a cell or selected range, and then clicking _____ on the shortcut menu. a. Format b. Cells c. Format Cells d. Cells Style

Q: If you want to print only part of a worksheet, you can set a print area, which is the region of the worksheet that is sent to the printer. _________________________

Q: When using the Format Painter, double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____. a. turn it on b. turn it off c. copy formatting d. paste formatting

Q: One of the benefits of Live Preview is that it _____. a. lets you see and evaluate different formats as you develop your workbook b. shows you what a document will look like when printed c. applies thematic styles to your document d. allows you to track changes in your document

Q: Put the following five steps in the order in which you would perform them to use the Paste Special function. 1. Select and copy a range. 2. Click the Paste button arrow in the Clipboard group on the HOME Tab. 3. Specify exactly what you want to paste. 4. Click Paste Special to open the dialog box. 5. Select the range where you want to paste the Clipboard contents. a. 1, 2, 4, 3, 5 b. 1, 2, 4, 5, 3 c. 1, 5, 2, 4, 3 d. 1, 5, 2, 3, 4

Q: Italic, bold, bold italic, and underline are examples of _____. a. font themes b. font styles c. graphics d. character settings

Q: _____ are an example of conditional formats in Excel. a. Data bars b. Quick Analysis tools c. Font sets d. Percentages

Q: In a workbooks theme, _____ colors are designated for text and background, _____ colors are used for accents and highlights, and _____ colors are used for hyperlinks. a. Four, two, six b. Two, four, six c. Four, six, two d. Six, four, two

Q: A _____ is the space between the page content and the edges of the page. a. margin b. border c. frame d. ruler

Q: To add a _____ to a sheet tab, right-click a sheet tab, point to Tab Color on the shortcut menu, and then click a color. a. fill color b. tab setting c. format color d. formatting style

Q: One way to ensure that you are using consistent formats is to copy and paste your formats using the Format _____. a. Master b. Gallery c. Palette d. Painter

Q: When creating an Excel document, you should avoid using _____ text and background together, since this is the most common form of color blindness. a. red and green b. yellow and blue c. black and white d. red and yellow

Q: Fonts, colors, and cell styles are organized in _____ categories. a. theme and non-theme b. numbers and text c. color and black and white d. form and function

Q: By default, numbers appear in the _____ and generally display values exactly as you type them. a. Home tab b. General format c. General number toolbar d. currency format

Q: Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value. a. numbers b. text c. universal numbers d. Greenwich Mean Time

Q: In Excel, dates are _____-aligned in the cell by default, regardless of date format. a. right b. left c. center d. top

Q: As a general rule, you should _____. a. center column titles, left-align text, and right-align numbers b. center column titles, right-align text, and left-align numbers c. right-align column titles, left-align text, and right-align numbers d. left-align column titles, left-align text, and right-align numbers

Q: The background image does not affect any cells format or content. _________________________

Q: A(n) ____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.

Q: ____________________ removes the data from the row or column as well as removes the row or column itself.

Q: Formatting changes only the appearance of datait does not affect the data itself. _________________________ a. True b. False

Q: Changing the number of decimal places displayed in a cell does not change the value stored in the cell. _________________________ a. True b. False

Q: The Format Painter does not copy formatting applied to selected text within a cell, and it does not copy data. _________________________ a. True b. False

Q: The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook. _________________________ a. True b. False

Q: Conditional formats are dynamic, so a cells appearance will change to reflect its current value. _________________________ a. True b. False

Q: A conditional format can make negative numbers red and positive numbers black. _________________________ a. True b. False

Q: Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line. _________________________ a. True b. False

Q: Each header and footer has three sectionsa left section, a center section, and a right section. _________________________ a. True b. False

Q: By default, Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margin. _________________________ a. True b. False

Q: Excel organizes fonts into theme and non-theme fonts. _________________________

Q: The cell reference for the merged cell is the upper-right cell reference. _________________________

Q: By default, Excel displays text in a black font color. _________________________

Q: You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page. a. shrink b. size c. scale d. scroll

Q: The ____________________ function will not include any cell in the range containing a non-numeric value in the final tally.

Q: According to the order of operation in Excel: a. Excel performs exponentiation, then multiplication and division, then addition, and subtraction. b. Excel performs multiplication, then exponentiation, then division, then addition, and then subtraction. c. Excel performs exponentiation, then multiplication, then division, then subtraction, and then addition. d. Excel performs multiplication, then division, then exponentiation, then addition, and then subtraction.

Q: To move the active cell up one row, press ____. a. Shift + Enter b. Ctrl + Tab c. Shift + Tab d. Ctrl + Enter

Q: Which of the following will not change the location of the active cell? a. drag and drop b. scrolling c. clicking another cell d. clicking a column heading

Q: When you copy a selection of cells using drag and drop, which appears before you release the mouse button? a. an outline of the new location of the selected range b. the range c. a cell reference of the old location d. shortcut tip

Q: What is the syntax for a SUM formula adding the values of cell F6 to F9? a. /SUM(F9:F6) b. =SUM(F6/F9) c. =END(F6:F9) d. =SUM(F6:F9)

Q: Ctrl + G is used to access the ____. a. Go to Next worksheet command b. G column c. Go to a location in the worksheet command d. formula view

Q: To change the order of operations, enclose part of the formula in ____. a. brackets b. italics c. parentheses d. quotation marks

Q: mm/dd/yyyy is known as ____. a. a text string b. text data c. a date format d. number data

Q: Keyboard ____________________ can help you work faster and more efficiently because you can keep your hands on the keyboard.

Q: Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet. a. color coding b. bolding c. highlighting d. italicizing

Q: Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys, the workbook file is updated to reflect the latest content. a. Ctrl + V b. Ctrl + G c. Ctrl + C d. Ctrl + S

Q: To switch to ____ mode, you double-click the cell. a. Insert b. Copy c. Edit d. Paste

Q: To move or copy a range of cells, select the correct order: 1. Move the pointer over the border of the selection until the pointer changes shape. 2. Select the cell or range you want to move or copy. 3. To move the range, click the border and drag the selection to a new location, or to copy the range, hold down the Ctrl key and drag the selection to a new location. a. 1,2,3 b. 3,2,1 c. 1,3,2 d. 2,1,3

Q: To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column. a. QuickFit b. AutoFit c. Full Column d. Longest

Q: A(n) ____________________ is a grouping of text and numbers in a rectangular grid or table.

Q: ____ makes it easier to enter repetitive text in cells. a. Editing mode b. AutoFit c. AutoComplete d. AutoFill

Q: The active cell is highlighted with a thick green border, its cell reference appears in the ____________________, and the corresponding column and row headings are highlighted.

Q: Which of the following takes precedence over multiplication? a. division b. exponentiation c. addition d. subtraction

Q: The range reference for a(n) ____________________ range includes the range reference to each range, separated by a semicolon.

Q: ____ enters text based on patterns it finds in the data. a. AutoComplete b. Flash Fill c. AutoFit d. Fill

Q: When you ____________________ a workbook, a dialog box might open, asking whether you want to save the workbook.

Q: In ____ orientation, a page is taller than it is wide. a. natural b. landscape c. portrait d. basic

Q: A(n) ____________________ is a named operation that replaces the arithmetic expression in a formula.

Q: ____ displays the location of the different page breaks within the worksheet. a. Normal b. Page Preview c. Page Break Preview d. Page Break Layout