Shared Flashcard Set

Details

ACC BLACKBOARD excel chapter 2 practice test
compilation of questions i got on the bb practice test
21
Other
Not Applicable
03/10/2011

Additional Other Flashcards

 


 

Cards

Term

 

To instruct Excel to display a hidden column, position the mouse pointer to the ____.
Definition
right of the column heading boundary where the hidden column is located and then drag to the right
Term
Which buttons in the Spelling dialog box will not change the spelling of the word?
Definition
Ignore Once

 

  
Ignore All
Term
To save a previously saved workbook with a new name or on a different drive, ____.
Definition
click the Save button on the Quick Access Toolbar
Term
To start a new line in a cell, press ____ after each line, except for the last line, which is completed by clicking the Enter box, pressing the ENTER key, or pressing one of the arrow keys.
Definition
ALT+ENTER
Term
The ____________________ of a worksheet is the version that shows the actual formulas entered, rather than the resulting values.
Definition
Formulas Version
Term
Excel places a small purple triangle, called a(n) ____________________, in a cell to indicate that a smart tag is available.
Definition
smart tag indicator
Term
When a workbook is sent as an attachment to an e-mail, the recipient can double-click the attachment to open it in Excel, or save it on disk and then open it at a later time.
Definition
True
Term
Excel does not allow the contents of a cell to be aligned vertically
Definition
False
Term
To import data stored on a Web site use a ____.
Definition
Web query
Term
Most Excel specialists who build Web queries use the worksheet returned from the Web query as an engine to supply data to another ____ in the workbook.
Definition
worksheet
Term
A smart tag indicator is a block plus sign located in the center of the cell.
Definition
False
Term
____________________ is the process of finding and correcting errors in a worksheet.
Definition
Debugging
Term
If you want to increase or decrease column width significantly, you can right-click a column heading and then use the ____ command on the shortcut menu to change the column’s width.
Definition
Column Width
Term
When an error occurs in a formula in a cell, Excel displays the ____ button next to the cell and identifies the cell with the error by placing a green triangle in the upper left of the cell.
Definition
Trace Error
Term
To toggle between the values version and the formulas version of a worksheet, hold down the ____ key.
Definition

 

CTRL key while pressing the ACCENT MARK (`)
Term
Regardless of the length and complexity of a formula, using Point mode to enter formulas always is slower and less accurate than using the keyboard.
Definition
False
Term

 

Modified Multiple Choice


Using arithmetic operation, the formula, =d4*e4, is the same as which formulas?
Definition

 

=D4 * E4
=d4 * e4
Term
A character is a dot on the screen that contains a color.
Definition
False
Term
Which view allows you to create or modify a worksheet while viewing how it will look in printed format.
Definition

 

Page Layout View
Term
Cell references in formulas must be entered in uppercase, and spaces cannot be added before or after arithmetic operators.
Definition
False
Supporting users have an ad free experience!