Content Frame
Note for screen reader users: There is text between the form elements on this page. To be sure that you do not miss any text, use item by item navigation methods, rather than tabbing from form element to form element.
Skip Breadcrumb Navigation
Home  arrow Chapter 5: Managing Large Workbooks and Using Advanced Sorting and Filtering  arrow Online Study Guide

Online Study Guide



This activity contains 25 questions.

Question 1.
Use the __________________ command to set the column and row titles so they remain on the screen while you scroll.


Open Hint for Question 1 in a new window.
 
End of Question 1


Question 2.
When you print a worksheet that has columns hidden, the hidden columns will print.


Open Hint for Question 2 in a new window.
   
 
End of Question 2


Question 3.
When you want to view separate parts of a worksheet at the same time use the _______________ command.


Open Hint for Question 3 in a new window.
 
End of Question 3


Question 4.
A _____________ is a predesigned set of colors, fonts, lines, and fill effects that look good together that can be applied to your entire Office 2010 file or to specific items.


Open Hint for Question 4 in a new window.
 
End of Question 4


Question 5.
When you create a custom style that style will be available in all other workbooks.


Open Hint for Question 5 in a new window.
   
 
End of Question 5


Question 6.
When printing your worksheets, __________ reduces the horizontal and vertical size of the printed data by a percentage or by the number of pages you specify.


Open Hint for Question 6 in a new window.
 
End of Question 6


Question 7.
The color scheme for Hyperlinks cannot be changed.


Open Hint for Question 7 in a new window.
   
 
End of Question 7


Question 8.
When you save a 2010 Excel file the file extension is .xlsx.


Open Hint for Question 8 in a new window.
   
 
End of Question 8


Question 9.
This type of file can be readily exchanged with various database programs: _____________.


Open Hint for Question 9 in a new window.
 
End of Question 9


Question 10.
The format used to publish a document and ensure that the appearance of the document is the same no matter what computer it is displayed on is called _______________?


Open Hint for Question 10 in a new window.
 
End of Question 10


Question 11.
A(n) ___________ sort arranges data alphabetically from A to Z, numbers from lowest to highest, or dates and times from earliest to latest.


Open Hint for Question 11 in a new window.
 
End of Question 11


Question 12.
You can only sort data in a worksheet on one criterion at a time.


Open Hint for Question 12 in a new window.
   
 
End of Question 12


Question 13.
When using a custom list to sort, Excel 2010 includes day-of-the-week and month-of-the-year lists.


Open Hint for Question 13 in a new window.
   
 
End of Question 13


Question 14.
____________ displays only the rows that meet the criteria or conditions that you specify to limit which records are included in the results.


Open Hint for Question 14 in a new window.
 
End of Question 14


Question 15.
You would use a(n) _________to specify three or more criteria for a particular column, to apply complex criteria to two or more columns, or to specify computed criteria.


Open Hint for Question 15 in a new window.
 
End of Question 15


Question 16.
You can also use an advanced filter for __________, copying selected rows to another part of the worksheet.


Open Hint for Question 16 in a new window.
 
End of Question 16


Question 17.
When you use an AutoFilter, the filter type is mutually exclusive for the column, meaning you can only use one at a time.


Open Hint for Question 17 in a new window.
   
 
End of Question 17


Question 18.
When comparing two values using comparison operators such as Equals (=), Greater Than (>), or Less Than (<), your result is a logical value that is either true or false.


Open Hint for Question 18 in a new window.
   
 
End of Question 18


Question 19.
The asterisk (*) is a _____________, use this to search a field when you are uncertain of the exact value or if you want to widen the search to include most records.


Open Hint for Question 19 in a new window.
 
End of Question 19


Question 20.
You can use any symbol as part of your search criteria to find a single unknown character.


Open Hint for Question 20 in a new window.
   
 
End of Question 20


Question 21.
The first step in adding subtotals is to sort the data by the field for which you want to create a subtotal.


Open Hint for Question 21 in a new window.
   
 
End of Question 21


Question 22.
In an outline there are three types of controls: Hide details (-), Show details (+), and Subtotals.


Open Hint for Question 22 in a new window.
   
 
End of Question 22


Question 23.
Detail data refers to the subtotaled rows that are totaled and summarized.


Open Hint for Question 23 in a new window.
   
 
End of Question 23


Question 24.
Match the following terms to their meanings:




Open Hint for Question 24 in a new window.
A matching question presents 4 answer choices and 4 items. The answer choices are lettered A through D. The items are numbered 24.1 through 24.4. Screen readers will read the answer choices first. Then each item will be presented along with a select menu for choosing an answer choice. Using the pull-down menus, match each item in the left column to the corresponding item in the right column.
A Sets the column and row titles so that they remain on the screen while you scroll.
B Portion of a worksheet bounded by and separated from other portions by vertical or horizontal lines.
C To select specific text, formatting, or a type of information within the workbook correctly.
D Move cells that have special characteristics; for example, to cells that are blank or to cells that contain constants as opposed to formulas.
[hint] 
[hint] 
[hint] 
[hint] 
End of Question 24


Question 25.
Match the following terms to their meanings:




Open Hint for Question 25 in a new window.
A matching question presents 4 answer choices and 4 items. The answer choices are lettered A through D. The items are numbered 25.1 through 25.4. Screen readers will read the answer choices first. Then each item will be presented along with a select menu for choosing an answer choice. Using the pull-down menus, match each item in the left column to the corresponding item in the right column.
A Use of two or more criteria on the same row.
B Copying the selected rows to another part of the worksheet instead of displaying the filtered text.
C Used to specify three or more criteria for a particular column, to apply complex criteria to two or more columns, or to specify computed criteria.
D Used to apply complex criteria to a single column.
[hint] 
[hint] 
[hint] 
[hint] 
End of Question 25





Copyright © 1995 - 2013 Pearson Education . All rights reserved. Pearson Prentice Hall is an imprint of Pearson .
Legal Notice | Privacy Policy | Permissions

Return to the Top of this Page