Microsoft Excel 2013 Lab

Gain hands-on expertise in Microsoft Office Specialist Excel 2013 exam with Microsoft Excel 2013 performance-based lab. The performance-based lab is versatile - labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. The lab covers all the objectives of Microsoft Office Specialist Excel 2013 exam which includes, handling fundamental excel formulas and tools and to improve their knowledge of the fundamental tools for calculating, organizing, visualizing and managing data in Microsoft Excel 2013.

Here's what you will get

Microsoft Office Specialist Excel 2013 exam has objective domains like to create and manage worksheets and workbooks, create cells and ranges, create tables, apply formulas and functions, create charts and objects. The audiences of the exam are information workers. The technology used is Microsoft Office 2013 suites. The exam provides credit towards certification of Microsoft Office Specialist.

The exam helps to build a brighter future and understand the computing skills which companies are demanding, improve your resume, distinguish yourself from other candidates, obtain precious experience and confidence, uplift your earning potential, gain industry-recognized certification and a successful future.

The exam also helps academic institutions, business and government organizations in many ways.

Video tutorials
Exam FAQs
What are the prerequisites for this exam? No prerequisite skills are required for taking this exam.
What is the exam registration fee? 96 USD
Where do I take the exam? Certiport
What is the format of the exam? Multiple choice, case study, drag and drop, short answers and so on
How many questions are asked in the exam? The exam contains 40-60 questions.
What is the duration of the exam? 50 minutes
What is the passing score? 700

(on a scale of 1-1000)

What is the exam's retake policy?
  1. Retake vouchers can only be used to retake the same exam that was failed.
  2. All vouchers must be used prior to their expiration dates, without exception.
  3. Retake vouchers must be used within 30 days of the initially failed exam.
  4. As of July 1, 2014, the retake policy changed to the following:
  • If a candidate does not achieve a passing score on an exam the first time, the candidate must wait 24 hours before retaking the exam.
  • If a candidate does not achieve a passing score the second time, the candidate must wait 48 hours before retaking the exam.
  • A two-day waiting period is imposed for each subsequent exam retake.
  • If a candidate achieves a passing score on an exam, the candidate may take it again.
Where can I find more information about this exam? To know more about the excel-2013-lab, click here.
Which certification covers this exam?
What are the career opportunities after passing this exam?
  • Application developer
  • Data Analyst
  • Executive Assistant
  • Senior executive assistant
  • Manager Trainee

Here's what you will learn

Hands on Activities (Labs)

  • Creating a blank workbook
  • Creating a workbook using a template
  • Moving a worksheet
  • Create a new sheet and color the sheet tab
  • Insert, rename, and hide a worksheet
  • Adding and hiding a column and a row
  • Editing a comment
  • Inserting a hyperlink
  • Using the Go To feature
  • Copy a sheet to another workbook
  • Inserting a watermark
  • Set column width and row height
  • Copying format of one range to another
  • Applying conditional formatting using multiple criteria
  • Convert text to columns
  • Split a worksheet horizontally
  • Hide the formula bar
  • Allowing editing on limited cells in a protected workbook
  • Unhide the formula bar
  • Change the movement behavior of a selection
  • Password protecting a workbook
  • Enabling Track Changes
  • Hide sheet tabs and scroll bars
  • Configuring default workbook settings
  • Changing the gridline color
  • Disabling AutoRecover
  • Changing default error checking rules
  • Changing default display options
  • Maintaining backward workbook compatibility
  • Printing an individual worksheet
  • Saving a template file
  • Open a template file as a copy
  • Saving a file in PDF format
  • Adding a header and footer
  • Printing repeated header rows
  • Specifying a print area and checking its layout
  • Changing font size of a heading style
  • Setting margins for printing
  • Configuring Page Setup for printing
  • Password protecting a workbook structure and worksheet
  • Using the Cut and Paste functions
  • Deleting data in a cell range
  • Using the Goal Seek feature
  • Showing cell dependency
  • Adding a custom series for the Fill Series option
  • Banding rows using an Excel table style
  • Applying a cell style to a cell range
  • Splitting range into columns
  • Unmerging previously merged cells
  • Merging and centering cell text
  • Applying conditional formatting
  • Applying a theme to a table
  • Removing a background image
  • Formatting a worksheet
  • Applying color scales
  • Banding rows by conditional formatting
  • Editing a defined range
  • Applying a Table Style
  • Formatting a cell range as a table
  • Banding columns by using conditional formatting
  • Deleting duplicate rows and sorting the table
  • Sorting a table
  • Filtering data
  • Using the REPT function
  • Calculating the surface area of a sphere
  • Changing a relative reference to an absolute reference
  • Displaying and evaluating formulas
  • Adding watch options for cell values
  • Enforcing immediate calculation of formulas
  • Applying conditional formatting on the cells
  • Using the MIN and MAX functions
  • Using the AVERAGE function
  • Using the CONCATENATE function
  • Using the RATE function
  • Using the CONVERT function
  • Using the ROUND function
  • Using the MROUND function
  • Displaying an average of selected values
  • Using the VLOOKUP function
  • Using the HLOOKUP function
  • Using the COUNTIF function
  • Concatenating text
  • Using the RIGHT and UPPER functions
  • Using the SUBSTITUTE function
  • Implementing data validation
  • Increasing chart length and breadth
  • Applying conditional formatting
  • Using Sparklines to illustrate data trends
  • Changing the Sparkline type to Sparkline Style Colorful #6
  • Configuring arrow width
  • Inserting SmartArt
excel-2013-lab excel-2013-lab
Microsoft Excel 2013 Lab
ISBN : 9781616912307
Rating :