CISS100 Ch6

WORD PROCESSING CONCEPTS

...

SPREADSHEET CONCEPTS

EXCEL

Cell

The location at the intersection of a row and column on a worksheet into which data can be typed.

Table tools contextual tab

used to change the design or layout of a table; available only when a table is selected.

Formulas

used to compute calculations

Insert tab

used to insert a table, picture, shape, or other object into the document.

Altair Engineering (software vendor)

uses license tokens - that are drawn from a central license server when the application is running and returned to the server when the application is finished.

Font Dialog Box Launcher

where is the small check box located to open the Font dialog box

Single-user license

you cannot legally make copies of the installation cd

Advantage of web-base software

can be accessed from any computer with an internet connection.

Live Preview

changes the appearance of selected items when a formatting command is pointed to

Editing

changing the content of a document, such as inserting or deleting words

4 basic categories of software

commercial, shareware, freeware, and public domain software.

Graphing or drawing features

commonly found in word processing programs

Cell address

consists of the column letter followed by the row number, such as B4 or E22

Home Tab

contains the most frequently used commands in that program

Mobile voice search

one growing mobile application

Disadvantage of web-base software

online applications tend to run more slowly, can not access if the internet goes down.

Common software commands

open ctrl+O, Save ctrl+S, etc

File tab

opens the Backstage view

Application software

programs that allow you to perform specific tasks on your computer, writing a letter, preparing an invoice, music, webpage, etc

Spreadsheet software

provides users with a convenient means of creating documents containing complex mathematical calculations

Word Processing

refers to using a computer and word processing software to create, edit, save, and print written documents, such as letters, contracts, manuscripts, newsletters, invoices, marketing material, and reports.

Rich Text Format

(.rtf) Universal extension

Word document extension

.docx (older .doc)

Spreadsheet

A document containing a group of values and other data organized into rows and columns; also called a worksheet in a spreadsheet program.

Ribbon

A feature found in recent versions of Microsoft Office that used tabs to

Table feature

A feature in Microsoft Word that allows you to easily align text in columns and rows.

Styles

A gallery of text formatting that can be applied quickly to paragraphs and characters

Horizontal software

A generic software that just about any kind of business can use

Freeware

