Ch 3

Question 1

A _________ sometimes called a system board, is the main circuit board of a personal computer.

Answer 1

motherboard

Question 2

CPU is another name for a ____________ which is the electronic component that interprets and carries out the basic instructions that operate a computer.

Answer 2

Processor

Question 3

Security experts recommend using a sticker to cover a ___________ when you are not using it and inserting a dummy plug in a microphone port when you are not using it.

Answer 3

webcam

Question 4

A ___________ is a device that combines features of a smartphone and tablet. It usually has a screen that measures 5 to 7 inches.

Answer 4

Phablet

Question 5

A _________ is a computer dedicated to providing one or more services to other devices on a network.

Answer 5

Server

Question 6

A ________ is a computer, usually with limited processing power, that enables users to send data to and or receive information a server or host computer.

Answer 6

Terminal

Question 7

A self service __________ is a freestanding terminal that usually has a touch screen for user interaction.

Answer 7

Kiosk

Question 8

A ____________ is the fastest, most powerful and most expensive computer.

Answer 8

Super computer

Question 9

A __________ is the smallest element in an electronic image.

Answer 9

Pixel

Question 10

___________ is the number of horizontal and vertical pixels in a display.

Answer 10

Resolution

Question 11

An __________ computer is a special purpose computer that functions as a component in a larger product such a scar or television.

Answer 11

Embedded

Question 12

The ___________ describes an environment where processors are embedded in every product imaginable allowing the products to communicate.

Answer 12

Internet of things

Question 13

A ___________ is the point at which a peripheral device attaches to or communicates with a device.

Answer 13

Port

Question 14

A ___________ joins a cable to a port.

Answer 14

Connector

Question 15

A USB port an connect up to _________ different peripheral devices together with a single connector.

Answer 15

127

Question 16

Bluetooth devices have to be within about ________ feet of each other.

Answer 16

33

Question 17

Wifi uses radio signals that conform to 802.11 standards that were developed by the ________________.

Answer 17

Institute of electrical and electronics engineers

Question 18

A ___________ is a prolonged under voltage that may cause loss of data.

Answer 18

Brownout

Question 19

A ____________ is a momentary over voltage that occurs when the increase in power lasts for less than one millisecond.

Answer 19

Spike

Question 20

A ____________ uses electrical components to provide a stable current flow and minimize the risk of an over voltage.

Answer 20

Surge protector

Question 21

Excel may change how the groups and buttons within the groups appear on the ribbon, depending on the computer or mobile devices_____________.

Answer 21

Screen resolution

Question 22

The _________ may be used to fill in a data series rather than typing and formatting all the entries.

Answer 22

Fill handle

Question 23

A formula using __________ cell reference instructs Excel to adjust cell reference as it is copied to a destination area.

Answer 23

Relative

Question 24

To keep a cell reference constant when you are copying, Excel uses a technique called __________ cell referencing.

Answer 24

Absolute

Question 25

Use an _________ function to determine the value of a cell based on a logical test.

Answer 25

IF

Question 26

____________ is an Excel feature that looks for patterns in data and automatically fills or formats data in remaining cells.

Answer 26

Flash fill

Question 27

A ___________ consists of cell references, numbers, and arithmetic operators that instruct Excel to perform a calculation.

Answer 27

Formula

Question 28

A formula in a cell that contains a reference back to itself is called a _____________.

Answer 28

Circular reference

Question 29

In Excel as n algebra, you can always use __________ to override the order of operations.

Answer 29

Parenthesis

Question 30

___________ allows you to select cells for use in a formula by using the pointer.

Answer 30

Point mode

Question 31

The _________ function displays the highest value of a range.

Answer 31

Max

Question 32

____________ functions ignore blank cells.

Answer 32

Statistical

Question 33

___________ checks which cells are referenced in the formula assigned to the active cell.

Answer 33

Range finder

Question 34

__________ Format button assigns a fixed dollar sign to a number and rounds the figure to the nearest 100th.

Answer 34

Accounting number

Question 35

__________ allows the user to automatically change how a cell appears based on the value of the cell.

Answer 35

Conditionally formatting

Question 36

A _________ is a dot on the screen the contains a color.

Answer 36

Pixel

Question 37

Click on the __________ tab on the ribbon to open Backstage view.

Answer 37

File

Question 38

A __________ is the intersection of a column and a row.

Answer 38

Cell

Question 39

Each workbook has 16,384 columns and 1,048576 rows for a total of ____________.

