Excel Test For Interview Download

Posted on

What version(s) of Excel?

How do you define 'proficiency?Proficiency at what: Version specific features or just general spreadsheet skills?

Job Skills Tests; Interview Practice. Free Excel Test for Interviews. Microsoft Excel is the most widely used software in today's workplaces. The power of the software is from the most basic calculations to the most complicated including manipulations of text. Prepare for your assessment with our JobTestPrep Excel practice and get the. In case you're prepping up for your next interview, and have listed Excel as one of your skills, take some time to go through these common Excel interview questions. I have tried to cover all the popular Excel interview questions I have seen being asked, as well as some that I thought could be good to know. Intermediate/Advanced Excel Practice Tests for Interview. JobTestPrep’s Excel 2016 preparation package provides you with a complete preparation experience by utilizing both intermediate/advanced Excel exercises as well as basic ones.

What specific skills you you actually use in your setting?

Is this going to be a 'paper only' test, or a 'hands on' / practical test spreadsheet they can use Excel in to demonstrate.The 'practical' test will include allowing them to use online help to find specific answers, demonstrating they know how to look for answers ..

Look for existing online training. Some include pretests, many include post tests. You can 'steal' test question ideas from them.

Ask this question at the 'Chandoo' site. They have lots of good resources and many 'experts' responding to questions



Here is the reply to the same question that was provided by this site: http://excelribbon.tips.net/

Excel Proficiency Testing

Summary: Need to figure out how good someone is with Excel? You need what is commonly called a 'proficiency test.' Here's the low-down on what is available and what you can do to make your determination. This tip (3426) applies to Excel 97 2000 2002 2003 2007

Mark needs to determine someone's proficiency with Excel and is wondering if there are any tests available that can run without the installation of any special software, macros, flash, or the like.

The short answer is that it depends—on lots of things. Proficiency tests are designed to measure how well someone does at a certain task. Excel is a tool you can use to accomplish some tasks, but it isn't a task itself. For example, a proficiency test may indicate how well someone does at creating pie charts, but may not do well on PivotTables, lookup formulas, or conditional formatting.

Because the number of things you can do with Excel is so large, many people develop their own in-house tests that, again, are geared toward specific tasks. An example would be to create a worksheet that has assorted raw data and then ask the user to do something with that data to reach a desired goal. You might even provide a question or two that direct the user to create a worksheet to solve the question.

If you prefer to not develop your own proficiency test, you should try doing a search on Google for what you need. For instance, you might search for 'Excel proficiency tests' (without the quote marks). If you want to limit the results further, add additional search terms that reflect the specific skills you want to test. For example, you could search for 'Excel proficiency tests charts' or 'Excel proficiency tests PivotTables.'

Finally, here are some specific resources pointed out by some ExcelTips subscribers:




The 365 Adoption Kit has a spreadsheet with links to some MS training courses. They include tests at the end of each unit ..

Office 365 Adoption Kit available


List of Learning Resources


The link to this spreadsheet is in the Office 365 Adoption Kit. It has links to over 450 free online MS Office 2013 Courses

2013 Support Links

Here are several places you can go to find help. Many of the pages point to the same resources.

Office365 - Forums http://community.office365.com/en-us/f/default.aspx

Office365 Community http://community.office365.com/en-us/default.aspx :

Get help with Office 365 http://onlinehelp.microsoft.com/en-us/office365-smallbusinesses/ff637531.aspx - simple suggestions of where to look for help

Office 365 - Support http://support.microsoft.com/ph/15834#tab0 : Links to customer service and technical solutions, downloads, updates, and answers to top issues.

Office 365 - Support http://www.microsoft.com/en-us/office365/support.aspx#fbid=wqplBJHlFni - Download, Install, Activate, Training, “Get Started” links

Office365 http://www.microsoft.com/en-us/office365/ - What’s New, Get Templates, Setup Office

End user training resources for Office 2013 and Office 365


Learn Office 2013 (and earlier) - Free Lessons for most apps

For example, the Word course has 24 lessons

Office.com Online training for 2013 2011 2010 2007


