Computer Review for 2nd Semester Final
About this set
Created by:
elizaorr98 on May 11, 2012
Subjects:
Classes:
Log in to favorite or report as inappropriate.
Order by
55 terms
Terms | Definitions |
|---|---|
 Access | ___________________ is a program known as a database management system (DBMS) |
| faster, flexible, accurate | Some of the benefits of a computerized DBMS are (3): |
| store; retrieve; analyze; print | A DBMS allows you to: a) _____________ information b) _____________ information c) _____________ information d) _____________ information |
| records | A database is a collection of _______ |
| record | A __________ is a complete set of data |
| fields | Each record is made up of one or more ________ |
| permanent | To delete a record from a table, select the record and then press the Delete key. After you've deleted a record, you cannot use the Undo button or press the Esc key to restore it. Deleting a record is ____________ |
| query | A _________ is a question you ask the database. |
| report | A _________ is commonly used to summarize data and to calculate totals. |
| compacting | _______________ a database rearranges how the database is stored on the disk and optimizes the performance of the database. |
| numbers | The purpose of the spreadsheet is to solve problems that involve _____________ |
| spreadsheet | A ___________________ is a grid of rows and columns in which you enter text, numbers, and the results of calculations. |
| worksheet | In Excel, a computerized spreadsheet is called a ____________. |
| columns | ____________ of the worksheet appear vertically, and are identified by letters at the top of the worksheet window. |
| rows | ________ appear horizontally and are identified by numbers on the left side of the worksheet window. |
| cell | A ____ is the intersection of a row and column. |
| formula | A _____________ is an equation that calculates a new value from values currently in a worksheet, such as adding the numbers in cell A1 and A2. |
| workbook | The file used to store worksheets is called a _________ |
| a) calculating a budget b) calculating grades c) payments for a loan | Spreadsheets have many uses. A few examples are (3): |
| name box; active cell; column letter; row number | Excel has some of the same basic parts as the other Office programs, but also has some additional buttons and parts. Name 4 of the additional buttons and parts of Excel. |
| numbers; text; formulas | Worksheet cells can contain (3): |
| print preview | Before you use the resources to print a worksheet, you should use ________ __________ to see how the printed pages will look. |
| AutoFit | ___________ determines the best width for a column or the best height for a row based on its contents. |
| truncated | Text that is too long to fit within a cell is displayed in the next cell, if it is empty. If the next cell already contains data, any text that does not fit in the cell is ____________, or hidden from view. |
| range | A group of selected cells is called a _________. |
| live preview | As you format cells, ______ ___________ shows the results of the different formatting options you can choose. |
| fill | The default ______ color of cells is white, but you can change this background color to help accentuate certain cells, such as descriptive labels or totals. |
| border | You can add emphasis to a cell by placing a _________ around its edges. |
| black cross | When you place the pointer over the fill handle, it changes to a _________ __________. |
| fill handle | The ______ __________ appears in the lower-right corner of the active cell or range. |
| number signs | Numbers that do not fit in the cell are shown as a series of __________ ________. |
| toggle | A command that you use by turning a feature on or off is known as a _________ command. |
| undo | When working on a document, you will sometimes delete text accidentally or change your mind about editing or formatting changes that you made. The ________ command is useful in these situations because it reverses recent actions. |
| operands | Worksheet formulas consist of two components: ___________ and operators. |
| Absolute | __________ cell references do not change when copied or moved to a new cell. |
| relative | A ________ cell reference adjusts to its new location when copied or moved. |
| mixed | Cell references that contain both relative and absolute references are called _________ cell references. |
| database | A __________ is a collection of objects. The objects work together to store, retrieve, display, and summarize data and also to automate tasks. |
| fields | In a database, each record is made up of one or more __________. |
| record selector | A _________ ___________ appears to the left of the first field for each record in the database. |
| query | A _________ is a database object that lets you ask the database about the data is contains. |
| filter | A _______ temporarily displays records in a datasheet based on the condition that you specify. |
| thumbnails | The Slides tab and the Outline tab contain _______________ or small images of the selected slide that you are working on. |
| Animation | _______________ is text, objects, graphics, or pictures that have motion in a PowerPoint presentation. |
| Transition | _______________ refers to the way each new slide appears on the screen during a PowerPoint presentation. |
| slide pane | The ________ _________ is the workbench for PowerPoint presentations. It displays one slide at a time and is useful for adding and editing text, inserting and formatting illustrations or objects, or generally modifying a slide's appearance. |
| logo | A _________ is a symbol that is designed to help customers remember a business and its products. |
| MS Publisher | ___________________ is a desktop publishing program that lets you create newsletters, greeting cards, business cards, calendars, and much more. |
| Objects | __________ are any items that can be modified in Publisher using the provided tools and features. |
| content library | The ________ __________ is a task pane used for storing text and graphics for future use. |
| Word | .docx |
| .xlxs | What is the file extension for Excel? |
| .pptx | What is the file extension for PowerPoint? |
| Access | .accdb |
| .pub | What is the file extension for Publisher? |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.
Completed “Learn” mode
studybuddies3 , brookie-brown22 , ilovepink97 , caraash , blakerblaker , elizaorr98