ASHWORTH C10 ONLINE EXAM 5

Question 1 of 40

2.5/ 2.5 Points

Where can you access email accounts on your Windows 7 computer in order to modify current accounts or create new ones?

A. Windows Live Essentials

B. Microsoft Outlook 2010

C. Yahoo! Mail

D. Gmail

Question 2 of 40

2.5/ 2.5 Points

When would you use a template when working with Word 2013?

A. When you want to create a document that will be saved to the cloud

B. When you want to create a document that will work in Google Docs

C. When you want to create a document that will work in Office 2010

D. When you want to create a document from a ready-made design

Question 3 of 40

2.5/ 2.5 Points

You are considering upgrading your Office 2010 to Office 2013. Which of the selections below is not true of either Office 2010 or 2013?

A. Office 2013 can integrate directly with the cloud.

B. Word 2010 can edit PDF files.

C. Office 2010 is not touch-friendly.

D. Office 2013 is more supportive of multiple monitors.

Question 4 of 40

2.5/ 2.5 Points

You mom calls you up. She is creating a book of poetry. Many of these poems only take up the first half of a document. She asks you if there is a way to skip to a new page without having to constantly hit the Enter Key. What do you tell her?

A. Have her create a Page Break by pressing Ctrl+Enter.

B. Have her create a Page Break by pressing Shift+Enter.

C. Have her create a Page Insert by pressing Ctrl+Enter.

D. Have her create a Page Insert by pressing Shift+Enter.

Question 5 of 40

2.5/ 2.5 Points

What is the purpose of creating a PST file?

A. To document a antivirus pattern that continues to be sent to your mailbox

B. To insert as a Signature for all outgoing emails

C. To save your emails so that you can restore your mailbox if necessary

D. To create a file that deleted emails will be sent to for deletion

Question 6 of 40

2.5/ 2.5 Points

An employee is setting up an Outlook email account and calls the help desk asking what to put for the incoming mail server. What is the answer?

A. The fully qualified domain name of the mail server

B. The IP address of the mail server

C. The protocol used by the mail server

D. The webmail address used by the webmail server

Question 7 of 40

2.5/ 2.5 Points

You are creating a document for your students at school using Word 2013. You are concerned that some of your students have older versions of Word. How can you ensure that your students can open up these Word files in older versions of Word?

A. Save them as a template.

B. Create the document with a template.

C. Save them as .doc files.

D. Save them as .docx files.

Question 8 of 40

2.5/ 2.5 Points

Someone calls you at the help desk and complains that his spell-checker isn’t working in real time as he types. How can you fix this problem?

A. Click the Review tab and check the box beside “Check Spelling as you Type.”

B. Click the Review tab and select Options and then check the box beside “Check Spelling as you Type.”

C. Click the File tab and check the box beside “Check Spelling as you Type.”

D. Click the File tab and select Options and then check the box beside “Check Spelling as you Type.”

Question 9 of 40

2.5/ 2.5 Points

Your boss is very concerned about security for Word 2013. He wants to disable Macro settings within his Word documents. How do you instruct him to do this?

A. File, Options, Trust Center, Macro Settings “Disable all macros with notification”

B. Security, Options, Trust Center, Macro Settings “Disable all macros with notification”

C. File, Security, Trust Center, Macro Settings “Disable all macros with notification”

D. File, Options, Security, Macro Settings “Disable all macros with notification”

Question 10 of 40

0.0/ 2.5 Points

A start-up company has hired you to implement an email strategy for its organization. The company wants all of its employees to have an enterprise-level email client and is considering Windows Live. They ask you if there are any limitations about this email solution. Which selection below is a major limitation?

A. Windows Live can’t insert signatures.

B. Windows Live can’t blind copy recipients.

C. Windows Live can’t use the IMAP protocol.

D. Windows Live has limited Exchange Server integration.

Question 11 of 40

2.5/ 2.5 Points

Your users are calling the help desk, complaining that they are constantly losing work they have done on a document in Word. How can you alleviate this with certainty?

A. Instruct your users to save their work every 10 minutes.

B. Have them select “Save AutoRecover Information” every 10 minutes in Options.