Free 15-minute webinars

Get to know the new Office

Freeze and lock Excel panes

Work with photos in Office

Set margins in Word

All about PowerPoint Slide Masters

More …View all

Microsoft Office 2013 and Office 365: A Deeper Dive


Free Ebooks

Free e-books for Windows administrators (updated) (merged)


#3 Huge collection of Free Microsoft eBooks for you, including: Office 2013 / 365, SharePoint 2010 / 2013, SQL Server etcEPUB / MOBI / PDF


#2 Another large collection of Free Microsoft eBooks and Resource Kits for you, including: SharePoint 2013, Office 2010 / 2013 / 365, Windows Phone, Lync and more. EPUB / MOBI / PDF


#1 Large collection of Free Microsoft eBooks for you, including: SharePoint, Visual Studio, Windows Phone, Office 365, Office 2010, SQL Server 2012, more. EPUB / MOBI / PDF

MS General Training Resources

Microsoft IT Academy:http://www.microsoft.com/education/itacademy/Pages/benefits.aspx - “

ITA enables you to offer training not only on fundamental technology skills but also technical courses for your students, faculty and staff who are interested in pursuing a career in IT after graduation.”

Microsoft Virtual Academy: http://www.microsoftvirtualacademy.com/ - “Successful technologists never stop learning and great technology never stops evolving. Microsoft Virtual Academy (MVA) offers online Microsoft training delivered by experts to help technologists continually learn, with hundreds of courses, in 11 different languages.”

Microsoft IT Learning/Training:http://www.microsoft.com/learning/en-us/training.aspx“Whether you’re an established professional or new to the field, our training will give you the expertise you need in a specific product or technology. When you learn from our Microsoft Certified Trainers, you can be confident that what you’ll learn will be accurate, complete, and up to date.”

Microsoft Partner Training:.“Sharpen your skills with training for the latest Microsoft technologies.

Partner learning paths specify the training courses that can help you reach particular goals.”

Microsoft Learning Microsoft Training Catalog:http://learning.microsoft.com/Manager/Catalog.aspx.“The Training Catalog is a comprehensive collection of Microsoft Learning resources, including online training, books, classroom training, exams, and more.”

2013 05 13- Webinar on Office training: 5 top courses and tips


What you will learn at Tuesday’s webinar

Top courses for Office 2010 and the new Office 365

What Vickie has learned about giving 1,000 “technology tips and tricks” presentations

Vickie’s tips on Styles, Excel tables and more

References for this webinar

Office.com/training: Courses for Office 2007, Office 2010 and the new Office

Vickie’s company for training and services: Redcape

Sign-up for free tips from Vickie: http://bit.ly/GetTipsVideos

Insert video into your presentation (Office training course)

How to create a basic chart in Excel 2010 (Office training course)

Use e-mail signatures in Outlook 2010 (Office training course)

Create your first Word 2010 document (Office training course)

VLOOKUP: What it is, and when to use it (Office training course)

Create your first Word document (Office training course)

Make the switch to Word 2013 (Office training course)

Office 2013 Preview training content available


23 Aug 2012 11:14 AM

The Office team has created lots of great training content to help users learn about the new features in Office Customer Preview and Office 365.

Content URL

Getting started resources http://office.microsoft.com/en-us/support/getting-started-with-office-2013-FX102809998.aspx

Make the switch to Excel 2013 http://office.microsoft.com/en-us/excel-help/make-the-switch-to-excel-2013-RZ102924304.aspx

Make the switch to OneNote 2013 http://office.microsoft.com/en-us/onenote-help/make-the-switch-to-onenote-2013-RZ102924426.aspx

Make the switch to PowerPoint 2013 http://office.microsoft.com/en-us/powerpoint-help/make-the-switch-to-powerpoint-2013-RZ102925029.aspx

Gesture Reference (for touch devices) http://office.microsoft.com/en-us/support/office-gesture-reference-HA102823845.aspx

For the latest information, see the Office Resource Kit article:

End user training resources for Office 2013 and Office 365

Training for the 2013 applications


15 minute free training webinars

