Excel Chapter 5 Intro To Business

A language web browsers can interpret A. HTML B. XPS C. PDF

A

A predesigned set of colors, fonts, lines, and fill effects that look good together is a: A. list B. theme C. text file

B

The default file format for Excel 2016: A. .xlsx B. XPS C. CSV

A

The area where you place the results when copying the results of a filter to another location in the worksheet: A. extract area B. active area C. criteria range

A

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: A. tab delimited text file B. PDF file C. .xlsx file

A

A portion of a worksheet window bounded by and separated from other portions by vertical or horizontal bars is a: A. border B. pane C. window

B

A sort order that you can define is a: A. defined list B. custom list C. custom sort

B

Command used to move to a specific cell or range of cells in a large worksheet: A. Find B. Go To C. List

B

The operator that requires each and every one of the comparison criteria that you specify must be true is the: A. Or comparison operator B. And comparison operator C. Detail comparison operator

B

A single piece of information that is stored in every record: A. database B. query C. field

C

A term sometimes used to refer to the first sort level in the Sort dialog box is: A. advanced sort B. minor sort C. major sort

C

The command that locates and selects specific text, formatting, or type of information within a workbook quickly is A. match B. sort C. find

C

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: A. extracting B. arranging C. scaling

C

To organize data in a particular order is to: A. filter B. sort C. query

B

Numbers sorted from highest to lowest are sorted in: A. descending order B. ascending order C. major order

A