ITA: Final

Question 1

Which of the following Microsoft Office applications is used to produce documents, including memos, newsletters, forms, brochures?

Answer 1

Word

Question 2

Which of the following is NOT something for which the Accessibility Checks?

Answer 2

Are there too many words?

Question 3

Which alignment spreads the text evenly between the left and right margins so that text begins at the left margin and ends uniformly at the right margin?

Answer 3

Justified

Question 4

Word’s __________ feature helps you customize how tracked changes are displayed in your document.

Answer 4

Markup

Question 5

A(n) ___________ is a citation or note that is placed at the bottom of a page.

Answer 5

Footnote

Question 6

When using Word, to select a paragraph, you ________.

Answer 6

triple-click in the paragraph

Question 7

Word’s __________ feature automatically moves words to the next line when the right margin is reached.

Answer 7

word wrap

Question 8

A __________ is the basic element of a PowerPoint.

Answer 8

slide

Question 9

A group of slides is called a _________.

Answer 9

deck

Question 10

Which of the following views would you use to simultaneously display multiple slides and easily change the order of the slides, or to delete one or more slides?

Answer 10

Slide sorter

Question 11

Which of the following views would you use to deliver a presentation using two monitors simultaneously?

Answer 11

Presenter

Question 12

Which of the following options allow you to insert an image in a shape?

Answer 12

Picture fill

Question 13

What do you do if you need to modify or delete the individual pieces of a group?

Answer 13

Ungroup

Question 14

When objects are layered, the order of the layering is called the ________.

Answer 14

stacking order

Question 15

The Accounting Number Format displays ____.

Answer 15

the dollar sign at the left edge of the cell

commas

two decimal places for the numeric value, with a column of values aligned on the decimal point

all of the above

Question 16

If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is ____.

Answer 16

0

Question 17

$B$1 is an example of a(n) ____ reference.

Answer 17

absolute

Question 18

When working with multiple worksheets in a workbook, it’s a good idea to ____ each worksheet.

Answer 18

rename

Question 19

In a VLOOKUP function, the argument ____ refers to the range containing the data that you want to search to find the lookup value.

Answer 19

table_array

Question 20

Which of the following options is the best tool when using a PivotTable that contains more data than you currently need?

Answer 20

Filtering

Question 21

When creating a one-variable data table that depicts the effect of different interest rates on a car payment, the interest rate is an example of which of the following?

Answer 21

Variable

Question 22

Is this a nested function?

Answer 22

=IF(AND(B7>5),”Yes”,”No”)

Question 23

Of the following, which is NOT a main object type in an Access database?

Answer 23

Record

Question 24

A ________ is a question you ask about data stored in a database.

Answer 24

Query

Question 25

The ________ view in Access looks similar to an Excel spreadsheet.

Answer 25

datasheet

Question 26

You can create or modify a table’s field names and data types in ________ view.

Answer 26

design

Question 27

A primary key:

Answer 27

must contain a unique value for each record within a table

Question 28

Access differs from other Microsoft software because it:

Answer 28

works primarily from storage

Question 29

Alice is working in a database containing the names, service locations, and services offered by landscapers. She needs to find landscapers that offer services in the Phoenix area and that service rare plants. The best way for her to search for this data is to perform a:

Answer 29

filter by form

Question 30

Ryan is working in a database that organizes vendor contact information. Ryan must find vendors located in Seattle and Portland. The vendors must have offices in both cities in order to meet Ryan’s requirements. He should use the Filter by Form ________ condition.

Answer 30

AND

Question 31

Irene is working in a database that organizes city court case information. Irene must find court cases in either Jackson county or Jefferson county. Irene should use the Filter by Form ________ condition.

Answer 31

OR

Question 32

You may choose Access over Excel in all of the following situations EXCEPT when you:

Answer 32

need to create complex charts

Question 33

A relationship is a connection between:

Answer 33

two or more tables using a common record

Question 34

A relational database has the ability to create relationships between two:

Answer 34

tables

Question 35

A field that is defined as a primary key in one table is defined as a(n) ________ in a related table.

Answer 35

foreign key

Question 36

You can use the ________ allows to make changes to the layout while you are viewing the data on the form.

Answer 36

stacked layout

Question 37

A ________ is a defined set of colors, fonts, and graphics that can be applied to a form or report.

Answer 37

theme

Question 38

When creating a report, ________ asks a series of questions and uses the answers to generate a customized report.

Answer 38

the Report Wizard

Question 39

To add a calculated field to a report, you would use________ view.

Answer 39

design

Question 40

You have been working in a database. Your boss asks you to design and print out a report for an upcoming board meeting. What view should you use to ensure that the report will print out as intended?

Answer 40

Print Preview