C. Have them select the “AutoSave to file” every 10 minutes on the Review tab.

D. Have them select the “AutoSave to file” every 10 minutes in Options.

Question 12 of 40

0.0/ 2.5 Points

Your sister asks you if it is possible to get an office productivity suite out there for free. What do you tell her?

A. Office Professional

B. Office Home and Student edition of Microsoft Office

C. SkyDrive

D. Office 365

Question 13 of 40

2.5/ 2.5 Points

Your boss informs you that one of the employees you supervise is under review. She wants you to send him copies of all emails you send to them without them knowing. How do you do this?

A. Copy her on all emails to that employee.

B. Blind-copy her on all emails to that employee.

C. Insert your boss’s signature on all emails to that employee.

D. Attach an email copy on all emails to that employee.

Question 14 of 40

2.5/ 2.5 Points

The name of the company you work for has recently changed. Because of this, you will need to go through some of the company Word documents and change the name for every instance that the company appears within the document. What is the easiest way to do this?

A. Use the “Change Name” utility on the Reference tab ribbon.

B. Click the Search command on the Review tab ribbon.

C. Click the Search command on the Home tab ribbon.

D. Click the Replace command on the Home tab ribbon.

Question 15 of 40

0.0/ 2.5 Points

Your sister wants to purchase Microsoft Office 2013 for her new laptop. She doesn’t want to pay for a subscription and she wants to pay the least amount of money possible. The applications she plans on using are Word, Excel, and Outlook. Which version of Office do you recommend for her?

A. Office Home and Student

B. Office Home and Business

C. Office Professional

D. Office 365

Question 16 of 40

2.5/ 2.5 Points

How is Office 365 different from Windows Live Office?

A. Office 365 is free.

B. Office 365 costs a monthly subscription fee.

C. Office 365 can be accessed through a web browser.

D. Office 365 only has limited application options.

Question 17 of 40

2.5/ 2.5 Points

You are training your employees how to save their documents in Word 2013. What menu path do you tell them to use?

A. Home, Save

B. Word, Save

C. File, Save

D. Review, Save

Question 18 of 40

2.5/ 2.5 Points

Your daughter is trying to send a video file to all of her girlfriends, but most of her emails are being returned. She asks you for help. What do you tell her?

A. Tell her to blind-copy the video files to everyone.

B. Tell her to upload the file to a cloud drive and email the link to everyone.

C. Tell her to hold the CTRL key down when she clicks the Insert File icon.

D. Tell her to zip the file into a compressed file and send it to everyone.

Question 19 of 40

2.5/ 2.5 Points

What type of Microsoft Server serves as an email server?

A. SQL Server

B. IIS

C. Exchange 2013

D. Directory Services

Question 20 of 40

2.5/ 2.5 Points

Your brother is interested in using Apache OpenOffice as an office productivity suite. He asks you what the advantages are of this application. You list several of them except for which of the following?

A. It is free.

B. It can read Word Files.

C. It can edit Excel files.

D. It has a subscription service.

Part 2 of 2 - Lesson 5 Questions 45.0/ 50.0 Points

Question 21 of 40

2.5/ 2.5 Points

Which formula below will add up the numbers in cells A1 and A8?

A. SUM(A1+D8)

B. =SUM(A1,A8)

C. =SUM(A1:A8)

D. =SUM(D1+D5)

Question 22 of 40

0.0/ 2.5 Points

Where is data input by default?

A. Into cell A1

B. Into the active cell

C. Into the formula bar

D. Into the default data cell

Question 23 of 40

2.5/ 2.5 Points

OpenOffice has an application that is similar to Excel called:

A. Math.

B. Worksheet.

C. Calc.

D. Evernote.

Question 24 of 40

2.5/ 2.5 Points

Which selection below represents an entry that would be seen in the active box?

A. =sum(A1:A3)

B. 15

C. (A1:A4)

D. E11

Question 25 of 40

2.5/ 2.5 Points

You want to create a relational database for your company. Which application below would assist you in doing this?

A. Visio

B. Project

C. Access

D. Evernote

