Question 40 of 40 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 40 of 40 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 39 of 40 2 5 Points You want to create a chart in Excel illustrating the sales growth of your company over the past 10 years Which graph would be ideal for this A Cell Chart B Bar Chart C Pie Chart D Worksheet Chart Question 38 of 40 2 5 Points Which option below represents a task that can be conducted in Excel through sorting A Showing all cells that have a number that ends with a 5 B Showing all cells that have nothing in them C Showing all cells that have the word Widget in them D Displaying the cells from smallest to largest Question 37 of 40 2 5 Points What third party application serves as an alternative to OneNote A Access B Visio C Project D Evernote Question 36 of 40 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 Question 35 of 40 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 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 33 of 40 2 5 Points You create a formula that adds cells E4 through E19 Three of these cells are blank What happens A Excel alerts you that the formula cannot be performed B Excel prompts you for data to input into the blank cells C The formula will assign an average value to the blank cells D The formula will assign a value of zero to the blank cells Question 32 of 40 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 31 of 40 2 5 Points What does the Screen Clipping function do in OneNote A Creates a new blank OneNote file B Captures a screenshot of your computer screen C Captures a YouTube video for OneNote D Captures an audio file from Media Player for OneNote Question 30 of 40 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 29 of 40 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 28 of 40 2 5 Points You are an inexperienced Excel user and dont know how to create your own formulas You want to use one of the preconfigured formulas but it doesnt 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 27 of 40 2 5 Points OpenOffice has an application that is similar to Excel called A Math B Worksheet C Calc D Evernote Question 26 of 40 2 5 Points What is the danger of using too much animation in a PowerPoint presentation A The files become too large B The animated effects can overshadow the content C The slides take too long to play out D Animated slides may not be compatible with older versions of PowerPoint Question 25 of 40 2 5 Points What is the purpose of Flash Fill in Excel 2013 A Integrates with Access 2013 to transfer data objects into worksheet cells automatically B Does predictive analysis to predict commonly inserted data items into worksheet cells C Automatically completes automated motions of organizations after creating a start and end point for an object D Automatically inputs information from Word files into OneNote in order to upload to a cloud drive Question 24 of 40 2 5 Points Which application below represents a Personal Information Management application A Excel B PowerPoint C Access D OneNot Question 23 of 40 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 22 of 40 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 21 of 40 2 5 Points Most of the slides used in a PowerPoint presentation are A content slides B title slides C graphic slides D template slides Question 20 of 40 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 19 of 40 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 Question 18 of 40 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 17 of 40 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 16 of 40 2 5 Points You are writing up a contract agreement for a new work assignment you just got with a local business You want to create the document so that when you send it to the client, the client cant alter it How can you do this A Save it as a DOCX file B Save it as a DOTM file C Save it as a PDF file D Save it as an RTF file Question 15 of 40 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 14 of 40 2 5 Points A user calls your help desk and says that he is trying to configure his Word document so that the text within his paragraphs is stretched from the left margin to the right margin What is your advice A Tell him to click the Align Left icon on the Home Ribbon B Tell him to click the Align Right icon on the Home Ribbon C Tell him to click the Justify icon on the Home Ribbon D Tell him to click the Column Width icon on the Page Layout Ribbon Question 13 of 40 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 bosss signature on all emails to that employee D Attach an email copy on all emails to that employee Question 12 of 40 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 11 of 40 2 5 Points What happens when you click Reply All for an email that you received A A single email will be sent to the sender B An email will be sent to everyone in your contacts C An email will be sent to everyone on the email server D An email will be sent to all recipients of the email Question 10 of 40 2 5 Points Your boss calls you in a panic He said he just deleted three paragraphs and doesnt know how to bring them back What do you tell him A Press Ctrl U on the keyboard B Press Ctrl D on the keyboard C Press Ctrl Z on the keyboard D Press Ctrl Y on the keyboard Question 9 of 40 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 8 of 40 2 5 Points Your sister wants to purchase Microsoft Office 2013 for her new laptop She doesnt 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 7 of 40 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 cant insert signatures B Windows Live cant blind copy recipients C Windows Live cant use the IMAP protocol D Windows Live has limited Exchange Server integration Question 6 of 40 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 5 of 40 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 4 of 40 2 5 Points Someone calls your help desk in a panic that she cant find the document she was just working on after opening up a second document How can you help her A Tell her to click the Show Documents icon located in the View Ribbon B Tell her to right click anywhere inside the View Ribbon tab and select the document C Tell her to hold the Windows key down and press the up down arrow and select the document D Tell her to right click on the Word Icon in the task bar and select the document Reset Selection Question 3 of 40 2 5 Points What is the purpose of an Automatic Reply A To let email senders know that you are out of town B To alert spammers so that their emails will be rejected C To reply to senders of large attached files D To reply to senders who are attaching viruses 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 2 of 40 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

