iClicker Questions BCIS

A data _______ is any file that contains the data you want to retrieve.

source

Although many of us may prefer not to think about it, ______ --the complete malfunction of a computer system-- and other typer of computer-related disasters do happen.

system failure

To ungroup worksheets, you can click a sheet ____ of a sheet not in the group.

tab

If a video is too long, or there are parts of the video that you don't want to show during the slide show, you can _______ it.

trim

The _____ is the first slide in a PowerPoint presentation.

Title slide

PMT(rate, nper, pv [, fv=0]) In the figure above, nper stands for the ______.

Total number of payment periods

A _____ is a malicious program that masquerades as something else-usually as some typer of application program.

Trojan horse

(T/F) A query is a request for information from a data source.

True

(T/F) Botnets are a major security threat since criminals are increasingly creating botnets to use for computer sabotage.

True

(T/F) Formatting changes only the appearance of data-it does not affect the data itself.

True

(T/F) Once you group a collection of worksheets, any changes you make to one worksheet are applied to all sheets in the group.

True

The ____ function searches vertically down the first column of the lookup table.

VLOOKUP

One example of a neural network is a(n) ____ system that uses cameras to inspect objects and make determinations-for example, the systems that check products for defects at manufacturing plants.

Vision

Which of the following theatre departments does NOT use CAD software? a. costume b. lighting and sound c. box office d. stage sets

c. box office

A column sparkling is used for _____.

column charts

In PowerPoint terms, _____ a photo means cutting out the parts you don't want to include.

cropping

Computer crime is sometimes referred to as ____.

cybercrime

The speed and distance of a Wi-Fi network depends on a variety of factors, such as the particular Wi-Fi standard and _____. a. the number of solid objects between the access point and PC (walls, doors) b. interference from devices using radio frequencies (baby monitors, microwave ovens) c. the hardware being used d. all of the above

d. all of the above

A marketing activity that can be considered a privacy risk is _____.

electronic profiling

The _____ is the most powerful computer in most cars.

engine control unit

A _____ is a security system that essentially creates a wall between a computer or network and the Internet in order to protect against unauthorized access.

firewall

A _____ item is a main item in a list.

first-level

A win/loss sparkling is used for _____.

highlighting positive and negative values

A line sparkling is used for _____.

highlighting trends

The term ____ refers to the rights of individuals and companies to control how information about them is collected and used.

information privacy

Which of the following is NOT true of computerized car analysis?

is more expensive than physical testing

Computer-generated fractals use _____ to create art.

mathematical formulas

Database marketing allows companies to ____.

mine customer databases and create marketing lists

Dancers rely on a technology called ____ to record and analyze their dance movements.

motion capture

You can ____ IF functions to allow for three or more outcomes.

nest

If you animate a list, the default is for the first-level items to appear ____.

one at a time

When you reference a cell or range in a different worksheet, the ___ separates the sheet reference from the cell reference.

!

The numbers, text, or cell references used by the function to return a value are called _______.

Arguments

_____ applications that exist in some form today include intelligent agents, expert systems, neural networks, and robotics.

Artificial Intelligence

_____ is the process of connecting the brained with a computer, such as impacting electrodes directly into the brain to restore lost functionality to or facilitate the communications of severely disabled individuals.

BCI

______ identify users by a particular unique biological characteristic.

Biometric access systems

The core of the U.S. VISIT system is a database of _____, such as digital fingerprints or iris scans

Biometric identifiers

The ____ function calculates the number of cells in a range that match criteria you specify.

COUNTIF

The _____ function calculates the number of cells in a range that match criteria you specify.

COUNTIF

_____ can be used to secure portable computers, external hard drives, and other portable pieces of hardware to a table or other object.

Cable locks

_________ uses computers to test product designs before the physical prototype is built.

Computer-aided engineering (CAE)

To make A1 the active cell, you should press which of the following keys?

Ctrl + Home

A _____ contains the actual values that are plotted on the chart.

Data series

______ splits a very large computing problem among any number of networked computers which communicate and coordinate processing with each other.

Distributed computing

Which of the following is NOT used in computer-aided surgery?

Drones

To switch to ______ mode, you double-click the cell.

Edit

Computer-based patient records are entered, stored, and maintained with the help of a(n) _____ system.

Electronic health record (EHR)

_____ refers to companies recording or observing the actions of employees while on the job.

Employee monitoring

(T/F) If you don't include a pv value, Excel assumes a future value of 1.

False

______ enters text based on patterns it finds in the data.

Flash Fill

_____ is an Excel tool used for modeling data and forecasting future values.

Forecast sheets

______ is an Excel tool used for modeling data and forecasting future values.

Forecast sheets

By default, numbers appear in the _____ and general display values exactly as you type them.

General format

A _____ is a computer system capable of assembling, storing, manipulating, and displaying data identified by location.

Geographic information system (GIS)

The _____ function returns the amount of a particular payment that is used to pay the interest on the loan.

IPMT

_______ functions find values in the tables of data and insert them in another location in the worksheet such as cells or in formulas.

Lookup

A _____ is a special type of serial port that connects the computer to an electronic musical instrument or other input device, such as an electronic piano keyboard.

MIDI port

_______ merges each of the rows in the selected range across the columns in the range.

Merge Across

______ is a special effect in which one video image is transformed into another image over the course of several frames.

Morphing

The _____ function calculates the number of payment periods in an investment or loan.

NPER

A carbon _____ is a tiny, hollow tube made up of carbon atoms, used as part of a variety of products today.

Nanotube

The first step in the scientific method involves _____.

Observing some occurrence or aspect of the world or identifying a problem.

To change the order of operations, enclose part of the formula in ______.

Parentheses

To edit a presentation without changing the original, create a copy of it. To do this, use the ____ command.

Save As

______ is an emerging technology field that combines computers, location-sensing technology, and wireless data in a vehicle.

Telematics

______ is the use of advanced computer technology to help health care professionals consult with each other and work together on cases, regardless of where the patients, medical professionals, and relevant clinical data are located.

Telemedicine

How should Excel categorize telephone numbers: as texts, numbers, or dates and times? Why?

Text

In the following formula: =IF(B1>=1000,"PASS", "FAIL")) what happens if B1=1000?

The formula returns the text "PASS".

In the following formula: =IF(A1="YES","DONE","RESTART"), what happens if A1= "NO"?

The formula returns the text "RESTART".

In the following formula: =IF(B1<5000,"BUY","SELL")) what happens if B1=5000?

The formula returns the text "SELL".

The _____ caption indicates a worksheet group.

[Selected Sheets]

Which of the following is NOT true of computerized voting systems? a. They provide equal access to every citizen. b. They simplify and streamline the voting process. c. They improve the accuracy of election results. d. They reduce the occurrence of lost or destroyed ballots.

a. They provide equal access to every citizen.

The IRS allows you to do all of the following at its Web site EXCEPT _____. a. having online chats with an IRS representative b. track the status of your refund c. download tax forms d. use tax calculators

a. have online chats with an IRS representative

After you insert a video, you can modify it by changing ____ options, changing the length of time the video plays, and applying formats and styles to the video.

playback