Term
|
How is the ribbon organized?
|
o Tabs
|
|
o Groups
|
|
o Commands
|
|
o Tabs, groups, and commands
|
|
Answer – The ribbon is organized into tabs, groups and commands. |
|
Definition
|
|
Term
|
What keys are shortcuts for opening dialog boxes?
|
o Function Keys
|
|
o Ctrl Key
|
|
o Alt Key
|
|
Answers – The Function keys commonly opens dialog boxes. |
|
Definition
|
|
Term
|
What keys perform quick commands?
|
o Functions Keys
|
|
o Ctrl Keys
|
|
o Alt Keys
|
|
Answers – The Ctrl key commonly performs quick commands.
|
|
Definition
|
|
Term
|
Which types of the following data can cells contain?
|
o Numbers
|
|
o Text
|
|
o Equations
|
|
o All of the above
|
|
|
Answers – Cells can contain numbers, text, and equations. |
|
Definition
|
|
Term
|
The Save As function is found in the Review Tab of the Office Ribbon.
|
Answers – False. It is in the file tab. |
|
Definition
|
|
Term
|
Microsoft_________is used to create budgets, manage accounts, perform mathematical calculations, and convert numerical data into charts and graphs.
· Excel
· Word
· PowerPoint
· Access
|
Answer- Excel |
|
Definition
|
|
Term
|
Microsoft_________________is useful for reports, essays, letters and documentation
· Excel
· Word
· Powerpoint
· Access
|
Answer- WORD |
|
Definition
|
|
Term
|
Microsoft PowerPoint is a program to create?
· Visual Presentations
· Spreadsheets
· Workbooks
· Documents
|
Answer- Visual Presentations |
|
Definition
|
|
Term
|
To locate specific text in your WORD document, you can use the ______________tool?
· Search
· Locate
· Find
· Documents
|
Answer- Find Tool |
|
Definition
|
|
Term
|
Common categories of ______________programs are word processors, spreadsheets, presentation software, and databases.
· Input
· Output
· Enhancement
· Productivity
|
Answer- Productivity Programs
|
|
Definition
|
|
Term
Active Cell
An active cell is the cell in which you are working currently. There can be only one active cell at a time. |
|
Definition
Cell
A cell is formed by the intersection of a row and a column. You can use a cell to store and display different types of data such as text, numbers, or formulas. |
|
|
Term
Cell address
Each cell in a worksheet is identified by a cell address. A cell address is made of the column letter and row number of the cell. For example, the cell formed by the first column and first row has the cell address A1. The cell address indicates the exact location of a cell in a worksheet. |
|
Definition
Cell pointer
A cell pointer is the highlighted rectangular border formed around an active cell. |
|
|
Term
Cell range
A cell range is a block of cells selected to implement a formula in a worksheet. |
|
Definition
Cell value
Cell value is the actual numeric value of the data in a cell. This value might not be the same as the data displayed in the cell. |
|
|
Term
Columns
The vertical divisions in a worksheet are called columns. Each column is identified by a letter. For example, the first column in a worksheet is A. |
|
Definition
Contextual Tabs
Tabs which are displayed only when a particular object type is selected. |
|
|
Term
Cursor
The cursor is a blinking vertical bar on the screen that marks the location at which the inserted text appears. You can also use the cursor to select text or graphics in a document. |
|
Definition
Database
A database contains objects that help you to store, edit, and format information.
|
|
|
Term
Database programs
You use database programs to store and manage data in an organized way. By using these programs, you can also sort or search for the information stored in a database. |
|
Definition
Desktop publishing (DTP) programs
DTP programs are used to combine text and graphics to create documents such as brochures, greeting cards, annual reports, books, or magazines. |
|
|
Term
Flat file database
A flat file database contains all the data in a single table. |
|
Definition
Formula bar
The formula bar is used to enter or modify data in a worksheet. When you type data in a cell, the data is displayed simultaneously in the active cell and in the formula bar. However, when you enter a formula in a cell, the formula is displayed in the formula bar, whereas the numeric value of the formula is displayed in the corresponding cell. |
|
|
Term
Group
A group is a labeled set of closely related commands. |
|
Definition
Label
A label is a text entry that is used to identify the type of information in a row or a column of a worksheet. Labels do not have any cell value associated with them.
|
|
|
Term
Mouse
The mouse is the primary input device used to interact with objects in Microsoft Windows. |
|
Definition
Pointer
The on-screen arrow or shape that moves when you move your mouse or other pointing device. It changes to a variety of shapes to indicate its current behavior. |
|
|
Term
Presentation software
You can use presentation software to combine graphics and text to create presentations. |
|
Definition
Productivity software
These are specialized programs that help you create and work with various types of documents. Common categories of productivity software are word processors, spreadsheets, presentation software, and databases. |
|
|
Term
Programs
A sequence of instructions that can be executed by a computer. A program is also known as software. |
|
Definition
Query
A query is a database object that enables you to locate the desired information in a database. |
|
|
Term
Relational database
A relational database stores data in multiple tables. |
|
Definition
Reports
You can create reports in a database program, such as Access 2007, to organize, summarize, and perform calculations on data stored in a database. |
|
|
Term
Rows
The horizontal divisions in a worksheet are called rows. Each row is identified by a number. For example, the first row in a worksheet is 1. |
|
Definition
Scroll bars
Scroll bars are vertical and horizontal bars located at the side or at the bottom of a display area. You can use scroll bars to move to a specific location in the work area |
|
|
Term
Spreadsheets
You use spreadsheet programs to create budgets, manage accounts, perform mathematical calculations, and convert numerical data into charts and graphs. |
|
Definition
Status bar
The status bar is a horizontal bar that is at the bottom of some productivity programs. This bar displays information about the current status of the program or document that you are viewing. |
|
|
Term
Title bar
The title bar is the horizontal bar that contains the name of the window. Most title bars also contain buttons to close, minimize, and resize the window. |
|
Definition
Toolbar
The toolbar is a block of buttons or menus that you can use to quickly perform common tasks. |
|
|
Term
Word processors
Word processors are used to create and modify text-based documents.
|
|
Definition
|
|
Term
Work area
The work area is the blank space within the program where you enter information. |
|
Definition
Workbook
A workbook is a file created in Excel 2007. A workbook can contain one or more worksheets and related items. |
|
|
Term
Worksheet
A spreadsheet is called a worksheet in Excel 2007. |
|
Definition
X-axis
The x-axis is the horizontal line in a chart. Typically, you show time on the x-axis. |
|
|
Term
Y-axis
The y-axis is the vertical line in a chart. |
|
Definition
|
|
