Your Office: Microsoft Office 2013, Volume 1 (Kinser et al.)
Access Module 1 Workshop 2
1) Which of the following is NOT one of the three steps in database design?
Answer: D
Diff: 1 Page Ref: 626
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
2) Which of the following is NOT true regarding database design?
Answer: B
Diff: 1 Page Ref: 626
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
3) Which of the following is true when breaking compound fields into smaller parts?
Answer: A
Diff: 2 Page Ref: 627
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
4) Illustrating some of the basic principles of database design, notice that a persons name is split into two fields and the address is ________.
Answer: D
Diff: 1 Page Ref: 627
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
5) Which of the following is NOT true when creating fields and entering data in those fields?
Answer: C
Diff: 1 Page Ref: 627
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
6) Which of the following is NOT true when dealing with international data?
Answer: D
Diff: 1 Page Ref: 628
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
7) Which of the following is NOT true about tables?
Answer: A
Diff: 2 Page Ref: 628-629
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
8) ________ define the kind of data that can be entered into a field, such as numbers, text, or dates.
Answer: C
Diff: 1 Page Ref: 629
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
9) ________ give more information on how the data is stored, entered, and processed.
Answer: D
Diff: 1 Page Ref: 629
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
10) The most appropriate data type to use for a Street Address field is the ________ data type, so a street address can contain numbers, letters, and special characters.
Answer: C
Diff: 1 Page Ref: 629
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
11) Data stored as a(n) ________ file cannot be imported into a table in Access.
Answer: B
Diff: 1 Page Ref: 629
Objective: Import Data from Other Sources
Text: Your Office: Microsoft Office 2013 Volume 1
12) Which of the following is NOT true when copying and pasting data from Excel into Access?
Answer: C
Diff: 2 Page Ref: 631
Objective: Import Data from Other Sources
Text: Your Office: Microsoft Office 2013 Volume 1
13) Access allows you to import a smaller portion of a worksheet, known as a ________, into a table.
Answer: C
Diff: 2 Page Ref: 633
Objective: Import Data from Other Sources
Text: Your Office: Microsoft Office 2013 Volume 1
14) A ________ is a character such as a tab or comma that separates the fields.
Answer: B
Diff: 2 Page Ref: 634
Objective: Import Data from Other Sources
Text: Your Office: Microsoft Office 2013 Volume 1
15) Which of the following is NOT true when entering data manually?
Answer: D
Diff: 2 Page Ref: 637
Objective: Enter Data Manually
Text: Your Office: Microsoft Office 2013 Volume 1
16) A(n) ________ key field is a field that uniquely identifies the record.
Answer: A
Diff: 2 Page Ref: 640
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
17) ________ indicates the maximum length of a data field.
Answer: C
Diff: 1 Page Ref: 641
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
18) Which of the following is NOT true when determining the field size?
Answer: A
Diff: 1 Page Ref: 641-642
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
19) Which of the following is NOT true when changing the data type in an existing field?
Answer: A
Diff: 1 Page Ref: 643
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
20) Which of the following is NOT true regarding input masks?
Answer: D
Diff: 2 Page Ref: 644
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
21) Which of the following is NOT true regarding table formatting?
Answer: C
Diff: 2 Page Ref: 645
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
22) ________ is an example of the Long Date format.
Answer: B
Diff: 2 Page Ref: 646
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
23) ________ is an example of the General Date format.
Answer: A
Diff: 2 Page Ref: 646
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
24) 4.5E + 13 is an example of the ________ format.
Answer: A
Diff: 2 Page Ref: 646
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
25) The ________ format displays at least one digit after the decimal point.
Answer: B
Diff: 2 Page Ref: 646
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
26) Which of the following is NOT true regarding keys?
Answer: D
Diff: 2 Page Ref: 647
Objective: Understand and Designate Keys
Text: Your Office: Microsoft Office 2013 Volume 1
27) Which of the following is NOT true regarding primary keys?
Answer: B
Diff: 2 Page Ref: 648
Objective: Understand and Designate Keys
Text: Your Office: Microsoft Office 2013 Volume 1
28) Which of the following is NOT true regarding foreign keys?
Answer: A
Diff: 2 Page Ref: 648
Objective: Understand and Designate Keys
Text: Your Office: Microsoft Office 2013 Volume 1
29) Two fields needed to uniquely identify a record are called a ________ key.
Answer: A
Diff: 1 Page Ref: 649
Objective: Understand and Designate Keys
Text: Your Office: Microsoft Office 2013 Volume 1
30) A university identifies a class by subject area and course number. The university has classes Math 101, Math 102, and MIS 101. It takes both subject and course number to identify a single course. The combination of the two fields is called a ________ key.
Answer: C
Diff: 2 Page Ref: 649
Objective: Understand and Designate Keys
Text: Your Office: Microsoft Office 2013 Volume 1
31) Sometimes your data will have a unique identifier that is already a part of your data. When that is true, you can use the field as a ________ key.
Answer: B
Diff: 2 Page Ref: 650
Objective: Understand and Designate Keys
Text: Your Office: Microsoft Office 2013 Volume 1
32) ________ is the process of minimizing the duplication of information in a relational database through effective database design.
Answer: D
Diff: 2 Page Ref: 652
Objective: Understand Basic Principles of Normalization
Text: Your Office: Microsoft Office 2013 Volume 1
33) Which of the following is NOT true regarding normalization?
Answer: A
Diff: 2 Page Ref: 652
Objective: Understand Basic Principles of Normalization
Text: Your Office: Microsoft Office 2013 Volume 1
34) Which of the following is NOT true regarding redundancy?
Answer: B
Diff: 2 Page Ref: 653
Objective: Understand Basic Principles of Normalization
Text: Your Office: Microsoft Office 2013 Volume 1
35) Which of the following is NOT true regarding a one-to-many relationship?
Answer: C
Diff: 2 Page Ref: 654
Objective: Understand Relationships Between Tables
Text: Your Office: Microsoft Office 2013 Volume 1
36) A ________ relationship is a relationship between two tables where one record in the first table corresponds to many records in the second table.
Answer: A
Diff: 2 Page Ref: 654
Objective: Understand Relationships Between Tables
Text: Your Office: Microsoft Office 2013 Volume 1
37) A ________ relationship is a relationship between tables in which one record in one table has many matching records in a second table, and one record in the related table has many matching records in the first table.
Answer: C
Diff: 2 Page Ref: 655
Objective: Understand Relationships Between Tables
Text: Your Office: Microsoft Office 2013 Volume 1
38) A ________ relationship is a relationship between tables where a record in one table has only one matching record in the second table.
Answer: B
Diff: 2 Page Ref: 655
Objective: Understand Relationships Between Tables
Text: Your Office: Microsoft Office 2013 Volume 1
39) Which of the following is NOT a step in creating a one-to-many relationship?
Answer: D
Diff: 2 Page Ref: 656
Objective: Create a One-to-Many Relationship
Text: Your Office: Microsoft Office 2013 Volume 1
40) Which of the following is NOT a step in creating a many-to-many relationship?
Answer: D
Diff: 2 Page Ref: 661
Objective: Create a Many-to-Many Relationship
Text: Your Office: Microsoft Office 2013 Volume 1
41) ________ is a database concept that ensures that relationships between tables remain consistent.
Answer: C
Diff: 2 Page Ref: 664
Objective: Understand Referential Integrity
Text: Your Office: Microsoft Office 2013 Volume 1
42) Datasheet view shows the values of the data within the table.
Answer: TRUE
Diff: 1 Page Ref: 628
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
43) Design view shows the structure of the table with the fields and their definitions.
Answer: TRUE
Diff: 1 Page Ref: 628
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
44) The lower pane of Design view has three columns: Field Name, Data Type, and Description.
Answer: FALSE
Diff: 1 Page Ref: 629
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
45) The Navigation Pane in Design view gives more information on how the data is stored, entered, and processed.
Answer: FALSE
Diff: 1 Page Ref: 629
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
46) A defined range is a group of cells that have been given a name that can then be used within a formula or function.
Answer: FALSE
Diff: 1 Page Ref: 633
Objective: Import Data from Other Sources
Text: Your Office: Microsoft Office 2013 Volume 1
47) A delimiter is a character such as a tab or comma that separates the fields.
Answer: TRUE
Diff: 1 Page Ref: 634
Objective: Import Data from Other Sources
Text: Your Office: Microsoft Office 2013 Volume 1
48) When you open a table in Design view, you can type data directly into the table.
Answer: FALSE
Diff: 1 Page Ref: 637
Objective: Enter Data Manually
Text: Your Office: Microsoft Office 2013 Volume 1
49) When you delete records from a table and realize you made a mistake, you can undo the deletion by clicking Undo in the Quick Access toolbar.
Answer: FALSE
Diff: 1 Page Ref: 638
Objective: Enter Data Manually
Text: Your Office: Microsoft Office 2013 Volume 1
50) A primary key field is a field that uniquely identifies the record.
Answer: TRUE
Diff: 1 Page Ref: 640
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
51) The Long Text data type is used to store textual or character information.
Answer: FALSE
Diff: 1 Page Ref: 640
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
52) The AutoNumber data type is used for keys.
Answer: TRUE
Diff: 1 Page Ref: 641
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
53) The field size indicates the maximum length of a data field.
Answer: TRUE
Diff: 1 Page Ref: 641
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
54) The Byte field size is used for integers that range from -32,768 to +32,767.
Answer: FALSE
Diff: 1 Page Ref: 642
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
55) The Single field size is used for large numbers with up to seven significant digits.
Answer: TRUE
Diff: 1 Page Ref: 642
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
56) An input mask defines a consistent template and provides the punctuation, so you do not have to type it.
Answer: TRUE
Diff: 1 Page Ref: 644
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
57) Input masks do not affect how data is stored.
Answer: FALSE
Diff: 1 Page Ref: 644
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
58) The Format property tells Access how data is to be displayed.
Answer: TRUE
Diff: 1 Page Ref: 645
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
59) A primary key is a value in a table that is the foreign key of another table.
Answer: FALSE
Diff: 1 Page Ref: 647
Objective: Understand and Designate Keys
Text: Your Office: Microsoft Office 2013 Volume 1
60) When defining keys, the combination of two fields is called a natural primary key.
Answer: FALSE
Diff: 1 Page Ref: 649
Objective: Understand and Designate Keys
Text: Your Office: Microsoft Office 2013 Volume 1
61) If your data has a unique identifier that is a natural part of your data, you can use the field as a natural primary key.
Answer: TRUE
Diff: 1 Page Ref: 650
Objective: Understand and Designate Keys
Text: Your Office: Microsoft Office 2013 Volume 1
62) Normalization is the process of minimizing the duplication of information in a relational database through effective database design.
Answer: TRUE
Diff: 1 Page Ref: 652
Objective: Understand Basic Principles of Normalization
Text: Your Office: Microsoft Office 2013 Volume 1
63) Redundancy occurs when data is repeated several times in a database.
Answer: TRUE
Diff: 1 Page Ref: 653
Objective: Understand Basic Principles of Normalization
Text: Your Office: Microsoft Office 2013 Volume 1
64) A many-to-many relationship is a relationship between tables in which one record in one table has many matching records in a second table, and one record in the related table has many matching records in the first table.
Answer: TRUE
Diff: 1 Page Ref: 655
Objective: Understand Basic Principles of Normalization
Text: Your Office: Microsoft Office 2013 Volume 1
65) A junction table breaks down the many-to-many relationship into two one-to-many relationships.
Answer: FALSE
Diff: 1 Page Ref: 659
Objective: Create a Many-to-Many Relationship
Text: Your Office: Microsoft Office 2013 Volume 1
66) Redundancy is a database concept that ensures that relationships between tables remain consistent.
Answer: FALSE
Diff: 1 Page Ref: 664
Objective: Understand Referential Integrity
Text: Your Office: Microsoft Office 2013 Volume 1
67) If you select Cascade Update Related Fields when you define a relationship, then when the primary key of a record in the one side table changes, Access automatically changes the foreign keys in all related records.
Answer: TRUE
Diff: 1 Page Ref: 667
Objective: Understand Referential Integrity
Text: Your Office: Microsoft Office 2013 Volume 1
68) A(n) ________ is a person, place, item, or event that you want to keep data about.
Answer: entity
Diff: 1 Page Ref: 626
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
69) A(n) ________ is information about the entity.
Answer: attribute
Diff: 1 Page Ref: 626
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
70) A(n) ________ is an association between tables based on common fields.
Answer: relationship
Diff: 1 Page Ref: 626
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
71) ________ view shows the values of the data within the table.
Answer: Datasheet
Diff: 1 Page Ref: 628
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
72) ________ view shows the structure of the table with the fields and their definitions.
Answer: Design
Diff: 1 Page Ref: 628
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
73) ________ define the kind of data that can be entered into a field, such as numbers, text, or dates.
Answer: Data types
Diff: 1 Page Ref: 629
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
74) Excel ________ are frequently imported as field names.
Answer: column headings
Diff: 2 Page Ref: 631
Objective: Import Data from Other Sources
Text: Your Office: Microsoft Office 2013 Volume 1
75) Access allows you to import a smaller portion of a worksheet, known as a(n) ________, into a table.
Answer: named range
Diff: 1 Page Ref: 633
Objective: Import Data from Other Sources
Text: Your Office: Microsoft Office 2013 Volume 1
76) A(n) ________ is a character such as a tab or comma that separates the fields.
Answer: delimiter
Diff: 1 Page Ref: 634
Objective: Import Data from Other Sources
Text: Your Office: Microsoft Office 2013 Volume 1
77) ________ fields can store up to 1 gigabyte of characters, of which you can display 65,535 characters in a control on a form or report.
Answer: Long Text
Diff: 1 Page Ref: 640
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
78) ________ fields have an upper limit of 255 characters.
Answer: Short Text
Diff: 1 Page Ref: 640
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
79) The ________ data type is used for keys.
Answer: AutoNumber
Diff: 1 Page Ref: 641
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
80) A(n) ________ means that when you open the item, you open it in its original application such as Excel.
Answer: OLE object
Diff: 1 Page Ref: 641
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
81) A(n) ________ lists either values retrieved from a table or query, or a set of values that you specified when you created the field.
Answer: Lookup Wizard
Diff: 1 Page Ref: 641
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
82) The field size indicates the ________ length of a data field.
Answer: maximum
Diff: 1 Page Ref: 641
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
83) The ________ field size is used for large numbers with up to seven significant digits.
Answer: Single
Diff: 1 Page Ref: 642
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
84) The ________ field size is used for integers that range from 0 to 255.
Answer: Byte
Diff: 1 Page Ref: 642
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
85) The ________ field size is used for very large numbers with up to 15 significant digits.
Answer: Double
Diff: 1 Page Ref: 642
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
86) A(n) ________ defines a consistent template and provides the punctuation, so you do not have to type it.
Answer: input mask
Diff: 1 Page Ref: 644
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
87) The ________ property tells Access how data is to be displayed.
Answer: Format
Diff: 1 Page Ref: 645
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
88) The ________ number format displays the number as entered.
Answer: General
Diff: 1 Page Ref: 646
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
89) The ________ number format displays at least one digit after the decimal point.
Answer: Fixed
Diff: 1 Page Ref: 646
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
90) The ________ number format uses the regional settings preset in Windows for the thousands divider.
Answer: Standard
Diff: 1 Page Ref: 646
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
91) ________ is the process of minimizing the duplication of information in a relational database through effective database design.
Answer: Normalization
Diff: 1 Page Ref: 652
Objective: Understand Basic Principles of Normalization
Text: Your Office: Microsoft Office 2013 Volume 1
92) ________ occurs when data is repeated several times in a database.
Answer: Redundancy
Diff: 1 Page Ref: 653
Objective: Understand Basic Principles of Normalization
Text: Your Office: Microsoft Office 2013 Volume 1
93) A(n) ________ relationship is a relationship between tables in which one record in one table has many matching records in a second table, and one record in the related table has many matching records in the first table.
Answer: many-to-many
Diff: 1 Page Ref: 655
Objective: Understand Basic Principles of Normalization
Text: Your Office: Microsoft Office 2013 Volume 1
94) If you select ________ Related Fields when you define a relationship, then when the primary key of a record in the one side table changes, Access automatically changes the foreign keys in all related records.
Answer: Cascade Update
Diff: 1 Page Ref: 667
Objective: Understand Referential Integrity
Text: Your Office: Microsoft Office 2013 Volume 1
95) If you select ________ Related Fields when you define a relationship, any time that you delete records from the one side table, the related records in the many side table are also deleted.
Answer: Cascade Delete
Diff: 1 Page Ref: 667
Objective: Understand Referential Integrity
Text: Your Office: Microsoft Office 2013 Volume 1
96) Match the following terms with their definition.
Answer: D, E, C, A, B
Diff: 1 Page Ref: 626-634
Objective: Understand Database Design
Text: Your Office: Microsoft Office 2013 Volume 1
97) Match the following data types with their description.
Answer: C, A, B, E, D
Diff: 1 Page Ref: 640-641
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
98) Match the following number field sizes with their description.
Answer: C, B, A, D, E
Diff: 1 Page Ref: 642
Objective: Create a Table in Design View
Text: Your Office: Microsoft Office 2013 Volume 1
99) Match the following Date/Time format field properties with the appropriate example.
Answer: B, D, E, C, A
Diff: 2 Page Ref: 646
Objective: Understand Masks and Formatting
Text: Your Office: Microsoft Office 2013 Volume 1
100) Match the following terms with their definition.
Answer: E, B, D, C, A
Diff: 2 Page Ref: 648-650
Objective: Understand and Designate Keys
Text: Your Office: Microsoft Office 2013 Volume 1
Your Office: Microsoft Office 2013, Volume 1 (Kinser et al.)
Excel Module 1 Workshop 2
1) The keyboard shortcut for apply the Comma format is ________.
Answer: C
Diff: 3 Page Ref: 431
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
2) Which of the following is NOT a numerical format?
Answer: A
Diff: 3 Page Ref: 431
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
3) How many options are there for aligning the contents within a cell?
Answer: C
Diff: 3 Page Ref: 435
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
4) is the ________ button.
Answer: C
Diff: 1 Page Ref: 436
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
5) ________ Format Painter allows you to use it multiple times.
Answer: B
Diff: 2 Page Ref: 439
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
6) The Cell Styles gallery is displayed by clicking Cell Styles in the:
Answer: B
Diff: 3 Page Ref: 441
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
7) The Picture dialog box is displayed by clicking Pictures in the:
Answer: A
Diff: 3 Page Ref: 442
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
8) is the ________ button.
Answer: C
Diff: 2 Page Ref: 442
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
9) The Table Styles gallery is displayed by clicking Format as Table in the:
Answer: B
Diff: 3 Page Ref: 443
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
10) To change a table back into a range, you click Convert to Range in the:
Answer: A
Diff: 3 Page Ref: 444
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
11) The Themes gallery is displayed by clicking Themes in the:
Answer: C
Diff: 3 Page Ref: 445
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
12) COUNT, AVERAGE, MIN, and MAX are examples of Excel ________.
Answer: B
Diff: 1 Page Ref: 446
Objective: Create Information with Functions
Text: Your Office: Microsoft Office 2013 Volume 1
13) The AutoSum button is located in the:
Answer: C
Diff: 3 Page Ref: 446
Objective: Create Information with Functions
Text: Your Office: Microsoft Office 2013 Volume 1
14) ________ is the SUM keyboard shortcut.
Answer: B
Diff: 3 Page Ref: 448
Objective: Calculate Totals in a Table
Text: Your Office: Microsoft Office 2013 Volume 1
15) The Total Row check box is located in the ________ group on the DESIGN tab.
Answer: A
Diff: 3 Page Ref: 452
Objective: Calculate Totals in a Table
Text: Your Office: Microsoft Office 2013 Volume 1
16) When cell D4 containing the formula =A4*B5 is copied to cell E2, the formula in cell E2 is________.
Answer: C
Diff: 2 Page Ref: 454
Objective: Create Information with Formulas
Text: Your Office: Microsoft Office 2013 Volume 1
17) The first argument in the SUBTOTAL function identifies the ________.
Answer: D
Diff: 3 Page Ref: 454
Objective: Calculate Totals in a Table
Text: Your Office: Microsoft Office 2013 Volume 1
18) Which of the following lists follows Excels order of operations?
Exponentiation
Addition and subtraction
Multiplication and division
Exponentiation
Multiplication and division
Addition and subtraction
Parentheses
Multiplication and division
Addition and subtraction
Parentheses
Addition and subtraction
Multiplication and division
Answer: B
Diff: 2 Page Ref: 455
Objective: Create Information with Formulas
Text: Your Office: Microsoft Office 2013 Volume 1
19) Which of the following is Excels symbol for multiplication?
Answer: D
Diff: 1 Page Ref: 455
Objective: Create Information with Formulas
Text: Your Office: Microsoft Office 2013 Volume 1
20) Following Excels order of operations, what is the result of the formula =10-4/2*(5-2)?
Answer: D
Diff: 2 Page Ref: 455
Objective: Create Information with Formulas
Text: Your Office: Microsoft Office 2013 Volume 1
21) The Conditional Formatting button is located in the:
Answer: D
Diff: 3 Page Ref: 457
Objective: Use Conditional Formatting to Assist Decision Making
Text: Your Office: Microsoft Office 2013 Volume 1
22) To remove conditional formatting from a range of cells, after selecting the range of cells:
Answer: A
Diff: 3 Page Ref: 463
Objective: Use Conditional Formatting to Assist Decision Making
Text: Your Office: Microsoft Office 2013 Volume 1
23) To hide a row of information, you place the mouse pointer over the row heading:
Answer: D
Diff: 2 Page Ref: 463
Objective: Hide Information in a Worksheet
Text: Your Office: Microsoft Office 2013 Volume 1
24) To hide or show gridlines in a worksheet, you click Gridlines in the:
Answer: B
Diff: 3 Page Ref: 464
Objective: Hide Information in a Worksheet
Text: Your Office: Microsoft Office 2013 Volume 1
25) The Show Formulas button in located in the:
Answer: D
Diff: 3 Page Ref: 465
Objective: Document Functions and Formulas
Text: Your Office: Microsoft Office 2013 Volume 1
26) The keyboard shortcut to hide or show formulas in a worksheet is ________.
Answer: A
Diff: 2 Page Ref: 466
Objective: Document Functions and Formulas
Text: Your Office: Microsoft Office 2013 Volume 1
27) Excel can present information in tabular and graphical formats.
Answer: TRUE
Diff: 1 Page Ref: 430
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
28) The Comma format is just the Accounting format with the currency symbol.
Answer: TRUE
Diff: 2 Page Ref: 431
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
29) is the Currency button.
Answer: FALSE
Diff: 2 Page Ref: 431
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
30) When using the Currency number format, zero values are displayed as a long dash () at the decimal position.
Answer: FALSE
Diff: 3 Page Ref: 433
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
31) When adding a fill color to a cell, the color palette is displayed by clicking the Fill Color button.
Answer: FALSE
Diff: 2 Page Ref: 437
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
32) You should use at most three fonts in a worksheet.
Answer: TRUE
Diff: 3 Page Ref: 439
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
33) A table style is a predefined set of formatting properties that control the appearance of a table.
Answer: TRUE
Diff: 1 Page Ref: 443
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
34) Striping uses alternating background colors of rows or columns to aid in visually tracking information.
Answer: FALSE
Diff: 1 Page Ref: 443
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
35) When using a table, is the Sort arrow.
Answer: FALSE
Diff: 2 Page Ref: 444
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
36) Once a range of data has been converted to a table, it CANNOT be converted back into a range.
Answer: FALSE
Diff: 1 Page Ref: 444
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
37) The default Excel theme is the Office theme.
Answer: TRUE
Diff: 2 Page Ref: 445
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
38) You can apply a different theme to each worksheet in your workbook.
Answer: FALSE
Diff: 2 Page Ref: 445
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
39) Formatting does not change the data value, it only changes its appearance.
Answer: TRUE
Diff: 1 Page Ref: 445
Objective: Format Cells, Cell Ranges, and Worksheets
Text: Your Office: Microsoft Office 2013 Volume 1
40) The AutoSum button is located in the Editing group on the HOME tab.
Answer: TRUE
Diff: 3 Page Ref: 446
Objective: Create Information with Functions
Text: Your Office: Microsoft Office 2013 Volume 1
41) You can use AutoSum function be selecting either the destination cell or the source cell(s).
Answer: TRUE
Diff: 2 Page Ref: 446
Objective: Create Information with Functions
Text: Your Office: Microsoft Office 2013 Volume 1
42) The argument for the COUNT function is limited to a range of contiguous cells.
Answer: FALSE
Diff: 2 Page Ref: 447
Objective: Create Information with Functions
Text: Your Office: Microsoft Office 2013 Volume 1
43) Clicking the AutoSum button displays a list of additional numeric functions such as COUNT and MAX.
Answer: FALSE
Diff: 2 Page Ref: 449
Objective: Create Information with Functions
Text: Your Office: Microsoft Office 2013 Volume 1
44) The MAX function finds the largest number in a range of numeric cells.
Answer: TRUE
Diff: 2 Page Ref: 450
Objective: Create Information with Functions
Text: Your Office: Microsoft Office 2013 Volume 1
45) To find the smallest numerical value in a range of cells, you would use the MIN function.
Answer: TRUE
Diff: 1 Page Ref: 450
Objective: Create Information with Functions
Text: Your Office: Microsoft Office 2013 Volume 1
46) When you format a range as a table, you must name every column in the table.
Answer: FALSE
Diff: 2 Page Ref: 451
Objective: Calculate Totals in a Table
Text: Your Office: Microsoft Office 2013 Volume 1
47) By applying a filter to a table, you can determine which data are shown.
Answer: TRUE
Diff: 1 Page Ref: 451
Objective: Calculate Totals in a Table
Text: Your Office: Microsoft Office 2013 Volume 1
48) Adding a total row to a table only allows you to sum the columns.
Answer: FALSE
Diff: 2 Page Ref: 451
Objective: Calculate Totals in a Table
Text: Your Office: Microsoft Office 2013 Volume 1
49) Only visible data is a table is used by the SUBTOTAL function in calculating results.
Answer: TRUE
Diff: 2 Page Ref: 451
Objective: Calculate Totals in a Table
Text: Your Office: Microsoft Office 2013 Volume 1
50) When first argument in the SUBTOTAL function is in the range 101-111, only the visible values in the specified range are used.
Answer: TRUE
Diff: 3 Page Ref: 454
Objective: Create Information with Formulas
Text: Your Office: Microsoft Office 2013 Volume 1
51) When cell D5 containing the formula =B5+E5 is copied to cell F6, the formula in cell F6 is =D6+G6.
Answer: TRUE
Diff: 2 Page Ref: 454
Objective: Create Information with Formulas
Text: Your Office: Microsoft Office 2013 Volume 1
52) ^ is the symbol used in Excel to indicate multiplication.
Answer: FALSE
Diff: 1 Page Ref: 455
Objective: Create Information with Formulas
Text: Your Office: Microsoft Office 2013 Volume 1
53) Following Excels order of operations, the result of the formula =2^3-6/2 is 1.
Answer: FALSE
Diff: 2 Page Ref: 455
Objective: Create Information with Formulas
Text: Your Office: Microsoft Office 2013 Volume 1
54) Conditional formatting allows you to dynamically change the appearance of cells so that it adds information to your worksheet.
Answer: TRUE
Diff: 1 Page Ref: 457
Objective: Use Conditional Formatting to Assist Decision Making
Text: Your Office: Microsoft Office 2013 Volume 1
55) To remove conditional formatting from a range of cells, you select the range of cells and then press Delete.
Answer: FALSE
Diff: 2 Page Ref: 463
Objective: Use Conditional Formatting to Assist Decision Making
Text: Your Office: Microsoft Office 2013 Volume 1
56) Conditional Formatting is a toggle button.
Answer: FALSE
Diff: 2 P
Once the order is placed, the order will be delivered to your email less than 24 hours, mostly within 4 hours.
If you have questions, you can contact us here