CIS - Final

¡Supera tus tareas y exámenes ahora con Quizwiz!

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


Conjuntos de estudio relacionados

MGT Chapter 12: Motivating Employees

View Set

Computer Fundamentals Module 1 - Impact of Digital Technology - Quiz

View Set

Chapter 11 Milady Esthetics Disorders and diseases of the skin

View Set

FIN 320 Chapter 11- Risk and Return

View Set

Chapter 14: Stress, Lifestyle, and Health - Part 4

View Set