Question 26 of 40

2.5/ 2.5 Points

You want to play your entire PowerPoint presentation thus far. What key will start the presentation in its entirety?

A. F5

B. F10

C. CTRL+P

D. N

Question 27 of 40

2.5/ 2.5 Points

You click the spacebar during a PowerPoint presentation. What happens as a result?

A. The presentation stops.

B. The next slide is presented.

C. The first slide is presented.

D. The previous slide is presented.

Question 28 of 40

2.5/ 2.5 Points

What is the purpose of using templates in PowerPoint?

A. Integrates animation and audio automatically

B. Inserts a consistent look and format to the entire presentation

C. Inserts the required formulas automatically into the presentation

D. Imports fonts and images from CSV files for the presentation

Question 29 of 40

2.5/ 2.5 Points

Which application is ideal to serve as an accompaniment to an oral sales presentation?

A. PowerPoint

B. Exel

C. OneNote

D. Access

Question 30 of 40

2.5/ 2.5 Points

What does the COUNT function do in Excel?

A. Shows the number of cells contained within a worksheet

B. Shows the number of active cells contained within a worksheet

C. Shows the number of formulas contained within a spreadsheet

D. Shows the number of entries within a selected range of cells

Question 31 of 40

2.5/ 2.5 Points

Which type of file can be used to import data into a spreadsheet?

A. DB file

B. PPT file

C. CSV file

D. DBX file

Question 32 of 40

2.5/ 2.5 Points

Which formula below will add up all of the numbers in cells D1 through D5?

A. SUM(D1+D5)

B. =SUM(D1,D5)

C. =SUM(D1:D5)

D. =SUM(D1+D5)

Question 33 of 40

2.5/ 2.5 Points

You press the “P” key during a PowerPoint presentation. What happens as a result?

A. The presentation stops.

B. The next slide is presented.

C. The first slide is presented.

D. The previous slide is presented.

Question 34 of 40

2.5/ 2.5 Points

How can you identify the Active Cell in Excel?

A. It is outlined in bold fashion.

B. The cell is filled in solid gray.

C. The data inside the cell is in red.

D. The data inside the cell is indented.

Question 35 of 40

2.5/ 2.5 Points

You are an inexperienced Excel user and don’t know how to create your own formulas. You want to use one of the preconfigured formulas but it doesn’t appear in the Formulas tab ribbon. What can you do?

A. Click the Insert Formula icon on the Formulas tab ribbon.

B. Click the Insert Formula icon on the Insert tab ribbon.

C. Click the Formula Generator icon on the Formulas tab ribbon.

D. Click the Formula Generator icon on the Insert tab ribbon.

Question 36 of 40

2.5/ 2.5 Points

You create a formula in A8 that adds up the numbers listed in A1 through A7. You copy the formula and paste it into C8. What happens in C8?

A. The sum of cells A1 through A8 appears.

B. The sum of cells C1 through C8 appears.

C. The sum of cells A1 through B8 appears.

D. The sum of cells A1 through C8 appears.

Question 37 of 40

2.5/ 2.5 Points

Which application below represents a Personal Information Management application?

A. Excel

B. PowerPoint

C. Access

D. OneNote

Question 38 of 40

0.0/ 2.5 Points

You have created a worksheet documenting sales over every quarter since the start of your company. Each column represents a quarter and each row represents a product you sell. Each cell contains the sales generated for that product. You want to find the highest sales figure for one of your products. Which formula will do this?

A. Perform the MAX formula for one of the columns.

B. Perform the MAX formula for one of the rows.

C. Perform the AVERAGE formula for one of the columns.

D. Perform the AVERAGE formula for one of the rows.

Question 39 of 40

2.5/ 2.5 Points

What third-party application serves as an alternative to OneNote?

A. Access

B. Visio

C. Project

D. Evernote

Question 40 of 40

2.5/ 2.5 Points

How do you change between worksheets inside an Excel Workbook?

A. Press the CTRL+W keys.

B. Hold the Windows Key and press the W key.

C. Click on a different sheet tab at the bottom.

D. Click the worksheet icon on the Home Ribbon.