Exam 9: Formula Auditing, data Validation, and Complex Problem Solving

Pierce wants to build a website for his remodeling business,but he doesn't want to have to learn any code.What tool should he use?

Free

(Multiple Choice)

5.0/5

(28)

Question 1

Correct Answer:

Verified

Mindy needs to feed data from her company's customer database to her department's internal website.How can she ensure the data will be formatted coming from the database in a way the web server can use?

Free

(Multiple Choice)

4.7/5

(36)

Question 2

Correct Answer:

Verified

Denise has thought of a clever name for her coffee shop's new website,and she wants to make sure no one else grabs it while she's having the website built.What company can she use to reserve the website address?

Free

(Multiple Choice)

4.8/5

(36)

Question 3

Correct Answer:

Verified

Which attribute makes a hyperlink open in a new tab in the browser?

(Multiple Choice)

4.8/5

(31)

Question 4

Eneida is ready to post her website files to her host's servers.What can she use to upload the files across the Internet?

(Multiple Choice)

4.8/5

(37)

Question 5

Liam is troubleshooting the code for some text on his website.What's wrong with this line? <head>About Our Company

(Multiple Choice)

4.9/5

(33)

Question 6

When you sign into a website,which computer does the processing to determine if you have the appropriate credentials to access the website?

(Multiple Choice)

4.9/5

(41)

Question 7

Hayne is starting his own business as a psychotherapist and needs to post a website advertising his services,contact information,and some tips on what clients can expect in therapy.What kind of website would best suit Hayne's needs?

(Multiple Choice)

4.7/5

(27)

Question 8

After developing your website,tweaking it so it looks exactly the way you want,and testing it to ensure everything works as expected,how can you make it available for other people to access it?

(Multiple Choice)

4.8/5

(44)

Question 9

As Denise is working on building her website,she gets an error message that warns her she's using a deprecated tag.What should she do to fix this problem?

(Multiple Choice)

4.9/5

(39)

Question 10

After registering your website's URL with Google Analytics,how will Google Analytics get access to your website to collect data about its traffic?

(Multiple Choice)

4.7/5

(24)

Question 11

Raul has noticed that,despite strong website traffic overall,visitors using smartphones rarely stay on the site for long.What should Raul check on after discovering this information?

(Multiple Choice)

4.8/5

(33)

Question 12

Ryan's website looks great on his desktop computer's display,but it's not working right when he tests it on his smartphone.What code does he need to adjust?

(Multiple Choice)

4.8/5

(40)

Question 13

Jayla has added a map feature to her website so customers can find her store more easily.However,she wants to make the map able to zoom so customers can zoom in or out as needed.What code does she need to adjust?

(Multiple Choice)

4.8/5

(25)

Question 14

Kristy's advocacy blog isn't getting much traffic.What can she use to attract more attention to her website?

(Multiple Choice)

4.9/5

(31)

Question 15

Lauren is proofing an HTML file before publishing the web page to her website.She sees the following code: <a href="http://facebook.com" target="_blank">Visit Facebook</a>

(Multiple Choice)

4.9/5

(39)

Question 16

What tags in the head section of an HTML document contain the JavaScript code?

(Multiple Choice)

4.8/5

(19)

Question 17

Marquis has a CMS-hosted website for his consulting business,and has been told by several customers that it would be easier to pay for his services if he could accept credit card payments online.What tool will help Marquis add this functionality to his website?

(Multiple Choice)

4.9/5

(44)

Question 18

When you visit your school's website on your smartphone,some of the links and resources are positioned differently on the page,making them more convenient.What feature of the website allows this variation?

(Multiple Choice)

4.9/5

(33)

Question 19

When Miles clicks a link in an article to visit another website that was referenced as a resource for the article,he notices "index.html" in the URL.What page is he likely visiting?

(Multiple Choice)

4.8/5

(31)

Question 20

Showing 1 - 20 of 22

Pierce wants to build a website for his remodeling business,but he doesn't want to have to learn any code.What tool should he use?

Mindy needs to feed data from her company's customer database to her department's internal website.How can she ensure the data will be formatted coming from the database in a way the web server can use?

Denise has thought of a clever name for her coffee shop's new website,and she wants to make sure no one else grabs it while she's having the website built.What company can she use to reserve the website address?

Which attribute makes a hyperlink open in a new tab in the browser?

Eneida is ready to post her website files to her host's servers.What can she use to upload the files across the Internet?

Liam is troubleshooting the code for some text on his website.What's wrong with this line? <head>About Our Company

When you sign into a website,which computer does the processing to determine if you have the appropriate credentials to access the website?

Hayne is starting his own business as a psychotherapist and needs to post a website advertising his services,contact information,and some tips on what clients can expect in therapy.What kind of website would best suit Hayne's needs?

After developing your website,tweaking it so it looks exactly the way you want,and testing it to ensure everything works as expected,how can you make it available for other people to access it?

As Denise is working on building her website,she gets an error message that warns her she's using a deprecated tag.What should she do to fix this problem?

After registering your website's URL with Google Analytics,how will Google Analytics get access to your website to collect data about its traffic?

Raul has noticed that,despite strong website traffic overall,visitors using smartphones rarely stay on the site for long.What should Raul check on after discovering this information?

Ryan's website looks great on his desktop computer's display,but it's not working right when he tests it on his smartphone.What code does he need to adjust?

Jayla has added a map feature to her website so customers can find her store more easily.However,she wants to make the map able to zoom so customers can zoom in or out as needed.What code does she need to adjust?

Kristy's advocacy blog isn't getting much traffic.What can she use to attract more attention to her website?

Lauren is proofing an HTML file before publishing the web page to her website.She sees the following code: <a href="http://facebook.com" target="_blank">Visit Facebook</a>

What tags in the head section of an HTML document contain the JavaScript code?

Marquis has a CMS-hosted website for his consulting business,and has been told by several customers that it would be easier to pay for his services if he could accept credit card payments online.What tool will help Marquis add this functionality to his website?

When you visit your school's website on your smartphone,some of the links and resources are positioned differently on the page,making them more convenient.What feature of the website allows this variation?

When Miles clicks a link in an article to visit another website that was referenced as a resource for the article,he notices "index.html" in the URL.What page is he likely visiting?

Creating a Worksheet and a Chart

Formulas,functions,and Formatting

Working With Large Worksheets, charting, and What-If Analysis

Financial Functions, data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

Data Analysis With Power Tools and Creating Macros

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Filters