Answer 39

17179869184

Question 40

A cell _________ is the coordinates of the intersection of a column and a row.

Answer 40

Reference

Question 41

The cell in which you canister data is called the _________ cell.

Answer 41

Active

Question 42

The horizontal and vertical lines on the worksheet are called __________.

Answer 42

Gridlines

Question 43

When you type contents into a cell, Excel displays the entry in the _________ bar.

Answer 43

Formula

Question 44

Excel displays the active cell reference in the ________ box on the left side of the formula bar.

Answer 44

Name

Question 45

A __________ is a visual representation of data.

Answer 45

Chart

Question 46

A ___________ is a series of two or more adjacent cells in a column or row or rectangular group of cells.

Answer 46

Range

Question 47

Excel provides predefined formulas which are called_________.

Answer 47

Functions

Question 48

The _________ is the small green square located in the lower right corner of the heavy border around the active cell. It may be used to copy formulas to adjacent cells.

Answer 48

Fill handle

Question 49

Use the __________ button to center contents over several columns.

Answer 49

Merge and center

Question 50

The __________ number format causes numbers to be displayed with tow decimal places and to align vertically with a $ before the number.

Answer 50

Accounting

Question 51

The ________ format causes numbers to be displayed with two decimal places and commas as thousands separators.

Answer 51

Comma style

Question 52

A ___________ chart shows the contribution of each piece of data to the whole, or total, of the data.

Answer 52

Pie

Question 53

A key logger is a type of _________ software that has the capability to record eery keystroke made to a log file.

Answer 53

Surveillance

Question 54

A key logger recorder can record __________ email, and any other information you type at any time using your keyboard.

Answer 54

Instant messages

Question 55

Key loggers can be embedded in __________ allowing your information to be transmitted to an unknown third party.

Answer 55

Spyware

Question 56

How do some employers use key loggers on the machines used by their employees?

Answer 56

Make sure employees use work computers for business purposes only

Question 57

Spyware is software that _________ gathers user information through a users Internet connection without his or her knowledge.

Answer 57

Covertly

Question 58

Spyware applications are typically bundled as a hidden component of _________ or shareware.

Answer 58

Free ware

Question 59

Spyware can also gather information about email addresses and even passwords and____________.

Answer 59

Credit card number

Question 60

Spyware is similar to a ___________ in that users unwittingly install the product when they install something else.

Answer 60

Trojan horse

Question 61

Rootlets are difficult to detect because they are activated before your systems __________ has completely booted up.

Answer 61

Operating system

Question 62

Rootlets are able to intercept data from ____________ , ___________, and the ____________.

Answer 62

Terminals, network connect, key board

Question 63

ICANN is short for _______________.

Answer 63

Internet corporation for Assigned names and numbers

Question 64

IANA is short for ______________.

Answer 64

Internet Assigned Numbers Authority

Question 65

IETF is short for______________.

Answer 65

Internet Engineering Task Force

Question 66

______________ was founded and run by Jon Postel, who is considered by many to be the father of the Internet.

Answer 66

IANA

Question 67

The daily oversight of assigning IP addresses is handled by__________.

Answer 67

IANA

Question 68

_________ was created as a non profit organization to take control away from the U.S. government.

Answer 68

ICANN

Question 69

The __________ develops internet standards and protocols, such as TCP.

Answer 69

IETF

Question 70

A temporary internet file is a file that is located on your hard drive and is used by __________ to store Web site data for every Web page or Url address the you visit.

Answer 70

Browser

Question 71

Loading a Website from a temporary Internet file is called_________.

Answer 71

Caching

Question 72

What is an advantage of having a temporary internet file stored on a device?

Answer 72

You can view the cached versions of recently visited web pages while offline.

Question 73

When you press the delete key in Windows, only ___________ to the files are moved.

Answer 73

Remove the short cuts

Question 74

____________ software allows anyone to reinstate data that has been deleted from a hard rive.

Answer 74

System recovery

Question 75

The disk wiping process will actually __________ your entire hard drive with data, several times.

Answer 75

Overwrite

Question 76

The government standard DoD 5520.22M, considered a medium security level, specifies _____________ iterations to completely overwrite a computer __________ times.

Answer 76

3,6

Question 77

Cookies are used by a Web server to keep track of what?

Answer 77

Users activity on a specific website

Question 78

Can a virus be spread with a cookie or access the hard drive of a computer?

Answer 78

No

Question 79

Can cookies read a computers hard drive?

Answer 79

No