Shared Flashcard Set

Details

Microsoft Excel
Microsoft Excel Test (tutorial 8,9,10)
35
Computer Science
Undergraduate 2
12/07/2012

Additional Computer Science Flashcards

 


 

Cards

Term
For cell and range names, names of 25 to 50 characters are considered practical, although names can be up to 255 characters.
Definition
FALSE
Term
Defined names are automatically substituted for the cell addresses in a formula.
Definition
TRUE
Term
Each cell can have at most three validation rules.
Definition
FALSE
Term
The frequency of error alert determines what choices the user is presented with when an invalid entry is attempted.
Definition
TRUE
Term
You cannot prevent users from changing all of the formulas in a worksheet.
Definition
False
Term
You can keep users from deleting worksheets or inserting new ones.
Definition
TRUE
Term
Even when the worksheet is unprotected, the locked property determines whether or not changes can be made to a given cell.
Definition
False
Term
Once you protect a worksheet, the locked property is enabled and controls whether or not a cell can be edited.
Definition
True
Term
Data validation can verify data that was entered into a worksheet before the validation criteria were applied.
Definition
True
Term
You can allow users to insert new rows or columns into a sheet, even if the sheet is protected.
Definition
True
Term
Even if a sheet is protected, you can limit the user to selecting only unlocked cells, or allow the user to select any cell in the worksheet.
Definition
True
Term
Each macro must have a unique name.
Definition
True
Term
By default, a macro will select the same cells regardless of which cell is first selected because the macro records a selection using relative cell references.
Definition
False
Term
When you open a file with macros, the response you see is based on the security level set on the computer.
Definition
True
Term
When the Ribbon is minimized, only the Quick Access Toolbar and the tab names are displayed.
Definition
True
Term
Applications typically include an interface to assist the user in using the system, ranging from special buttons that assist in existing specific tasks to changing the entire Excel interface with customized ____.
a.
commands
c.
toolbars
b.
menus
d.
all of the above
Definition
d.
all of the above
Term
The following is a valid function name: ____.
a.
FY2010
c.
Net-Income
b.
Print_Area
d.
none of the above
Definition
d.
none of the above
Term
Range names must begin with ____.
a.
a letter
c.
a number
b.
the underscore character
d.
either a. or b.
Definition
d.
either a. or b.
Term
If your data is organized in a tabular format, you can quickly create range names for each column or row in the list by using the ____ dialog box.
a.
Make from Table
c.
Create from Selection
b.
Name
d.
Assign
Definition
c.
Create from Selection
Term
An input message appears when the cell becomes active, and can be used to specify the ____ of data the user should enter in that cell.
a.
aspect
c.
format
b.
type
d.
cast
Definition
b.
type
Term
Using the Excel data validation feature, you can specify a(n) ____ of acceptable values.
a.
roster
c.
array
b.
series
d.
range
Definition
d.
range
Term
7. In the Allow list box in the Data Validation dialog box, the ____ option means that the cell will accept only integers.
a.
Integer
c.
Numerical
b.
Decimal
d.
Whole Number
Definition
a.
Integer
Term
In the Allow list box in the Data Validation dialog box, the ____ option means that the validation rule will be based on an Excel logical formula.
a.
Rule
c.
Custom
b.
Logical
d.
Validation
Definition
c.
Custom
Term
Sometimes when you build a worksheet for other users, you may decide to add a(n) ____ message to a cell even if you don't validate the data in that cell.
a.
value
c.
key
b.
input
d.
user
Definition
b.
input
Term
One way of reducing the chance of data-entry error is to display a(n) ____ message when a user clicks on the cell.
a.
value
c.
key
b.
input
d.
user
Definition
b.
input
Term
Excel supports ____ types of error alerts.
a.
two
c.
six
b.
three
d.
eleven
Definition
b.
three
Term
The most serious error alert is the ____ alert.
a.
Warning
c.
Security
b.
Information
d.
Stop
Definition
d.
Stop
Term
The least severe error alert is the ____ alert.
a.
Stop
c.
Information
b.
Security
d.
Warning
Definition
c.
Information
Term
Every cell in a workbook has a(n) ____ property that determines whether or not changes can be made to that cell.
a.
ensured
c.
security
b.
locked
d.
changeable
Definition
b.
locked
Term
Protecting the ____ prohibits users from renaming, deleting, hiding, or inserting worksheets.
a.
skeleton
c.
format
b.
structure
d.
location
Definition
b.
structure
Term
Protecting the ____ prohibits users from moving, resizing, closing, or hiding parts of the Excel window.
a.
structure
c.
content
b.
windows
d.
all of the above
Definition
b.
windows
Term
A digital ____ is like a seal of approval.
a.
affidavit
c.
signature
b.
clause
d.
salutation
Definition
c.
signature
Term
For simple macros, it is easier to create a macro using the macro ____.
a.
recorder
c.
explorer
b.
manager
d.
programmer
Definition
a.
recorder
Term
A macro can be stored in ____.
a.
the current workbook
c.
a new workbook
b.
the Personal Macro workbook
d.
any of the above
Definition
d.
any of the above
Term
The ____ Macro workbook is a hidden workbook opened whenever you start Excel, making its macros available anytime you use Excel.
a.
Universal
c.
Microsoft
b.
Personal
d.
XP
Definition
b.
Personal
Supporting users have an ad free experience!