Databases and Spreadsheets
Databases and Spreadsheets

Databases and Spreadsheets

Lead Author(s): Saylor Academy

Source: Saylor

Student Price: FREE

This question package covers concepts applicable to spreadsheets and databases and the best application of one or the other to a situation.

This content is licensed under the Creative Commons Attribution 3.0 Unported License.

Databases Question 1

A friend wants to get involved in your mail order greeting card business, and is going to help by answering inquiries, quoting prices, and taking orders. You want to provide an easy way for him to view product details without allowing him to change the data that is already in the system. You will do this by using (a) ______________ that allow(s) him to view existing data but not change it.

A

queries

B

select queries

C

switchboard

D

tables

E

form

Databases Question 2

A ______________ is the field used to define each record in a table.

A

record

B

primary key

C

product

D

database

E

table

Databases Question 3

A(n) ______________ is a term used to describe business or knowledge workers who are involved in the process of data collection and storage, transformation of business systems, and information dissemination.

A

Computer Programmer

B

Business Analyst

C

Database Analyst

D

Business Manager

E

Project Coordinator

Databases Question 4

Allen receives weekly updated printouts from his customer. Each printout contains a list of the equipment needed for the next month. Each weekly update also contains major adjustments for the final two weeks of the report based upon the company’s confidence that future business is available. After receiving the 20‑page report, Allen spends six hours entering the data into his company database. The Shipping Department for Allen’s company wants a copy of the data once entered. They take the list and manually mark off the shipped items. Once all of the items have shipped, Shipping enters the item updates into the same database. Which of the following options would make this process more efficient?

A

Provide the Shipping Department access to a database report of the data with update permission for a shipping status field.

B

Provide the Shipping Department with update access to the database.

C

Provide the Shipping Department with update and query permission of the database.

D

Continue with the existing process.

E

Allen should give the original data to the Shipping Department to enter.

Databases Question 5

Allen receives weekly updated printouts from his customer. Each printout contains a list of the equipment needed for the next month. Each weekly update also contains major adjustments for the final two weeks of the report based upon the company’s confidence that future business is available. After receiving the 20‑page report, Allen spends six hours entering the data into his company database. Twice a week, the Inventory Control Manager requests Allen provide a printout from the database of the equipment that is currently in inventory, and projections for the upcoming weeks. The manager uses the information to place orders for parts to cover the next two weeks. Which of the following would make this process more efficient?

A

Provide the Inventory Control Manager access to a database form that contains the required information.

B

Extract the required data to a spreadsheet file and deliver it to the Inventory Control Manager.

C

Tell the Inventory Control Manager that you can only deliver the report once a week.

D

Continue with the existing process.

E

Allen should ask his administrative assistant to prepare the report for the Inventory Control Manager.

Databases Question 6

Allen receives weekly updated printouts from his customer. Each printout contains a list of the equipment needed for the next month. Each weekly update also contains major adjustments for the final two weeks of the report based upon the company’s confidence that future business is available. After receiving the 20‑page report, Allen spends six hours entering the data into his company database. Allen has a weekly meeting with his manager that requires him to prepare a report of all sales orders and their delivery status. The report takes him almost two hours to prepare and it usually contains math errors or omitted information. Which of the following would make this process more efficient?

A

Print the raw data and bring it to the meeting.

B

Create a form in the database that contains all the required information and print prior to the meeting.

C

Extract the data into a spreadsheet and use the spreadsheet tool to manipulate the data.

D

Continue with the existing process.

E

Allen should task his administrative assistant to prepare the report for the manager.

Databases Question 7

Gordon Brown, the Executive Director of Great Energy Inc., sits at his desk and thumbs through the four financial presentations given to him by his Directors. He is scheduled to present the information to the Board of Directors in a few days, but is disappointed with the presentations’ content and format. Each presentation features a different layout, font, and header; even the content varies. After returning from the board meeting, Gordon relays to his directors that the Audit Committee is requesting access to the current financial data as well as data from the last four years. The committee is not sure what reports they would need or in what format the data should be presented. Based on this vague request, what tool would you use to prepare this data?

