Excel Chapter 5: End of Chapter Quiz Already Passed

Document Content and Description Below

Excel Chapter 5: End of Chapter Quiz Already Passed Freeze Panes ✔✔The command to set the column and row headings so that they remain on the screen while you scroll to other parts of the worksh... eet. Arrange All ✔✔The command that tiles all open program windows on the screen. Cell Styles ✔✔A set of formatting characteristics that you can apply to a cell Hyperlink ✔✔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. CSV (comma separated values file) ✔✔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. PDF (portable document format) ✔✔The file type developed by Adobe Systems that is a visual representation of a document. Ascending ✔✔Values sorted from A to Z Database ✔✔An organized collection of facts related to a specific topic Record ✔✔All of the categories of data pertaining to one person, place, thing, event, or idea. Criteria ✔✔The term used for conditions that you specify that must be matched for the record to be included in the search results Query ✔✔The term that refers to asking a question of the data in a database AutoFilter menu ✔✔The term used for conditions that you specify that must be matched for the record to be included in the search results. Comparison operators ✔✔The Equal sign (=), Greater Than sign (>), or Less Than sign (<) used singly or in combinations to compare two values. Wildcard ✔✔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. Extract ✔✔To pull out multiple sets of data for comparison purposes find ✔✔The command that locates and selects specific text, formatting, or type of information within a workbook quickly is: pane ✔✔A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars is a: Go To ✔✔Command used to move to a specific cell or range of cells in a large worksheet theme ✔✔A predesigned set of colors, fonts, lines, and fill effects that look good together is a: scaling ✔✔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: .xlsx ✔✔The default file format for Excel 2016: tab delimited text file ✔✔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: HTML ✔✔A language web browsers can interpret sort ✔✔To organize data in a particular order is to: descending order ✔✔Numbers sorted from highest to lowest are sorted in: field ✔✔A single piece of information that is stored in every record: custom list ✔✔A sort order that you can define is a: And comparison operator ✔✔The operator that requires each and every one of the comparison criteria that you specify must be true is the: major sort ✔✔A term sometimes used to refer to the first sort level in the Sort dialog box is: extract area ✔✔The area where you place the results when copying the results of a filter to another location in the worksheet: [Show More]

Last updated: 2 years ago

Preview 1 out of 5 pages

Buy Now

Instant download

We Accept: