1. Spreadsheets

NOTE: This set of flashcards is based on the given pointers to review. Good luck!!

Spreadsheet

An interactive computer application program for organization and analysis of information in tabular form

Microsoft Excel

a powerful data visualization and analysis tool; written and distributed by Microsoft with all the basic features of a spreadsheet; the first to use a graphical user interface with pull-down menus and a point-and-click capability; was released in September 30, 1985

Multiplan

originally marketed as a program called _________ in 1982

Workbook

a file created in a spreadsheet application.

Worksheet

basic unit of a workbook, it is a grid of cells where data are entered.

Cell

basic unit of a worksheet. It is the intersection of rows and columns.

Cell Address

a combination of a column letter and row number.

Range

a rectangular group of cells in a worksheet; It is identified by its first and last cell separated by a colon. e.g. A4:E9

Data Types

• Logical Data Type

• Number Data Type

• Text Data Type

• Error Data Type

Logical Data Type

True or False; Boolean values

Number Data Type

numerical values; stores all numbers as Double-Precision Floating Point values

Text Data Type

labels

Error Data Type

error messages e.g., (#NUM!, #REF!)

Different Mouse Pointers

• Mouse Pointer

• Cross Bar

• Cell Pointer

• Fill Handle/Autofill

• I-Beam

• Split Screen Arrow

• Select

Mouse Pointer

to select commands, buttons and navigate around the window

Cross Bar

Appears between column letters and row numbers used to adjust column width or row height

Cell Pointer

For selecting cells

Fill Handle/Autofill

For copying formulae or extending a data series

I-Beam

Indicates that you may type text in this area

Cell Reference

a cell or a range of cells on a worksheet and can be used in a formula

Types of Cell References

• Relative

• Absolute

• Mixed

Relative Cell Reference

mostly used to sum up values

reference: https://www.javatpoint.com/cell-references-in-excel

Absolute Cell Reference

a cell reference in which the corresponding reference is locked, meaning that the row and column remain constant; e.g., multiplying the values by a fixed increased rate of 5%

reference: https://www.javatpoint.com/cell-references-in-excel

Mixed Cell Reference

to multiply each column cell with each respective cell of the row

reference: https://www.javatpoint.com/cell-references-in-excel

Functions in Excel

• SUM

• ROUND

• IF

• AVERAGE

SUM

adds all values

reference: https://edu.gcfglobal.org/en/excel2013/functions

AVERAGE

determines the mean or average of values

reference: GCFGlobal

ROUND

rounds a number to a given number of places

reference: ExcelJet

IF

one of the logical functions, to return one value if a condition is true and another value if it's false

reference: MicrosoftSupport

General Rules

1. Formulas and Functions always begin with an equal sign.

2. Do not enter any extra spaces between formulas and functions.

3. Uppercase or lowercase characters can be used when entering a function

4. Arguments in a function must always be enclosed in parenthesis.

5. All arguments must be separated by a single comma.