Specialized Functions (Chapter 7) Multiple Choice Questions Study Guide
1. A workbook
contains a list of university students. You want to identify the total number
of students who are seniors and who are majoring in biology. Without modifying the
Datasets and Tables (Chapter 4) Multiple Choice Questions Study Guide
1.) You have a large dataset that will print on several pages. You want to ensure that related
records print on the same page with column and row labels visible and that confidential
What-If Analysis (Chapter 6) Multiple Choice Questions Study Guide
1.) In the solver parameters dialog box, the _ cell must always contain a formula.
A.) Changing Variable
2.) When using the Goal Seek Command, how m
Formulas and Functions (Chapter 2) Multiple Choice Questions Study Guide
1.) If cell D15 contains the formula =$C$5*D15, what is the D15 in the formula?
A.) Mixed Reference
C.) Circular Reference
D.) Range Name
2.) What function woul
Subtotals, PivotTables, and PivotCharts (Chapter 5) Multiple Choice
Questions Study Guide
1.) A worksheet contains data for businesses that are sponsoring this years Arts Festival.
The worksheet contains these columns in this sequence: Business Name, Addr
Microsoft Excel Vocabulary Terms
Shows common gallery choices on the Ribbon rather than in a dropdown list
New characters being added to existing characters
Blinking vertical line that shows were your text or object w
Introduction to Access (Chapter 1) Multiple Choice Questions Study Guide
1.) Which sequence represents the hierarchy of terms, from smallest to largest?
A.) Database, table, record, field
B.) Field, record, table, database
C.) Record, field, table, databa
Relational Databases and Queries (Chapter 2) Multiple Choice Questions
1.) When entering, deleting, or editing table data:
A.) The table must be in Design View
B.) The table must be in Datasheet View
C.) The table may be in either Datasheet or
Creating and Using Professional Forms and Reports Data (Chapter 4)
Multiple Choice Questions Study Guide
1.) Which form tool does not place controls onto a form automatically?
A.) Form Wizard
B.) Form Tool
C.) Form Design Tool
D.) Datasheet Tool
2.) The d
Customize, Analyze, and Summarize Query Data (Chapter 3) Multiple Choice
Questions Study Guide
1.) Which of the following correctly identifies the rules for the order of operations?
A.) Exponentiation, parentheses, addition, subtraction, multiplication, d
Mike Gemmati Mr. Bossert CIS 106.02 November 25th 2007 Computer Ethics As of September 2003, there were approximately 70 million Americans or about 62 percent of the American population had at least one home computer. Another statistic is that about