Computer Midterm
true
A SmartArt graphic is a visual representation of information and ideas.
report
A ________ is a database object that displays the fields and records from a table or query in an easy-to-read format suitable for printing.
query
A ________ is a database object that retrieves specific data from one or more database objects.
chart
A ________ is a graphic representation of data.
trendline
A ________ is a graphic representation of trends in a data series.
field
A ________ is a single piece of information that is stored in every record.
database
A ________ is an organized collection of data.
true
A chart is a graphic representation of data.
embedded
A chart that is inserted into the same worksheet that contains the data used to create the chart is called ________.
another location in the worksheet or the company intranet
A hyperlink in a worksheet may take you to which of the following locations ________.
false
A line chart can have only one line.
theme
A predesigned set of colors, fonts, lines, and fill effects that look good together and that can be applied across all Office 2016 applications is called a ________.
list
A series of rows that contains related data is known as a ________.
false
A series of rows that contains related data is known as a query.
true
A synonym is a word that has the same or similar meaning to a word that you have selected.
text and headings
A theme combines font sets for ________.
true
A user can change the column widths of multiple fields at the same time.
file
A user can close the existing database and leave Access open to continue working on anther database by clicking close from the ________ tab.
true
A user can create a PDF electronic image of a table instead of printing a paper copy from the Print Preview screen.
SHIFT
A user can delete multiple columns from Layout view of a Form by holding down the ________ key and clicking on the range of columns to delete.
double clicking
A user can move the Available Fields to the Selected Fields in the Query Wizard by clicking the > button or by ________ on the Available Field.
true
A user can populate a table with records by typing the data directly into the table.
true
A user can quickly create a new form for data within a table by making the table active and selecting Form from the create tab.
table
A user can run a query on a ________ or on other existing queries.
true
Access automatically saves each record when you move to the next row; you do not need to click Save.
bestfit
Adjusting the column width of any field to fit the contents is referred to as ________.
run
After a user creates a new query or edits an existing query they must ________ the query to display the corresponding results.
true
All templates provided by Microsoft are safe and users can enable content if any warning message is displayed.
true
An enclosure notation on a business letter alerts a reader to the fact that a document is included with the letter.
reporting relationships
An organization chart depicts ________ within an organization.
database
An organized collection of facts related to a specific topic is known as a ________.
false
Automatic spell checking in Word is not set by default; it must be turned on to be active.
orientation and page breaks
Before printing or distributing a large worksheet, the Print Preview option enables you to see ________.
.xlsx
By default, Excel 2016 files are saved in the native Microsoft Excel Workbook file format with the following file extension ________.
true
By default, when a user opens a table and selects Report from the Create tab, all fields and all records are included in the report.
import
By using the ________ feature, users do not have to manually enter data into tables if the information already exists in a Word table or Excel spreadsheet.
chart sheet
Charts can be placed on a separate sheet called a ________.
labels
Column and row titles that describe the values in the column or row are known as ________.
vertical
Column charts present data graphically in ________ columns.
true
Ctrl + Home is a quick, easy way to navigate to the top of a document.
flat
Databases that not related or linked to other data are called ________ databases.
true
Each table should have a field that contains a unique value for each record in the table.
true
Entering data on a single-record form will automatically update the data in the record without having to click save.
true
Excel worksheets and workbooks can be saved as web pages.
short text
Fields that contain numbers that are not used in calculations should be set to ________.
false
From the File tab, you can insert a file into an existing document.
As red and blue wavy underlines
How do potential spelling and grammar errors display in Word 2016?
Hold down Ctrl and click in the sentence
How do you quickly select a sentence?
Double-click the word
How do you select an individual word?
texts and graphics
Hyperlinks can be attached to which of the following items?
Table Tools Design
If gridlines do not show on a table without borders, click the Borders button arrow, and then click View Gridlines on the ________ tab.
autonumber
If the dataset of a table does not contain a unique ID field, a user can add a field and use the ________ data type to create one automatically for each record.
protection
If you need to make changes to a template after it is protected, you must first remove the ________.
true
If you need to make changes to a template, you must first remove protection.
true
If you place your chart on a separate sheet it is referred to as a chart sheet.
true
If you send a resume to a company, it is good practice to include a cover letter.
true
If your worksheet is wider than one page, you will also want to repeat the row titles on each page when you print or view the worksheet.
short text
In Access, the default data type is ______.
true
In Access, users can add additional tables to databases created from templates.
design
In ________ view of a table, the data is not displayed, instead the structure of the table and its fields are displayed.
true
In an Excel chart element, the data marker is a column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point.
unlocked
In order for individuals completing your form to type their data into designated cells, the cells must be ________.
DBMS
Microsoft Access 2016 is a ________ that controls how related collections of data are stored, organized, retrieved and secured.
false
Once users select a data type for a field and enter data, they cannot change the data type.
false
Primary keys must be numbers.
tab delimited text file
Saving an Excel worksheet as a ________ separates the cells of each row with tab characters.
Design
Settings related to fonts are found on the ________ tab.
tiny charts that fit within a cell and give a visual trend summary alongside your data
Sparklines are ________.
true
Sparklines are tiny charts that fit within a cell and give a visual trend summary alongside your data.
false
Subtotal rows that are totaled and summarized are referred to as actual data.
detail
Subtotaled rows that are totaled and summarized are referred to as ________ data.
false
Templates can only be used on the computer on which they are created.
blue dashed lines and the page number on the worksheet
The Page Break view shows where the page breaks will occur by displaying ________.
false
The Primary key must be the first field in each record.
false
The Short Text data type will allow a user to store up to 512 characters in that field.
left
The Text Pane displays to the ________ of the SmartArt diagram.
placeholders
The Text Pane includes ________ in which you can type text into a SmartArt graphic.
navigation
The ________ Pane displays and organizes the names of the objects in a database.
data type
The ________ classifies the kind of data that can be stored in each field. Examples are number, text or date.
inside address
The ________ is the name and address of the person receiving a business letter.
primary
The ________ key refers to the unique field that identifies each record.
layout
The ________ view of a form allows a user to view the data while making changes to the elements of the form.
255
The default field size for Short text fields is ____ .
Custom Office Templates
The default folder where custom template files are stored is named ________.
chart area
The entire chart with all of its elements is called the ________.
field
The first step in adding subtotals to a group or list is to sort the data by the ________ for which you want to create a subtotal.
legend
The key that defines the colors assigned to categories in a chart is called a(n) ________.
true
The most common date format for a letter is, as an example, July 4, 2018.
show and hide
The outline bar along the left side of a worksheet enables you to ________ levels of detail with a single mouse click.
true
The outline bar along the left side of a worksheet enables you to show and hide levels of detail with a single mouse click.
panes
The portions of a worksheet window bounded by and separated from other portions by vertical or horizontal lines as a result of using the Freeze Panes command are referred to as ________.
design
There are two views for tables in Access: Datasheet view and ________ view.
true
To create sparklines, first select the data you want to plot.
alt
To display measurements on the ruler while changing column widths, hold down the ________ key while dragging the marker.
freeze pane
To freeze column and row titles on the screen so that they are visible while you scroll, which of the following command(s) would you use?
create
To make a new query, click on the ______ tab.
column
To make comparisons among related data, use a ________ chart.
save as
To save an Excel file in another file format, use the ________ command.
arrange all
To tile multiple open worksheets on the screen, use the ________ command.
true
To use the Append option to add records to an existing table, the column headings in the Excel worksheet must be identical to the field names in the table.
true
Two options on the AutoFit button on the Table Tools Layout tab are AutoFit to Contents and AutoFit to Window.
true
Use a wildcard character to search a field when you are uncertain of the exact value for which you are searching.
true
Users should not store redundant data within a database and should create a new table to contain that data.
false
Using Access, a user can only select one table or query to perform a simple select query on.
false
Using Access, increasing the column width will also increase the number of characters a user can enter in each field.
false
Using Access, one of the major advantages of using a database template is that it will populate the tables with data.
autonumber
What data type describes a unique sequential or random number assigned by Access as each record is entered ?
currency
What data type describes monetary values and numeric data that can be used in calculations?
number
What data type represents a quantity of how much, or how many, and may be used in calculations ?
Adds a new row
What does pressing Tab in the last cell of a table do?
true
When a designer shortens the field length of an existing field, all data for existing records will be truncated to match the new field length.
design and layout
When a table is active in a Word document, the two additional tabs that display on the ribbon are ________.
four
When considering to use the Currency data type, a user should understand that they can store data with one to ________ decimal places.
labels
When creating a column chart, selecting ________ for the data helps the reader understand the chart.
ID
When creating a new table, Access creates the first field and names it ________ which Access assigns a unique sequential number.
fields
When creating a table, a user should keep a record to a single instance of each set data that is broken down into its smallest usable parts called ________.
data
When deleting a field from a table, Access will delete the field and corresponding ________.
What questions should this database be able to answer?
When designing a new database, the first question users should ask themselves is ________.
true
When importing a new table from an existing Excel worksheet, the user can use the existing headings from the Excel spreadsheet so that they do not have to re-type them.
false
When importing a new table from an existing Excel worksheet, the user must import all columns from Excel into the new Access table.
common field
When linking two tables in a relational database, a user will use a ________ to create the link.
save
When making design changes to a table, a user must ________ the table before changes will apply.
true
When outlining a worksheet, if the data is not organized so that Excel can outline it automatically, you can create an outline manually.
tab or enter
When users are entering data into a record, they can use the ________ key to move to the next field to increase efficiency and they are not required to use the mouse to click in each field.
bordered in orange
When you create a table in Word 2016 from the Table button on the Insert tab, as you select the number of rows and columns you want, the cells are ________.
false
When you press Enter within a table cell, the insertion point moves to the next cell.
password
When you protect a worksheet, you can add an optional ________ to prevent someone from disabling a worksheet's protection.
Right-click, point to Synonyms
When you select a word in a document and you want to select a synonym, what do you do?
F7
Which keyboard shortcut key opens the Spelling & Grammar feature?
process
Which of the following SmartArt graphic categories would be best to show a timeline?
Excel Template, Excel 97-2003 Workbook, CSV or tab delimited
Which of the following are some frequently and commonly used file formats for Excel?
record
Which of the following describes all of the categories of data pertaining to one person, place, thing, event, or idea within a table row?
Move the pointer to the left of any line and when the arrow pointer displays, triple-click
Which of the following enables you to select everything in an entire document?
database wizard
Which of the following is NOT a way method to create a new database?
Records From: ________ To: ________
Which of the following is NOT an option for print range of a table?
The complimentary closing
Which of the following is referred to as the closing line of a business letter?
Size 10
Which of the following is the standard business envelope?
true
Word includes predesigned templates for a cover letter.
true
You can add effects, for example a bevel, to a SmartArt graphic.
format as table
You can create a custom table style by clicking ________.
true
You can customize your table by creating and applying a custom table style of your own design.
false
You can reduce the horizontal and vertical size of the printed data by changing the arrangement of the number of pages in a workbook.
smartart graphic
________ is a visual representation of information and ideas.
form
________ is an Access object with which you can enter data, edit data, or display data from a table or query.
protection
________ prevents anyone from changing a workbook.
true
user must have Internet Access to search online templates.
