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