+0
Karma
| Class: | ISM 110 - Business Computing I |
| Subject: | Info Sys and Operations Mngmt |
| University: | University of North Carolina at Greensboro |
| Term: | Fall 2009 |
INCORRECT
CORRECT

|
____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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Koofers.com
Front |
Back |
|
|---|---|---|
| ____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 | |
| 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 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 | |
| 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 | |
| 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 th | worms | |
| the ___ collects scattered pieces of files on the hard drive and rearranges them sequentially on the hard drive | disk defragmenter | |
| 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 |
© Copyright 2012 , Koofers, Inc. All rights reserved.
The information provided on this site is protected by U.S. and International copyright law, and other applicable intellectual property laws, including laws covering data access and data compilations. This information is provided exclusively for the personal and academic use of students, instructors and other university personnel. Use of this information for any commercial purpose, or by any commercial entity, is expressly prohibited. This information may not, under any circumstances, be copied, modified, reused, or incorporated into any derivative works or compilations, without the prior written approval of Koofers, Inc.