INFS Stewart Exam 2
1) The ________ function is used to join the text from two or more cells into one cell. A) CONCATENATE B) PASTE C) PROPER D) TEXT
A) CONCATENATE
13) The ________ function is used to count the number of cells in a range that meet one specified criterion. A) COUNTIF B) COUNT C) COUNTA D) COUNTIFS
A) COUNTIF
2) The nodes on the original Internet system were ________. A) Educational institutions B) military bases C) large corporations D) marketing companies
A) Educational institutions
10) Which of the following transmission media is NOT used to transmit signals on an Ethernet network? A) Topology B) Twisted-pair C) Fiber-optic D) Wi-Fi
A) Topology
20) In VBA, a programming ________ is a statement that documents what the code does. A) comment B) statement C) sub D) module
A) comment
22) Which generation of programming languages is closer to natural language but still requires some programming knowledge? A) Fourth-generation B) Third-generation C) Fifth-generation D) Second-generation
A) fourth-generation
30) ________ is similar to the way people think, acknowledging that not everything can be answered as a yes or no question. A) Fuzzy logic B) Expert systems C) Neural networks D) Neural logic
A) fuzzy logic
4) In the ________ phase of the SDLC, the project team is assembled and the feasibility studies are completed. A) analysis B) planning C) maintenance D) implementation
B) planning
13) ________ technologies use telephone lines to carry digital signals. A) FTTH B) DSL C) FiOS D) WiMAX
B) DSL
20) Machine language is written in ________. A) binary B) C++ C) assembly language D) Java
A) binary
24) A lookup function that returns a value from a list based on an index number is the ________ function. A) WEEKDAY B) SERIAL C) CHOOSE D) WORKDAY
D) WORKDAY
11) Programs that interpret HTML to display a webpage are called ________. A) interpreters B) translators C) compilers D) web browsers
D) Web Browsers
14) ________ is a general term used to describe a set of tools that change the values in cells to show how those changes affect the outcome of other formulas on a worksheet. A) Goal Seek B) Scenario Manager C) Scenario Summary D) What-if analysis
D) What-if analysis
23) ________ raises money from multiple small investors rather than a few large ones. A) Crowdresourcing B) Crowdbrowing C) Crowdfunding D) Crowdsourcing
C) Crowdfunding
6) ________ make data entry easier because they can be set up to match the layout of a paper document. A) Reports B) Records C) Forms D) Queries
C) Forms
17) Which of the following is NOT a type of programming error? A) Syntax B) Runtime C) Logic D) Grammatical
D) grammatical
5) If your computer has a ________, someone else can gain access to it undetected. A) zombie B) logic bomb C) rootkit D) botnet
C) rootkit
17) In the URL http://www.irs.gov, irs is the ________. A) TLD B) protocol C) subdomain D) domain name
D) Domain name
4) To display records in a table that meet certain criteria, you would apply a ________. A) sort B) delimiter C) column D) filter
D) Filter
4) You can change the user name for your copy of Excel in the ________ section in the Excel Options dialog box. A) Customize Ribbon B) Proofing C) Formulas D) General
D) General
1) A ________ is descriptive text that is added to worksheet cells without modifying the data. A) note B) comment C) revision D) callout
B) comment
18) The ________ function searches for a specific item in a range and returns the relative position of the item. A) LOOKUP B) INDEX C) SUBTOTAL D) MATCH
C) SUBTOTAL
17) The file extension used for a chart template is ________. A) .xml B) .xlsx C) .xltx D) .crtx
D) .crtx
21) 198.168.0.1 is an example of a(n) ________. A) protocol B) domain name C) DNS D) IP address
D) IP address
15) A ________ is a dynamic visual representation of data with fields assigned to the value and category axes. A) PivotTable B) query C) slicer D) PivotChart
D) PivotChart
14) A third-party program, such as Adobe Flash Player, is considered to be a(n) ________. A) toolbar B) add-on C) tab D) plug-in
D) Plug-in
23) Which device on a network performs network address translation? A) Repeater B) Router C) Splitter D) Hub
B) Router
18) ________ is a high-level programming language that can be used to write and modify macros. A) VBE B) VBA C) HTML D) XML
B) VBA
6) A message that informs a user about the types of data allowed in a cell is a(n) ________. A) data message B) input message C) error message D) validation message
B) input message
21) In Excel, you can use ________ to automate tasks. A) C++ B) macros C) Java D) HTML
B) macros
19) A ________ error is an error in programming design that results in an unexpected outcome. A) syntax B) grammatical C) logic D) runtime
C) logic
9) When sending one email to everyone in your address book, you should use the ________ field to keep their addresses private. A) To: B) Cc: C) Subject D) Bcc:
D) Bcc:
26) You can use a social ________ site to save and share your favorites online. A) news B) media marketing C) review D) bookmarking
D) Bookmarking
15) The process that combines the changes from multiple copies of a workbook into a single copy is called ________. A) Compare Files B) Track Changes C) Accept Changes D) Compare and Merge
D) Compare and Merge
7) ________ is an unlawful attack on computers or networks done to intimidate a government or its people. A) Cybercrime B) Computer fraud C) Cyber-stalking D) Cyber-terrorism
D) Cyber-terrorism
9) Wireless access points that are available in public spaces are called ________. A) Hyperlinks B) Network Access Points C) Internet protocols D) Hotspots
D) Hotspots
28) Which is an example of a social news site? A) Facebook B) Yelp C) LinkedIn D) reddit
D) Reddit
28) An Excel add-in used to find solutions to a complex problem to achieve a desired goal is ________. A) What-if analysis B) Goal Seek C) Scenario Manager D) Solver
D) Solver
2) A text function used to remove spaces from a string leaving a single space between words is the ________ function. A) MID B) CHOOSE C) TEXT D) TRIM
D) TRIM
7) In what phase of the SDLC does testing occur? A) implementation B) analysis C) maintenance D) design
D) design
19) A ________ connects two or more computers in a network. A) repeater B) hub C) router D) switch
D) switch
10) The ________ function returns a value of TRUE when at least one of the specified conditions is true. A) OR B) AND C) IF D) VLOOKUP
A) OR
17) ________ recommends music to you based on your listening preferences. A) Picasa B) Pandora C) Flickr D) SnapDragon
B) Pandora
21) When you set up your wireless router, you should change the ________, which is also called the wireless network name. A) WAP B) SSID C) NAT D) WEP
B) SSID
21) A chart ________ is a quantity for which the value is selected for particular circumstances. A) data series B) type C) template D) parameter
D) parameter
8) The result of a ________ function depends on whether a condition is true or false. A) Statistical B) Text C) Logical D) Financial
C) Logical
9) During the ________ phase of the SDLC, updates to the system may occur, bugs are fixed, and new features are added. A) implementation B) analysis C) maintenance D) design
C) maintenance
5) A ________ network is one that has at least one computer that provides centralized management, resources, and security. A) homegroup B) peer-to-peer C) workgroup D) client-server
D) client-server
11) A ________ is a device that connects two or more networks together. A) router B) hub C) switch D) modem
A) Router
23) The ________ function adds the cells in a range that meet one specified criterion. A) SUMIF B) SUM C) SUMIFS D) SUMA
A) SUMIF
18) The ________ must remain fixed in order to calculate the future value of an asset. A) interest rate B) principal C) period D) present value
A) interest rate
23) A(n) ________ is a control that is compatible with earlier versions of the program. A) legacy object B) ActiveX control C) button D) check box
A) legacy object
4) A ________ network is a network in which all computers are considered equal. A) peer-to-peer B) homegroup C) client-server D) workgroup
A) peer-to-peer
6) Before you can use the Subtotal tool to display summary statistics, you must ________ the column to be subtotaled. A) sort B) group C) total D) filter
A) sort
10) ________ can be used in a PivotTable report to visually separate the data. A) Row labels B) Banded columns C) Summary statistics D) Column labels
B) Banded columns
9) ________ hackers hack into systems to steal or vandalize. A) Red-hat B) Black-hat C) Gray-hat D) White-hat
B) Black-hat
8) To connect peripherals at short ranges, you would use the ________ wireless technology. A) Ultraviolet B) Bluetooth C) Infrared D) RFID
B) Bluetooth
16) The ________ feature prevents unauthorized users from making changes to a worksheet. A) Lock Cells B) Protect Sheet C) Protect Workbook D) Lock Sheet
B) Protect Sheet
22) The rules for communication between devices are called ________. A) firewalls B) protocols C) packets D) domains
B) Protocols
12) ________ conveys the steps of an algorithm using English-like statements that focus on logic, not syntax. A) Quasicode B) Pseudocode C) Virtual code D) Structured code
B) Pseudocode
29) Using social media to sell services is called ________. A) Short Message Service (SMS) B) Social media marketing (SMM) C) Secure Sockets Layer (SSL) D) Really Simple Syndication (RSS)
B) Social Media Marketing (SMM)
10) In a relational vehicle database, a ________ relationship occurs when each vehicle record may link to several repair records, but each repair can link to only one vehicle. A) simple query B) many-to-many C) one-to-one D) one-to-many
D) one-to-many
2) Each computer is considered equal in a ________ network. A) client-server B) wide area C) virtual private D) peer-to-peer
D) peer-to-peer
31) When you buy a textbook online from Amazon.com, you are participating in ________ e-commerce. A) B2B B) C2A C) A2C D) B2C
D)B2C
10) Hacking to make a political statement is called ________. A) politicking B) sneaking C) cracking D) hacktivism
D)hacktivism
25) An online environment for programming that allows development, testing, and deploying custom applications is called ________. A) client-side programming B) platform-as-a-service C) software-as-a-service D) server-side programming
B) platform-as-a-service
6) The ________ in a PivotTable use the values to categorize the data by rows. A) records B) row labels C) groups D) fields
B) row labels
2) In a database, a ________ stores data in rows and columns. A) field B) table C) cell D) matrix
B) table
22) The ________ feature allows you to define intervals at which to save copies of all open Excel files. A) AutoSave B) DocumentRecovery C) AutoRecover D) RecoverAll
C) AutoRecover
30) When one business provides services for another, it is a type of e-commerce called ________. A) C2B B) C2C C) B2B D) B2C
C) B2B
29) The process used by Excel to compute formulas and functions and display the results is called ________. A) computation B) solving C) calculation D) updating
C) Calculation
19) In VBA, a ________ is a set of instructions that is part of a program. A) comment B) statement C) sub D) module
C) sub
22) An array formula is enclosed in ________ brackets. A) ( ) B) [ ] C) { } D) " "
C) {}
4) When a formula contains the wrong type of data, the ________ error value occurs. A) #VALUE B) #NAME? C) #REF! D) #N/A
A) #VALUE
26) The function used to calculate the average of cells that meet multiple criteria is ________. A) AVERAGEIFS B) AVERAGE C) SUMIF D) AVERAGEIF
A) AVERAGIFS
32) ________ e-commerce allows anyone to sell or trade items online. A) C2C B) C2B C) B2C D) B2B
A) C2C
36) The # symbol used by Twitter is called a(n) ________. A) hashtag B) avatar C) forum D) digital footprint
A) hashtag
9) The ________ function returns a value of TRUE only when ALL specified conditions are true. A) OR B) AND C) IF D) VLOOKUP
B) AND
15) You would install a(n) ________ if you wanted to enable new capabilities in your web browser. A) toolbar B) add-on C) plug-in D) taskbar
B) Add-on
19) The ________ function defines categories and how data is aggregated in an OLAP cube. A) CUBE B) CUBEMEMBER C) CUBEVALUE D) Inquire
B) CUBEMEMBER
5) An email claiming that you have won a lottery might be an example of ________. A) cyberbullying B) computer fraud C) cyber-stalking D) cyber-harassmen
B) computer fraud
9) An Excel spreadsheet is an example of a(n) ________ database. A) object-oriented B) flat C) relational D) hierarchical
B) flat
8) A cell value that is referred to in a formula or function is a(n) ________ cell. A) argument B) precedent C) dependent D) relative
B) precedent
1) In a one-to-one relationship, both tables use the same ________ to link two records. A) query B) primary key C) foreign key D) form
B) primary key
6) If the referenced cells in a formula do not contain any data, the ________ error value occurs. A) #VALUE B) #NAME? C) #REF! D) #N/A
C) #REF!
25) When using Windows, to make changes, install hardware, or configure settings, you need to use the ________ account on your computer. A) client B) guest C) administrator D) master
C) administrator
30) GIS is made up of datasets, also called ________, of geographically referenced information about Earth's surface. A) sets B) information C) datacaches D) layers
D) layers
14) A ________ is a collection of table formatting options that can be applied to a range with a single click. A) thumbnail B) fill style C) style set D) table style
D) table style
11) The collection of websites that enable users to create user-generated content, connect, network, and share is called social ________. A) methods B) channels C) connections D) media
D) Media
6) When the Internet backbone was privatized, five large ________ Access Points made up the new backbone. A) Ethernet B) Fiber C) Wireless D) Network
D) Network
11) A ________ in a PivotTable report is derived from formulas you create, which can include other PivotTable fields. A) row value B) summary statistic C) Value Field Setting D) calculated field
D) calculated field
3) A ________ contains the information for a single entity in the database. A) table B) record C) field D) cell
D) cell
22) A(n) ________ is a control that allows a user to select one or more values in a group of choices. A) legacy object B) ActiveX control C) button D) check box
D) check box
16) The rules that ensure the correct construction of coding commands in a programming language is called the ________. A) grammatical B) logic C) semantic D) syntax
D) syntax
22) To secure your wireless network at home, you should ________. A) back up the computers on the network B) password-protect important document files C) set the SSID to CLOSED D) use wireless encryption with a difficult passphrase
D) use wireless encryption with a difficult passphrase
22) Microsoft Office is an example of a(n) ________. A) geographic information system (GIS) B) office support system (OSS) C) transaction-processing system (TPS) D) Structured Query Language (SQL)
B) office support system (OSS)
19) A data ________ rule would prevent a user from entering text in a date/time field. A) manipulation B) validation C) monitoring D) redundancy
B) validation
16) Wi-Fi networks used in homes and public hotspots use the ________. A) W3C standards B) IEEE 802.11 standards C) POP protocols
B) IEEE 9802.11 standards
13) The ________ records all changes made to a workbook, who made the change, and when the data was changed. A) tracking log B) change history C) change tracking D) review log
B) change history
35) A Facebook ________ is used to promote an organization, a product, or a service. A) Page B) Account C) profile D) user
A) Page
16) A custom chart type that you can save and apply like any other chart type is a ________. A) chart template B) chart style C) dual axis chart D) chart sheet
A) chart template
27) When you enter your credit card information in a website, you know the website is encrypted when you see ________ in the address bar. A) https B) http C) shttp D) ssl
A) https
21) To ensure that a person does not misspell Wednesday in a field, a(n) ________ list can be used. A) lookup B) Find feature C) master
A) lookup
16) You can use the ________ function to retrieve summary data from a PivotTable report. A) CUBEVALUE B) GETPIVOTDATA C) CUBE D) Slicer
B) GETPIVOTDATA
4) In a database, a ________ is the collection of related data that displays in a row. A) group B) record C) label D) field
B) Record
18) If you misspell a command word in a computer program, you have created a ________ error. A) runtime B) semantic C) syntax D) logic
B) semantic
5) If there is no match when a Lookup function is employed, the ________ error value occurs. A) #VALUE B) #NAME? C) #REF! D) #N/A
D) #N/A
10) ________ is the authoring language that defines the structure of a webpage. A) Hypertext B) User-generated content C) TLD D) HTML
D) HTML
22) Which organization coordinates the Internet naming system? A) FCC B) WWW C) W3C D) ICANN
D) ICANN
21) The ________ add-in assists with analyzing and reviewing workbooks to understand their design function and data dependencies. A) OLAP B) Power View C) Power Pivot D) Inquire
D) Inquire
12) What project was coordinated by the U.S. Department of Energy and the National Institutes of Health? A) ARPANET B) Integrated Automated Fingerprint Identification System C) Combined DNA Index System D) Human Genome Project
D) human genome project
10) The ________ feature is used to view changes in cells that are not visible in the worksheet. A) Trace Precedents B) Formula Auditing C) Data Table D) Watch Window
D) watch window
10) A trendline in which the data points create a symmetric arc is a(n) ________ trendline. A) Linear Forecast B) Moving Average C) Exponential D) Linear
C) Exponential
6) For a company that uses only two floors of an office building, all of the company's computers and printers will be connected by a ________. A) WAN B) MAN C) LAN D) PAN
C) LAN
13) A company with offices in Buffalo and Seattle would use dedicated ________ lines to connect the two offices. A) PAN B) WLAN C) WAN D) MAN
C) WAN
15) In a dual axis chart, one or more data series can be plotted on a ________ axis. A) trendline B) primary vertical C) secondary vertical D) horizontal
C) secondary vertical
18) Antivirus software uses ________ to search for known viruses. A) virus checks B) stop-and-search checks C) definition date checks D) signature checking
D) signature checking
12) Which of the following is NOT a common LAN topology? A) Star B) Bus C) Hierarchical D) Ring
C) Hierarchial
24) Fifth-generation programming languages are primarily used in ________ applications. A) binary B) SaaS C) artificial intelligence D) webpage
C) artificial intelligence
23) Which is NOT a SQL relational keyword? A) WHERE B) QUIT C) FROM D) SELECT
B) Quit
8) The least expensive form of Internet connection is ________. A) DSL B) cable C) FTTH D) dial-up
D) Dial-up
16) In the URL http://www.irs.gov, http is the ________. A) TLD B) subdomain C) domain name D) protocol
D) Protocol
15) ________ is the largest online video-hosting site in the world. A) Flickr B) MySpace C) Skype D) YouTube
D) Youtube
20) A router is a form of security because it ________. A) scans your email for malicious content B) implements User Account Control (UAC) C) scans webpages before displaying the content D) acts like a firewall
D) acts like a firewall
14) In a virtual community, you can communicate with other people by using a(n) ________. A) captcha B) profile C) alias D) avatar
D) avatar
11) A ________ workbook is one in which multiple users on a network can make changes at the same time. A) shared B) collaborative C) network D) tracked
A) shared
5) ________ is an example of asynchronous communication. A) Skype B) Email C) Chat D) VoIP
B) Email
1) An Excel workbook can contain only one ________. A) transformation B) data model C) query D) data shape
B) data model
25) Wikis are designed for ________, which is allowing people to contribute more than just posting a response. A) collaboration B) expert opinions C) asynchronous communication D) synchronous communication
A) Collaboration
18) The backbone of the Internet is composed of numerous Internet ________ Points around the world. A) Exchange B) Connection C) Hyperlink D) Relay
A) Exchange
16) ________ is the largest online image-sharing site in the world. A) Flickr B) MySpace C) Skype D) LinkedIn
A) Flickr
27) The ________ function looks for a value in the top row of a table and returns a value from a row in the same column. A) VLOOKUP B) HLOOKUP C) INDEX D) ARRAY
A) HLOOKUP
1) Which of the following is a method of synchronous online communication? A) Instant Messaging B) Email C) Forum D) Newsgroup
A) Instant messaging
3) ________ allows you to communicate with one person at a time. A) Instant messaging B) Really Simple Syndication (RSS) C) User generated content D) Secure Sockets Layer (SSL)
A) Instant messaging
20) You can only share workbooks through the E-mail command in Excel if your organization uses ________. A) Outlook B) Gmail C) Yahoo! D) Hotmail
A) Outlook
17) ________ is an Excel add-in that is a powerful tool used for data analysis and to create data models. A) Power Pivot B) Power View C) PivotChart D) Inquire
A) Power Pivot
3) ________ data modifies the data from other data sources to meet your needs. A) Transforming B) Modeling C) Querying D) Combining
A) Transforming
17) A ________ appears to be a legitimate program, but is actually something malicious. A) Trojan horse B) worm C) rootkit D) botnet
A) Trojan horse
25) The ________ function takes a serial number value and returns the day of the week. A) WEEKDAY B) SERIAL C) CHOOSE D) WORKDAY
A) WEEKDAY
5) The desired output from the ________ phase of the SDLC is a list of requirements for a new system. A) analysis B) maintenance C) planning D) design
A) analysis
15) Network speeds are measured in ________ per second. A) bits B) hertz C) nanos D) bytes
A) bits
3) A ________ displays as a red triangle in the upper right corner of a cell. A) comment indicator B) locked cell C) tracked change D) flag
A) comment indicator
34) ________ is one of the most popular C2C websites. A) eBay B) Amazon C) Google Checkout D) PayPal
A) eBay
7) A message that informs a user that invalid data has been entered in a cell is a(n) ________. A) error alert B) validation message C) input message D) data message
A) error alert
10) The ________ Error alert is the most flexible and allows the user to just click OK to accept invalid data. A) Information B) Alert C) Warning D) Stop
A) information
1) The SDLC follows the development of a system from planning to the final stage, ________. A) maintenance B) implementation C) analysis D) design
A) maintenance
20) A data ________ defines the fields in a database and the type of data that each field contains. A) mine B) dictionary C) warehouse D) reference
A) mine
14) Data in a(n) ________ database are stored in data cubes. A) multidimensional B) relational C) hierarchical D) flat
A) multidimensional
31) Simulating human thinking by emulating the biological connections of the brain is called ________. A) a neural network B) biofeedback C) fuzzy logic D) an expert system
A) neural network
12) A ________ data table changes a value in a formula using input from either a row or a column. A) one-variable B) zero-variable C) two-variable D) variable
A) one-variable
3) In a delimited text file, each row ends with a ________. A) paragraph mark B) tab C) comma D) period
A) paragraph mark
10) The ________ a set of five steps that a programmer follows to create a computer program. A) Software Design Lifecycle B) Program Development Cycle C) Program Design Lifecycle D) Computer Programming Cycle
A) software design lifecycle
15) A small sample image of a style displayed in a gallery is a ________. A) thumbnail B) snapshot C) clip D) snip
A) thumbnail
17) Once a worksheet is protected, you must ________ any cells to which you want to allow changes. A) unlock B) lock C) protect D) unprotect
A) unlock
7) The PivotTable ________ display the summary statistics for the selected fields in the report. A) values B) row labels C) groups D) fields
A) values
20) Tweets are limited to ________ characters each. A) 50 B) 140 C) 230 D) 340
B) 140
8) A distorted series of letters and numbers, called a ________, is used to ensure that you are a human and not a computer. A) password B) captcha C) signature D) verification
B) Captcha
24) When you trust the collective opinion of a crowd of people rather than an expert, it is known as ________. A) crowdresourcing B) crowdsourcing C) crowdsampling D) crowdreferencing
B) Crowdsourcing
1) The Internet was originally created as a communication system for the ________. A) Department of Education B) Department of Defense C) U.S. Congress D) University System
B) Department of Defense
5) In a database, title, author, publication date, and ISBN are examples of ________. A) records B) fields C) tables D) queries
B) Fields
20) A ________ can be set by an employer to prevent you from accessing eBay. A) switch B) firewall C) router D) wireless access point
B) Firewall
16) The ________ of an asset, such as an investment or a home, is its value at the end of a period of time. A) final value B) future value C) investment value D) present value
B) Future Value
19) Workbooks can be shared directly to ________ in Excel 2016 if you are logged into a Microsoft account. A) Save and Send B) OneDrive C) Google D) Dropbox
B) OneDrive
18) ________ is an Excel add-in that allows the user to interact with data and create visualizations and presentations. A) Power Pivot B) Power View C) PivotChart D) Inquire
B) Power View
21) Podcasts allow time ________, so you can listen on your own schedule. A) lagging B) shifting C) delay D) warping
B) Shifting
6) ________ technology is used for sending email messages. A) Forward-and-push B) Store-and-forward C) Get-and-put D) Push-and-pull
B) Store and forward
19) Most home routers also include a built-in ________. A) range extender B) switch C) hub D) network interface card
B) Switch
26) .com is an example of a(n) ________. A) DNS B) TLD C) LTE D) NAP
B) TLD
21) A(n) ________ formula would be used to calculate the sum of the values in one column multiplied by the sum of the values in another column. A) logical B) array C) lookup D) statistical
B) array
21) The INDEX function ________ returns a value from a location in a table or range of cells. A) table B) array C) reference D) name
B) array
16) A ________ changes your home page and redirects you to other websites. A) zombie B) browser hijacker C) rootkit D) botnet
B) browser hijacker
27) A(n) ________ improves over time by learning from its interactions. A) knowledge base B) cognitive computing system C) decision support system D) inference engine
B) cognitive computing system
5) Data can be sorted based on the ________ applied to each cell in a column. A) number formatting B) conditional formatting C) border color D) font
B) conditional formatting
11) A(n) ________ uses a range of cells to show how changing one or two values in a formula will affect the formula's result. A) Watch Window B) data table C) Outline pane D) Formula Audit
B) data table
1) A file in which the data in each column is separated by an identifying character such as a comma is a ________ text file. A) fixed B) delimited C) separated D) columnar
B) delimited
14) When data series in a chart have mixed types of data, you can use a ________ chart to plot a second value series. A) pie B) dual axis C) column D) bar
B) dual axis
18) The standard way that information in a file is encoded for storage is called the ________. A) file template B) file type C) software version D) worksheet template
B) file type
11) A graphic view of an algorithm is called a ________. A) structure chart B) flowchart C) Venn diagram D) Gantt chart
B) flowchart
17) ________ is a what-if analysis tool that finds a specific value for a cell by adjusting the value of another cell. A) Formula Auditing B) Goal Seek C) Trace Precedents D) Convert Table to Range
B) goal seek
7) Subtotaled data is displayed as a(n) ________ with three levels. A) chart B) group C) outline D) table
B) group
29) The ________ was created in an effort to make it easier for victims to report cybercrimes. A) USA PATRIOT Act B) Internet Crime Complaint Center C) Homeland Security Act D) Computer Fraud and Abuse Act
B) internet crime complaint center
14) Which statement about a logic bomb is FALSE? A) They are often planted by disgruntled IT workers. B) It can spread to other machines. C) It can lay dormant until specific conditions are met. D) It can be triggered on a specific date.
B) it can spread to other machines
25) An expert system is a computer programmed to ________. A) use SQL statements to respond to requests B) make decisions in real-life situations C) search the web for experts D) present possible decision outcomes
B) make decisions in real-life situations
4) Clickjacking results in ________. A) sending spam to your friends' email accounts B) malware posting unwanted links on your Facebook page C) you sending money to get more money in return D) your Facebook account being closed without your knowledge
B) malware posting unwanted links on your Facebook page
1) In Excel, a file that is not the current Excel 2016 format is a ________ file. A) text B) non-native C) binary D) native
B) non-native
13) Another name for the actual attack caused by a virus is a ________. A) worm B) payload C) logic bomb D) hoax
B) payload
17) The future value of an asset can be calculated when ________ are constant over time. A) investments B) payments C) withdrawals D) deposits
B) payments
16) The ________ database is the most popular type used by businesses. A) hierarchical B) relational C) multidimensional D) flat
B) relational
17) If you want to connect your home network to the Internet, you will need a ________ in addition to a modem. A) repeater B) router C) terminator D) switch
B) router
23) A(n) ________ can be used in or returned by a function to indicate the position of a value in a series. A) parameter B) serial number C) auto number D) index
B) serial number
14) A tool used with a PivotTable to filter data based on distinct values in columns is a ________. A) timeline B) slicer C) calculated field D) group
B) slicer
4) Which would make the best primary key in a table? A) Last name B) Social Security number C) First name D) Street Address
B) social security number
24) You should use a(n) ________ account for everyday computing on a computer running Windows. A) guest B) standard C) visitor D) administrator
B) standard
18) A ________ is a device that connects multiple devices on a LAN. A) bus B) switch C) router D) repeater
B) switch
8) To print data or display it in an easy to read format, a ________ can be used. A) report B) table C) record D) form
B) table
11) A prebuilt workbook that already contains content and formatting which can be used as a pattern to create a new workbook is a ________. A) trendline B) template C) chart D) consolidation
B) template
9) A ________ is an object that can be inserted on a worksheet to provide additional information. A) caption B) text box C) cell D) range
B) text box
3) What was the ARPANET? A) A project of the Department of Transportation B) The origins of the Internet C) A network of two computers D) A network originally authorized by President Truman
B) the origins of the internet
19) The FTP protocol is used to ________. A) log in to a secure webpage B) transfer files C) surf the web D) verify an email address
B) transfer files
12) The difference between a virus and a worm is a ________. A) worm is a threat to your computer, but a virus is not B) virus needs a host file, but a worm does not C) virus replicates itself, but a worm cannot self-replicate D) virus is a threat to your computer, but a worm is not
B) virus needs a host file, but a worm does not
20) If loan payments will be made monthly for 10 years, ________ should be entered as the Nper argument in the FV function. A) 1 B) 10 C) 120 D) 12
C) 120
19) If the annual interest rate of a loan is 5% and you want to calculate the interest rate for each monthly payment, you would enter ________ as the Rate argument in the FV function. A) 5% B) 5% * 12 C) 5% / 12 D) - 5%
C) 5% /12
24) Which operator is used to return results that includes two specific words? A) NOT B) BUT C) AND D) OR
C) AND
4) ________ communication allows you to send a message to someone who is not online at the same time. A) Static B) Dynamic C) Asynchronous D) Synchronous
C) Asynchronous
29) ________ is the application of information technology to the field of biology. A) Biofeedback B) Biocoenosis C) Bioinformatics D) Bioengineering
C) Bioinformatics
12) The ________ function is used to count the number of cells in a range that are not blank. A) COUNTIF B) COUNT C) COUNTA D) COUNTIFS
C) COUNTA
20) The ________ function defines the values derived from the cross-tabulation of the categories in an OLAP cube. A) CUBE B) CUBEMEMBER C) CUBEVALUE D) Inquire
C) CUBEVALUE
12) The ________ command is used to summarize and report results from separate worksheets. A) Subtotal B) Group C) Consolidate D) Outline
C) Consolidate
23) The ________ enables users to enter a friendly name like whitehouse.gov instead of an address like 74.125.224.72. A) IP B) TLD C) DNS D) ISP
C) DNS
7) Which broadband service are you likely to use if you live in a very remote area? A) Cable B) Satellite C) DSL D) Fiber
C) DSL
5) ________ rules place restrictions on the types of data that can be entered into cells. A) Data protection B) Data type C) Data validation D) Proofing
C) Data Validation
14) The ________ worksheet displays the entire change history and does not display again when the workbook is closed and reopened. A) Review B) Changes C) History D) Tracking
C) History
7) Which statement about email is FALSE? A) Copies of your email may exist on several servers even after the recipient deletes it. B) Your employer may read your email at your work. C) It cannot be accessed by hackers. D) Email can be used for targeted marketing
C) It cannot be accessed by hackers
27) Which of the following is a client-side programming technology? A) Perl B) PHP C) JavaScript D) JSP
C) JavaScript
13) ________ is a social network that is designed for business connections. A) Facebook B) Twitter C) LinkedIn D) Yahoo!
C) LinkedIn
7) A trendline that has data points following a smooth curve to show data fluctuations is a(n) ________ trendline. A) Exponential B) Linear C) Moving Average D) Linear Forecast
C) Moving Average
25) Wi-Fi that is made available in some cities and towns is known as ________ Wi-Fi. A) Broadband B) Regional C) Municipal D) Corporate
C) Municipal
15) ________ allows the user to selectively extract data from different viewpoints. A) An office support system (OSS) B) A transaction-processing system (TPS) C) Online analytical processing (OLAP) D) A decision support system (DSS)
C) Online analytical processing (OLAP)
2) The ________ function is used to capitalize the first letter of each word of text. A) PASTE B) CONCATENATE C) PROPER D) TEXT
C) PROPER
22) You can subscribe to ________ feeds to stay up-to-date on podcasts and news feeds. A) NSS B) DNS C) RSS D) PSS
C) RSS
24) The ________ function adds the cells in a range that meet multiple criteria. A) SUM B) SUMA C) SUMIFS D) SUMIF
C) SUMIFS
11) ________ functions are used to describe a collection of data such as totals, counts, and averages. A) Logical B) Text C) Statistical D) Financial
C) Statistical
9) In a PivotTable report, the default statistic that is calculated for each group is a(n) ________. A) average B) count C) total D) maximum
C) Total
19) ________ is an example of a microblogging site that allows a limited number of characters in a post. A) The Blogosphere B) Blogger C) Twitter D) Flickr
C) Twitter
14) Employees who are travelling can connect securely to their office network through the Internet when a ________ has been established. A) PAN B) LAN C) VPN D) WLAN
C) VPN
7) In a WLAN, devices are connected by ________. A) ultraviolet B) Bluetooth C) Wi-Fi D) RFID
C) Wi-Fi
33) What happens when you click the padlock icon on a webpage? A) You can turn off the security setting of the website. B) You can turn on the security setting of the website. C) You can get a security report about the website. D) There is no padlock icon on a webpage.
C) You can get a security report about the website
15) Procedural programming involves ________. A) writing executable pseudocode B) defining objects and the actions that can be performed on them C) a step-by-step list of instructions D) drawing flowcharts to ensure that procedures are followed
C) a step-by-step list of instructions
28) Knowledge engineers develop ________, which are programmed to make decisions in real-life situations. A) fuzzy logic B) clones C) knowledge bases D) expert systems
C) knowledge bases
28) In an office acceptable use policy (AUP), which of the following might be prohibited? A) Checking work email B) Purchasing business supplies online C) Logging in to eBay D) Viewing an associate's electronic calendar
C) logging in to eBay
3) Which is the correct order of the phases in the SDLC? A) Requirements, analysis, design, implementation and testing, maintenance B) Requirements, planning, design, implementation, testing C) Planning, analysis, design, implementation and testing, maintenance D) Planning, requirements, design, implementation, testing
C) planning, analysis, design, implementation and testing, maintenance
7) A ________ could be used to retrieve all the phone numbers from a student database. A) table B) report C) query D) form
C) query
18) Which is NOT an advantage of data normalization? A) Makes it easier to update records B) Increases query speed C) Reduces the database size D) Increases database development time
C) reduces the database size
20) The INDEX function ________ returns the reference of a cell at the intersection of a specified row and column. A) table B) array C) reference D) name
C) reference
11) Which statement about cookies is FALSE? A) They are used by websites to identify you. B) It is a small text file. C) They cannot collect information you do not want to share. D) They can be installed without your knowledge.
C) they cannot collect information you do not want to share
23) C++ is an example of a ________-generation language. A) fourth B) fifth C) third D) second
C) third
13) A ________ data table changes one value in a formula using one input from a column and one input from a row. A) one-variable B) zero-variable C) two-variable D) variable
C) two-variable
8) When the data validation Error alert is set to ________, the user is given the option to proceed even if the data is invalid. A) Information B) Alert C) Warning D) Stop
C) warning
37) ________ is used to make a website easier to find by both people and software and increases a webpage ranking in search engine results. A) RSS B) SMM C) SEO D) IM
C)SEO
25) The ________ function is used to calculate the average of a range of cells that meet one criterion. A) AVERAGEIFS B) AVERAGE C) AVG D) AVERAGEIF
D) AVERAGEIF
18) A ________ is similar to an online journal, in which you can write about anything you want to share. A) bulletin B) log C) chronicle D) blog
D) Blog
12) All the information someone can find out about you by searching the web is called your ________. A) avatar B) folksonomy C) tagged information D) digital footprint
D) Digital footprint
8) The PivotTable ________ pane is used to change fields from rows to columns, to add or remove fields, and to change the fields used to calculate values. A) Pivot B) Summary C) Values D) Fields
D) Fields
8) A trendline that has data points following a nearly straight line is a(n) ________ trendline. A) Linear Forecast B) Moving Average C) Exponential D) Linear
D) Linear
3) The ________ function returns a specified number of characters starting from a specified position in the data. A) LEFT B) TRIM C) RIGHT D) MID
D) MID
6) ________ redirects you to a phony website by hijacking a domain name. A) Phishing B) Clickjacking C) Shill bidding D) Pharming
D) Pharming
4) The ________ function returns a specified number of characters, starting from the right side of the data. A) LEFT B) MID C) TRIM D) RIGHT
D) RIGHT
15) A ________ is a set of values that Excel can save and substitute in cells to perform a what-if analysis. A) summary B) range C) goal D) scenario
D) Scenario
10) An email ________ is a block of text that is automatically put at the end of your messages. A) closing B) salutation C) identifier D) signature
D) Signature
27) ________ sites let users evaluate hotels, movies, games, books, and other products and services. A) Social bookmarking B) Really Simple Syndication C) Captcha D) Social review
D) Social Review
8) When a company pays people to hack into its own system, it calls in ________ hackers. A) green-hat B) black-hat C) gray-hat D) white-hat
D) White-hat
2) The cyberbullying of one adult by another adult, using a computer is known as ________. A) pharming B) phishing C) cyberbullying D) cyber-harassment
D) cyber-harassment
1) A database is a collection of ________ that has been organized in a meaningful way. A) spreadsheets B) files C) information D) data
D) data
31) GIS can be used by local municipalities to ________. A) capture criminals B) budget for waste management facilities C) warn citizens of weather-related events D) design emergency routes
D) design emergency routes
5) In a database, a ________ is a category of data organized in a column. A) record B) label C) group D) field
D) field
13) Which is a type of data that can be stored in an object-oriented database? A) Documents and spreadsheets B) Documents C) Spreadsheets D) Images, audio, and video
D) images, audio, and video
26) A(n) ________ is a set of rules that are used to apply a knowledge base to each situation. A) difference engine B) cognitive computing system C) decision support system D) inference engine
D) inference engine
17) The science and telecommunication industries would most likely use the ________ database type. A) multidimensional B) relational C) flat D) object-oriented
D) object-oriented
3) An email supposedly from your bank asking for your password so that it can troubleshoot your account is a form of ________. A) pharming B) cyber-stalking C) cyberbullying D) phishing
D) phishing
24) When you decide to use your neighbor's open wireless network without permission, you are ________. A) hacking B) trolling C) wardriving D) piggybacking
D) piggybacking
13) Worksheet data can be consolidated by ________. A) outline level B) columns or rows C) subtotals D) position or category
D) position or category
2) The process of applying transformations to data is known as ________ data. A) combining B) modeling C) querying D) shaping
D) shaping
21) In VBA, a programming ________ is a line of instructions in a sub. A) comment B) module C) sub D) statement
D) statement
9) When the data validation Error alert is set to ________, the user is prevented from entering invalid data in the cell. A) Information B) Alert C) Warning D) Stop
D) stop
2) A ________ file is one that stores only characters and no formatting. A) tabbed B) fixed C) flat D) text
D) text
28) Which is NOT a CODIS index? A) Arrestee B) Forensic C) Missing Persons D) Victims
D) victims
25) Moving through a neighborhood trying to locate open wireless access points is called ________. A) surfing B) trolling C) hacking D) wardriving
D) wardriving
2) The SDLC, the traditional model for system development, is also called the ________ approach. A) spiral B) whirlpool C) Gantt D) waterfall
D) waterfall
13) ________ is the process of converting an algorithm into a language the computer can understand. A) Debugging B) Flowcharting C) Coding D) Writing
C) Coding
30) The ________ Act passed by the U.S. Congress in 1986 made it a crime to access classified information. A) USA PATRIOT B) Cyber Security Enhancement C) Computer Fraud and Abuse D) Cybersecurity
C) Computer Fraud and Abuse
1) Which cybercrime is considered to be a form of harassment? A) Pharming B) Clickjacking C) Cyber-stalking D) Phishing
C) Cyber-Stalking
23) The ________ protocol resolves the domain name amazon.com to an IP address. A) SMTP B) DHCP C) DNS D) FTP
C) DNS
2) A copy of Excel can be personalized by adding a(n) ________ in the Excel Options dialog box. A) property B) tag C) user name D) account
C) username
3) Which of the following statements about P2P networks is FALSE? A) They can only support a small number of devices. B) The services and security are centralized. C) All computers are considered equals. D) They can share a printer.
B) The services and security are centralized
12) Adding a browser ________ gives you quick access to the features of the application that installed it. A) add-on B) toolbar C) plug-in D) home page
B) Toolbar
7) The ________ function searches the first column in a table to find matching values. A) VALUE B) VLOOKUP C) MATCH D) HLOOKUP
B) VLOOKUP
2) A moderated chat room ensures that ________. A) parental controls are in effect B) all content is screened C) only subscribers participate D) no one under the age of 18 is online
B) all content is screened
16) A ________ can be applied to a table that can be used to reference the table in formulas or to select the table. A) style B) name C) range D) filter
B) name
3) PROPER(CONCATENATE(B2," ",C2)) is an example of a ________ function. A) combined B) nested C) layered D) string
B) nested
29) A doctor may use a(n) ________ to help diagnose an illness. A) knowledge base B) neural network C) expert system D) clone
B) neural network
20) The s in https stands for ________. A) sponsored B) secure C) system D) service
B) secured
1) P2P networks are normally found in ________. A) corporations B) universities C) homes D) libraries
C) homes
5) A ________ is a chart element used to identify the data series in the chart. A) title B) data point C) legend D) category
C) legend
26) Which of the following is a server-side programming technology? A) JavaScript B) ActiveX controls C) Java applets D) ASP
D) ASP
4) What is the Internet backbone? A) A company's main connection to the Internet B) The system of satellites that carry the Internet's signals C) The four original nodes of the Internet D) High speed connection between networks
D) high speed connection between networks
8) In what phase of the SDLC does user training take place? A) analysis B) planning C) maintenance D) implementation
D) implementation
14) When you define objects and the actions that can be performed on them, you are using ________ programming. A) procedural B) object-methodology C) algorithm D) object-oriented
D) object-orientated
6) In a column chart, a group of related columns represents a ________ in the chart. A) data series B) data point C) legend D) slice
A) data series
19) When using the MATCH function, a value of 0 for the Match_type argument will return the first value in the specified range that is ________ the Lookup_value. A) equal to B) greater than or equal to C) less than or equal to D) greater than
A) equal to
13) A plus sign next to a group in a PivotTable report is a(n) ________ icon. A) expand B) summary C) filter D) collapse
A) expand
5) The 4G network standard includes ________ technologies. A) FTTH B) DSL C) LTE D) FiOS
C) LTE
26) Which would be the strongest password? A) customer B) p22w0r6 C) p@55W0?d D) p@ssw*rd
C) p@55W0?d
9) One of the most important reasons for Ethernet standards is it ________. A) can prevent unauthorized users from accessing the Internet B) allows the government to keep tabs on what you are doing C) assures equipment from different manufacturers is compatible D) prevents overburdening your computer
C) assures equipment from different manufacturers in compatible
24) The test that a transaction processing system uses to make sure that transactions are fully completed or aren't undertaken at all is known as ________. A) consistency B) isolation C) atomicity D) durability
C) atomicity
12) The Excel feature that allows reviewers to see the changes made by all reviewers is ________. A) merging B) collaboration C) change tracking D) comments
C) change tracking
24) A ________ is a control that runs a VBA macro when clicked. A) legacy object B) check box C) command button D) module
C) command button
9) A cell value that gets it value from the value in another cell is a(n) ________ cell. A) absolute B) precedent C) dependent D) relative
C) dependent
6) The ________ is the logical model of a new system. A) specification list B) system specification report C) design diagram D) requirement report
C) design diagram
21) A ________ is a network composed of a group of clients and servers under the control of one central security database. A) homegroup B) workgroup C) domain D) client
C) domain
12) ________ displays only the data that satisfies specified conditions. A) Sorting B) Expanding C) Filtering D) Collapsing
C) filtering
