Chapter 5
• By default, Excel 2013 files are saved with the _____ file name extension
o .xlsx
• The default file format for Excel 2013
o .xlsx
• Wildcard
o A character such as the asterisk (*) used to search a field when you are uncertain of the exact value or when you want to widen the search to include more records
• File name extension
o A file name extension is a set of characters that helps the Windows operating system understand what program should open it
• AutoFilter menu
o A menu of filtering commands that displays when you click one of the filter arrows in an Excel table
• Cell styles
o A set of formatting characteristics that you can apply to a cell
• Record
o All of the categories of data pertaining to one person, place, thing, event, or idea
• Database
o An organized collection of facts related to a specific topic
• The operator that requires each and every one of the comparison criteria that you specify must be true is the:
o And comparison operator
• A(n) __________ sort refers to text that is alphabetical from A to Z
o Ascending
• Saving an Excel worksheet as a(n) ___________ file will save the contents of the cells by placing commas between them
o CSV
• A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars is a:
o pane
• The page formatting that reduces the horizontal and vertical size of the printed data by a percentage or by the number of pages that you specify is:
o scaling
• The file type that saves an Excel file with tabs between each cell in a row and a paragraph return at the end of each row:
o tab delimited text file
• A predesigned set of colors, fonts, lines, and fill effects that look good together is a:
o theme
• To organize data in a particular order is to:
o Sort
• Hyperlink
o Colored and underlined text that, when clicked, takes you to another location in the worksheet, to another file, to a Web page on the Internet, or on your organization's intranet
• The Sort button can be found in the Sort & Filter group on the ___________ tab
o DATA
• If you have hidden columns or rows in your workbook, they will still display when printed
o False
• When you save a worksheet as a webpage, Excel changes the contents of the worksheet into JavaScript format
o False
• Wildcards cannot be used in Advanced Filtering
o False
• Freeze Panes
o Freeze Panes is the command that sets the column and row titles so that they remain on the screen while you scroll
• Arrange All
o Freeze panes
• Command used to move to a specific cell or range of cells in a large worksheet:
o Go To
• To move to a specific cell or a range of cells in a large worksheet, use the ___________ command
o Go To
• Use the _________ command to quickly locate cells with special characteristics, such as blank cells
o Go To Special
• HTML
o HTML is a language web browsers can interpret
• The two sets of fonts combined in a theme include a text font and a __________ font
o Headings
• You can use a(n) ________ to connect to another file or a webpage on the Internet
o Hyperlink
• XPS was developed by ___________
o Microsoft
• You will find the Themes gallery in the Themes group on the ___________ tab
o PAGE LAYOUT
• Panes
o Panes are the portions of a worksheet window bounded by and separated from other portions by vertical or horizontal lines
• _____________ can be applied to force the worksheet to print within a selected number of pages
o Scaling
• To sort data based on several criteria at once, use the ______
o Sort dialog box
• Arrange All command
o The Arrange All command tiles all open Excel windows on the screen
• Comparison operators
o The Equal sign (=), Greater Than sign (>), or Less Than sign (<) used singly or in combinations to compare two values
• Split command
o The Split command divides the window into multiple resizable panes to view distant parts of your worksheet at once
• Freeze Panes
o The command to set the column and row headings so that they remain on the screen while you scroll to other parts of the worksheet
o The file type developed by Adobe Systems that is a visual representation of a document
• CSV file
o The file type that saves an Excel file so that there is a comma between each cell and a paragraph return at the end of each row
• Query
o The term that refers to asking a question of the data in a database
• Criteria
o The term used for conditions that you specify that must be matched for the record to be included in the search results
• Extract
o To pull out multiple sets of data for comparison purposes
• By using a custom filter, you can use comparison criteria to compare two values
o True
• Excel includes a day-of-the-week custom list, which allows for chronological sorting of the days
o True
• Excel provides features that help you to control the screen display so you can navigate and locate information quickly even on a large worksheet
o True
• If the file to which a hyperlink refers is moved, the hyperlink must be modified to reflect the change
o True
• The Page Break Preview window displays blue dashed lines to show where the page breaks are located
o True
• The first step in adding subtotals is to sort the data by the field for which you want to create a subtotal
o True
• When you want someone to be able to view a document but not change it, use either a PDF or XPS format
o True
• You can add subtotals to a list by first sorting the data by the field for which you want to create a subtotal
o True
• Ascending
o Values sorted from A to Z
• The file type developed by Microsoft that is a visual representation of a document is:
o XPS
• The term that describes filtering actions in which each additional filter that you apply is based on the current filter is:
o additive
• The use of two or more criteria on the same row-all conditions must be met for the records to be included in the results:
o compound criteria
• Numbers sorted from highest to lowest are sorted in:
o descending order
• The area where you place the results when copying the results of a filter to another location in the worksheet:
o extract area
• A single piece of information that is stored in every record:
o field
• The command to find and select specific text, formatting, or type of information within a workbook quickly is:
o find