Koofers

Final - Flashcards

Flashcard Deck Information

Class:ISM 110 - Business Computing I
Subject:Info Sys and Operations Mngmt
University:University of North Carolina at Greensboro
Term:Fall 2009
- of -
INCORRECT CORRECT
- INCORRECT     - CORRECT     - SKIPPED
Shuffle Remaining Cards Show Definitions First Take Quiz (NEW)
Hide Keyboard shortcuts
Next card
Previous card
Mark correct
Mark incorrect
Flip card
Start Over
Shuffle
      Mode:   CARDS LIST       ? pages   PRINT EXIT
____Should be inserted into a worksheet to explain the purpose of formulas Comments
If the active cell is A1, the cell address A1 displays in the: Name Box
Active commands are displayed in the _____ bar. Status
The ____ command is used to center text within one cell so that it displays appropriately across the content of a worksheet. Merge and Center
Generated by Koofers.com
The words "phall@prenticehall.com" would be treated as what type of data in Excel? text
If a cell contains today's date, the data is treated as: A value
To modify the appearance of a range of cells, utilize commands on the ____ dialog box. Format Cells
Arithmetic operations, cell references, and ___ can be used in Excel formulas. constants
Generated by Koofers.com
The fill handle can be used to copy formulas or finish a(n) _____ series. Text
If you have formula that must always reference columnA but the row needs to adjust as your copy your formula, you want to use a( mixed
values used in calculations in functions are: arguments
If you need to determine how many cells in a range are NOT blank, use the ____ function. COUNTA
Generated by Koofers.com
The ___ function obtains its time and date from the computer's clock. Now
To copy formatting from a cell to a range of cells, use the: Format Painter
When entering the amount of a loan in the PMT function, it should be entered as a(n) ___ number for the result to be positive. Negative
To group and display similar data, use a ___ chart. clustered column
Generated by Koofers.com
The chart to use for displaying trends over a period of time is a ___ chart. line
If researchers wanted to display the relationship between variables in a scientific experiment, they could use a ___ chart. Scatter
change the color of the plot area of a chart by choosing the option ___ form the shortcut menu. format plot area
to control a shape's ____, hold down the shift key while drawing the shape. proportion
Generated by Koofers.com
adding a level to a chart may be accomplished through the format data series- 3-d option
___ fields are used to sort table data. key
the ___ enables you to move to a cell quickly by typing the desired cell references in it and pressing enter. GoTo dialog box
to hide a worksheet, it must be__ active
Generated by Koofers.com
Valid option for file name -they can contain space -they can contain commas -periods are discouraged in filename
the feature that catalogs all media clips is: the clip organizer
if you want transitions to appear with all slides, you should: click apply to all button
Digital storage oscilloscopes, Mars exploration rovers and the Mars Reconnaissance orbiter require a __ operating system real-time
Generated by Koofers.com
the MS-DOS operating system is a: command-driven interface, single-task operating system
Linux is a(n) ___ operating system. open-source
Files are NOT stored in: FAM
A computer virus attaches itself to and attempts to hide within the code of a(n) ___ program. Host
Generated by Koofers.com
___ viruses attach themselves to documents such as Word and Excel. Macro
___ are viruses that are triggered by the passage of time or on a certain date. time bombs
unlike other viruses, ___ are viruses that can run independently of host file execution and are much more active in spreading th worms
the ___ collects scattered pieces of files on the hard drive and rearranges them sequentially on the hard drive disk defragmenter
Generated by Koofers.com
the page number command is in the ___ group header and footer
you need to view the changes your boss made to a document. what tool do you use? show markup/reviwer
Generated by Koofers.com

List View: Terms & Definitions

  Hide All 38 Print
 
Front
Back
 ____Should be inserted into a worksheet to explain the purpose of formulasComments
 If the active cell is A1, the cell address A1 displays in the:Name Box
 Active commands are displayed in the _____ bar.Status
 The ____ command is used to center text within one cell so that it displays appropriately across the content of a worksheet.Merge and Center
 The words "phall@prenticehall.com" would be treated as what type of data in Excel?text
 If a cell contains today's date, the data is treated as:A value
 To modify the appearance of a range of cells, utilize commands on the ____ dialog box.Format Cells
 Arithmetic operations, cell references, and ___ can be used in Excel formulas.constants
 The fill handle can be used to copy formulas or finish a(n) _____ series.Text
 If you have formula that must always reference columnA but the row needs to adjust as your copy your formula, you want to use a(mixed
 values used in calculations in functions are:arguments
 If you need to determine how many cells in a range are NOT blank, use the ____ function.COUNTA
 The ___ function obtains its time and date from the computer's clock.Now
 To copy formatting from a cell to a range of cells, use the:Format Painter
 When entering the amount of a loan in the PMT function, it should be entered as a(n) ___ number for the result to be positive.Negative
 To group and display similar data, use a ___ chart.clustered column
 The chart to use for displaying trends over a period of time is a ___ chart.line
 If researchers wanted to display the relationship between variables in a scientific experiment, they could use a ___ chart.Scatter
 change the color of the plot area of a chart by choosing the option ___ form the shortcut menu.format plot area
 to control a shape's ____, hold down the shift key while drawing the shape.proportion
 adding a level to a chart may be accomplished through theformat data series- 3-d option
 ___ fields are used to sort table data.key
 the ___ enables you to move to a cell quickly by typing the desired cell references in it and pressing enter.GoTo dialog box
 to hide a worksheet, it must be__active
 Valid option for file name-they can contain space
-they can contain commas
-periods are discouraged in filename
 the feature that catalogs all media clips is:the clip organizer
 if you want transitions to appear with all slides, you should:click apply to all button
 Digital storage oscilloscopes, Mars exploration rovers and the Mars Reconnaissance orbiter require a __ operating systemreal-time
 the MS-DOS operating system is a:command-driven interface, single-task operating system
 Linux is a(n) ___ operating system.open-source
 Files are NOT stored in:FAM
 A computer virus attaches itself to and attempts to hide within the code of a(n) ___ program.Host
 ___ viruses attach themselves to documents such as Word and Excel.Macro
 ___ are viruses that are triggered by the passage of time or on a certain date.time bombs
 unlike other viruses, ___ are viruses that can run independently of host file execution and are much more active in spreading thworms
 the ___ collects scattered pieces of files on the hard drive and rearranges them sequentially on the hard drivedisk defragmenter
 the page number command is in the ___ groupheader and footer
 you need to view the changes your boss made to a document. what tool do you use?show markup/reviwer