IT 101 Final exam
projectors
Displays visual output from a computer on a large surface such as a wall or screen
Joystick
Game controller with a handheld vertical lever, mounted on a base, that you move in different directions to control the actions of the simulated vehicle or player.
Which of the following software applications is considered a collaborative productivity application?
Google Docs
What is it called when someone attempts to befriend you online for the purpose of stealing confidential or sensitive information?
Social engineering
Which of the following statements is NOT true about a local firewall?
A firewall is a protective barrier between a computer or network and others on the Internet that inspects data being transmitted to or from a network to prevent unsolicited data exchanges. There are two types of firewalls: hardware firewalls and software firewalls. Hardware firewalls are physical devices, often used on larger, corporate networks, that block unauthorized traffic and intruders from accessing the network. Software firewalls, also called local firewalls, are installed on your computer or device and block unauthorized communication to or from the network. Software firewalls often are built into the computer's operating system
touchpad (trackpad)
A flat surface that is touch sensitive, and you move your finger around the touchpad to move the pointer on the screen.
Staked column chart
A column chart that places the data series values within combined columns showing how much is contributed by each series.
100% stacked column chart
A column chart that places the data series values within combined columns showing what percentage is contributed by each series.
bar chart
A column chart turned on its side so that the length of each bar is based on its value
Central Processing Unit (CPU)
A complex integrated circuit that consists of millions of electronic parts and is primarily responsible for converting input (data)into meaningful output (information)
chart title
A descriptive label or name for the chart.
scanner
A device that converts a paper image into electronic file that you can open and work with on your computer.
uninterruptible power supply (UPS)
A device that maintains power to computer equipment in case of an interruption in the primary electrical source
multi touch screens
A display that can respond to multiple fingers touching the screen simultaneously.
touch screen
A display that lets you touch areas of the screen to interact with software
paging file
A file on a hard disk that Windows uses to hold parts of programs and data files that do not fit in RAM.
Which network protocol allows devices to communicate with each other over a short range, usually less than 30 feet/9 meters?
bluetooth
mouse
The most common type a pointing device used with computers.
Which of the following is NOT true about mobile health?
The need for visits to the doctor's office is increased.
Random Access Memory (RAM)
The storage location that is part of every computer and that temporarily stores open apps and document data while a computer is on.
copy
To make a duplicate copy of a file, folder, or other object that you want to store in another location.
drag and drop
To move text or a graphic by dragging it to a new location using the mouse.
As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job. Which of the following is a true statement Carter can make to Ted about PivotTables?
To remove a field from a PivotTable, you click the field's check box in the PivotTable Field list
save
To store a file permanently on a disk or to overwrite the copy of a file that is stored on a disk with the changes made to the file.
Read-only format
cells can be viewed in the worksheet but not changed
column chart
chart that displays data values as columns with the height of each column based on its value.
video card
circuit board that processes image signals
Peripheral device
device such as a keyboard, mouse, printer, or speakers that can connected to an extend a capability of a computer.
properties
helpful information added to a file to help others identify, understand, and locate it
metadata
information that describes data and is used in Microsoft Windows document searches
mark a file as a final
makes file read-only, others can open but can't change
_____ refers to critical thinking skills allowing people to evaluate and create responsible media.
media literacy
A network administrator is usually not required on a _____ network
peer-to-peer network
Devices on a _____ area network are connected via Bluetooth.
personal
app
short for "application," a computer program that performs a specific set of functions
Every ____ consists of an object that contains a button for each unique value in that field.
slicer
port
slot on the computer or device where you can attach a peripheral device.
Which of the following is an example of a personal area network?
smartwatch and phone connected via Bluetooth
Network _____ specify how computers access a network, data transmission speeds, and the types of hardware the network uses, including cable and wireless technology.
standards
In a _____ network, each device on the network is attached to a central server. If the server fails, then the other devices will be unable to communicate, but if a connected device fails, then all other devices will still be able to communicate.
star
How to freeze panes
start with the cell that you want to scroll, click the View tab, click the Freeze Panes button in the Window group, then click Freeze Panes
keywords
terms users can search for that will help them locate your workbook
M-commerce
the ability to conduct commerce using a mobile device for the purpose of buying or selling goods or services
Stylus
A pen shape digital tools for making selections and entering information on the touchscreen
Wheel
A type of game controller that mirrors the functionality of a steering wheel in a vehicle
Warren creates a table listing the height and weight of students in his class. He enters the heading "Name" in cell A3 and the names of students in cells A4 to A9, the heading "Height" in cell B3 and the height of students in cells B4 to B9, the heading "Weight" in cell C3 and the weight of students in cells C4 to C9. What formula can he use to look up the height of one of the students, Sari, whose name, height, and weight are mentioned in cells A7, B7, and C7, respectively?
=INDEX(A3:C9,4,2)
combination chart
A chart that combines two or more Excel chart types into a single graph.
relational database
A database that represents data as a collection of tables in which all data relationships are represented by common values in related tables
What is a MAC address?
A unique hardware address for your device
As the new manager at your local grocery store, you want to create a more efficient inventory process by allowing outside vendors and suppliers to review current inventory records and adjust recurring shipment orders to reduce product waste. What type of network should you use?
Extranet
A worksheet has the following data in it: Cell range A2 to A10 in column A lists the years from 2010 to 2019. Cell range B2 to B10 in column B lists the types of food items sold during each year: Tomatoes, Oranges, Pears, Pineapples, Potatoes, and Onions. Cell range C2 to C10 in column C lists the sale of each item in each year. If we insert the formula =COUNTIFS("=Onions","B2:B10") in cell A11, it will give us the count of the number of times "Onions" has been listed in the worksheet. (T/F)
F
Bandwidth is a term that describes the number of devices connected to a network. (T/F)
F
If you connect to a Wi-Fi network that does not require a wireless network key, it is still secure enough to send private information because wireless networks encrypt all data anyway. (T/F)
F
RFIDis a network protocol used in credit cards, smartphones, and tickets to facilitate close-range communication. (T/F)
F
Slicers are applied directly to either a PivotTable or a PivotChart. (T/F)
F
As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job. Ted wants to use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million. How would he accomplish this?
He would develop a PivotTable using the value filter.
Which component of virtualization controls virtual switches and its ports?
Hypervisor
ASCII
In computer concepts, an 8-bit coding scheme, which means that 8 bits are used to represent uppercase and lowercase letters, mathematical operators, and logical operations.
Virtual memory
In the computer concepts, the capability of an operating system to temporarily store data on a storage medium until it can be "5swapped"into RAM.
Non-volatile
Memory that does not lose its contents when the power is removed.
volatile
Memory that loses its contents when power is removed.
all in one computer
Similar to a desktop computer, but the monitor and system unit our house together.
earbuds
Small speakers that rest inside each ear canal
copy and pasting
To move text or graphics using the Copy and Paste commands.
cut and paste
To move text or graphics using the Cut and Paste commands.
paste
To place a copied item from the Clipboard to a location in a document.
Before going into space, astronauts spend many hours training on flight simulators allowing them to learn how to fly without life and death consequences. How would you describe the technology the flight simulator is using?
Virtual Reality
To protect confidential company information from hackers while at a work conference, you must be sure to use which of the following networks when accessing the Internet at a hotel
Virtual private network
buzzword
- a word of phrase, often an item of jargon, that is fashionable at a particular time or in a particular context- example) big data, AI, machine learning
motherboard
A Circuit board inside a computer that contains the micro processor, the computer memory, and other internal devices.
embedded chart
A chart object placed in a worksheet.
hierarchy chart
A chart that show the relative contribution of groups to a whole.
system clipboard
A clipboard that stores only the last item cut or copied from a document. See also Clipboard and Office Clipboard.
data marker
A graphical representation of a value in a chart, such as a column or pie slice.
Spreadsheet
A grid of rows and columns in which you enter text, numbers, and the results of calculations.
You need to install a Linux VM in Hyper-V which is currently running on a Windows Server 2012 R2 computer. What will you install?
A guest OS
Solid state drive SSD
A hard drive without moving parts, and is faster and more durable than magnetic drives.
SQL (Structured Query Language)
A language that provides a standardized way to request information from a relational database system.
leader line
A line that connects a data label to its corresponding data marker.
tick marks
A line that divides the scale into regular intervals on a chart axis.
printer
A machine that prints characters or other images on paper making a hard copy
Which of the following describes an "evil twin"?
A normal looking yet fraudulent Wi-Fi network that allows hackers to capture personal information users transmit using it.
laptop
A portable computer that is smaller than the average briefcase and light enough to carry comfortably, often called a notebook.
Device driver
A program that controls a device attached to your computer, such as a printer, monitor, or video card.
digital pen
A small device, shaped like a pen, that you can use to draw, tap icons, or tap keys on an on screen keyboard, similar to a stylus, but is more capable because it has programmable buttons.
tablet
A small, flat computer with a touch sensitive screen that accepts input from a digital pen, stylus, or your fingertips
sizing handle
A square or dot on the edge of a selection box that is used to change the object's width and height.
Trackball
A stationary pointing device with a ball anchored inside a casing, as well as two or more buttons.
chart subtype
A variation of a chart type
graph
A visual representation of a set of data values; also called a chart.
chart
A visual representation of a set of data values; also called a graph.
digital divide
A worldwide gap giving advantage to those with access to technology
secondary axis
An alternate axis in a chart against which other data series with a different scale is plotted; usually appears on the right side of a chart.
paint apps
An app designed for drawing pictures, shapes, and other graphics with various onscreen tools
Format pane
An area that provides a collection of commands to format the selected chart element.
USB hub
An external device that contains many USB ports.
Chart elements
An individual part of a chart, such as the title or the legend.
game controller
An input device you use when playing a video game
Power on self test (POST)
At start up, a sequence that tests all computer components for proper operation.
Which function would be used to count the number of cells within a range that satisfy a specific criteria?
COUNTIF
input device
Communicates instructions and commands to a computer. Common input devices are keyboard, mouse, stylus, scanner, microphone, game controller.
desktop computer
Computer that typically consists of the system unit, monitor, keyboard, and mouse. (Not portable)
Which of the following could indicate a DoS attack on your company server?
Customers cannot view the website on their device because the page will not load.
bus width
Determines the speed at which data in a computer travels, also referred to as word size
Motion sensing controller
Game controller that allows users to guide on screen elements with air gestures
Dance pad
Game controller that is a flat, electronica device divided into panels that users price with their feet in response to instructions from the video game.
Gamepad
Game controller, held with both hands, that controls the movement and actions of players or objects in video games or computer games.
Why is a cable modem classified as a digital model?
It sends and receives digital data over a digital line
minor tick marks
Lines that identify the smaller intervals between major tick marks on a chart axis.
While waiting for her latte at Starbucks, Georgia decides to check her work email and pay a few bills online. She opens the Wi-Fi settings on her device and sees several connections available. Knowing the activities she plans to do online, which of the following networks should Georgia connect to?
My verizon vpn
You are configuring a VM's network connection. You want the VM to obtain an IP address from the host while still being able to connect to devices on the physical network. What type of connection should you configure?
NAT mode
Which of the following is an authentication method to keep your data safe?
NOT encryption
Sean is studying at a friend's house and notices that he can connect to the wireless network without entering a wireless network key. What does this indicate about the network?
NOT the network most likely uses a firewall for protection
Speakers
Output devices used to convey audio output, such as music, voice, sound effects, or other sounds
multi-core processor
Processor with multiple cores
Arithmetic Logic Unit (ALU)
Responsible for performing arithmetic operations in the CPU.
Edwin wants to insert a Pivot Chart to summarize raw data. Which of the following combination of clicks/selections/entries should he use to do this?
Select Cell > Insert > PivotChart > OK
bit
Short for binary digit, the smallest unit of data a computer can process.
presentation software
Software that is used to create and edit information to present in an electronic slide show format.
If you upload photos to a NAS device, everyone on the network can access them. (T/F)
T
primary axis
The axis against which data series in a chart is plotted; usually appears along the left side of a chart.
horizontal axis (category axis)
The axis that displays the category values from each data series.
vertical axis (value, axis)
The axis that displays the series values from the data series.
chart area
The chart and all of the other chart elements.
Which of the following is a disadvantage of using cloud computing to share files?
The inability to access your files if you lose your Internet connection.
Firmware
The instructions on the ROM chip.
hard drive
The most common storage medium on a computer; can be magnetic or solid state
What is one way hackers can trick you into transmitting personal data over on a public network without your knowledge?
They disguise the network as an "evil twin"
In a connected network, how are hubs and switches similar to one another?
They provide a central point for cables in a network
How do advertisers use data to know which products would most likely appeal to you?
They track your Facebook and Instagram posts and "likes."
What is the U.S. Federal Communication Commission's role in regard to Internet access?
To release rules surrounding Internet access
cut
To remove an item from a document and place it on the Clipboard.
cross platform
Tools that developers can use to build apps that work on multiple platforms.
What type of network sends signals through airwaves and usually does not require cables?
Wireless network
Barrier to Entry
a barrier to entry, or an economic barrier to entry, is a cost that must be incurred by a new entrant into a market that incumbents do not have or have no had to inicur
big data
a broad term for datasets so large or complex that traditional data processing applications are inadequate.
database
a collection of organized data that allows access, retrieval, and use of data
Cloud computing
a computing-infrastructure and software model for enabling ubiquitous access to shared pools of configurable resources (such as computer networks, servers, storage, applications and services), which can be rapidly provisioned with minimal management effort, often over the internet. Cloud computing allows users and enterprises with various computing capabilities to store and process data either in a privately-owned cloud, or on a third-party server located in a data center - thus making data-accessing mechanisms more efficient and reliable. Cloud computing relies on sharing of resources to achieve coherence and economy of scale, similar to a utility.- Storage power of IT servers on a virtual network- remote service for storage- Example) the music industry and the evolution of the CDs --> MP3s--> now Spotify and their use of the cloud; also the use of Amazon Web Services (AWS)
byte
a group of 8 bits, A field size for number feels that allows entries only from 0 to 255.
binary system
a number system that has just two unique digits, 0 and 1, called bits
A modem can also function as what other piece of hardware?
a router
view
a set of display and or print setting s that you can name and save, then access at ta later time by using the Excel Custom Views feature; can be created without having to create separate sheets
native app
a stand-alone application designed to run on a specific platform and device
big data
a term for data sets that are so large or complex that traditional data processing application software is inadequate to deal with them. Big data challenges include capturing data, data storage, data analysis, search, sharing, transfer, visualization, querying, updating and information privacy- combination of 2 phenomenon's; social media and personal computers- used to help make more informed decisions- example) Facebook addressing Instagram's even though Instagram does not make any money with their services.
Dynamic page breaks
adjusts automatically when you insert or delete rows and columns and when you change widths or row heights
productivity apps
allow one to create documents for business and personal use
Graphics and media apps
allow one to interact with digital media
Local applications
an application that runs from the hard drive of a local computer
Headphones
an output device with a part to cover each ear through which you can listen to music, radio broadcasts, etc. without other people hearing
mobile apps
apps that you access on a smartphone or tablet
clustered column chart
column chart that displays the data values in separate columns side by side.
On the far right, in the figure above, there is the PivotTable field list. The items listed there, such as "Day" and "Segment" are ____ in the table.
columns
Panes
columns and rows that freeze or remain in place while you scroll
Surge suppressor
device that prevents power fluctuations from damaging electronic components
You click on the number of engagements in a PivotTable and a new worksheet opens with a listing of the 9 relevant records. This is referred to as:
drilling down
Personal interest apps
give one tools to pursue interests
When describing a client/server network, which of the following would be considered a client?
laptop
On the bottom-right corner of the figure above, there are four squares labeled FILTER, COLUMNS, ROWS, and VALUES. These four areas represent the ____ of the PivotTable.
layout
The local community college want to increase its online offerings. To do so, the college will most likely need to purchase a ______.
learning management system (LMS)
Keisha needs to connect to the Internet, but no wireless networks or Wi-Fi hotspots are available. What can she use instead to make the connection?
mobile hotspot
To access the Internet, a router must be connected to a _____
modem
Brick & Mortor
refers to a physical presence of an organization or business in a building or other structure. The term brick-and-mortar business is often used to refer to a company that possesses or leases retail stores, factory production facilities, or warehouses for its operations
Digital Transformation
the change associated with the application of digital technology in all aspects of human society- 3 key ideas: technologies, change, radicality (touching everywhere)
Change management
the planning and introducing of new processes, methods of working, ect. in a company or organization: With effective change management, changes are handled quickly and have the lowest possible impact on service quality
form factor
the shape and size of a computer.
Lock
to protect sensitive information you lock one or more cells so that other people can view the values and formulas in those cells, but not change it
watermark
translucent background design that prints behind your data
What is an ISP?
A telecommunications company that sells Internet access.
clipboard
A temporary storage area for items that are cut or copied from any Office file and are available for pasting. See Office Clipboard and System Clipboard.
office clipboard
A temporary storage area shared by all Office programs that can be used to cut, copy, and paste multiple items within and between Office programs. The Office Clipboard can hold up to 24 items collected from any Office program. See also System Clipboard.
benchmark
A test run by a laboratory or other organization to determine processor speed and other performance factors.
axis title
Descriptive text that appears next to an axis.
What type of virtual network connection should you configure to isolate your VM from the physical LAN?
Host-only mode
Gridline
In a chart, a line that extends the value of a major or minor tick mark across the plot area.
data bar
A conditional format that adds a horizontal bar to the background of a cell proportional in length to the cell's value.
data callout
A data label that appears as a callout bubble pointing to a data marker.
optical media
Portable storage devices, such as CDs, DVDs, and Blu-ray discs, that use a laser to read and write data.
Digital Maturity
- how digitally transformed a company is- example from class discussion on KPIs. What criteria would you use to measure digital maturity? --> access to internet/infrastructure, popularity of mobile phone payments, time spent on devices, digitization of government (adapting laws for digitization), degree of process automation, ect
BYOD (bring your own device)
- refers to the policy of permitting employees to bring personally owned devices (laptops, tablets, and smart phones) to their workplace, and to use those devices to access privileged company information and applications- example of our analysis in class:--FOR) saves company money, productivity, ease of use, increase employee happiness, less maintenance cost on company.--AGAINST) security, confidentiality, compatibility, licenses, support of IT
A shopkeeper creates an Excel sheet to list different items he sold today. Rows A1 to A3 contain headings—Order ID, Selling price, and Quantity, respectively. Cells B1 to H1 list the order ID for the items sold—1001,1002,1003,1004, and 1005, respectively. Cells B2 to H2 list their respective selling price—$10, $12.5, $14, $7.5, and $8. Cells B3 to H3 list their respective quantities—10, 12, 6, 5, and 13. If he enters the formula in cell J1 as: =HLOOKUP (1004, A1: H3, 2, FALSE), what will the formula return?
7.5
sparkline
A chart that is displayed within a worksheet cell.
unicode
A coding system that represent text and symbols in computers, communications equipment, and other devices that use text.
productivity suite
A collection of productivity apps such as Microsoft Office 365, Apple iWork, G Suite, or Apache OpenOffice.
The score of a student inserted in the B2 cell is 65 and in the C2 cell is 75. Which of the following functions will you insert in the D2 cell so that it returns FALSE if any of the conditions are false for the values in the B2 and C2 cells?
=AND(B2>=70, C2>=80)
Barry creates a table showing ranks and percentage his students obtained in their final exams. He enters the heading "Name" in cell A3 and the names of students in cells A4 to A9, the heading "Rank" in cell B3 and the height of students in cells B4 to B9, the heading "Percentage" in cell C3 and the weight of students in cells C4 to C9. One of the students, Cara's name, rank, and percentage are mentioned in cells A7, B7, and C7, respectively. He types Cara's rank in cell A14. What formula can he use in cell B14 to find the column in which Cara's rank is?
=MATCH (A14,A3:C3,0)
The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60. which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?
=NOT(OR(B2>=60, C2>=60))
The score of a student in two subjects are inserted in the B2 and C2 cells and the passing score for each subject is 60. Which of these functions will you insert in the D2 cell so that it returns TRUE if at least one score is greater than or equal to 60, or else it returns FALSE?
=OR(B2>=60, C2>=60)
G suite
A Google platform that includes Docs, Sheets, Presentations, Classroom, and Forms
Selection box
A box surrounding an object such as a chart that is used to move or resize the object.
chart legend
A box that identifies the data markers associated with each data series.
When you create a VLAN on a switch, which of the following occurs?
A broadcast domain is created
pie chart
A chart in the shape of a circle divided into slices like a pie; shows data values as a percentage of the whole.
line chart
A chart that displays data values using a connected line rather than columns or bars.
mobile device
A portable or a handheld computing device, such as a smart phone or tablet, with a screen size of 10.1 inches or smaller.
Which company was the first to develop personal computers?
Apple
photo and image editing apps
Apps that provide the capabilities of paint apps and let you enhance and modify existing photos and images.
You are on vacation and want to see where all the restaurants and trendy shops are in relation to your hotel. You remember there is an app on your phone that will use your location and show you that information. What is the app using?
Augmented reality
output device
Conveys information from the computer to the user. Common output devices include displays, speakers, headphones, projectors, and printers.
How are the ways you learn and the ways AI learn similar?
Both use past experiences to predict likely outcomes and responses.
Which of the following is true about broadband connections?
Broadband connections are "always-on" with devices connected to them.
What does a DSL modem use to send and receive digital data?
Copper telephone wiring
As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job. If Ted decides that he wants to work with non-numeric data in his PivotTable, what function must he use to produce summaries?
COUNT
_____ is the intersection of traditional and digital media.
Convergent Media
save as
Command used to save a file for the first time or to create a new file with a different filename, leaving the original file intact.
word processing software
Commonly used software to create documents and reports, mailing labels, flyers, brochures, newsletters, resumes, letters, and more.
Which of the following is an ethical obligation of online communication? A. Be honest .B. Be polite. C. Fact check yourself. D. All of these
D
swap file
Data that cannot fit in RAM and uses an area of the hard disk called virtual memory. Also called a paging file.
document properties
Details about a file, such as author name or the date the file was created, that are used to describe, organize, and search for files.
word size
Determines the speed at which state it in a computer travels also referred to as bus width
As chief financial officer, you want to send the fourth quarter profit/loss spreadsheets to the president of the company. How can you send the report without worrying about someone else accessing it?
Encrypt the data in the report.
4G and 5G networks provide slower data transmission speeds than 3G networks. (T/F)
F
A router is a system of two or more devices linked by wires or cables. (T/F)
F
Which of the following statements do opponents of net neutrality agree with?
ISPs should charge more for high-bandwidth connections.
Which of the following is a reason an administrator might want to separate traffic by segmenting the network?
Improve performance
Scale
In a chart, the range of values displayed on a chart axis.
webcams
In computer concepts, a camera built into a computer, which is primarily use for video conferencing, chatting, or online gaming.
pointing device
In computer concepts, a device used to .2 and select specific objects on the computer screen. Examples of point devices include a mouse, touchpad, and track ball.
Plug and Play
In computer concepts, devices that begin functioning properly as soon as you connect them to your computer.
clock speed
In computer concepts, the speed at which a processor can execute instructions. Clock speed either can be measured in megahertz or gigahertz
headsets
Includes one or more headphones for output, and a microphone for input.
keyboard
Input device that contains not only characters such as letters, numbers, and punctuation, but also keys that can issue commands.
cameras
Input devices that support adding pictures or videos to a computer.
artificial intelligence
Intelligence exhibited by machines. Colloquially, the term, "artificial intelligence" is applied when a machine mimics "cognitive" functions that humans associate with other human minds, such as "learning" and "problem solving"- example) Google home, the movie "her" and an artificial partner through an app, chatbot,
If you want to share information with individuals who are internal to your organization, which type of network would you want to use?
Intranet
Alex received an email from what appeared to be his bank. What would indicate the message was actually a phishing attempt?
It contained typos and other grammatical errors.
As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job. Ted wants to be able to use his PivotTable to combine items into groups. Which of the following is true?
Items that appear as column labels can be grouped.
Which of the following network standards applies to cellular networks?
LTE
major tick marks
Lines that identify the main units on a chart axis.
control unit
Manages the flow of instructions within the processor.
A small grocery owner creates a table for the different types of fruits sold in his shop. He inserts headings in cells A1, B1, C1, and D1 as Order ID, Fruit, Unit Price, and Quantity. He then inserts Order ID 1001 to 1004 for each fruit in cells A2 to A5, respectively, type of fruits—Apples, Oranges, Mangoes, and Grapes in cells B2 to B5, respectively, unit price of each fruit as $10, $9, $30, and $18 in cells C2 to C5, respectively, and quantity of each fruit as 5, 7, 8, and 9 in cells D2 to D5, respectively. In cell F1, he inserts the formula: =LOOKUP(1003, A1:A5, B1:B5). What will the following function return?
Mangoes
Which of the following statements is true about public networks?
Many public networks are not secure.
What internal device does a computer use to connect to a wired or a wireless network?
Network interface card
Why would you want to connect your computer to a network?
Networks allow computers to share resources, such as hardware, software, data, and information
read-only memory (ROM)
Permanently installed memory on your computer attached to the motherboard. The ROM chip contains the BIOS, which tells your computer how to start.
restore
Returning an operating system or files to their default settings, or migrating back to the operating systems previous version.
Which virtualization technology provides network services that are not directly tied to physical devices on the network?
SDN
By default, the PivotTable report uses the ____ function for numbers in the Values area.
SUM
You are dropping your friend back home after a night at the movies. From the car, she turns on the indoor lights in her home using an app on her phone. How is your friend able to do this?
She has a home network with smart home devices.
External hard drives
Storage drive housed in a separate case, and typically connected to your computer using a USB cable.
Processor cache
Stores frequently use data next to the processor so that it can easily and quickly be retrieved.
cloud storage
Storing electronica files on the Internet, not on a local computer; often called storing data "in the cloud"
What does a computer use to determine the size of its IPv4 address network ID?
Subnet mask
The same slicer can be applied to multiple PivotTables and their associated PivotCharts allowing you to filter the entire dashboard based on criteria you choose. (T/F)
T
When we add fields to the Column Labels area, they appear as headings on the left of the table. (T/F)
T
When you create a PivotTable, you need to specify where to find the data for the PivotTable. (T/F)
T
Wireless networks that are available in public places, such as hotels, restaurants, and coffee shops, are known as Wi-Fi hotspots. (T/F)
T
You can drag one field to the FILTERS area of the PivotTable Fields pane to allow the user or viewer of the PivotTable to change what values are displayed. (T/F)
T
data label
Text associated with an individual data marker.
hyperlink
Text or a graphic that opens a file, Web page, or other item when clicked. Also called a link.
PMT function
The financial function that calculates the payment schedule required to repay a loan.
plot area
The part of a chart that contains the graphical representation of the data series.
data source
The range that contains the data to display in a chart.
data series
The range that contains the values plotted on a chart.
How does a wireless network key work with an encrypted wireless network?
The sending and receiving devices must know the wireless network key to communicate.
cycle
The smallest unit of time a process can measure
platform
The software, or operating system, a device uses.
How are delivery drivers able to meet the delivery timelines selected by customers when purchasing products?
They use a PGS to avoid traffic delays
microphone
Used to enter voice or sound data into a computer.
What should you consider installing if you want to consolidate the services currently offered by four different servers while maintaining the application isolation provided by using separate servers?
VMware ESXi
What protocol should you consider deploying that allows you to provide redundancy by using a virtual IP address assigned to a group of routers?
VRRP
Which of these functions will you use to find the variance of a population of all of the values to be summarized?
Varp
Voice synthesizer
Voice output that converts text to speech
freeze
columns and rows that freeze or remain in place while you scroll
excel custom views feature
create several different views of a worksheet without having to create separate sheets
To protect a computer or a server, a(n) ______ can be installed that would act as a barrier and inspect data being transmitted to or from the network.
firewall
Web apps
programs accessed over the Internet, in a browser, or on a mobile device
Application Software
programs that help you perform specific tasks when using your computer or device
Computers communicating on a network must follow a _____, a common set of rules for exchanging information.
protocol
Device management apps
provide tools for maintaining a computer or device
Communications apps
provide tools for sharing or receiving information
You cannot change data directly in the PivotTable. Instead, you must edit the Excel table, and then ____, or update, the PivotTable to reflect the updated data.
refresh
tiles
repeated view
Which of the following is the science that combines technology and engineering?
robotics
When it comes to secure data storage on a network, which of the following statements is true?
roles can be granted to individuals to view files and make changes to files on a network.
What hardware is essential to creating a home Wi-Fi network?
router
Portable apps
run from removable storage device such as an external hard drive or from the cloud
Data entry area
unlock cells in which data will be changed and lock cells in which the data should not be changed
Instance
view the worksheet in its own workbook
target
where a hyperlink takes you to a worksheet, another document, a website
