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