Cis 105 Final

Front 1

Types of RAM

Back 1

most popular DDR2-SDRAM or DDR3-SDRAM

appears today in memory modules/cards

today, RAM modules usually DIMM or SIMM (predecessor).

*RAM is power supply dependent

Front 2

NIC (network interface card)

Back 2

device that typically allows computers to be joined to network (usually LAN via Ethernet language)

Front 3

Six Steps Involved in Starting Computer

Back 3

1. Locate and activate BIOS

2. Initiate POST

3. Load OS
4. Configure and customize the system

5. Load system utilities

6. Authenticate user

Front 4

Types of boots

Back 4

cold boot - you start a computer that has not yet been turned on

warm boot - you restart a computer that is already on

Front 5

Hanging indent

Back 5

first line begins at left margin, but all other lines in the source are indented

*length quote often set apart by indenting from both the left and right margins.

Front 6

Format Painter

Back 6

*in Clipboard group in Home tab

**double click Format Painter to copy format to multiple areas

***single click Format Painter to copy format to one other selection

First select text containing desired format, then initiate Format Painter

Front 7

What is a pivottable?

Back 7

*used for data mining

is a powerful interactive data mining feature that enables you to summarize and analyze data

Front 8

Creating pivottables

Back 8

1) From QuickAnalysis, select dataset including field names, click Tables in QA gallery, look at different recommended pivottables, create PivotTable

2) Ribbon: Go to Insert tab, PivotTable, get Create Pivot Table dialog box

Front 9

Areas of a PivotTable

Back 9

Filters Area

Columns Area

Rows Area

Values Area

Refresh tab to update PivotTable

Front 10

Excel Date/Time functions

Back 10

TODAY()
NOW()