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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Academia199. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.49. You're not tied to anything after your purchase.