Does Microsoft have FREE training for the NEW Office 365?


MSDN Office 365 Online Training Labs Available, plus many more Office 365 resources


Many links for online training and other information Good resources.

Free Office Training

http://office.microsoft.com/en-us/training/ 15 minute Webinars 2013, 2012, 2007 and 2011 Mac

http://blogs.office.com/b/project/archive/2013/04/18/free-project-2013-quick-start-training-available-on-demand.aspx - Project 2013, 9hr, 13modules

Infinite Training - 700+ short Office Training Videos - 1-10 mins each


Technet End user training resources for Office 2013 and Office 365


This article contains links to end-user training resources. To download a Quick Start Guide, you must have the free Adobe Reader installed. To view a “Make the switch to” video course, you can use the free PowerPoint Viewer.

The following table contains lists of training resources for Office 365 and for all the Office 2013 applications.

End user training resources for Office 2013 and Office 365


Office 365 If your organization signed up for Office 365 and you need to start reading email, sharing documents, and more, see the following resources to get started with Office 365:

Excel 2013 Excel 2013 has a brand-new look and it’s also designed to help you get professional-looking results quickly. To learn about new features in Excel 2013, see the following resources:

Excel 2013 Quick Start Guide

What’s new in Excel 2013

Excel training

Make the switch to Excel 2013

Windows 8 & Office 2013Touch Guide

