Q&A Hero

Computer Science

Q: mm/dd/yyyy is known as ____. a. a text string b. text data c. a date format d. number data
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: 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: 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. _________________________
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
1 2 3 … 99

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