Q&A Hero

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

Q: A(n) ____________________ of the original range is placed in the new location without removing the original range from the worksheet.

Q: When text wraps within a cell, the column width increases so that all of the text within the cell is displayed. _________________________

Q: The characters +, -, *, and / are examples of ____. a. formulas b. values c. arithmetic operators d. calculations

Q: A formula is written using operands that combine different values, resulting in a single value that is then displayed in the cell. _________________________

Q: An Excel formula always begins with a(n) ____. a. parentheses b. equals sign c. plus sign d. colon

Q: Every function follows a set of rules, or syntax, which specifies how the function should be written. _________________________

Q: The formula used to multiply cell A1 by cell C1 is ____. a. =A1*C1 b. C1*A1 c. =A1/C1 d. A1*C1

Q: Cutting moves the selected content, whereas copying duplicates the selected content. _________________________

Q: A(n) ____ is a group of cells in a rectangular block. a. cluster b. adjunct c. selection d. range

Q: When you insert a new row, the existing rows are shifted down and the new row has the same width as the row above it. _________________________

Q: When you insert a new column, the existing columns are shifted to the ____ and the new column has the same width as the column directly to its left a. right b. up c. down d. left

Q: In the formula, =2+6*2, addition would be calculated after multiplication. _________________________

Q: If you want to create a new line within a cell, press the ____ keys to move the insertion point to the next line within the cell. a. Ctrl + Enter b. Alt + Enter c. Alt + E d. Ctrl + E

Q: Normal view shows how the worksheet will appear when printed. _________________________

Q: What is the result of the expression =50+20/10*5? a. 60 b. 1 c. 25 d. 50

Q: The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions. a. database b. spreadsheet c. expression d. formula

Q: In ____, the ribbon increases in height, the buttons are bigger, and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need. a. Touch Mode b. Click Mode c. Tap Mode d. Normal Mode

Q: AZ is an example of a ____. a. column heading b. row heading c. cell reference d. Name box

Q: To go to column A of the current row, press ____. a. Ctrl + Home b. Home c. Shift + Tab d. Tab + Enter

Q: An Excel worksheet can have a maximum of ____ columns in a worksheet. a. 156 b. 256 c. 16,384 d. 17 million

Q: To make A1 the active cell, you should press which of the following keys? a. Page Up b. Page Down c. Home d. Ctrl + Home

Q: A keyboard shortcut is a key or combination of keys that you press to access a feature or perform a command. _________________________

Q: You can move to the previous or next sheet by pressing the ____ keys. a. Alt + Page Up or Alt + Page Down b. Ctrl + Page Up or Ctrl + Page Down c. Tab + Page Up or Tab + Page Down d. F4 + Page Up or F4 + Page Down

Q: A common business practice is to include a worksheet named Documentation that contains a description of the workbook, the name of the person who prepared the workbook, and the date it was created. _________________________

Q: Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____. a. semi-colon b. period c. colon d. comma

Q: The name of the active workbook appears in the status bar of the Excel window. _________________________ a. True b. False

Q: The formula bar displays the value or formula of the active cell. _________________________ a. True b. False

Q: The sheets in a workbook are identified in the sheet tabs at the top of the workbook window. _________________________ a. True b. False

Q: The AutoComplete feature automatically completes an entry based on previous entries in a column. _________________________ a. True b. False

Q: A ScreenTip is a box with descriptive text about a command that appears when you point to a button on the ribbon. _________________________ a. True b. False

Q: Speed Fill enters text based on patterns it finds in the data. _________________________ a. True b. False

Q: The worksheet is organized into individual cells. _________________________ a. True b. False

Q: An adjacent range is a collection of separate ranges. _________________________ a. True b. False

Q: Numeric data is any number that can be used in a mathematical calculation. _________________________ a. True b. False

Q: AutoFit changes the column width or row height to display the longest or tallest entry within the column or row. _________________________ a. True b. False

Q: Column width is expressed in terms of the number of characters a column can contain or the size of the column in points. _________________________