A

Word processing

B

Spreadsheet

C

Presentation

D

Database

E

Email

Databases Question 8

Greg has a database of all his golf students, and he would like to create short programs designed to retrieve data from the database. What feature of the database should Greg use?

A

Queries

B

Tables

C

Fields

D

Grids

E

Sorts

Databases Question 9

In order to link separate tables together in a database, the primary key of one table is repeated in another table where it is called a ______________ key.

A

primary

B

secondary

C

master

D

repeater

E

foreign

Databases Question 10

One month after implementing a new manual logging system, Karen asks Steve to convert the document, which is used to log billable time in 15‑minute intervals and notes, into an electronic form so that she can have real‑time access to the information. Which of the following Office suite of tools would you suggest Steve use to digitalize the log?

A

Word processing

B

Spreadsheet

C

Presentation

D

Database

E

Email

Databases Question 11

The Executive Director notices the calendar in the break room and comments on the great idea. Upon returning to her Chicago office, she sends an email asking Susan to help the other four departments implement a break room calendar that can be accessed electronically by those with permission. Based on this request, what tool would you recommend Susan?

A

Word processing

B

Spreadsheet

C

Presentation

D

Database

E

Email

Databases Question 12

The ______________ tool provides wizards to help users to create tables, queries, forms and reports, and it comes supplied with a set of predefined table definitions for tracking assets, customers, sales orders, invoices and many other commonly useful items.

A

word processing

B

spreadsheet

C

presentation

D

database

E

email

Databases Question 13

Your son’s Boy Scout troop was the second highest fund raising troop in your state. Next year, the troop wants to double their performance from last year and secure the number one position. One of the parents recommends purchasing a list of every address in your region. She believes this information can help determine the neighborhoods with the highest fund raising potential. What office suite tool should be used with the address list to maximize the analysis of the data?

A

Word processing

B

Spreadsheet

C

Presentation

D

Database

E

Email

Databases Question 14

______________ are short programs requesting that data be retrieved from, added to, or modified in a table.

A

Queries

B

Tables

C

Fields

D

Grids

E

Sorts

Databases Question 15

______________ data is most suitable when information must be separated into conceptual groups such as knives, forks and spoons; or males and females.

A

Categorical

B

Discrete

C

Continuous

D

Random

E

Sample

Databases Question 16

______________ data is often grouped in categories (“fewer than three,” “four or more”) and treated as data groups which have numerical values associated with them, but only whole values.

A

Categorical

B

Discrete

C

Continuous

D

Random

E

Sample

Databases Question 17

______________ provide(s) a professional‑looking interface for viewing the forms and reports that you have created in your database.

A

Queries

B

Select queries

C

A switchboard

D

Tables

E

A form

Databases Question 18

______________ show(s) the database records and fields you have selected (and any calculated fields you may have defined), but do(es) not change any of the values in your underlying database tables.

A

Queries

B

Select queries

C

Table queries

D

Tables

E

Form

Spreadsheets Question 1

Allen receives weekly updated printouts from his customer. Each printout contains a list of the equipment needed for the next month. Each weekly update also contains major adjustments for the final two weeks of the report, based upon the company’s confidence that future business is available. After receiving the 20‑page report, Allen spends six hours entering the data into his company database. Which of the following would make the process more efficient?

A

Request a spreadsheet file and upload the data into the database.

B

Hire a data entry clerk to enter the data.

C

Ask the customer to send only one week of data at a time.

D

Continue with the existing process.

E

Request and enter only two weeks of data at a time.

Spreadsheets Question 2

Diane Green is hired as a coordinator for your non‑profit’s fund raising event. The event includes seven fund raising activities that will commence two weeks before the main event, and that must be tracked and reported daily. Based on the success of each individual event, the president of the non‑profit will make phone calls and send e‑mails to encourage participation. Diane is considering the options listed below. Which one would provide the most valuable results?