Copyrighted software that may be sued free of charge. (MS IE, Real's Real Player). Widely available over the internet.

Function

A named formula that can be entered into a worksheet cell to perform some type of calculation or to extract information from other cells in the worksheet. There are hundreds of functions that can be used in spreadsheets for statistical, date and time, engineering, math, logical, and text-based computations.

Worksheet

A single spreadsheet document in a spreadsheet program

Mini toolbar

A small toolbar that appears when the mouse pointer is placed on a selected text object; provides commands for working with the text.

Installed software

A software program that must be installed on a computer before it is run.

Contextual tab

A tab containing groups of buttons that represent commands for customizing and formatting the selected object.

Backstage view

A view that replaces the File menu that appeared in previous versions of Office. contains common command such as open, save, print, send, and publish.

Software license

An agreement, either included in a software package or displayed on the screen during installation, that specifies the conditions under which a buyer of the program can use it.

ASPs

Application service providers are companies that deliver Saas

Spreadsheet software

Application software used to create spreadsheets, which typically contain a great deal of numbers and mathematical computations organized into rows and columns.

Word processing software

Application software used to create, edit, save, and print documents. typically include improved collaboration, security, and rights-management tools.

Document formatting

Arranging or settling out data in a specific way

Menu bar

At the top of the screen, a listing of the names of menus, each of which contains a set of commands

Formatting

Changing the appearance of a document, such as changing the margins or font size.

Shareware

Copyrighted software distributed free of charge on a trial basis with payment by the honor system.

Commercial software

Copyrighted software that is developed, usually by a commercial company and sold for a profit. (MS Office, turbo tax, garageBand). users can obtain a site license or network license. demo or trial versions may be available - but missing key features

Free online office suites

Google Docs, ThinkFree Online, Zoho.

Icons

Graphic images or symbols that represent applications

Freeware

IE, OpenOffice.org, Quick Time player, Yahoo!Missenger

Column

In a spreadsheet program, a vertical group of cells on a worksheet

Free alternative office suites

LibreOffice and OpenOffice.org

Public domain

Lynx, Quake 3

Commercial Software examples

MS Office, Norton AnitVirus, Adobe photoshop, World of Warcraft

Frequently used Word processing program

Microsoft Word, Corel WordPerfect, Apple Pages (all a part of software suites)

MS Office

One of the most widely used office software suites

Copyrights

Ownership rights for original creative works

what-if analysis

Process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet. Experiment with various possible scenarios.

Vertical software

Software designed for a specific purpose

Open source software

Software programs made up of source code that is available to the public. can be copywrited

Web-based software (Saas)

Software that is delivered on demand via the Web; also referred to as Software as a Service and cloudware.

Public domain software

Software that is not copyrighted and is free to copy and distribute without restriction

Paragraph formatting

The process of changing the appearance of a paragraph.

Character formatting

The process of changing the way characters appear on the screen and in print.

Shareware

WinZip, Video Edit Magic, Image Shrinker ,Deluxe Ski Jump 3

Font style

bold, italic or underline

Software suite

a collection of software programs bundled together and sold as a single software package.

Workbook

a collection of worksheets saved in a single spreadsheet file

Keyboard shortcuts

a combination of keyboard keys that are pressed in unison to issue a specific software command.

Template

a document that is already created and formatted to fit a particular purpose, such as a fax cover sheet, resume, memo, business card, calendar, invoice, newsletter, or web page.

Google Docs

a fee Web-based office suite

The data entered into a cell is usually ...

a label, a constant value, a formula, or a function.

font face or typeface

a named collection of text characters that share a common design, such as Calibiri or Times New Roman

Range or block

a selected group of cells. Ranges are always rectangular and are identified by specifying two opposite corners of the range, such as D8 through E9.

Label

a text-based entry in a worksheet cell that identifies data on the worksheet

message boards

a web site where you can post messages and reply to messages posted by others

Presentation graphics software

allows users to create visual presentatoin to convey information more easily to others.

Word processing software

allows users to easily create and edit complex text-based documents taht can also include images and other content

Database software

allows users to store and organize vast amounts of data and retrieve specific information when needed.

Search

allows you to search for help topics by typing a keyword or phrase

Mobile software

always downloaded from an app store, Apples's App Store, Blackberry's App World, Android Market

Formula

an entry in a worksheet cell that performs computations on worksheet data and displays the results.

Insertion Point

an on-screen character that looks like a blinking vertical line; indicates the current location in a document, which is where the next change will be made.

Filename

appears on the title bar once a file has been saved one time.

Constant value

are numbers (such as 105 or 12740.25) and are entered into a cell without any additional characters.

Row

in a spreadsheet program, a horizontal group of cells on a worksheet

Documents are created...

in the RAM and then saved on a storage medium

Status Bar

indicates the number of pages and words currently in the document, the current document view and zoom level, and so on.

Picture tools contextual tab

is displayed on teh Ribbon whenever an image is selected

Installation program

is how program software is installed

Active cell or current cell

is the selected cell and has a border around it so it is easy to identify.

Cell pointer

is used to select a cell

tabs

located in the Ribbon, which contain groups of related commands for the program being used.

Word wrap

means the insertion point automatically moves to the beginning of the next line when the end of the screen line is reached.

Font size

measured in point

Commands are issued through

menus, keyboard shortcuts, or command buttons located on a toolbar or Tibbon

Mobile software (apps)

software specifically designed for a specific type of mobile phone or other mobile device. Over 500,000 apps for the iPhone. most apps are free or minimal cost. some compatible with desktop software

Ownership rights

specify the allowable use of that program.

Running instance

the number of software instances (installed or virtual) being used at any given time

Prepare for Sharing

to avoid the embarrassment of distributing a document with hidden text, internal comments, personal information, and other data you may not want to pass onto others, click File,Info, and then Prepare for Sharing to check for and remove this data before distribution.

rights-management tools

tools used to protect original content form misuse by others. Digital signatures, encryption and other security tools