Final exam info teach
You want to search the web for information on the movie Captain America: Civil War. What would be the best way to enter the key terms to get the most specific results? (1 point) * Civil War "Captain America: Civil War" Captain America * Captain America Civil War
"Captain America: Civil War"
Which of the following top-level domains identifies a degree-granting institution? (1 point) .gov .edu .net .info
.edu
You want to create a single chart that shows the proportion of yearly sales for five divisions for each year for five years. Which type of chart can accommodate your needs? (1 point) Pie chart 100% stacked column chart Clustered bar chart Surface chart
100% stacked column chart
A formula containing the entry =$B3 is copied to a cell one column to the right and two rows down. How will the entry appear in its new location? (1 point) =$C5 =$B3 =B3 =$B5
=$B5
A formula containing the entry =$B3 is copied to a cell one column to the right and two rows down. How will the entry appear in its new location? (1 point) =$C5 =$B3 =B3 =$B5
=$B5
What function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5? (1 point) =COUNT(B5:F5) =AVERAGE(B5:F5) =SUM(B5:F5)/5 =MEDIAN(B5:F5)
=AVERAGE(B5:F5)
What function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5? (1 point) =COUNT(B5:F5) =AVERAGE(B5:F5) =SUM(B5:F5)/5 =MEDIAN(B5:F5)
=AVERAGE(B5:F5)
Which of the following functions should be used to insert the current date and time in a cell? (1 point) =DATE =TODAY() =NOW() =CURRENT()
=NOW()
Which of the following functions should be used to insert the current date and time in a cell? (1 point) =DATE =TODAY() =NOW() =CURRENT()
=NOW()
Which of the following is not an appropriate use of the SUM function? (1 point) =SUM(B3:B45) =SUM(A8:A15,D8:D15) =SUM(F1:G10) =SUM(D15-C15)
=SUM(D15-C15)
Which of the following is not an appropriate use of the SUM function? (1 point) =SUM(B3:B45) =SUM(A8:A15,D8:D15) =SUM(F1:G10) =SUM(D15-C15)
=SUM(D15-C15)
Which of the following is not an Internet protocol? (1 point) HTTP ARPANET BitTorrent FTP
ARPANET
Which of the following is not an Internet protocol? (1 point) HTTP ARPANET BitTorrent FTP
ARPANET
Which is NOT an event associated with the beginning of the Internet? (1 point) The first e-mail program was written by Ray Tomlinson. Amazon.com was one of the first websites on the Internet. TCP/IP protocol was developed that allowed different computers to communicate with each other. The U.S. Department of Defense creates ARPA
Amazon.com was one of the first websites on the Internet.
Which is NOT an event associated with the beginning of the Internet? (1 point) The first e-mail program was written by Ray Tomlinson. Amazon.com was one of the first websites on the Internet. TCP/IP protocol was developed that allowed different computers to communicate with each other. The U.S. Department of Defense creates ARPA.
Amazon.com was one of the first websites on the Internet.
What is a fast way to apply several formats at one time? (1 point) Click each one individually. Use Auto Fill. Apply a cell style. Use Copy and Paste options.
Apply a cell style.
Ensuring that the content, tone, and style of a website match your needs is checking for: (1 point) Relevance Audience Bias Authority
Audience
Given the formula =B1*B2+B3/B4^2, what operation is calculated first? (1 point) B2+B3 B4^2 B3/B4 B1*B2
B4^2
Which of the following is not a type of sparkline? (1 point) Bar Win-Loss Line Column
Bar
AND, OR, and NOT are examples of ________ operators. (1 point) keyword Jacobean relational Boolean
Boolean
Which of the following is a supporting argument for geolocation devices posing a threat to privacy? (1 point) Businesses are responsible to educate consumers about how they use geolocation data. Society may need to reevaluate its expectations as to the amount of privacy in people's digital lives. The social norm has shifted and people have become comfortable with sharing more information, including their location. Many businesses incorporate geolocation as a primary marketing strategy; the loss of privacy is outweighed by the benefit to consumers
Businesses are responsible to educate consumers about how they use geolocation data.
All of the following are types of e-commerce business EXCEPT ________. (1 point) C2C C2B B2B B2C
C2B
Which of the following is NOT a port? (1 point) HDMI Thunderbolt USB CPU
CPU
Which of these is considered the "brains" of the computer? (1 point) ROM USB CPU RAM
CPU
What do you click to remove a data series from a chart so that you can focus on other data series? (1 point) Chart Series Chart Filters Chart Styles Chart Elements
Chart Filters
Currently, a column chart shows values on the value axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend? (1 point) Change the chart type to a clustered column chart. Click Switch Row/Column in the Data group on the Design tab. Click Layout 2 in the Chart Layouts group on the Design tab and apply a different chart style. Click Legend in the Labels group on the Layout tab and select Show Legend at Bottom
Click Switch Row/Column in the Data group on the Design tab.
You selected and copied worksheet data containing formulas. However, you want the pasted copy to contain the current formula results rather than formulas. What do you do? (1 point) Click the Paste arrow in the Clipboard group and select Formulas. Display the Paste Special dialog box and select Formulas & Number Formatting. Click Paste in the Clipboard group on the Home tab. Click the Paste arrow in the Clipboard group and select Values & Source Formatting.
Click the Paste arrow in the Clipboard group and select Values & Source Formatting.
Which of these is an example of optical storage media? (1 point) DVD thumb drive SSD a flash memory card
DVD
If you want to show exact values for a data series in a bar chart, which chart element should you display? (1 point) Legend Data labels Chart title Value axis title
Data labels
Which of the following does not display automatically when you create a clustered column chart? (1 point) Chart title placeholder Data labels Legend Gridlines
Data labels
Which of the following characteristics is not applicable to the Accounting Number Format? (1 point) Commas to separate thousands Dollar sign immediately on the left side of the value Zero values displayed as hyphens Two decimal places
Dollar sign immediately on the left side of the value
________ is installed on your computer, and when the program is opened, your e-mail downloads to your computer. (1 point) E-mail server E-mail host package E-mail client software Web-based e-mail program
E-mail client software
Which step is not part of planning a worksheet design? Decide what outputs are needed to achieve the purpose. Enter labels, values, and formulas. State the purpose of the worksheet. Decide what input values are needed
Enter labels, values, and formulas.
Which of the following would be an example of a C2C business? (1 point) BestBuy Etsy Target Google
Etsy
A blog is usually written by multiple authors. (1 point) True False
F
Digital activism is an exercise platform. (1 point) True False
F
Webcasts are delivered only as prerecorded audio and video content. (1 point) True False
F
What is the keyboard shortcut to create an absolute reference? (1 point) F4 Alt F3 F2
F4
What is the keyboard shortcut to create an absolute reference? (1 point) F4 Alt F3 F2
F4
Which of the following is not an alignment option?(1 point) Merge & Center Fill Color Wrap Text Increase Indent
Fill Color
When you start to type =AV, what feature displays a list of functions and defined names? (1 point) Insert Function dialog box Function ScreenTip Formula AutoComplete Function Arguments dialog box
Formula AutoComplete
When you start to type =AV, what feature displays a list of functions and defined names? (1 point) Insert Function dialog box Function ScreenTip Formula AutoComplete Function Arguments dialog box
Formula AutoComplete
What should you do if you see pound signs (###) instead of values or results of formulas? (1 point) Adjust the row height. Increase the column width. Increase the zoom percentage. Delete the column.
Increase the column width.
Assume that the data on a worksheet consume a whole printed page and a couple of columns on a second page. You can do all of the following except what to force the data to print all on one page? (1 point) Select a smaller range as the print area. Increase the left and right margins. Decrease the Scale value. Decrease column widths if possible.
Increase the left and right margins.
After you create a line type sparkline, what option should you select to display dots for each data point? (1 point) High Point Negative Point Markers Sparkline Color
Markers
If cell E15 contains the formula =$C$5*J$15, what type of cell reference is the J$15 in the formula? (1 point) Absolute reference Mixed reference Syntax Relative reference
Mixed reference
If cell E15 contains the formula =$C$5*J$15, what type of cell reference is the J$15 in the formula? (1 point) Absolute reference Mixed reference Syntax Relative reference
Mixed reference
Which of the following is NOT a precaution to take when shopping online? (1 point) Shop at well-known, reputable sites. Pay with a debit card, not a credit card. Avoid making online transactions on a public computer. When placing an order, make sure you receive a confirmation number.
Pay with a debit card, not a credit card.
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5? (1 point) Periodic interest rate APR Number of payment periods Loan amount
Periodic interest rate
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5? (1 point) Periodic interest rate APR Number of payment periods Loan amount
Periodic interest rate
Which type of chart is the least appropriate for depicting yearly rainfall totals for five cities for four years? (1 point) Column chart Pie chart Bar chart Line chart
Pie chart
How can you display formulas within the cells instead of the cell results? (1 point) Click Cell References on the Home tab. Press Ctrl+G. Press Ctrl+`. Press Ctrl+C
Press Ctrl+`.
Which power control option performs a warm boot? (1 point) Restart Log off Sleep Shut down
Restart
The "fathers of the Internet" are Vinton Cerf and ________. (1 point) Robert Kahn Robert Cailliau Tim Berners-Lee Bill Gates
Robert Kahn
The value axis currently shows increments such as 50,000 and 100,000. What option would you select to display the values in increments of 50 and 100? (1 point) More Primary Vertical Axis Title Options Show Axis in Thousands Show Right to Left Axis Show Axis in Millions
Show Axis in Thousands
Geolocation requires a GPS chip in a mobile device. (1 point) True False
T
The "S" in HTTPS stands for secure and indicates that the secure sockets layer protocol has been applied to the website. (1 point) True False
T
Which of the following is not true about the VLOOKUP function? (1 point) The lookup table must be in descending order. The lookup table must be in ascending order. The default match type is approximate. The match type must be false when completing an exact match.
The lookup table must be in descending order.
Which of the following is not true about the VLOOKUP function? (1 point) The lookup table must be in descending order. The lookup table must be in ascending order. The default match type is approximate. The match type must be false when completing an exact match.
The lookup table must be in descending order.
The World Wide Web was based on a protocol developed by ________. (1 point) Tim Berners-Lee CERN Vinton Cerf Ray Tomlinson
Tim Berners-Lee
The unique address for a particular website is the ________. (1 point) URL client domain section protocol
URL
Which search strategy should you use to search for a specific phrase? (1 point) Use a wild card around the phrase. Use asterisks around the phrase. Use quotation marks around the phrase. Include Boolean operators in the phrase
Use quotation marks around the phrase.
Which search strategy should you use to search for a specific phrase? (1 point) Use a wild card around the phrase. Use asterisks around the phrase. Use quotation marks around the phrase. Include Boolean operators in the phrase.
Use quotation marks around the phrase.
You just copied a range of data containing formulas. However, you want to preserve the formula results and the original number and text formatting in the pasted range. Which paste option would you select? (1 point) Values & Source Formatting Values & Number Formatting Keep Source Formatting Formulas
Values & Source Formatting
Which of the following are personal video journal entries posted on the web? (1 point) Vlogs Blogs Newsgroups Podcasts
Vlogs
Which of the following describes an IP address? (1 point) It identifies any computer connecting to the Internet. It identifies a website. It is referred to as a dotted quad. all of the above
all of the above
A ________ is a personal journal posted on the web. (1 point) wiki blog podcast webcast
blog
The Internet was created to provide (1 point) a secure form of communications. a common communication means for all computers. both a and b neither a nor b
both a and b
A(n) ________ is a navigation aid that shows the path you have taken to get to a web page or where the page is located within the website. (1 point) index cookie trail navigation bar breadcrumb trail
breadcrumb trail
What is the navigation aid that shows users the path they have taken to get to a web page located within a website? (1 point) social bookmarks Bookmarks breadcrumb trail Favorites
breadcrumb trail
Software that enables you to display and interact with text and other media on the web is a web ________. (1 point) client server browser agent
browser
In an Internet exchange of data, which type of computer asks for data? (1 point) client server servicer requester
client
n an Internet exchange of data, which type of computer asks for data? (1 point) client server servicer requester
client
Which of the following is NOT found on a motherboard? (1 point) RAM sound card CPU hard drive
hard drive
In the URL https://www.whitehouse.gov/blog, which part is considered the protocol? (1 point) .gov /blog www.whitehouse.gov https
https
Which of the following is NOT a social networking site? (1 point) LinkedIn YouTube Facebook iTunes
iTunes
Which of the following would be best for synchronous text-based communication? (1 point) instant messaging blogging texting e-mail
instant messaging
Which of the following would be best for synchronous text-based communication? (1 point) instant messaging blogging texting e-mail
instant messaging
Which of the following is not an argument of the IF function? (1 point) value_if_true value_if_false logical_test lookup_value
lookup_value
Which is NOT an example of a mobile operating system? (1 point) macOS Android iOS Windows 10
macOS
Search engines that search other search engines are called (1 point) betasearch engines. gigasearch engines. megasearch engines. metasearch engines.
metasearch engines.
Ordering a mocha latte and paying for it from the Starbucks smartphone app is using what type of Internet commerce? (1 point) B2B mobile commerce C2C social commerce
mobile commerce
Which of the following would NOT be a good precaution to take when making online purchases? (1 point) pay by debit card, not credit card pay by credit card, not debit card use a prepaid credit card use a third-party processor such as PayPal
pay by debit card, not credit card
Which feature of a browser enables you to secure a tab permanently? (1 point) tab isolation tear-off tabs tabbed browsing pinned tabs
pinned tabs
What web browser feature would be particularly useful when using public computers? (1 point) pinned tabs session restore privacy browsing all of the above
privacy browsing
In the URL: https://www.microsoft.com/surface, the portion labeled "http" is the ________. (1 point) protocol top-level domain path domain name
protocol
When using the Internet for research, you (1 point) should look for sites with only a few links. can assume everything is accurate and appropriate. should evaluate sites for bias and relevance. can assume if there is no author listed, the site is not appropriate for research.
should evaluate sites for bias and relevance.
A subset of e-commerce that uses social networks to assist in marketing and purchasing products is known as ________ commerce. (1 point) friend source social crowd
social
If you would like to return to a website that you visited last week but can't remember the URL, you should look at: (1 point) the Recycle Bin the History list a breadcrumb list any of the above
the History list
In the URL: https://www.microsoft.com/surface, the portion labeled ".com" is the ________. (1 point) subdirectory top-level domain host protocol
top-level domain
All of the following are tips for professional e-mail etiquette EXCEPT ________. (1 point) use abbreviations such as "u," "r," and "BRB" to keep the e-mail message shorter include a meaningful subject line be concise and to the point use spell-checker and proofread before sending
use abbreviations such as "u," "r," and "BRB" to keep the e-mail message shorter
A ________ allows users to add, remove, or edit its content. (1 point) chat blog podcast wiki
wiki
Which technology is being used in creating a document with Google Docs? (1 point) blog microblog wiki e-mail
wiki
Which technology is being used in creating a document with Google Docs? (1 point) blog microblog wiki e-mail
wiki
The concept of the Internet was developed by the U.S. Department of Defense as a network that ________ in event of an attack. (1 point) allows commerce to continue would not be disrupted easily would not be easily hacked provides point to point connections
would not be disrupted easily