A

Send the president a daily spreadsheet containing all of the data from the seven fund raising activities.

B

Send the president a summary spreadsheet of the seven fund raising activities for the current day.

C

Create and send the president a word processing document and insert the summary of the seven fund raising activities for the current day.

D

Create and send the president a word processing document with a summary of the spreadsheet data for the current day and all prior days’ fund raising activities.

E

Explain how the integration of two major office suite tools can help inform business decisions and address business needs.

Spreadsheets Question 3

Gwen, your company’s sales manager, uses a spreadsheet to report her monthly and quarterly sales progress. Her new manager, who lives in Paris, has requested that she send him a weekly letter with a summary of this information. Gwen went to see her co‑worker for help with business need. Which of the following items best describe what she should ask her co‑worker to provide?

A

Summarize how word‑processing and spreadsheet data may be integrated.

B

Explain why such integration can help inform business decisions.

C

Identify the tool functions that allow for integration and sharing across wordprocessing documents and spreadsheets.

D

Describe how to design a spreadsheet document with integrated word‑processing data, as well as perform this task.

Spreadsheets Question 3

In a spreadsheet tool, dates and times are displayed as text but are stored as ______________.

A

formulas

B

numbers

C

graphs

D

text

E

charts

Spreadsheets Question 4

Sharon Smith, the Finance Director of Baker and Baker Manufacturing, stands in the hallway outside her boss’s office reviewing the report her staff prepared in the last hour. The “report” consists of a collection of hand‑written notes regarding the company’s financial status. However, Sharon’s boss frequently calls her office and demands a status report within the hour. Which of the following tools would be most useful to address Sharon’s problem?

A

Word processing

B

Spreadsheet

C

Presentation

D

Database

E

Email

Spreadsheets Question 5

Steve is working with some spreadsheet data and needs to calculate a result depending on one or more conditions. What spreadsheet function should Steve use?

A

SUM

B

IF

C

Average

D

COUNT

E

TODAY

Spreadsheets Question 6

Steve is working with spreadsheet data and wants to calculate the total of a set of numbers. What spreadsheet function should he use?

A

SUM

B

IF

C

Average

D

COUNT

E

TODAY

Spreadsheets Question 7

The ______________ spreadsheet tool function calculates a result depending on one or more conditions.

A

SUM

B

IF

C

average

D

COUNT

E

TODAY

Spreadsheets Question 8

The ______________ spreadsheet tool function calculates the total of a set of numbers.

A

SUM

B

IF

C

average

D

COUNT

E

TODAY

Spreadsheets Question 9

The ______________ spreadsheet tool function lets you view just the records that you want to see. The other records in your data table will still be there, but hidden.

A

sort

B

filter

C

subtotal

D

formula

E

SUM

Spreadsheets Question 10

______________ is a spreadsheet tool feature that allows you to repeat a data series (such as the days of the week, months of the year, or a numbers series such as odd numbers) over a range of cells.

A

Formulas

B

Numbers

C

Graphs

D

Auto fill

E

Charts

Spreadsheets Question 11

______________ is the spreadsheet data type that consists mainly of alphabetic characters, but can also include numbers, punctuation marks, and special characters.

A

Formulas

B

Numbers

C

Graphs

D

Text

E

Charts

Spreadsheets Question 12

______________ is the spreadsheet data type that starts with an “=” sign and contains at least one logical or mathematical operation (or special function), combined with numbers and/or cell references.

A

Formulas

B

Numbers

C

Graphs

D

Text

E

Charts

CC BY 3.0 - Saylor

Content on this site is licensed under a Creative Commons Attribution 3.0 Unported License .

Saylor Academy and Saylor.org® are trade names of the Constitution Foundation, a 501(c)(3) organization through which our educational activities are conducted.

Course Designer: n/a