Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
111 Cards in this Set
- Front
- Back
The ____________ contains buttons corresponding to the most basic commands in Excel.
|
standard toolbar
|
|
what is an Excel spreadsheet
|
worksheet
|
|
what is a computerized version on an accountant's ledger
|
spreadsheet
|
|
The ___________ is used to copy the formatting of a selected cell to other cells.
|
format painter
|
|
You saved an Excel document as a Web page and are viewing it in Internet Explorer. You notice a mistake and use the round-trip HTML feature to edit the page. In Internet Explorer, you notice that the browser is still displaying the "old" page. What is the most likely explanation?
|
You did not refresh the Web page in Internet Explorer.
|
|
To create a Web query:
|
select the Import External Data command on the Data menu.
|
|
Excel stores all dates as ___________.
|
intergers
|
|
To update the data in a Web query:
|
click the Refresh button on the External Data toolbar
|
|
Pointing is more accurate and usually faster than using the keyboard to enter cell references.
|
true that!
|
|
To create a new Web query, use the Refresh command.
|
false
|
|
The Today() function always returns the system date.
|
true
|
|
A chart is based on numeric values called
|
data points
|
|
In an embedded chart, the ____________ indicate(s) it is currently selected.
|
sizing handles
|
|
Charts can be embedded in a worksheet or created in a:
|
chart sheet
|
|
You can use the ____________ toolbar to add text boxes and other objects to a chart.
|
drawing
|
|
If you specify the data series are in rows, the Chart Wizard will use ____________ for the category labels.
|
the first row
|
|
If you specify a data series in columns, the Chart Wizard will use ____________ as the data series.
|
all columns but the first
|
|
The key that will quickly create a default chart in its own worksheet is:
|
f11
|
|
Which of the following is NOT suited for multiple data series?
|
pie chart
|
|
You have a Word memo that is open, and linked to an Excel worksheet. You make changes in the worksheet. The memo is:
|
updated immediately.
|
|
You have a Word memo that has an embedded Excel worksheet. You save the original worksheet. The memo is:
|
never updated.
|
|
The feature that allows you to create a document containing objects from another application is:
|
object linking and embedding.
|
|
data point is a grouping of data series
|
False
|
|
All of the following are required arguments to the PMT function EXCEPT:
|
the time interval of the payments; i.e. months or years
|
|
When using the FV function, which required argument is normally expressed as a negative number?
|
The amount of the periodic payment.
|
|
You have used the FV function to calculate the value of your retirement fund and feel that you won’t have enough money. Which of the following can be used to calculate the return you will have to earn to reach your investment objectives?
|
The Goal Seek command.
|
|
You want to use the PMT function to calculate the monthly payment on a car loan. The price of the car is in cell B2, the down payment amount is in cell B3, the annual interest rate is in cell B5, and the term (in years) of the loan is in cell B6. Cell B4 contains the formula =B2 – B3. Which of the following will return the correct answer?
|
=PMT(B5/12, B6*12, -B4).
|
|
To select a non-contiguous cell range, after selecting the first cell range, hold down the ____________ key to select all other ranges.
|
Crtl
|
|
When copying formulas to other rows and columns, references to the assumptions in the worksheet are normally ____________ references.
|
absolute
|
|
To create a table where two parameters are varied, use ____________ references so that the formula can be copied to the other cells in the table.
|
Mixed
|
|
When a cell is not wide enough to display the results of the formula in that cell, ____________ is displayed in that cell.
|
##########
|
|
If you want to specify the order in which rows in a spreadsheet are displayed, use the:
|
sort command
|
|
The equal to (=) sign and not equal to (<>) sign are examples of:
|
relational operators
|
|
Which is NOT a required argument to the IF function?
|
The column containing the breakpoints
|
|
Which of the following is NOT included in the computation for the COUNTA function?
|
empty cells
|
|
To keep row and/or column headings visible as you scroll through the worksheet, use the ____________ command.
|
freeze panes
|
|
To display only rows meeting certain criteria, use:
|
the AutoFilter command
|
|
A function accepts arguments, which can be either variables or constants.
|
true
|
|
The PMT function can be used to calculate the monthly payment on a car loan; the FV function calculates the future value of an investment.
|
true
|
|
With the Goal Seek command, you may only change one input parameter at a time
|
true
|
|
With the Goal Seek command, you may only change one input parameter at a time
|
true
|
|
Rows not meeting the criteria are hidden, but not deleted.
|
true
|
|
Numeric value to look up, range of the table to look up, the column number containing the desired value
|
VLOOKUP
|
|
Rate of return, term, amount of periodic payment
|
FV
|
|
Conditional test, value_if_true, value_if_false
|
IF
|
|
Interest rate, term, present value (principal)
|
PMT
|
|
Keeps row and/or column headings visible as you scroll through the worksheet
|
Freeze panes command
|
|
Causes different parts of the worksheet to be displayed on the screen
|
Scrolling
|
|
Displays only rows meeting certain criteria
|
AutoFilter command
|
|
Lets you make rows invisible on the screen and when the worksheet is printed
|
Hide Rows command
|
|
What is not one of the seven types of Access database objects?
|
charts
|
|
What acronym describes the phenomenon that the information produced by a system is only as good as the data on which the information is based?
|
GIGO
|
|
What option would you choose to display all the records that were different than the currently selected record?
|
Filter Excluding Selection
|
|
A report can be based on either a query or a table.
|
true
|
|
Provides information based on the data within an underlying table
|
Query
|
|
Where you add, edit, and delete records
|
Datasheet view
|
|
Which of the following should be defined as a numeric field?
|
price
|
|
Every field in a table has a:
|
field name and a data type.
|
|
Which data type would you assign to the phoneNumber field?
|
text field
|
|
Which of the following will automatically be created as a drop-down list in an Access form?
|
A bound control that was defined through the Lookup Wizard
|
|
What is the term for a characteristic or attribute of an object that determines how the object looks and behaves?
|
property
|
|
What section does virtually every form contain?
|
detail section
|
|
The properties for a control are displayed in a:
|
property sheet
|
|
Which control has as its source an expression rather than a field?
|
calculated control
|
|
What property imposes data validation by requiring that data be entered in a specific way?
|
The Input Mask property
|
|
What is the name of a button that can be added to a form to enable creating a new record?
|
commands button
|
|
A database system will almost surely fail if all of the necessary data is not included in the system.
|
true
|
|
Calculated fields should not be stored in a table because they are subject to change, waste space, and are otherwise redundant.
|
true
|
|
The Validation Rule property for a field automatically enters a designated (default) value for the field in each record that is added to the table.
|
false
|
|
Form Wizard does require that you specify the table or query on which the form will be based.
|
true
|
|
All forms consist of controls that accept and display data, perform a specific action, decorate the form, or add descriptive information.
|
true
|
|
A calculated control has as its data source an expression rather than a field.
|
true
|
|
Has a data source.
|
bound control
|
|
Has no data source.
|
unbound control
|
|
Has as its data source an expression rather than a field.
|
calculated control
|
|
A combination of operators, field names, constants, and/or functions.
|
expression
|
|
Provides the ability to choose the fields and /or style.
|
form wizard
|
|
Produces a form containing all of the fields in the underlying table or query.
|
autoforms
|
|
Facilitates data entry by displaying literal characters, such as slashes in a date
|
read creating a table section
|
|
Rejects any record that does not have a value entered for this field.
|
required property
|
|
Rejects any record where the data entered does not conform to the specified rules for data entry.
|
validation rule property
|
|
Changes the way a field is displayed or printed, but does not affect the stored value.
|
format property
|
|
Specifies the error message that is displayed when a record is rejected because the data does not conform to the specified rules for data entry
|
validation text property
|
|
A report may be based on:
|
either a table or a query
|
|
Which type of report lists every field for every record in a single column?
|
columnar
|
|
Which of the following is not required by the Report Wizard?
|
The number of rows in the query
|
|
Which of the following is used to add the current date to a report each time it is printed?
|
=Now()
|
|
The design grid in the query window:
|
helps you create a select query
|
|
The most common type of query is called a:
|
select query
|
|
The Count function calculates:
|
the number of records within a group.
|
|
Which of the following conditions is implemented by values entered into different Criteria rows of the same field in a design grid?
|
OR
|
|
Which of the following conditions is implemented by values entered into multiple columns of the same Criteria row in a design grid?
|
AND
|
|
What type of action query removes one or more records from a table according to designated criteria?
|
delete query
|
|
Which of the following is true regarding action queries?
|
All action queries are irreversible.
|
|
Which type of query consolidates data from an Access table and presents the information in a row and column format (similar to a pivot table in Excel)?
|
crosstab query
|
|
Which of the following adds records from one table to the end of another table?
|
append query
|
|
A dynaset looks and acts like a table but it is not a table.
|
true
|
|
A select query searches the underlying table to retrieve the data that satisfies the query.
|
true
|
|
Action queries do not make changes to the database.
|
false
|
|
In queries, values entered in multiple columns of the same Criteria row implement an AND condition
|
true
|
|
Grouping records within a report enables you to perform calculations on each group.
|
true
|
|
The detail section appears in the main body of a report and is printed once for every record in the underlying table (or query).
|
false
|
|
The resulting data of a select query can be modified to update the data in the underlying table(s).
|
true
|
|
A crosstab query consolidates data from an Access table in a row and column format.
|
true
|
|
There is no difference between data and information.
|
false
|
|
The criteria row in a Design grid determines the records that will be selected from the underlying table.
|
true
|
|
Displays fields in a row
|
tabular report
|
|
Displays fields in a row
|
columnar report
|
|
Displays the field name
|
field row
|
|
Determines whether or not the field will be displayed in the query results
|
criteria row
|
|
Where the specifications for the select query are entered
|
design grid
|