AICE IT AS Practical SG

bot class study guide :( (seperated by chapters)

(Excel) Spreadsheet

Software that can organize, analyze, and manipulate data that is organized in a grid of rows and columns.

(Excel) Page Setup

Size of paper to print on, orientation (portrait or landscape), to print gridlines for all the cells or not, whether to include row and column headings and whether certain rows will be repeated at the top of each page.

(Excel) Fit to page

The possible ways to set the spreadsheet to fit a specific number of pages. Options are fit all columns on one sheet, fit all rows on one sheet, fit the sheet to one page, or fit the sheet to a specified number of pages across and down.

(Excel) Margins

The top, bottom, left and right margins can be adjusted to provide space at the edges to provide space for printing.

(Excel) Header and Footer

Information can be included at the top and bottom of each printed spreadsheet. Usually has the title, author, page number, file name, and/or date.

(Excel) Cell

A single unit/rectangle of a spreadsheet formed at the intersection of a column and a row where data can be entered or positioned. Its reference (name/address) is based on its column and row.

(Excel) Editing and inserting rows

Rows are inserted to the left of existing columns.

Rows and columns can be deleted.

Rows and Columns can be resized.

Can be made taller or shorter.

Can be made wider or slimer.

Can be resized to enable different sizes of text to fit or to allow multiple lines of text within one cell.

Can be resized to allow more data to fit in the column or to save space by narrowing the column.

(Excel) Hiding rows or columns

It is possible to hide a row or column, it is data hidden that may not need to be seen by the user or may contain private info.

(Excel) Merging two cells together

Creates a single cell with the reference being the original upper left cell of the merged cells.

(Excel) Protecting cells or worksheets

It is possible to protect a worksheet from having any changes made to it

It is also possible to protect a worksheet while allowing certain cells to be edited or changed. To do this, cells must be edited and unlocked prior to protecting the worksheet.

Cells can be protected so that the formula cannot be seen by a user which instead displays the data. (Display Formula Button)

(Excel) Formula

A mathematical calculation using +,-,x, or the division symbol.

(Excel) Range

A selection of cells (usually defined by XY:XY, where x is the letter of the column and y is the number of the row)

(Excel) Freezing panes and windows

Freezing panes makes it so the top row remains on the screen as the user scrolls down on the worksheet. Used when a spreadsheet is too large that it cannot visibly all fit onto the screen.

(Excel) .CSV files

Comma Separated values is a file format often used for source files.

(Excel) Wrapping Text

Wrapping text makes it so the text fits evenly in a cell or range. Incase it is too big or cut off.

(Excel) Display Formulae

This button toggles the formula view, which displays the formula for a cell.

(Excel) Mathematical Operators

Any of these symbols can be entered in the formula bar and calculate. + is addition, - is subtraction, * is multiplication, / is division, ^ to make a power or square.

(Excel) Naming Cells and Ranges

It is a good idea to give a cell or range a name if it is going to be referred to many times.

(Excel) Data formats

Type and Examples
—————————-
Date 02/05/2015

Time 3:44 PM

Text abcdefg

Numeric 25

Currency $15.45

Percentage 25%

Fractions 1/4

(Excel) Orientation

the direction of text, like horizontal or vertical.

(Excel) Alignment

positioning the text so that it is in line, for example align left, right, or center.

(Excel) Comments

Comments can be added to cells that can be seen when selected.

(Excel) Conditional Formatting

Cells can be formatted based upon certain conditions being met. This is known as conditional formatting.

(Excel) Types of conditional formatting

Values in a cell that are equal to a set criteria

Values in a cell that are greater or less than a set criteria

Values in a cell that are between set criteria

Values in a cell that are duplicated elsewhere in the worksheet

Values that are above or below average

A scale of values from lowest to highest

(Excel) Relative Cell Referencing

A cell reference that changes when it is copied into other cells

(Excel) Absolute Cell reference

A cell reference that does not change when it is copied into other cells, usually by placing a $ sign before the cell reference.

(Excel) Function

A ready-made formula representing a complex calculation.

(Excel Function) Sum