CIS - Final
A value being looked up outside the range of the table causes the VLOOKUP function to return the _____ error message.
#N/A
How many bits equal a byte?
8
Generally, home users using basic application software such as word processing should have ____ of RAM.
8gb and up
This function locates the starting position of one text value within another text value, and is case sensitive.
=find
The ____ is the component of the processor that performs arithmetic, comparison, and other operations
ALU
A(n) ____ flash drive is a flash memory device that plugs in a port like the one shown in the accompanying figure on a computer or portable device.
USB
________ use flash memory to provide high capacity storage through the USB port.
USB flash drives
____ is the most common type of volatile memory.
RAM
_____ is temporary or volatile memory that stores bytes of data and program instructions for the processor to access.
RAM
_________ is temporary, or volatile, memory that stores bytes of data and program instructions for the processor to access.
RAM
The _____ function is used when a table direction is vertical.
VLOOKUP
The Accelerated Graphics Port (AGP) is ____.
b
Additional money owed at the end of a loan, where you must specify a negative future value is called __________.
balloon payment
Modems are use for ________ connections.
both
The PCI bus is ____.
c
The general form of the VLOOKUP function is _____.
c
Which of the following examples of NOT function used in formulas are not correct?
c
The excessive use of gridlines and data labels is referred as _________?
chart junk
The descriptive text that identifies the chart's contents is __________?
chart title
Each tick of the system clock equates to a ____.
clock cycle
Adding interest earned each period to the principal for the purposes of computing interest for the next period is called __________.
compound interest
Excel provides _______ tools, which are tools you can use to identify a set of conditions and specify the formatting if those conditions are met.
conditional formatting
_______ charts are a way to show the information contained in a pie chart for more than one series?
doughnut
The Comma Style button on the Ribbon causes number to be displayed to the nearest ___
hundredths
The faster the clock speed, the more ____ the processor can execute per second.
instructions
A(n) ____ is often used by enterprises to allow employees to access the corporate intranet from home and while on the road
virtual private network (VPN)
Distance education is the conducting classes over the ______ with no physical class meetings.
web
When user runs a _____, Excel imports the external data in the form of a worksheet
web query
Memory ____ on the motherboard hold the memory modules.
slots
The process that allocates the value of an asset evenly throughout the life of the asset is called _______.
straight line depreciation
The power ____ is the component of the system unit that converts the wall outlet AC power into the DC power a computer requires.
supply
Which of the following is the most common type of B2B e commerce?
supply chain management
A(n) ____, which can be a peripheral or a chip, creates sound from digital instructions.
synthesizer
If col_index_num is greater than the number of columns in table_array, VLOOKUP returns the _____ error value.
#ref!
When using the Fill Handle to copy formulas, place the pointer on the lower right corner of the selected cell(s) until it changes to a _________.
+
The default doughnut chart starts at the ___ o'clock position?
12
The World Wide Web was born in ________.
1993
To show 8 exponents of 2 in Excel, it should be _______.
2^8
If you enter 3+2*10 in a cell exactly as show, what value would result?
3+2*10
This function locates the starting position of one text value within another text value, and is not case sensitive.
=search
This function removes all spaces in a text string except for the single spaces between words.
=trim
Which of the following form currently accounts for the most revenues of all ecommerce types?
B2B
Which of the following is the most familiar form of ecommerce for individuals?
B2C
Which segment do eBay and Amazon.com belong?
B2C's
Within the circuitry of a computer, each channel along which bits transfer, called a(n) ____, allows the various devices both inside and attached to the system unit to communicate with each other.
Bus
To calculate the number of cells in a range that contains numbers and texts, which of the following function should be used?
COUNTA
The ____ interprets and carries out the basic instructions that operate a computer.
CPU
What two functions automatically calculate the interest values between two periods and the principal values between two periods?
Cumipmt and Cumprinc
With a type of memory module called a(n) ____ the pins on opposite sides of the circuit board do not connect and thus form two sets of contacts.
DIMM
The four stages of the machine cycle are (1) ______ the instruction from memory, (2) ________ and (3) _______ the instruction, then (4) _______ the results
Fetch, decode, execute, store
A ____ port was formerly referred to as an IEEE 1394 port.
FireWire
A (n) ____ tells you the exact location of the receiver on the earth's surface.
GPS
The _____ function is used when the table direction is horizontal.
HLOOKUP
Which Excel function should you use when you want to look up a value from a two dimensional table, where both the columns and rows can be varied?
INDEX
For a wireless device to transmit signals via infrared light waves, both the computer and the device must have a(n) ____ port.
IrDa
____ is built directly into a processor chip and usually has a very small capacity.
L1 cache
Current processors include advanced transfer cache, a type of ____ built directly on a processor chip.
L2 cache
____ is a cache separate from the processor chip on the motherboard.
L3 cache
A ______ is a thin, flat display that uses liquid crystals placed between two pieces of glass to form images on a backlit screen.
LCD
A special type of serial port that connects the system unit to a musical instrument, such as an electronic keyboard, is called a(n) ____ port.
MIDI
ExpressCard modules are the next generation of ____ Cards.
PC
In regards to the PMT Function, when cash is received it is considered __________ and when cash is paid out it is considered ___________.
Positive Cash Flow : Negative Cash Flow
A ____ houses RDRAM chips.
RIMM (Rambus inline memory odule)
_______:hold the data and instructions currently being processed (~300 bytes).
Registers
Many GSM phones have a ___ card that stores subscriber information and personal data and can be transferred to other GSM phones.
SIM
A ____ has pins on opposite sides of the circuit board that connect together to form one set of contacts.
SIMM
A _____ port can be used to connect a variety of peripherals to a computer, and contain no moving parts like magnetic or optical drives.
USB
A(n) ____ drive fits into a port that is itself an interface that can connect up to 127 different peripherals together with a single connector.
USB
HiSpeed USB is also known as ____.
USB 2.0
_________ has been adopted my Mircrosoft in its office suite to standardize data descriptions across applications.
XML
Which of the following is not the benefit of shopping online?
You have the ability to feel the material, try it on and see how it's made of which you want to buy.
. If match_type is 1, which of the following statements is true?
a
The Rate Function, which returns the interest rate per period of an annuity, involves what function syntax?
a
Write a formula to choose the name of the fifth day of the week from the list starting with Sunday, Monday, Tuesday....Saturday.
a
Often, financial institutions use this term that is equivalent of a yearly simple interest rate, taking into account compounding called ___________.
annual percentage yield
Synchronous DRAM (SDRAM) chips ____.
are synchronized to the clock system
A/An ________ combines the feature of a line chart with a bar or column chart.
area chart
For the VLOOKUP function to work correctly, the table _____ must be in ascending sequence.
arguments
The table_array contains what are called table _____.
arguments
The values that is used with a function are called ____
arguments
A SCSI port is ____.
b
Double Declining Balance, which computes depreciation at an accelerated rate, includes what function syntax?
b
Which of the following statements is true about LOOKUP and VLOOKUP functions?
b
____ size is the number of bits the processor can interpret and execute at a given time.
word
A computer's performance can also be affected by the processor's _______ , which is the number of bits that a CPU can process at once.
word length
. What is the most popular MMORPG game out right now?
world of warcraft
A ________ plot is commonly used in financial stock reporting.
candle stick
The cases of the system unit, sometimes called the ____, is made of metal or plastic and protects the internal electronic components from damage.
chassis
A computer ____ is a small piece of semiconducting material, usually silicon, on which integrated circuits are etched.
chip
Embedded computers are sometimes referred to as:
chip or processor
The pace of the system clock, called the ____ speed, is measured by the number of ticks per second.
clock
The ____ unit is the component of the processor that directs and coordinates most of the operations in the computer.
control
__________: sequentially accesses program instructions, decodes them, and coordinates the flow of data throughout the system.
control unit
Today's Web browsers allow Web servers to store small text files called _______ on their computers.
cookies
Most high performance PCs use some type of processor in the Intel ____ family
core
Which of the following can be used to count the number of cells in a range that contain numbers?
count
The USB (universal serial bus) and FireWire bus are ____.
d
Which of the following description is not true?
d
Which of the following is correct about Highlight Cells Rules submenu options?
d
_______ displays performance indicators similar to a car's dashboard.
dashboard
. ________ is a process that involves evaluating data to identify problems with the content of a database.
data analysis
________ are the points in a data series in which the X axis and Y-axis values intersect.
data points
A(n) _________ is a collection of data from sources across an entire enterprise.
data warehouse
the term ____ refers to the process of translating instructions into signals the computer can execute.
decoding
The process by which a company spreads the expense of an asset over its useful life is called ___________.
depreciation
On ____, the electronic components and most storage devices are part of the system unit and other devices, such as the keyboard, mouse, and monitor, normally occupy space outside the system unit.
desktop personal computers
With a(n) __________ the actual data may be spread across several databases at different locations.
distributed database
_________ computing is a cause of concern for data security due to issues of training and control.
end-user
A(n) ________ diagram illustrates the relationships between tables in a relational database.
entity relationship
____ is the process of carrying out commands.
executing
The ____ bus for a PC Card is the PC Card bus.
expansion
A(n) ____ module is a removable flash memory device about one/half the size of a PC Card that adds memory, communications, and multimedia capabilities to mobile computers.
expresscard
Notebook and other mobile computers have at least one ____ slot, which is a special type of expansion slot.
expresscard
A kiosk is a computer station that provides teachers with specific and useful information and services?
false
____ is the process of obtaining a program instruction or data item from memory.
fetching
The wider the bus, the ____ the transfer of data.
fewer the number of transfer steps required and the faster
ROM chips called ____ contain permanently written data, instructions, or information that is recorded when the chip is manufactured.
firmware
____ is a type of nonvolatile memory that can be erased electronically and reprogrammed, similar to EEPROM.
flash memory
_______ is a form of solid state storage, that does not require moving parts to read and write data.
flash memory
A ______ is a chip that, unlike RAM, is nonvolatile and keeps its memory without the need for electricity.
flash memory card
After establishing about the relational operator and the condition, you need to specify the formatting to be applied if the condition is met. These cannot include _______ ?
font type
A situation where inaccurate input causes inaccurate output in a database is often called ___________.
garbage in, garbage out
A(n) ____ changer is a device that enables users to join two connectors that are both female or both male.
gender
____ are installed in internal bays.
hard disk drives
A(n) ____ is a small ceramic or metal component with fins on its surface that absorbs and disperses heat produced by electrical components such as a processor.
heat sink
A FireWire ____ is a device that plugs in a FireWire port on the system unit like the one in the accompanying figure and contains multiple FireWire ports in which users plug cables from FireWire devices.
hub
A USB ____ is a device that plugs in a USB port on the system unit and contains multiple USB ports in which users plug cables from USB devices.
hub
A private network made accessible to select _____ is called intranet.
insiders
A(n) ____ circuit, which is etched on a computer chip, contains many microscopic pathways capable of carrying electrical current.
integrated
AMD is the leading manufacturer of ____ compatible processors, which have an internal design similar to Intel processors, perform the same functions, can be as powerful, but often are less expensive.
intel
A method of evaluating profitability takes a similar approach to that of NPV in that it considers cash flows and discounts them back to present value is called __________.
internal rate of return
What is the meaning of "#REF!" error message?
invalid cell reference
A ________ is a box that identifies patterns or colors assigned to the data series in the chart.
legend
____ technology uses a continuous flow of fluid(s), such as water and glycol, in a process that transfers the heated fluid away from the processor.
liquid cooling
Together, four operations (fetching, decoding, executing, and storing) comprise a(n) ____ cycle.
machine
_____ storage devices use the magnetic properties of iron oxide particles to store bits and bytes.
magnetic
_______ is the link between content in a document and the instructions for formatting that content.
markup language
The _____ function displays the highest value in a range
max
A ____ module, which is a small circuit board where RAM chips usually reside, being inserted into the motherboard.
memory
A(n) ____ card is a removable device that allows users to transfer data and information conveniently from mobile devices to their desktop computers.
memory
____ consists of electronic components that store instructions waiting to be executed by the processor, data needed by those instructions, and the results of processed data (information).
memory
Programmers use ____ instructions to program a PROM chip.
microcode
Some computer and chip manufacturers use the term ____ to refer to a personal computer processor chip.
microprocessor
The _________ accesses instructions stored in memory over the system bus.
microprocessor
The largest area of growth in technology has been in which of the following:
mobile devices
The 30 day _________ trendline is used to smooth out data, making it easier to spot trends.
moving average
A(n) ____ processor is a chip with two or more separate processors.
multi core
Which of the following is not considered a PC?
netbook computer
A hyperlink is an element in an electronic document. Which one of the following can a hyperlink not be found in?
number
All commands for opening, saving, and printing files can accessed from the _____.
office button
______ storage media store bits by using an optical laser to burn pits into the surface of a highly reflective disc surface.
optical
Which of the following can be used for absolute cell referencing?
option a and c
EDI uses network systems and follows standards and procedures that allow _____ from one system to be processed directly as _____ to other systems, without human intervention.
output, input
The time it will take to earn sufficient profits so that the loan can be paid back is called ________?
payback period
A(n) ____, such as a keyboard or printer, is a device that connects to the system unit and is controlled by the processor in the computer.
peripheral
What is the highest digital metric?
peta
What trade of business is likely to use a supercomputer?
pharmaceutical companies
. A _______ chart is used to display the percentage contribution that each category makes to a whole.
pie
With ____, the processor begins fetching a second instruction before it completes the machine cycle for the first instruction.
pipelining
. A _____ is a dot on the screen that contains a color
pixel
Many of today's computers support ____, which means the computer automatically can configure adapter cards and other peripherals as users install them.
plug and play
The function that finds the value of the payment per period, assuming that there are constant payments and a constant interest rate for the duration of the loan is called ________.
pmt function
"A new window that opens above the current one to display an advertisement." is the description of which type of Web advertising?
pop up
________ is a field that uniquely identifies each record in a database file.
primary key
With _______ charts values radiate from the center of the chart.
radar
_____ allows you to make immediate changes to the cells referenced in a formula
range finder
A processor contains small high speed storage locations, called ____, that temporarily hold data and instructions.
registers
The _________ model places data in two dimensional tables.
relational
Display ______ is a measure of pixels on the screen. The higher the resolution, the smaller the pixels and images they create.
resolution
________ is a(n) outline of the logical and physical structure of the data and relationships among the data in the database.
schema
_________ is used to store data more permanently without the need for electricity
secondary storage
The _______ web is a version of the Web where Web content is organized in a manner that makes it easier to identify and manage.
semantic
Interest that is paid solely on the amount of the original principal value is called _______.
simple interest
A ______ storage device stores data using transistors and can be volatile or nonvolatile.
solid-state
The ____ of a printer in measured by the number of pages printed per minute (ppm).
speed
The first consideration in selecting a computer is typically its ________
speed
Excel has a _______ that user can use to check the worksheet for spelling errors
spell checker
_______ displays the trend of the contribution of each value over time.
stacked line
The role of memory to store both data and programs is known as the ____ concept.
stored program
A type of processor called ____ on a chip integrates the functions of a processor, memory, and a video card on a single chip.
system
The ____ board is the main circuit board of the system unit.
system
The ____ unit is a case that contains electronic components of the computer used to process data.
system
The processor relies on a small quartz crystal circuit called the ____ clock to control the timing of all computer operations.
system
The ________ connects the CPU to the chipset, and through it to RAM and other components on the motherboard.
system bus
The VLOOKUP function searches the far left column of the _____.
table array
What is a method of sending short messages, no longer than 160 characters, between cell phones?
texting
With Excel, user can enter functions using these methods, except:
the options ribbon
Given the following lookup function, from which column in the lookup table will data be returned? VLOOKUP (A1, C10:E35, 3, FALSE)
the third column
A _____ is a predefined set of colors, fonts, chart styles, cell styles and fill effects that can be applied to an entire workbook
theme
Double Data Rate SDRAM (DDR SDRAM) chips are even faster than SDRAM chips because they ____.
transfer data twice for each clock system
A(n) ____, which is contained on an integrated circuit, can act as an electronic switch that opens or closes the circuit for electrical charges.
transistor
_______ graphically illustrate trends in the data using a statistical technique known as regression?
trendlines
. A computer network is a telecommunications network that connects two or more computers for the purpose of sharing data, hardware, and software resources.
true
A hacker is an individual who subverts computer security without authorization.
true
The first step in cleaning a computer is ____.
turn it off, unplug it, and unplug all cables from the ports
A(n) _______ contains data that is difficult to place in a traditional database system, such as drawings, fingerprints, and sound recording.
unstructured database
Rambus DRAM (RDRAM) chips are another type of DRAM chips that are much faster than SDRAM chips because they ____.
use pipelining techniques
A(n) ____ card converts computer output into a video signal that travels through a cable to the monitor, which displays an image on the screen.
video
. _____________ is a technology that combines video and phone call capabilities along with shared data and document access.
video conferencing
The size of a bus, called the bus ____, determines the number of bits that the computer can transmit at one time.
width
Some cell phones provide voice communications over a _____ network.
wifi
The ease of installation of a(n) _____ network is making it the obvious choice for most home networks.
wifi
. A wiki is a web site that allows users to:
add, remove, and edit
To append a dollar sign to a number, use the ____ format
accounting number
Some external peripherals such as an external modem, speakers, or a tape drive have an AC ____, which is an external power supply.
adapter
____ card is a circuit board that enhances functions of a component of the system unit and/or provides connections to peripherals.
adapter
A network __________ is a person responsible for setting up and maintaining the network, implementing network policies, and assigning user access permissions.
administrator
Data refers to which of the following:
all of the above
Preventive maintenance of your computer requires a few basic products, including ____.
all of the above
The cell of Excel can contain ______.
all of the above
Web is used for
all of the above
What are the strengths of computers?
all of the above
What is considered a special Purpose Computer?
all of the above
What is one of the primary types of information systems?
all of the above
Which of the following is (are) Ecommerce application(s)
all of the above
Which of the following is true about Conditional Formatting Presets?
all of the above
The standard method of detailing a loan transaction is to set up what is called a __________.
amortization table
Bluetooth technology is ____.
an alternative to IrDA that uses radio waves to transmit data between two devices
"A rectangular area embedded in the Web page content for advertising, often across the top of the page." is the description of which type of Web advertising?
banner
A(n) ____ is an opening inside the system unit in which additional equipment can be installed.
bay
Why is the VLOOKUP function used more often than other lookup functions?
because most tables are vertical
One gigahertz (GHz) equals one ____ ticks of the system clock per second.
billion
Which of the following can be accomplished by a spyware program?
block access to hackers
________ enables a wide assortment of digital devices to communicate wirelessly over short distances.
bluetooth
Straight line depreciation is calculated on excel by ____________.
both a and b
________ allow three dimensional data to be plotted in 2-D on two axes.
bubble charts
Which of the following statements is false about LOOKUP and VLOOKUP functions?
c