Question 40 of 40 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 40 of 40 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 39 of 40 2 5 Points You want to create a chart in Excel illustrating the sales growth of your company over the past 10 years  Which graph would be ideal for this  A  Cell Chart B  Bar Chart C  Pie Chart D  Worksheet Chart Question 38 of 40 2 5 Points Which option below represents a task that can be conducted in Excel through sorting  A  Showing all cells that have a number that ends with a 5 B  Showing all cells that have nothing in them C  Showing all cells that have the word Widget in them D  Displaying the cells from smallest to largest Question 37 of 40 2 5 Points What third party application serves as an alternative to OneNote  A  Access B  Visio C  Project D  Evernote Question 36 of 40 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  Question 35 of 40 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 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 33 of 40 2 5 Points You create a formula that adds cells E4 through E19  Three of these cells are blank  What happens  A  Excel alerts you that the formula cannot be performed  B  Excel prompts you for data to input into the blank cells  C  The formula will assign an average value to the blank cells  D  The formula will assign a value of zero to the blank cells  Question 32 of 40 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 31 of 40 2 5 Points What does the Screen Clipping function do in OneNote  A  Creates a new blank OneNote file B  Captures a screenshot of your computer screen C  Captures a YouTube video for OneNote D  Captures an audio file from Media Player for OneNote Question 30 of 40 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 29 of 40 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 28 of 40 2 5 Points You are an inexperienced Excel user and dont know how to create your own formulas  You want to use one of the preconfigured formulas but it doesnt 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 27 of 40 2 5 Points OpenOffice has an application that is similar to Excel called  A  Math  B  Worksheet  C  Calc  D  Evernote  Question 26 of 40 2 5 Points What is the danger of using too much animation in a PowerPoint presentation  A  The files become too large  B  The animated effects can overshadow the content  C  The slides take too long to play out  D  Animated slides may not be compatible with older versions of PowerPoint  Question 25 of 40 2 5 Points What is the purpose of Flash Fill in Excel 2013  A  Integrates with Access 2013 to transfer data objects into worksheet cells automatically B  Does predictive analysis to predict commonly inserted data items into worksheet cells C  Automatically completes automated motions of organizations after creating a start and end point for an object D  Automatically inputs information from Word files into OneNote in order to upload to a cloud drive Question 24 of 40 2 5 Points Which application below represents a Personal Information Management application  A  Excel B  PowerPoint C  Access D  OneNot Question 23 of 40 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 22 of 40 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 21 of 40 2 5 Points Most of the slides used in a PowerPoint presentation are  A  content slides  B  title slides  C  graphic slides  D  template slides Question 20 of 40 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 19 of 40 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  Question 18 of 40 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 17 of 40 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 16 of 40 2 5 Points You are writing up a contract agreement for a new work assignment you just got with a local business  You want to create the document so that when you send it to the client, the client cant alter it  How can you do this  A  Save it as a DOCX file  B  Save it as a DOTM file  C  Save it as a PDF file  D  Save it as an RTF file  Question 15 of 40 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 14 of 40 2 5 Points A user calls your help desk and says that he is trying to configure his Word document so that the text within his paragraphs is stretched from the left margin to the right margin  What is your advice  A  Tell him to click the Align Left icon on the Home Ribbon  B  Tell him to click the Align Right icon on the Home Ribbon  C  Tell him to click the Justify icon on the Home Ribbon  D  Tell him to click the Column Width icon on the Page Layout Ribbon  Question 13 of 40 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 bosss signature on all emails to that employee  D  Attach an email copy on all emails to that employee  Question 12 of 40 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 11 of 40 2 5 Points What happens when you click Reply All for an email that you received  A  A single email will be sent to the sender  B  An email will be sent to everyone in your contacts  C  An email will be sent to everyone on the email server  D  An email will be sent to all recipients of the email  Question 10 of 40 2 5 Points Your boss calls you in a panic  He said he just deleted three paragraphs and doesnt know how to bring them back  What do you tell him  A  Press Ctrl   U on the keyboard  B  Press Ctrl   D on the keyboard  C  Press Ctrl   Z on the keyboard  D  Press Ctrl   Y on the keyboard  Question 9 of 40 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 8 of 40 2 5 Points Your sister wants to purchase Microsoft Office 2013 for her new laptop  She doesnt 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 7 of 40 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 cant insert signatures  B  Windows Live cant blind copy recipients  C  Windows Live cant use the IMAP protocol  D  Windows Live has limited Exchange Server integration  Question 6 of 40 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 5 of 40 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 4 of 40 2 5 Points Someone calls your help desk in a panic that she cant find the document she was just working on after opening up a second document  How can you help her  A  Tell her to click the Show Documents icon located in the View Ribbon  B  Tell her to right click anywhere inside the View Ribbon tab and select the document  C  Tell her to hold the Windows key down and press the up down arrow and select the document  D  Tell her to right click on the Word Icon in the task bar and select the document  Reset Selection Question 3 of 40 2 5 Points What is the purpose of an Automatic Reply  A  To let email senders know that you are out of town B  To alert spammers so that their emails will be rejected C  To reply to senders of large attached files D  To reply to senders who are attaching viruses 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 2 of 40 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

Accepted Answer

The Answer is in the image, click to view ...

Question 40 of 40 2.5 Points Which selection below represents an entry that would be seen in

Question:

Entrepreneurship

Question 40 of 40 2.5 Points Which selection below represents an entry that would be seen in

Question:

Expert Answer:

The Answer is in the image, click to view ... View the full answer

Entrepreneurship

Students also viewed these Accounting questions