Users who are new to Office with Windows 8 on a touch screen can learn about touch and gestures in the text version of the Office Touch Guide. ( http://go.microsoft.com/fwlink/p/?LinkId=272428 )

http://office.microsoft.com/en-us/support/office-2010-touch-guide-FX102821959.aspx 30-sec videos

Office 2010

45 Tips using Microsoft Office 2010 w/ Vickie Sokol Evans - 80 min video

https://jb121.infusionsoft.com/app/linkClick/871/ec7b93895cd3c894/51783/18a5910b1ebcfa29 - PDF with 100 tips. The 45 tips in video are a subset

Free Book download, Learn Excell 97-2007 from MrExcel, 926 pg PDF

http://www.mrexcel.com/msft.html -

http://www.mrexcel.com/forum/forum.phpQuestion forum

Here is the TOC from one Excel book. You can use it as a guide for topics / categories you want to create test questions for.

Excel 2010 Custom Training Guide from CustomGuide website

excel-courseware-2010 custom guide example custom course.pdf

Program Fundamentals

Starting Excel 201011

What’s New in Excel 201012

Understanding the Excel Program Screen13

Giving Commands14

Using Command Shortcuts 16

Excel Test For Interview Download

Creating a New Workbook18

Opening a Workbook19

Previewing and Printing a Worksheet20

Saving book21

Closing a Workbook23

Using Help24

Exiting Excel26

Getting Started with Worksheets

Navigating a Worksheet30

Entering Labels and Values 31

Selecting a Cell Range and Entering Data in a Cell Range 32

Overview of Formulas and Values33

Entering Formulas34

Entering Content Automatically36

Editing a Worksheet

Editing Cell Contents40

Copying and Moving Cells41

Controlling How Cells Are Moved or Copied43

Collecting Items to Move or Copy45

Checking Your Spelling46

Inserting Cells, Rows, and Columns48

Deleting Cells, Rows, and Columns49

Using Undo and Redo ..50

Finding and Replacing Content51

Adding Comments to Cells 53

Formatting a Worksheet

Formatting Text58

Formatting Values 59

Adjusting Row Height and Column Width60

Working with Cell Alignment61

Adding Cell Borders and Background Colors62

Copying Formatting64

Applying and Removing Cell Styles65

Creating and Modifying Cell Styles66

Using Document Themes68

Applying Conditional Formatting70

Creating and Managing Conditional Formatting Rules72

Finding and Replacing Formatting74

Creating and Working with Charts

Choosing and Selecting the Source Data80

Choosing the Right Chart81

Inserting a Chart82

Editing. Adding, and Removing Chart Data84

Changing Chart Data86

Changing Chart Layout and Style88

Working with Chart Labels 89

Changing the Chart Gridlines91

Changing the Scale92

Emphasizing Data94

Using Chart Templates96

Changing Chart Type97

Using Sparklines98

Managing Workbooks

Using Workbook102

Selecting and Switching Bet104

Inserting and Deleting Worksheets105

Renaming, Moving, and Copying Worksheets106

Splitting and Freezing a Window108

Creating Headers and Footers110

Hiding Rows, Columns, Works112

Selling the Print Area114

Adjusting Page Margins and Orientation116

Adding Print Titles, Gridlines, and Row and Column117

Adjusting Paper Size and Print Scale 119

Printing a Selection, Multiple Worksheets, and 120

Working with Multiple Workbook Windows121

Creating a Template123

More Functions and Formulas

Formulas with Multiple Operators128

Inserting and Editing a Function129

AutoCalculate and Manual Calculation131

Defining Names133

Using and Managing Defined Names135

Displaying and Tracing Formulas137

Understanding Formula Errors139

Using Logical Functions (IF)141

Using Financial Functions (PMT)142

Using Database Functions (DSUM)143

Using Lookup Functions (VLOOKUP)144

User Defined and Compatibility Functions145

Test Excel File Download

Financial Functions146

Date & Time Functions147

Math & Trig Functions148

Statistical Functions151

Lookup & Reference Functions152

Database Functions153

Text Functions154

Logical Functions 155

Information Functions156

Engineering and Cube Functions157

Working with Data Ranges

Sorting by One Column .161

Sorting by Colors or Icons . 163

Sorting by Multiple Columns .165

Sorting by a Custom List166

Filtering Data168

Creating a Custom AutoFilter169

Using an Advanced Filler170

Working with Tables

Creating a TAble175

Adding and moving Data177

Working With the total Row179

Sorting a table181

Filtering a table183

Removing Duplicate rows of data184

Formatting the Tab185

Using Data Validation187

Summarizing a Table with a Pivot Table189

Converting to a Range190

Working with PivotTables

Creating a PivotTable194

Specifying PivotTable Data 195

Changing a PivotTable’s Calculation196

Filtering and Sorting a PivotTable197

Working with PivotTable Layout198

Grouping PivotTable Items 200

Updating a PivotTable202

Formatting a PivotTable203

Creating a PivotChart204

Using Slicers205

Sharing Slicers Between PivotTables .207

Analyzing Data

Creating Scenarios211

Creating a Scenario Report213

Working with Data Tables214

Using Goal Seek216

Using Solver217

Using Text to Columns219

Grouping and Outlining Data221

Using Subtotals223

Consolidating Data by Position or Category225

Consolidating Data Using Formulas227

Working with the Web and External Data

Inserting a Hyperlink231

Importing Data from an Access Database or Text File232

Importing Data from the Web and Other Sources234

Working with Existing Data Connections236

Working with Macros

Recording a Macro240

Playing and Deleting a Macro242

Adding a Macro to the Quick Access Toolbar243

Editing a Macros Visual Basic Code244

Inserting Cop d Code in a Macro245

Declaring Variables and Adding Remarks to VBA Code 247

Prompting for User Input249

Using The IF … THEN … ELSE Statement250

Customizing Excel

Customizing t254

Customizing the Quick Access Toolbar256

Using and Customizing AutoCorrect 257

Changing Excel’s Default 0ptions259

Creating a Custom AutoFill List260

Creating a Custom Number Format261

http://www.oaltd.co.uk/MVP/Default.htm - Excel MVP Page, a file library where MS Excel MVPs can place example files


http://www.contextures.com/excelfiles.html#FN0022 - Sample Excel Files - Excel Templates - Data Validation, Filters, Conditional Formatting, UserForms, VBA, Add-Ins, External Data, Charts and Graphics, PivotTables, Functions, Scenarios, Comments

http://www.pierrefondes.com/- 100+ example sheets and charts

http://www.ozgrid.com/ - Free excel examples and free training

http://excelunusual.com/archive/category/tutorials/ - as well as tutorials there are many examples for specific areas such as animation, games, aerodynamics, physics, science etc