Computer Science > QUESTIONS & ANSWERS > Excel Chapter 5: End of Chapter Quiz Already Passed (All)

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:

We Accept
document-preview

Buy this document to get the full access instantly

Instant Download Access after purchase

Buy Now

Instant download

We Accept:

We Accept

Also available in bundle (1)

EXCEL BUNDLED EXAMS QUESTIONS AND ANSWERS (2022/2023) WITH VERIFIED SOLUTIONS

EXCEL BUNDLED EXAMS QUESTIONS AND ANSWERS (2022/2023) WITH VERIFIED SOLUTIONS

By Nutmegs 2 years ago

$30

29  

Reviews( 0 )

$9.00

Buy Now

We Accept:

We Accept

Instant download

Can't find what you want? Try our AI powered Search

100
0

Document information


Connected school, study & course


About the document


Uploaded On

Apr 26, 2023

Number of pages

5

Written in

Seller


seller-icon
Nutmegs

Member since 4 years

622 Documents Sold

Reviews Received
77
14
8
2
21
Additional information

This document has been written for:

Uploaded

Apr 26, 2023

Downloads

 0

Views

 100

Document Keyword Tags


$9.00
What is Scholarfriends

In Scholarfriends, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.

We are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Scholarfriends · High quality services·