Microsoft Office Assessment Tests Microsoft Office tests are among the most commonly used pre-employment assessments tests. The tests can be taken separately, but are usually taken together (in some cases as part of a larger set of tests that might also include personality tests, a typing test or other assessments). Tests usually come in three levels: basic, intermediate and advanced. The level depends on the nature of the position and the assessment company providing the test. Three Kinds of Tests. Interactive: The most common of the three. You are required to complete a set of actions while editing a document or a workbook (for example, in excel you might be asked to create a chart based on a table).
The test is performed on a software simulating the Microsoft Office environment. There are usually between 25 – 30 questions constructed in a logical order. Multiple-Choice Questions: The multiple choice tests are usually around 20-30 questions long. On these tests, familiarity with the software's terminology and interface is crucial. Adaptive Test: Usually a multiple choice questions test that begins with intermediate level questions followed by harder or easier questions, according to your success on previews questions. These tests are relatively hard, and aren't common. Kenexa ProveIt!
Microsoft Tests Prove It is one of the leading companies offering Microsoft Office assessment tests. They offer employers interactive simulation tests for Microsoft Excel, Word, Power Point and many more. JobTestPrep offers exclusive practice packs for Prove It MS and assessment tests, designed to match Kenexa's test topics. Frequently Asked Questions.
Q: Which tests can I practice for? A: We currently offer practice packs for Excel //and Word / as well as Excel+Word bundle packs for the and versions. Q: Will I be able to use the preparation kit again if I need it in the future? A: Yes, once you have purchased the kit, it is available for 1 year or 100 uses (whichever comes first). Q: Can I practice Excel and Word as part of my JobTestPrep PrepPack™? A: No, These practice packs are not part of the premium pack.
Q: Which version of Excel/Word should I purchase? A: In most cases, the assessment company will inform you as to which version you will be tested on.
However, you can only practice the version installed on your computer. In the case that the version you'll be tested on is different than the one you have on your computer, you have 2 options:. Try and use another device. Practice with the version you have on your computer. Although there will be some differences between the versions, the logic behind the questions will not change. Practice for Success JobTestPrep offers you the opportunity to prepare for your Microsoft Excel and Microsoft Word assessment tests. Preparation is the key to success so start practicing today and increase your chances of scoring high on your test.
Related Links.
Performance based assessment and test preparation tools to help individuals achieve IT certification credentials. Many of your students will be anxious to assess their knowledge of applications prior to taking the certification exams. Additionally, we recognize the need for educators to properly assess an individual’s knowledge. To this end, Certiport has partnered with GMetrix to deliver industry-leading practice tests. These tests, with included reporting and insight features, ensure your students are adequately prepared to their certification exam. Why GMetrix practice tests?.
Accurately replicate a 'live application' testing environment. Enhance learning through self-paced practice questions. Build familiarity with the testing environment. Increase confidence towards certification exams. Better prepare students to pass certification exams. Testing mode:. Students experience what the certification exams will be like.
Timed practice tests present scenarios to perform just like the actual certification exam Training mode:. Students work at their own pace as they receive feedback and step-by-step instructions for each question Practice tests available for:. Word 2016, 2013, 2010. Word Expert 2016, 2013, 2010.
Excel 2016, 2013, 2010. Excel Expert 2016, 2013, 2010.
PowerPoint 2016, 2013, 2010. Outlook 2016, 2013, 2010. Access 2016, 2013, 2010.
SharePoint 2013, 2010. OneNote 2013, 2010.
Excel is synonymous with spreadsheets, and for good reason. Decades after its introduction on the original Macintosh, Excel continues to be the most powerful spreadsheet app. It's not just a desktop app anymore, either. Today, you can use Excel on Windows, Mac, iOS, Android, and even the web.
That latter version is perhaps the most interesting. Microsoft Excel Online is a free, online version of Excel that includes the functions, chart tools, and more that you'd expect from a spreadsheet.
Similar to Google Sheets, Microsoft Excel Online lets you collaborate with others in real-time, gather answers in an online survey, and crunch numbers with Excel functions. Most importantly, though, Excel Online now lets you connect your spreadsheet with other web apps to gather data and start automated workflows—and since it syncs with traditional Microsoft Excel, you can use the Online version to add automations to any spreadsheet. If you've used Excel for years, switching to a web app may sound scary. In this guide, we'll walk you through everything you need to get your spreadsheets in the cloud, so you can gather data and collaborate—and still use Excel on your desktop. What is Microsoft Excel Online? Microsoft Office Online gives you free, collaborative versions of Word, Excel, and more in the cloud Microsoft Excel Online—along with the rest of —are a new take on the traditional Office suite you've used for years. Typically, you'd buy a copy of Office for a few hundred dollars and install it on your computer.
That's how Office has been sold for years, starting with the first version of Excel for Macintosh in 1986. Microsoft Office is so ubiquitous, its bundled apps including Word, Excel, and PowerPoint are synonymous with documents, spreadsheets, and presentations—they're the standard business apps across most industries. Microsoft Excel Online is the free version of Excel that works in your browser. It's a companion app to Excel, designed to let you view and edit your Excel spreadsheets online. And yet, it's still a full spreadsheet app that supports nearly every Excel function and includes charting and survey tools to help you gather and visualize data. It's better than Google Sheets for working with existing Excel files or sharing spreadsheets with other Excel users, and at the low cost of free, is the cheapest way to use Excel. You can use all of Excel Online's features for free, as long as you don't have more than 5GB of files in OneDrive, Microsoft's online file storage.
Or, if you still want a copy of Office installed on your computer as well, the best option today is subscribing to Office 365, which gives you the most recent versions of Office for your computer along with file sharing in OneDrive. You can store all of your files in OneDrive, then edit any of the Office files online with Office Online. And—with the Business versions of Office 365, for now—you can use to connect your spreadsheets to your favorite apps. Here are the Office 365 options you can choose from:. Free: With a Microsoft account, you can use Office Online and save up to 5GB of files in OneDrive for free.
$6.99/month: Get Office apps on your computer, and 1TB of OneDrive storage. $9.99/month: Get Office apps for 5 people in your family, along with 1TB of OneDrive for each user.
$8.25/month: Get Office on your work computer, with 1TB OneDrive for Business storage with professional integrations. $12.50/month: Get Office on your work computer and 1TB OneDrive for Business storage, along with email and video conferencing. No matter which account you have, you can use the all of Office Online—including Excel Online. So let's dive in. Need to make presentations?
Check out our to learn how to make presentations, collaborate with your team, and present them from your browser all for free. Excel Online Basics. Just like Excel on your desktop, Excel Online starts out with templates and recent files There are two easy ways to open Microsoft Excel Online: Go to and click the Excel link to create a new spreadsheet, or open and click on a spreadsheet you've saved online (we'll look at later on). If you open Excel Online from Office.com, you'll see a variety of templates to start a new spreadsheet, along with a list of recently opened sheets on the left side.
Click a template or the blank spreadsheet option to start making a new spreadsheet. Tip Want a quicker way to open Excel Online? Just bookmark to open it in a click. Or install for one-click access to Microsoft Excel Online and every other Office Online app.
Excel Online includes the core Excel features—even the status bar for quick sums and averages Microsoft Excel Online looks much like you'd expect. Your data is organized in rows and columns, with tools and features included in an Office ribbon toolbar. On the bottom right, the standard Excel status bar is included, with quick sums and averages of the cells you've selected. Just click in a cell and type to start adding data to your spreadsheet. Or, paste in data from your computer or other spreadsheets, with the standard options to paste the formulas, values, or formatting.
To change the formatting, just click the toolbar buttons at top. You can tweak fonts, colors, text alignment, and number formats, or choose to wrap text and merge cells. Right-click to insert rows—or click the Insert button at the top for more detailed options. There's also Sort and Find tools to keep your data organized. Excel Online includes nearly all default Excel functions There is one spot where Excel Online is full featured: Functions. Excel 2016 includes, including 11 new ones just added to this version (along with 51 functions added in 2013, and 57 added in 2010)—and they're all included in the Excel Web App. There are only 411 functions listed in the Excel Web App's Functions menu, but it actually supports all but 3 built-in Excel functions: SQL.REQUEST, JIS, and EUROCONVERT.
Everything else is supported; even if the function isn't shown in the auto-complete dropdown, it'll still work once you enter it correctly. To add a function, just type = followed by your function name.
Excel will auto-complete the function name—press the Tab key to accept the suggested function—and then give you tips on what data you should include in the function. Or, you can look through the included functions by clicking the fx button right under the toolbar.
You can click cells to add them to your function, just as in other versions of Excel. And, once you've added a function to a cell, just select it and drag down to add the function to all of the other cells you've selected. Excel Online includes most of Excel's chart features Once you've added data to your spreadsheet and have crunched your numbers with functions, it's time to bring it to life with charts. Excel Online includes a wide range of charts—and most of the tools you need to customize their appearance. Just select the data you want to visualize, then click the Insert menu and select one of the chart styles you'd like. Excel will automatically generate the chart—and if you don't like it, just click any of the other chart types in the new Chart tab. You can edit chart titles, legends, and labels in Excel Online Then, you can customize your chart's title, legends, and labels.
Just select the menu option for the item you want, and you can both add text and customize where it's displayed. Unfortunately, there are no theme or color options for charts in Excel Online. If you want something different from the default colors, start your spreadsheet using one of the built-in Excel templates, and your charts will pick up the colors from that template. Alternatively, open your spreadsheet in Excel on your computer to change the design—then save it, and the changes will show up in Excel Online, too. Tables let you sort and filter data easily in spreadsheets Or, perhaps you just need an easier way to sort through data. For that, Excel's Tables are the tool you need. Select the data you want to sort through, and click the Format as Table button in the Home toolbar.
You can then sort each column, filter for specific items (say, all items that include the text 'tool'), or use number filters to find items that equal or are greater than/less than, above or below average, or the top 10 items in that column. Or, you can add custom filters to find exactly the data you want. Excel for Mac and Windows also includes, 2-dimensional tables that give you more powerful ways to view and organize data. You can't create them in Microsoft Excel Online—but if you have already added them to a spreadsheet, you can view them in Excel Online. Gather Data with an Excel Survey With your spreadsheets online, Excel can work in the background even when your computer is turned off. One of the handiest ways to use that is with Excel Online's built-in Surveys tool. It's one Excel feature you won't find in the other versions of Excel.
Just open a spreadsheet in Excel Online, click the Survey button in the Home tab, then select New Survey. The Excel survey your respondents will see Then, click the Share Survey button to copy a link to your survey. You can share that link privately in emails, or share it publicly to get a wider range of answers.
Excel will automatically save your survey responses to a new sheet in your spreadsheet, with table formatting so you can easily sort through and filter your survey responses. For a more full-featured form app connected to a spreadsheet, check out our. Or, use any, and connect it to your Excel spreadsheet with integrations. Share and Collaborate in Microsoft Excel Online. Work on your spreadsheet together in real-time in Excel Online Once your colleagues have opened your spreadsheet, everyone can work on it together inside Excel Online—though you can't open the file in traditional Excel apps at the same time. You'll see a list of the names of collaborators in the top right along with the cell they're currently editing. As changes are made, you'll see cells currently being edited shaded in that users' color, and cells selected by another user highlighted with their color.
Add Comments to Your Spreadsheet To work together a bit better, click the Review tab to open Excel's comment tools. You can add a comment to a cell, show or hide the comments sidebar, or edit and delete any comments already on the spreadsheet. You can't add a second comment to a cell that already has a comment, and can't reply to comments, so you might need to work a bit to find a system that works well for your team. It's a good way to let others know where you left off work—or to identify cells that need changed—at least. Share a Copy of Your Spreadsheet.
You can download your spreadsheets in Excel or Open Document formats Want to share your spreadsheet with others offline so they can edit it in a traditional copy of Excel? You could either copy the spreadsheet from your OneDrive folder, or you can download a new copy from the web. Just click the File menu in Excel Online, select Save As, then choose Download a Copy to download a.xlsx formatted copy of your spreadsheet.
Alternatively, you can download an formatted.ods spreadsheet to use in alternative spreadsheet tools like OpenOffice and LibreOffice. Moving Your Existing Spreadsheets to Excel Online. OneDrive syncs your files so you can view them anywhere If you're already an Excel user, you'll likely want to move your existing spreadsheets to the web so you can view and edit them in Excel online. There are two ways to do that.
You could open, and drag-and-drop your Excel spreadsheets to save them online. The best option, though, is to install the OneDrive apps, and sync your spreadsheets to the cloud. You can then edit them either with Excel on your computer or online with Excel Online, and have the changes saved to both places automatically. To do that, just and install it, then log in with your Microsoft account. If you have multiple accounts—say a OneDrive for Business account for work and a free account for personal files—you can sync both of them at the same time.
Then, copy your Excel files to the new OneDrive folder to sync them with Excel Online. Browse, organize, and view your files online You can then open OneDrive online and see all of your synced files, organized into folders just like on your computer. And if you're ready to edit one, just click it to open it in Excel Online. Any changes you make to the spreadsheet online will be saved back to your computer automatically. And if you make any new spreadsheets online, they'll also be saved to your computer in standard.xlsx format that you can open in any modern version of Excel. That's one of the best features of Excel Online: it saves your data in real files, so your spreadsheets aren't trapped in the cloud.
Opening Older Spreadsheets in Excel Online One thing to note: Excel Online can only open.xlsx and.xlsm files, and with the latter it won't be able to run any macros included in the workbook. If you upload an older.xls file, or a.csv spreadsheet to OneDrive and then try to open it online, Excel will just download the file to your computer instead of opening it. As such, you'll first need to convert any spreadsheets you want to use online to the newer.xlsx format.
Just open them in Excel, open the Save as dialog from the File tab or menu, then select Excel Workbook (.xlsx). You can then add those files to OneDrive to view and edit them online. Add extra features to Excel with Add-ins Microsoft Excel Online may have as many functions as traditional Excel, but it doesn't include anywhere near as many features. You can fix that to a degree with Office Add-ins.
From the, you can find a wide variety of free and paid tools for Excel. Incredibly, the same add-ins designed for Excel 2016 run in Excel Online, so you can use many of the same powerful tools that would otherwise require desktop Excel. To add an add-in to your Microsoft Excel Online spreadsheet, click the Insert menu in Excel Online and select Office Add-ins to browse the store right inside your spreadsheets. Once you've found an add-in you want to use, just click the Add button to install it—and occasionally you'll then need to click a Start button to enable the add-in. Ablebits' Trim Spaces Add-in removes extra spaces from your spreadsheet You'll then see your add-ins from the sidebar along with any comments you've added to your documents. When you re-open this spreadsheet, those same add-ins should open in the sidebar again.
If you don't see them, just open the Add-ins Store again, add the same add-in to your spreadsheet, and the sidebar will appear with any add-ins you've enabled. There are a number of great add-ins, many of which connect to web apps and let your spreadsheets create invoices, manage projects, and more. Some of the most handy are those that add extra features to Excel, or replace built-in features you'd find in Excel 2016.
Here are some of the best to try:. to search deeply through your spreadsheets. to remove duplicate data. to make your data easier to use in a spreadsheet. to remove extra blank spaces from your spreadsheets.
to find differences between text. to merge rows, columns, or entire ranges. to solve optimization problems for statistics. to create maps from your spreadsheet data.
to add extra data analysis functions to Excel There is one thing you can't run in Excel Online: macros. Macros let you automate Excel, either by letting Excel record what you do in a spreadsheet or by writing simple code. For that, you'll need a traditional copy of Excel installed on your computer. Then, you can to make powerful spreadsheets, and sync them with OneDrive to still be able to view and edit their info online. Want to build your own Excel Online add-ins? Here's a to help you get started. Connect Excel to 700+ Apps with Zapier Integrations.
Another great way to do more with Excel Online is with using app automation tool Zapier. Zapier can watch your spreadsheet for new or updated rows, and then start workflows with over 600 other apps based on that data from your spreadsheet.
Or, it can search through your spreadsheet, add a new row, or even update existing rows in your spreadsheets. For now, Excel web integrations only work with Excel Online if you have an Office 365 for Business, OneDrive for Business, or Sharepoint Online account. Now all you have to do is click the + icon beside each of the column names from Excel, and select the correct data from Trello to add to the spreadsheet. Once everything's customized the way you want, test and turn the Zap on, and Zapier will automatically log all archived tasks to your spreadsheet. There are dozens of ways you can use integrations like these to save data to your Excel spreadsheet automatically and get work done right from your spreadsheet.
Here are some of the most popular integrations—or check out Zapier's for more ideas and ways to connect your favorite apps. Microsoft Excel Online may be designed as a sidekick to traditional Excel, but it's a powerful tool it its own right. You can create spreadsheets, crunch numbers, collaborate and more right from your browser for free. And with add-ons and integrations, you can add any extra features you want to your spreadsheet.
It's the perfect way to use Excel anywhere—and may be the best way to get started with Excel if you don't already have a copy installed. → Now that you've mastered Excel Online, check out our so you'll be ready to make presentations in your browser, too.
Guide To Microsoft Office 2017 Review Questions And Answers
Learn More About Spreadsheets with Zapier Spreadsheets are incredibly powerful tools, no matter which app you create them in. They can manage your finances and mailing lists—or they can turn your website's analytics data and let you build your own custom apps. In our new book, you'll find a number of tutorials on how to get more out of spreadsheets. And don't worry: the same tutorials will work in Excel Online with only minor differences. Here are some of the best tutorials to help you get started:. If you're just getting started with spreadsheets, check out. Want to manage contacts in a spreadsheet?
Here's. Spreadsheets can help you write faster, too. Here's. Then, and to make it work in Excel, just use the to get Google Analytics data in your spreadsheet Or, you can download a copy to learn more about spreadsheets on your own anytime.
Download The Ultimate Guide to Google Sheets. Download in (18.0 MB). Download in (17.5 MB). Download in (36.8 MB).
Download in (69.4 MB) This article was originally published on September 8th, 2016, and was updated recently with Microsoft Excel Online's latest features. Excel for Macintosh ca. 1986 photo by via.
. Holden commodore svz workshop manual. Pricing does not reflect any promotional offers or reduced pricing for Microsoft Imagine Academy program members, Microsoft Certified Trainers, and Microsoft Partner Network program members. Pricing is subject to change without notice. Pricing does not include applicable taxes. Please confirm exact pricing with the exam provider before registering to take an exam. Effective May 1, 2017, the existing cancellation policy will be replaced in its entirety with the following policy: Cancelling or rescheduling your exam within 5 business days of your registered exam time is subject to a fee. Failing to show up for your exam appointment or not rescheduling or cancelling your appointment at least 24 hours prior to your scheduled appointment forfeits your entire exam fee.
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam.
View video tutorials about the on Microsoft exams. Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text. Do you have feedback about the relevance of the skills measured on this exam? All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback.
We appreciate your input in ensuring the quality of the Microsoft Certification program. If you have concerns about specific questions on this exam, please submit an.
If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your. Note: There are exam updates effective as of December 15, 2017.
To learn more about these changes and how they affect the skills measured, please download and review the. Support Microsoft Store, Microsoft Store for Education, Microsoft Store for Business, and cloud apps.
Install and manage software by using Microsoft Office 365, Microsoft Store for Business apps, or Microsoft Store for Education apps; sideload apps by using Microsoft Intune; sideload apps into online and offline images; deeplink apps by using Microsoft Intune; integrate Microsoft account, including personalization settings. Support authentication and authorization. Identify and resolve issues related to multi-factor authentication, Windows Hello for Business, virtual smart cards, picture passwords, and biometrics; implement workgroup and domain authentication; implement Homegroup; configure computer and user authentication using secure channel, account policies, credential caching, and Credential Manager; implement local accounts and Microsoft accounts; configure Windows Hello for Business; implement Azure AD Join; connect Microsoft accounts to domain accounts. Migrate and configure user data. Migrate user profiles; configure folder location; configure profiles, including profile version, local, roaming, and mandatory. Configure Hyper-V.
Create and configure virtual machines including integration services; create and manage checkpoints; create and configure virtual switches; create and configure virtual disks; move a virtual machine’s storage. Configure mobility options.
Configure offline file policies, power policies (powercfg), Windows to Go, sync options, Sync Center, and Wi-Fi direct. Configure security for mobile devices. Configure BitLocker; configure startup key storage. Support mobile devices. Support mobile device policies including security policies, remote access, and remote wipe; support mobile access and data synchronization including Work Folders and Sync Center; support broadband connectivity including broadband tethering and metered networks; support Mobile Device Management by using Microsoft Intune including, Windows 10, Windows 10 Mobile, iOS, and Android.
Deploy software updates by using Microsoft Intune. Use reports and In-Console Monitoring to identify required updates; approve or decline updates; configure automatic approval settings; configure deadlines for update installations; deploy third-party updates. Manage devices with Microsoft 365 Solution. Provision user accounts; enroll devices; view and manage all managed devices; configure the Microsoft Intune subscriptions; configure the Microsoft Service Connection Point role; manage user and computer groups; configure monitoring and alerts; manage policies; manage remote computers. Configure information protection. Manage and configure Office 365 Data Loss Prevention, Windows Information Protection and BitLocker, Azure Information Protection, Microsoft Cloud App Security, Office 365 Advanced Security Management.
Configure IP settings. Configure name resolution; connect to a network; configure network locations. Configure networking settings. Connect to a wireless network; manage preferred wireless networks; configure network adapters. Configure and maintain network security. Configure Windows Firewall; configure Windows Firewall with Advanced Security; configure connection security rules (IPsec); configure authenticated exceptions; configure network discovery. Support data storage.
Identify and resolve issues related to the following: DFS client including caching settings; storage spaces including capacity and fault tolerance; OneDrive. Support data security.
Identify and resolve issues related to the following: Permissions including share, NTFS, and Dynamic Access Control (DAC); Encrypting File System (EFS) including Data Recovery Agent; access to removable media; BitLocker and BitLocker To Go including Data Recovery Agent and Microsoft BitLocker Administration and Monitoring (MBAM). Configure shared resources.
Configure shared folder permissions; configure HomeGroup settings; configure libraries; configure shared printers; configure OneDrive. Configure file and folder access. Encrypt files and folders by using EFS; configure NTFS permissions; configure disk quotas; configure file access auditing Configure authentication and authorization. Configure remote connections. Configure remote authentication; configure Remote Desktop settings; configure VPN connections and authentication; enable VPN Reconnect; configure broadband tethering; configure Remote Desktop client for Windows 10 Mobile, iOS, and Android; protect remote desktop credentials with Remote Credential Guard; enable restricted admin mode for RDP in Windows 8.1 and Windows 2012 R2. Configure mobility options.
Configure offline file policies; configure power policies; configure Windows to Go; configure sync options; configure Wi-Fi direct. Deploy and manage RemoteApp. Configure RemoteApp and Desktop Connections settings, configure Group Policy Objects (GPOs) for signed packages, subscribe to the Desktop Connections feeds, export and import RemoteApp configurations, support iOS and Android, configure remote desktop web access for distribution. Support desktop apps. Support desktop app compatibility using Windows Assessment and Deployment Kit (ADK); desktop application co-existence using Hyper-V and App-V; configuration of User Experience Virtualization (UE-V); deploy desktop apps by using Microsoft Intune. Configure system recovery.
Configure a recovery drive; configure system restore; perform a refresh or recycle; perform a driver rollback; configure restore points. Configure file recovery. Restore previous versions of files and folders; configure File History; recover files from OneDrive.
Configure and manage updates. Configure update settings; configure Windows Update policies; manage update history; roll back updates; update Microsoft Store apps. Who should take this exam? Candidates for this exam are Windows device support technicians or Windows Device System Administrators who are responsible for building solid identities, protection of content (data loss protection), mobile device management policy, virtualization with Hyper-V, and application management using the Company Portal or the Microsoft Store. Candidates should have experience with Windows desktop administration, maintenance, troubleshooting, Windows 10 security, and integrated Azure features. Candidates should have a basic understanding of Windows networking technologies, Active Directory, and Microsoft Intune.
More information about exams We recommend that you review this exam preparation guide in its entirety and familiarize yourself with the resources on this website before you schedule your exam. See the for information about registration, videos of typical exam question formats, and other preparation resources. For information on exam policies and scoring, see the. This preparation guide is subject to change at any time without prior notice and at the sole discretion of Microsoft.
Microsoft exams might include adaptive testing technology and simulation items. Microsoft does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format. To help you prepare for this exam, Microsoft recommends that you have hands-on experience with the product and that you use the specified training resources. These training resources do not necessarily cover all topics listed in the 'Skills measured' section.
More about Office. is part of the package and is a cloud-based application designed to be used for asking questions and compiling the responses using the power of cloud services. Forms can handle everything from simple poll questions to complicated branching questionnaires and quizzes. This quick tutorial will show you how Microsoft Forms works and suggests some ways the application could simplify your future data analytical tasks. SEE: (TechRepublic PDF) Microsoft Forms Keep in mind that as of September 2017, Microsoft Forms is considered a preview version, so some of the following procedures could change slightly depending on feedback. To access Forms, log in to the online version of Office 365 and use the app switcher to find the corresponding Forms icon in the menu. Since it is a new preview app, the default position is near the bottom of the menu, so you may have to scroll.
Click the Forms icon to start the app. You should see a screen similar to Figure A. After you create your question and corresponding answers, you can specify whether respondents can have multiple answers and whether the question must be answered before moving to the next question. After you have written more than one question, you can choose to move specific questions up and down the entire list of questions to change the sequence, as shown in Figure C. Figure C Once your set of questions is complete, you can share it with as many or as few potential respondents as you desire by clicking the Share tab in the commands menu. You will have several choices on how you want to share your questionnaire.
You can share with specific people via email or you can create a link to share with members of your domain. You can also create a link to share with anyone. In addition, Forms will create an embed code you can use to insert your questionnaire into a webpage. ( Figure D) Figure D To check responses, click the Responses tab on your questionnaire. Forms will display a chart listing the responses and graphing out the results, as shown in Figure E. You can transfer the results to Excel for further analysis if you wish, and from there you can transfer the results to other analytical tools, like. Figure E As you can see, Microsoft Forms is easy to use, but it's also effective.
If you want to see what a Forms poll looks like to a respondent, check out the —I'll keep it live for the foreseeable future. SEE: (Tech Pro Research) Bottom line In years past, an enterprise looking to conduct a customer satisfaction survey or produce a questionnaire would have to commission a service company specializing in the practicalities of those tasks. These companies would typically have proprietary software available that could ask the questions and compile the responses. Those days are long gone. Microsoft Forms allows enterprises to conduct customer surveys, question trainees to determine their knowledge of procedures, confirm compliance with human resources training, etc. And it does this without having to hire specialized services or teams of application developers. If you have Office 365 Business Premium or one of the enterprise versions, Forms could be a real time-saver for your company.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |