Q&A Hero

Software Design & Engineering

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: 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: 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: 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. _________________________
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
1 2 3 … 7

Subjects

Accounting Anthropology Archaeology Art History Banking Biology & Life Science Business Business Communication Business Development Business Ethics Business Law Chemistry Communication Computer Science Counseling Criminal Law Curriculum & Instruction Design Earth Science Economic Education Engineering Finance History & Theory Humanities Human Resource International Business Investments & Securities Journalism Law Management Marketing Medicine Medicine & Health Science Nursing Philosophy Physic Psychology Real Estate Science Social Science Sociology Special Education Speech Visual Arts