Loading

Module 1: Productivity Programs

Notes
Study Reminders
Support
Text Version

2.6 Advanced Keyboard Techniques

Set your study reminders

We will email you at these times to remind you to study.
  • Monday

    -

    7am

    +

    Tuesday

    -

    7am

    +

    Wednesday

    -

    7am

    +

    Thursday

    -

    7am

    +

    Friday

    -

    7am

    +

    Saturday

    -

    7am

    +

    Sunday

    -

    7am

    +

Advanced Keyboard Techniques
*
*
* [Show Transcript] ADVANCED KEYBOARD TECHNIQUES

You use the function keys for special tasks in different programs. For
example, you use the F1 key to display the Help file associated with a
program. The tasks of the function keys are specific to each program. For
example, when you press the F5 key in PowerPoint 2007, it starts a slide
show, whereas when you press the same key in Word 2007, it displays the
Find and Replace dialog box.

You use the navigation keys to control the movement of the cursor. These
keys include HOME, END, PAGE UP, PAGE DOWN and four arrow keys. The HOME
key usually moves the cursor to the start of a line or a document. The END
key moves the cursor to the end of a line or a document. The PAGE UP and
the PAGE DOWN keys move the cursor up or down, one screen at a time. The
number of lines that it moves will vary depending on the size of your
monitor. You can also use the four arrow keys to move the cursor vertically
or horizontally on the display screen.

Keyboard shortcuts are key combinations usually involving command keys
that help you quickly perform an action without using the menus or toolbar
icons. For example, you can press CTRL+P to print the current document by
using the default printer settings.

While working with different programs, you may have to insert special
characters and symbols. On a standard keyboard, you do not have dedicated
keys for specific characters and symbols. For example, you may want to
enter the copyright symbol in a document, and there is no dedicated key for
it. However, you can insert special characters by using a combination of
specific keys on a standard keyboard. To enter the copyright symbol, you
can press ALT+0169. GLOSSARY

-------------------------
A

Active Cell

An active cell is the cell in which you are working currently. There can
be only one active cell at a time.
-------------------------
C

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.

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.

Cell pointer

A cell pointer is the highlighted rectangular border formed around an
active cell.

Cell range

A cell range is a block of cells selected to implement a formula in a
worksheet.

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.

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.


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.
-------------------------
D

Database

A database contains objects that help you to store, edit, and format
information.

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.

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.
-------------------------
F

Flat file database

A flat file database contains all the data in a single table.

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.
-------------------------
L

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.
-------------------------
M

Mouse pointer

The mouse pointer is an on-screen arrow or other shape that moves when you
move the mouse or other pointing device.
-------------------------
P

Presentation software

You can use presentation software to combine graphics and text to create
presentations.

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.

Programs

A sequence of instructions that can be executed by a computer. A program
is also known as software.
-------------------------
Q

Query

A query is a database object that enables you to locate the desired
information in a database.
-------------------------
R

Relational database

A relational database stores data in multiple tables.

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.


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.
-------------------------
S

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.

Spreadsheets

You use spreadsheet programs to create budgets, manage accounts, perform
mathematical calculations, and convert numerical data into charts and
graphs.

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.
-------------------------
T

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.

Toolbar

The toolbar is a block of buttons or menus that you can use to quickly
perform common tasks.
-------------------------
W

Word processors

Word processors are used to create and modify text-based documents.

Work area

The work area is the blank space within the program where you enter
information.

Workbook

A workbook is a file created in Excel 2007. A workbook can contain one or
more worksheets and related items.

Worksheet

A spreadsheet is called a worksheet in Excel 2007.
-------------------------
X

x-axis

The x-axis is the horizontal line in a chart. Typically, you show time on
the x-axis.
-------------------------
Y

y-axis

The y-axis is the vertical line in a chart. Lesson 2 - COMMON
FEATURES AND COMMANDS 2.6 - ADVANCED KEYBOARD TECHNIQUES
[15]



Links:
------
[1] http://alison.com/#A
[2] http://alison.com/#C
[3] http://alison.com/#D
[4] http://alison.com/#F
[5] http://alison.com/#L
[6] http://alison.com/#M
[7] http://alison.com/#P
[8] http://alison.com/#Q
[9] http://alison.com/#R
[10] http://alison.com/#S
[11] http://alison.com/#T
[12] http://alison.com/#W
[13] http://alison.com/#W
[14] http://alison.com/#W
[15]
http://alison.com/mod/scorm/player.php?a=305¤torg=eXeRM_Module34823c6301d286658d32&scoid=14567