Exam 3 Review Excel Ch Question and answers rated A+ 2024/2025 Exam 3 Review Excel Ch. 7 & 8, Access Ch. 1-3
You can click the ________ button on the table toolbar to sort records in alphabetical
order, from A to Z. - correct answer ascending
Irene is working in a database that organize...
Exam 3 Review Excel Ch. 7 & 8, Access
Ch. 1-3
You can click the ________ button on the table toolbar to sort records in
alphabetical
order, from A to Z. - correct answer ✔ascending
Irene is working in a database that organizes city court case information. Irene
must find
court cases in either one of two cities. Irene should use the Filter by Form
________
condition. - correct answer ✔OR
In the table pictured above, if you wanted to organize the data from the lowest
Client ID
to the highest Client ID, you would ________ the Client ID field. - correct
answer ✔sort
Which of the following statements best describes a one-to-many relationship
between
two tables? - correct answer ✔A primary key in the first table matches
several foreign keys in the second table.
When defining a field, the field ________ property determines how much
physical storage
space the field requires. - correct answer ✔size
,Which statement accurately describes the function of a query? - correct
answer ✔Queries manipulate data stored in tables, displaying only those
records which match the query's criteria
A field name can begin with a(n) ________. - correct answer ✔number
The ________ view in Access looks similar to an Excel Spreadsheet. - correct
answer ✔Datasheet
In the table pictured above, the ________ field would make the best primary
key. - correct answer ✔Client ID
Constants that are used as arguments in expressions can be defined as
________. - correct answer ✔Values that do not change
An expression or integer value specifying total number of payments in a loan
is the
________ argument in the PMT function. - correct answer ✔num_periods
A ________ produces professional appearing formatted information derived
from the
information contained in tables or queries. - correct answer ✔report
Consider the following equation: 3 * (6 + 5) - 4 /2. Which operation would be
calculated
FIRST according the order of operations: - correct answer ✔(6 + 5)
Which of the following would be the best choice for a primary key? - correct
answer ✔Social Security Number
, You can use ________ to create a relationship between two tables using a
common field. - correct answer ✔join lines
What function in a Totals Row would calculate the least valued data item in a
group? - correct answer ✔Minimum
When choosing between Access and Excel, it is best to use Excel in all of the
following
circumstances EXCEPT: - correct answer ✔you need to create complex
charts or graphs
The ________ organizes and lists the database objects in an Access
database. - correct answer ✔navigation pane
A(n) ________ is a variable or constant that is needed to produce output for a
function in
a calculated field. - correct answer ✔argument
Steven is working on a database that stores student data. He needs to find
students
majoring in either one of two majors. He is looking for students majoring in
Economics.
He also is looking for students majoring in History. Which operator would
Steven use to
find this information? - correct answer ✔OR
Two or more tables which contain duplicate data is an example of ________. -
correct answer ✔data redundancy
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper Academia199. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €13,12. Je zit daarna nergens aan vast.