CIS 105 Study guide for exam

What function would most appropriately accomplish the same thing as =(B5+C5+D5+E5+F5)/5?

=AVERAGE(B5:F5)

Ethernet Card

A board inside a computer to which a network cable can be attached.

expansion card

A circuit board inserted into a slot on the motherboard to enhance the capability of the computer.

Motherboard

A circuit board that contains all of the computer system's main components.

Comments for VBA

A comment is text in the code that is used to document or explain what a section of code is doing. Comments are not executable code. In VBA a comment line appears in green and begins with an apostrophe.

Video Card

An interface card installed in the computer to control visual output on a monitor. Also called display adapter or graphics card.

machine language

Binary code made up of 0s and 1s; usually this is data converted from a high-level language by a compiler. Often used as a synonym for low-level programming language.

system unit

Case that contains the electronic components of a computer that are used to process data.

CPU/Processor

Central Processing Unit, the brain of the computer, executes commands, its speed is measured in millions or billions of instructions per second

Buses

Collection of wires that carry signals between various components of the computer system

Modem

Communications hardware device that facilitates the transmission of data.

Input

Data that is entered into the computer system via an input or storage device.

Design time vs. run time

Design is the mode for designing and creating VBA code - Run time is the mode where the program statements are executed

Decision for VBA

Evaluate a condition and then execute program statements based on outcome o IF - THEN - ELSE statements o Select Case statements

Which sequence represents the hierarchy of terms, from smallest to largest?

Field, record, table, database

the speed of the microprocessor

How fast a computer can process instructions depends partially on

bps (bits per second)

Measurement of how fast data is moved from one place to another. A 56K modem can move ~56,000 bits per second.

The first row of a table often includes text in one cell that spans the width of all other table data below. What command enables you to design the first row in that manner?

Merge

The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C7?

Number of payment periods

Ports

Places on the outside of the computer that connect to the motherboard and allows hardware to work

RAM

Random Access Memory

Downloading

Receiving data, such as a music or video file, from a server or another computer system

You perform several edits in a table within an Access database.When should you execute the Save command?

Records are saved automatically; the Save command is not required.

Primary Storage

The computer's main memory, which consists of the random access memory (RAM), cache memory, and the read-only memory (ROM) that is directly accessible to the CPU

data transmission

The transfer of data between computers or other electronic devices through a network.

Why would you press Ctrl+` in Excel?

To display cell formulas

Keywords for VBA

Words or symbols in a programming language that have a specific purpose are known as keywords. In VBA keywords appear in blue. Some general keywords include: • Dim • If - Then - Else • End If • True • False

A workbook is defined as:

a file containing related worksheets

output device

allows the user to view or listen to the data a computer processes such as a monitor, printer, headphones, or speakers

Sound Card

an expansion board that enables a computer to manipulate and output sounds

Microprocessor

an integrated circuit that contains all the functions of a central processing unit of a computer.

Declaring Variables

are defined by the programmer to store values that can change (vary) while the program code is being executed. ex: Dim curSalary as Currency

A mixed cell reference

contains both an absolute and a relative cell reference.

Using the fill handle on a cell containing a formula

copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula.

input device

data entered into the computer through a variety of devices such as a keyboard, microphone, scanner, flash drive, or mouse

The Formula Bar:

displays the formula or contents of an active cell.

volatile

highly unstable; explosive

Procedures for VBA

is a named sequence of programming statements that perform a set of actions.

Decision Structure

is a programming structure that makes a comparison between a known value and a variable.

A cell in Excel is defined as

is the intersection of a column and a row.

Primary Storage

program relies upon locations in RAM to temporarily hold data while the program is running.

What is VBA?

programming language that is used to enhance Microsoft Office applications like Word, Excel, PowerPoint, Access, and Outlook. VBA is a subset of the Visual Basic programming language.

The IF - THEN - ELSE statement

represents a decision structure that consists of a logical test. If the logical test is TRUE then one block of code will be executed. If the logical test is not TRUE (it is FALSE) then an alternative block of code will be executed.

To ensure that columns and rows are the same size and width, you should:

select Distribute Rows or Distribute Columns in the Cell Size group.

Uploading

sending data, such as a music or video file, from a local computer system to another computer system or server

Outputs

the goods, services, and ideas that result from the conversion of inputs

storage

the process of retaining encoded information over time

Bits

the smallest unit of data in a computer

Code Window

the window in Visual Basic Editor (VBE) that displays the Visual Basic code (commands) for a macro

Bytes

used to measure the amount of information a device can store

Data Type for VBA

which will identify the kind of data the variable or constant will hold and how this data is stored in RAM.

Delcaring Constants

will store values that are specified at the beginning of the program and they will remain the same (constant) while the program code is being executed. ex: Const sngSalesTax As Single = 0.075