itapp q2

Excel

A powerful spreadsheet app that allows users to organize data, complete calculations, make decisions, graph data, develop professional-looking reports, publish organized data to the web, and access real-time data from websites.

Workbooks, Worksheets, Charts, Tables, Web Support

4 Majors Parts of Excel

Workbooks

like a notebook

Worksheets

sheets inside the notebook, a single sheet in a workbook

Charts

Graphic elements that illustrates data

Tables

organizes and stores data within worksheet

Web Support

allows users to save excel worksheets in the browser so that they can view and manipulate in the browser

Columns

represented by letters

Rows

represented by numbers

Cell

the intersection of columns and row

Sheet tab

pages

Statue Bar

where you can see what the excel is doing

number

an amount or value using ant of the following characters 1 2 3 4 5 6 7 8 9 + - {}, / *. $ as well as a blank space

active cell

has a heavy border surrounding the cell and highlighted rows and column

Auto Fill Option

Provides option for how to fill cells following a fill operation, such as dragging the fill handle

Auto Correct Option

Undoes an automatic correction, stops future automatic corrections of this type, or causes Excel to display the Autocorrect Options dialog box

Insert Option

Lists formatting options following an insertion of cells, rows, or columns

Paste Option

Specifies how moved or pasted items should appear (e.g., with original formatting, without
formatting or with different formatting)

Trace Error

Lists error-checking options following the assignment of an invalid formula to the cell

Copy Cells

Fill the destination area with contents using the format of source area. Do not create a series.

Fill Series

Fill destination area with series using format of source area. This option is the default.

Fill Formatting Only

Fill the destination area using the format of source area. No content is copied unless fill is in series.

Fill Without Formatting

Fill destination area with contents, without applying the formatting of source area.

Fill Months

Fill the destination area with a series of months using the format of source area. Same as Fill Series and shows as an option only source area contains the name of a month.

Absolute Cell

$B$4

Relative Cell

B4

Mixed Ref

B$4 or $B4

Loan Amount

Price–Down Payment

Monthly Payment

Use of the function “

Total Cost

Monthly Payment x 12 x Years/Term + Down
Payment

Total Interest

Total Cost–Price

Banded Row

Different Colors of Succeeding Row