Excel 2016 English Practice Test
Practice Test Offline
The 77-727 Practice Test will prepare you to pass the MOS 2016 Excel Core certification exam. By completing the tasks you will improve your practical skills in creating and managing Worksheets and Workbooks, managing data cells and ranges, creating tables, performing operations with formulas and functions and creating charts and objects.
These same tasks will help you understand the objectives and competencies tested on the Microsoft 77-727 certification exams.
These same tasks will help you understand the objectives and competencies tested on the Microsoft 77-727 certification exams.
| Info | Learning objectivesCreate and Manage Worksheets and Workbooks. Create Worksheets and Workbooks. Navigate in Worksheets and Workbooks. Format Worksheets and Workbooks. Customize Options and Views for Worksheets and Workbooks. Configure Worksheets and Workbooks for Distribution. Manage Data Cells and Ranges. Insert Data in Cells and Ranges. Format Cells and Ranges. Summarize and Organize Data. Create Tables. Create and Manage Tables. Manage Table Styles and Options. Filter and Sort a Table. Perform Operations with Formulas and Functions. Summarize Data by using Functions. Perform Conditional Operations by using Functions. Format and Modify Text using Functions. Create Charts and Objects. Create a Chart. Format a Chart. Insert and Format Objects. |
|---|
CLOUD PRODUCTS - System Requirements
- Any Operating System
- Browser compatible with HTML5
- Broadband connection recommended
- Recommended resolution 1280 x 800 or higher
DESKTOP PRODUCTS - System Requirements
| Platform | Operating System | Browser | |||
|---|---|---|---|---|---|
| Chrome 39 | Firefox 34 | Internet Explorer 10 and 11 | Safari 8 | ||
| PC | W7 x86 | X | X | X | |
| W7 x64 | X | X | X | ||
| W8.1 x86 | X | X | X | ||
| W8.1 x64 | X | X | X | ||
| MAC | OSX 10.9 | X | X | X | |
| OSX 10.10 | X | X | X | ||
| LINUX | Linux x86 | X | X | ||
| Linux x64 | X | X | |||
| Surface Pro | Windows 8 | X | X | X | |
| Platform | Operating System | Browser | ||||
|---|---|---|---|---|---|---|
| Safari 8 | Android | Chrome 39 | Internet Explorer RT | Internet Explorer 11 | ||
| iPad* | IOS 8 | X | X | |||
| iPhone 5 or higher* | IOS 8 | X | X | |||
| iPhone 4* | IOS 7 | X | X | |||
| Android Tablet* | 4.0 or higher | X | X | |||
| Android Phone* | 4.0 or higher | X | X | |||
| Lumia 920 or higher* | Windows Phone 8.1 | X | ||||
| Surface | Windows RT | X | ||||
*Online use only with these devices
Download System Requirements
- Win7, Win8.1, Linux 64 bits, MAC OSX 10.9 and 10.10
- We no longer support XP