Chapter 5

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

• 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

• PDF

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


संबंधित स्टडी सेट्स

5.3 Solving Trig Equations by RHO

View Set

APES Final Exam (Practice Test 6)

View Set

Food Final Material, Food Quizzes, Food Final Prep

View Set

Chapter 11 Book-specific Clinical Case Activity 10 of 24

View Set

Teaching & Learning / Patient Education

View Set