Scroll to top button

excel-2013-lab : Microsoft Excel 2013 Lab

excel-2013-lab
excel-2013-lab
Microsoft Excel 2013 Lab
ISBN : 978-1-61691-230-7
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.

Labs

Online labs can be used to supplement training. uCertify labs are an inexpensive & safe way to explore and learn. uCertify labs are versatile - labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training.

Here's What You Get

Video tutorials
91+
Minutes
45+

Hands on Activities

Create and manage worksheets and workbooks

  • 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

Create cells and ranges

  • 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

Create tables

  • 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

Apply formulas and functions

  • 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

Create charts and objects

  • 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

Mentoring

Mentoring is Add-on licence, please select while purchasing. Our Mentors are available 24/7 to provide you an expert support via online chating. They are subject matter experts and ready to provide answer to your questions.

Exam Information

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.

Prepare for the following certification

Career Prospects
  • Application developer
  • Data Analyst
  • Executive Assistant
  • Senior executive assistant
  • Manager Trainee
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

The exam fee may vary depending on the country.

Where do I take the exam?
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.

Copyright © 2002-2017 uCertify / All Rights Reserved.