Excel Assessment Test Questions and Answers

By Vadim.MikhailenkoBasic Excel Skills Test, Excel Assessment Test, Excel Interview Questions, Excel Test for Interview Candidates

A Microsoft Excel test is a pre-employment hiring assessment that employers use during the recruitment process to check how proficient candidates are with Microsoft Excel. Spreadsheets allow users to input and analyse data efficiently, and are used in all kinds of office jobs; as such, Microsoft Excel Assessment Tests are becoming increasingly common. In this post we will learn how to get prepared for Microsoft Excel Pre Employment Test by looking at Top 50 Excel Test for Job Interview Questions and Answers. We are also going to look at how companies conduct excel skills test, how employers test for Excel skills, review sample questions asked as part of Excel Portion of Job Interview and look at the resources to get prepared for each test the fastest way possible.

 

Why Employers Test Job Candidates?

Assessing a job candidate’s Microsoft Excel proficiency is an important step in making the right hire. The intermediate Microsoft Excel skills test is helpful in learning if a job candidate understands how to manipulate the many functions, tools, and formulas of Excel to present extensive information, identify key trends, or calculate financial and numerical data.

Microsoft Excel is a complex business application which allows companies to record, track, and analyze data and perform very complex modelling and calculations, essential for measuring company performance, maximizing return on investment, and defining goals. Since Microsoft Excel is used in a lot of organizations, employers would like to make sure that candidates has solid Excel skills and experience using the tool. A new employee who can comfortably navigate is prepared to immediately contribute by producing meaningful, data-driven spreadsheets, reports, and graphs to best serve company needs.

 

How Employers Test for Excel Skills?

There are multiple providers that conduct the tests and each one of the tests is a little different. Most of the time employers use below providers to conduct the tests

  • Indeed.com
  • IKM
  • SkillCheck
  • TotalTesting

Because Microsoft Excel is so popular and useful, companies are trying to evaluate candidates by conducting pre-employment assessment test. An Excel Interview Test is a screening process employers use as part of the candidate employment interview to test a potential candidate on their knowledge and proficiency of Microsoft Excel.

Each employer might use a slightly different variation of the Excel test. The Excel Assessment Test typically broken down into a multiple-choice section and an interactive portion. Some tests are timed but some of them do not have a limit on how long applicant can take to answer the questions, but there might be exceptions.

 

Excel Skill Assessments through questions

There are different types of questions typically being presented during Excel Test :

  • Multiple Choice Questions
  • Multiple Answer Questions
  • True/False Questions

 

Interactive Test Simulators

It is rare that only one type of question is used during the test – most of the time questions are part of the large pool and testing software randomly selects certain number of questions from the pool and presents them to the candidate.

 

Hands-On Excel Skill Assessment

Sometimes companies also conduct hands on Excel Job Interview Test when they provide candidates with sample data file as ask them to perform certain tasks with the data, based on instructions provided.

 

Excel Skills Tested as Part of Test

During Excel Interview employer assesses candidate’s ability to use Microsoft Excel's user interface quickly and efficiently to access the right features and perform simple tasks in the application. It validates fundamental knowledge from determining the best way to open a recently closed Workbook to using the correct formula to perform automatic calculations. Candidates are required to answer true/false,  multiple-choice questions and multiple answer questions, based on Excel spreadsheets, charts and tables filled with sample data

Below is the list of topics candidates are tested for:

  • Follow the correct steps to apply formatting, use formulas or accomplish certain things in spreadsheet
  • Apply styles, use simple fill patterns and apply formatting
  • Identify the proper keyboard shortcuts to accomplish tasks more quickly.
  • Choose the right formula and cell references to automatically calculate values.
  • Perform basic tasks like hiding rows, preventing cell overflow, and pasting data.

Since each question comes with a strict time limit (one minute or less), the test will also measure a candidate’s ability to quickly format, isolate and manipulate data under a significant amount of pressure without any outside help.

 

Hands On Abilities Evaluated

  • Ability to edit Excel worksheets and workbook by identifying common functions, applying basic keyboard shortcuts, and manipulating columns and rows
  • Ability to apply sorting and filtering options as well as statistical functions to explore and summarize values
  • Ability to customize the look and feel of a Excel workbook using cell formatting tools

 

Complexity Levels of Excel Employment Assessment Tests

Microsoft Excel harbor very basic calculations to very advanced data processing and analysis that requires in-depth knowledge of every tools of Excel. Depending on the position candidate is  applying for you are likely to face a pre-employment Excel test with varying level of difficulty. Microsoft Excel Employment Assessment tests can be categorized into at least three levels of difficulty:

  • Microsoft Excel Basics Test: The basic test will evaluate your skills performing basic Excel functions. This can include anything from printing, formatting cells, inserting tables, and so on. If you have used Excel in the past or familiar with other similar applications you should be able to refresh your skills with the quick tutorial, practice sample excel interview questions to pass assessment test. Basic Excel Test for Interview Candidates is a screening process for entry-level or experienced candidates, including administrative assistants, retail store managers, Sales Representatives, Marketing Representatives, Accountants, Entry level Analysts, or any other position that requires using Microsoft Excel.
  • Intermediate Microsoft Excel test: This test requires more than basic knowledge but is not as complex as the advanced level test. The intermediate Microsoft Excel skills test presents candidates with a series of timed questions designed to assess their knowledge of Microsoft Excel. For passing this test, you will need to study and practice in advance using different tools and resources and ideally have practical experience of solving problems with Microsoft Excel. The Intermediate Excel Test is typically offered to evaluate skills of Business Analysts, Project Managers, Architects and other professionals, that may be responsible for complex decision making.
  • Advanced Microsoft Excel test: This test is designed for job that require to use Excel in a more complex manner. The test will evaluate your skills with pivot tables, creating macros, filtering, and functions such as IF, IFS, VLOOKUP, SUMIFS, VBA and other advanced concepts used in Microsoft Excel. An advanced Excel user would need to have advanced formula skills. He would have a skill and confidence to make his own formula to adapt to any situation. Typically, this test is offered to Senior Professionals, Executives, Financial Analysts, Scientists and other professionals that may need to use advanced features of Microsoft Excel.

What Employers are Looking For?

Microsoft Excel is a comprehensive tool that allows businesses to record, track, and analyze data essential for measuring company performance, maximizing return on investment, and defining goals – when used to its fullest potential. A new employee who can comfortably navigate Excel is prepared to immediately contribute by producing meaningful, data-driven spreadsheets, reports, and graphs to best serve company needs.

Assessing a job candidate’s Microsoft Excel proficiency is an important step in making the right hire. The Beginners Microsoft Excel skills test is helpful in learning if a job candidate understands how to manipulate the many functions, tools, and formulas of Excel to present extensive information, identify key trends, or calculate financial and numerical data.

Microsoft Excel assessment test helps predict a job candidate’s ability to:

  • Enter sales figures and properly apply formulas to generate sales totals by date, representative, product or region.
  • Conditionally format cells with the goal of highlighting specific dates, values, or ranges.
  • Create bar graphs and pie charts from large datasets to illustrate critical company data, performance metrics, and outlook.

TIP #1 – What are the Smartest Ways to Prepare for Assessment Test:

  • Use outlines from Test provider (Indeed.com, SkillsCheck, IKM) and review their sample questions
  • Take Online Training Courses, if available
  • Download and read Assessment Test Books and eBooks
  • Download and Use Practice Tests

TIP #2 – What to do during the test:

  • Try to schedule test in the morning, when you have high levels of energy
  • Get a good sleep before the test.
  • Do not take a test if you are tired
  • Read Question carefully (ideally more than once)
  • Answer easy questions first (if you have a choice)
  • This would allow you to leave harder questions for the end, but you will get easy answers in
  • Validate your answer with more than one method (i.e. Common sense, Manual Calculations, Use Calculator etc.)

TIP #3 – How to Pass Assessment Test Today:

  • Be prepared for Assessment Test at Home
    • You might be monitored and timed
  • Anticipate questions based on the job position
  • Research and practice before the test
  • Reflect after the test and take notes
    • Use these notes to get ready for next test
  • Improve your Skills in Between Tests by taking Practice tests and timing yourself

Get Ready For Excel Test for Interview Candidates

Basic Excel Assessment Test Overview

The basic Microsoft Excel skills test challenges a candidate’s ability to navigate the Excel user interface quickly and efficiently in order to access the right features and perform simple tasks – from determining the best way to open a recently closed Workbook to using the correct formula to perform automatic calculations. Candidates will be required to answer multiple-choice questions based on Excel spreadsheets, charts and tables filled with sample data, as well as images of Excel buttons and tools, testing their ability to:

  • Apply simple fill patterns, formatting, and styles to cells.
  • Identify the proper keyboard shortcuts to accomplish tasks more quickly.
  • Follow the correct steps to make one spreadsheet look like another.
  • Choose the right formula and cell references to automatically calculate values.
  • Perform basic tasks like hiding rows, preventing cell overflow, and pasting data.

Since each question comes with a strict time limit (one minute or less), the test will also measure a candidate’s ability to quickly format, isolate and manipulate data under a significant amount of pressure without any outside help.

ABILITIES EVALUATED
Ability to navigate and modify an Excel workbook by identifying common tools, applying basic keyboard shortcuts, and manipulating columns and rows
Ability to apply basic sorting and filtering options as well as statistical functions to explore and summarize values
Ability to customize the look and feel of a workbook using cell formatting tools

 

 

WHY TEST?

Microsoft Excel is a comprehensive tool that allows businesses to record, track, and analyze data essential for measuring company performance, maximizing return on investment, and defining goals – when used to its fullest potential. A new employee who can comfortably navigate Excel is prepared to immediately contribute by producing meaningful, data-driven spreadsheets, reports, and graphs to best serve company needs.

Assessing a job candidate’s Microsoft Excel proficiency is an important step in making the right hire. The intermediate Microsoft Excel skills test is helpful in learning if a job candidate understands how to manipulate the many functions, tools, and formulas of Excel to present extensive information, identify key trends, or calculate financial and numerical data.

The intermediate Microsoft Excel skills test helps predict a job candidate’s ability to:

Enter sales figures and properly apply formulas to generate sales totals by date, representative, product or region.
Conditionally format cells with the goal of highlighting specific dates, values, or ranges.
Create bar graphs and pie charts from large datasets to illustrate critical company data, performance metrics, and outlook.
Use this intermediate Microsoft Excel skills test to quickly and easily automate the screening process for entry-level or experienced candidates, including administrative assistants, retail store managers, sales representatives, accountants, project managers, or any other position that requires using Microsoft Excel.

Practice Excel Assessment Test Questions and Answers

Instructions: For each question below, review the question and try to anticipate what the correct answer is. Once completed, click Show Answer button, to validate if your guess was correct. Review explanations to the questions and repeat the process as many time as necessary for you to learn.

Tip: If you are getting ready for the test sometime soon, for best results, it might be best to go through all the questions multiple times per day, but taking a break in between attempts (i.e. morning, afternoon & evening)

 

Question. Selecting multiple columns, especially if they run into the hundreds, can take a long time if you do this the manual way by using your mouse. What is a shortcut for quickly selecting a range of contiguous columns?
a) Select the first column. Hold down Ctrl and press the right arrow on the keyboard.
b) Select the first column. Hold down Ctrl and drag the mouse cursor towards the right.
c) Select the first column. Hold down Shift and press the right arrow on the keyboard.
d) All of the above options are correct.

Answer: The correct answer is c. Selecting the first column, holding down Shift and pressing the right arrow key will allow you to quickly select columns that are directly adjacent to each other. You can select all the columns up to the end of the worksheet by holding down the Ctrl key and then pressing Shift and the right arrow (Ctrl+Shift+Right Arrow). This is the ideal solution for hiding columns you do not use to make your worksheet appear tidier.

 

Question. Select which of the following lists most accurately represent functions found in the Backstage View in Excel:
a) Save, Page Layout, Document Preview, Print, Recent Workbooks and Review.
b) Save, Save As, Open, Close, Info, Recent Workbooks, Recent Places, New, Print and Options.
c) Save, Save As, Open, Recent Print, Print Preview, Page Layout, Options and Access.
d) None of the above lists are entirely correct.

Answer: The correct answer is b. All the other options above contain items that are not located in the Backstage View.

 

Question. Which of the following functions are you likely to find under the Insert tab on the Ribbon?
a) Insert a page break.
b) Insert a formula.
c) Insert a table.
d) Insert track changes.

Answer: The correct answer is c. Although the other functions (i.e. Insert a page break, insert a formula or insert track changes) are also elements you might be inserting into a spreadsheet, they are not under the Insert Tab.

 

Question. The Recent Workbooks list located in the Backstage View shows all workbooks recently opened. What action can I take to ensure a workbook remains on this list regardless of how many workbooks I opened subsequent to opening this workbook?
a) I can save the Workbook to the Recent Workbooks folder.
b) By adding the Workbook to My Favorites on the Quick Access Toolbar.
c) The Recent Workbooks list automatically keeps all workbooks that have been opened and I do not need to do anything.
d) By 'pinning' the workbook to the Recent Workbooks list by clicking the pin icon located next to it.

Answer: The correct answer is d. After pinning a workbook to the list the only way to remove it is to click the pin again.

 

Question. What is the keyboard shortcut to select a row of active cells?

a) Ctrl + Spacebar
b) Shift + Spacebar
c) Shift + End
d) Ctrl + End?

Answer: The correct answer is b. Holding down the Shift key while pressing Spacebar will select the entire row in which the cursor is currently positioned in Microsoft Excel.

 

Question. Most workbooks in Excel contain multiple worksheets (noted on the tabs at the bottom right-hand side of the Excel screen). Which of the following is the keyboard shortcut to for switching between worksheets in Microsoft Excel?
a) Alt+Tab
b) Alt+PgDn/PgDn
c) Ctrl+PgDn/PgUp
d) Ctrl+UpArrow/DownArrow

Answer: The correct answer is c. You can use either Ctrl+PgDn or Ctrl+PgUp to switch between the available worksheets in a workbook. Press this shortcut repeatedly to navigate through the available worksheets.

 

Question. Most workbooks in Excel contain multiple worksheets (noted on the tabs at the bottom right-hand side of the Excel screen). Which of the following is the keyboard shortcut to for switching between worksheets in Microsoft Excel?
a) Alt+Tab
b) Alt+PgDn/PgDn
c) Ctrl+PgDn/PgUp
d) Ctrl+UpArrow/DownArrow

Answer: The correct answer is c. You can use either Ctrl+PgDn or Ctrl+PgUp to switch between the available worksheets in a workbook. Press this shortcut repeatedly to navigate through the available worksheets.

 

Question. Jason has a workbook open that his colleague created. The workbook is titled: "Management Budget". John wants to use this workbook as a base for creating a workbook called "Project Management". Which of the following is the correct sequence of actions for him to take?
a) File Tab – Save – File Name – "Project Management" – Save.
b) File Tab – Save As – File Name – "Project Management" – Save.
c) File Tab – Open – File Name – "Project Management" – Open.
d) File Tab – Save As – File Name – "Management Budget" – Save as Type – "Project Management".

Answer: The correct answer is b. This will save a duplicate of the workbook with the name "Project Management".

 

Question. What happens when you select cells and press Ctrl+2?
a) Text in the selected cells are underlined.
b) Italic formatting is applied to the text in the selected cells.
c) Bold formatting is applied to the text in the selected cells.
d) A duplicate of the selected cells will be inserted directly below the selection.

Answer: The correct answer is c. Using Ctrl+2 you can quickly apply bold formatting to a selected cell, row or column. Another alternative to make selection bold is to use the more traditional Office shortcut of Ctrl+B to achieve the same result.

 

Question. The following shortcut key combinations will allow you to Open, Close and create a New workbook, respectively:
a) Pressing Alt + O to Open, Alt + C to Close, Alt + N for New.
b) Pressing Control + O for Open, Control + C for Close, Control + N for New.
c) Pressing Control + O for Open, Control + W for Close, Control + N for New.
d) None of the above options are correct.

Answer: The correct answer is c. Holding down the control key on your keyboard whilst pressing O, W or N respectively will allow you to quickly access the Open dialogue box, close an open workbook and create a New blank workbook.

 

Question. What is the keyboard shortcut for reversing (undoing) your last action?
a) Ctrl+U
b) Ctrl+Z
c) Ctrl+X
d) Ctrl+Y

Answer: The correct answer is b. Holding down the Ctrl key on your keyboard and pressing the Z key at the same time will undo the last action you performed in the selected workbook. Holding down Ctrl and pressing Z repeatedly will undo multiple actions that have been performed.

 

Question. Mikhala made some changes to a workbook called "Sept 2014". She then clicked Save As, typed "Sept_2014_New" in the File Name box and clicked Save. Which of the following statements are true?
a) The changes Lucy made to "Sept 2014" will be reflected in the new workbook, "Sept_2019_New" only.
b) The changes Lucy made will be reflected in both versions, "Sept 2014" and "Sept_2019_New".
c) By using the Save As function Lucy replaced the file "Sept 2014" with "Sept_2019_New". The original file no longer exists.
d) The changes Lucy made will stay in "Sept 2014" and will not be reflected in "Sept_2019_New".

Answer: The correct answer is a. When you click Save As, Excel assumes you want to save all the changes you made to a new workbook. Unless you clicked save in the existing workbook, none of the changes you made will be saved in the original.

 

 

Question. Which of the following functions is NOT associated with the Review Tab on the Ribbon?
a) The spelling checker.
b) The sort data function.
c) The comment function.
d) The track changes function.

Answer: The correct answer is b. The sort function is associated with the Data tab on the Ribbon and not with the Review Tab.

 

Question. Allen is using a colleague's PC. He is curious as to how much his colleague earns and when he sees a folder with the title "Budget", he decides to snoop. He opens the folder and views a few of the workbooks in this folder. Will his colleague be able to know he snooped, and if yes, how?
a) No, Ben is safe. Unless his colleague is an IT specialist, he will never find out.
b) Yes, if his colleague presses the Data tab on the Ribbon, this will reveal a list of recently displayed documents.
c) No, Excel automatically deletes recently access workbook and file history if you close and shutdown the PC.
d) Yes, if his colleague opens the Backstage View and go to the Recent Workbooks and Recent Places area.

Answer: The correct answer is d. Unless his colleague first opens and works on a number of other workbooks / folders that will push the files Ben viewed out of the list, his colleague could easily see which workbooks and even which files Ben had viewed.

 

Question. Which shortcut key combination can be used to insert the current date into a cell?
a) Ctrl+D
b) Ctrl+Shift+; (Control+Shift+semicolon)
c) Ctrl+; (Control+semicolon)
d) Ctrl+Shift+D

Answer: The correct answer is c. Holding Ctrl key and pressing ; (semicolon) key at the same time inserts current date into the spreadsheet. This is a great shortcut for timesheets that require a user to insert the date into a sheet on a continual basis. The formatting of the date, for example 01/01/2015 or 1 January 2015, will depend on the formatting applied to the cell in which the date is inserted.

 

Question. What happens when you press the shortcut combination Ctrl+i while you have cells, containing content such as text or numbers, selected?
a) This italicizes the selected content.
b) This launches the Excel Information and Help dialogue box.
c) This inserts a new row or column depending on the selection.
d) This hides the selected cell range.

Answer: The correct answer is a. Pressing Ctrl+i makes selection italic. You can also use the shortcut Ctrl+3 to achieve the same result.

 

Question. A client emails you and informs you that they were unable to open a workbook you sent them as they still use MS Excel 2010. Which of the following options will quickly resolve this issue and allow the client to open the workbook?
a) They will need to install MS Excel 2010 or use someone else's software in order to open the workbook.
b) You can use the Save As function to select a Save As Type: Excel 2010 Workbook.
c) If you open the workbook, you can go to the client and copy and paste all the content into their version of Excel.
d) If you rename your workbook: "Excel 2003", this will allow the client to open the file.

Answer: The correct answer is b.

 

Question. What is the shortcut key to save a workbook?
a) Ctrl+Enter
b) Ctrl+Shift+S
c) Alt+S
d) Ctrl+S

Answer: The correct answer is d. Clicking Ctrl+S saves active document in Microsoft Excel. You can quickly and continually save a worksheet whilst working, without lifting your fingers from the keys on your keyboard, by using this shortcut to save.

 

Question. Which of the following statements about the Print Preview is true?
a) It allows you to view what your document will look like before you physically print the pages.
b) You access the Print Preview area of the by pressing: Control + P.
c) You access the Print Preview area by clicking on the File button to go to the and then on the Print button.
d) All of the above statements are correct.

Answer: The correct answer is d.

 

Question. What is the difference between Excel for desktop and Excel 365?

Answer: Office 2016 for Desktop is the newest version of the Office productivity suite (Word, Excel, PowerPoint and other application), typically accessed via the desktop. Office 365 is a cloud-based subscription to a suite of programs including Office 2016. Office files can be accessed in the browser and on Mobile devices, which allows you more flexibility.

You can also download and install Office 2016, including Excel 365 on your desktop as part of Office 365 subscription. Full desktop versions of Office (Word, PowerPoint, Excel plus OneNote and Publisher) is included with license for up to 5 computers per user.

 

Question. What are the most typically used functions in Microsoft Excel?

Answer: This is an open ended question, which shows personal preferences and might trigger different answers from candidates with different level of experience. One of the most useful Excel functions is SUM, which allows you to quickly to sum a range of cells by using AutoSum button. It automatically enters a SUM function in the selected cell. The SUM function totals one or more numbers in a range of cells.

Other useful Excel functions that are very commonly used are are AVERAGE, MAX and MIN.

 

Question. What is a function in Microsoft Excel?

Answer: Functions are predefined formulas and are already available in Excel. Formulas in Excel are useful to perform various mathematical, statistical, and logical operations. You can type in a formula (though you have to be sure it's exactly right) or you can use Excel's preset formulas called functions.

If you type in the formula, you must start with an equal sign, so Excel knows that the data in the cell is a formula. After the =, what comes next depends on what you’re trying to do. Excel offers you some suggestions and shows the syntax for the given function. Excel also corrects you and provides suggestions if you have made a mistake, whily typing.

 

Question. What is the order of operations used when evaluating formulas in Excel?

Answer: Excel uses an order of operations when evaluating different operators within the formula, using below sequence:

  • Parentheses
  • Exponents
  • Multiplication
  • Division
  • Addition
  • Subtraction

You can easily remember the sequence as PEMDAS, based on the first letters of above listed operations, and this would allow you to quickly bring it up and shine during the interview: when evaluating formulas, Excel always processes operators in this order. If you find yourself receiving an unexpected result from your mathematical formulas, double-check to make sure that parentheses are used properly to achieve the results you want.

 

Question. What are the most important data types in Excel, and how are they used?

Answer: It is hard to pinpoint most important data types, but most typically used Excel data types are Number, Percentage, Date and Text:

Excel Typical Data Types (Number, Text, Percentage and Date)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

How to get prepared for Excel Assessment Test & Interview

Learn Excel in 25 Simple Steps

When applying for the job that requires Microsoft Excel Basic Skills, candidates will be tested to demonstrate their knowledge of the product. Employers would like to test candidates to understand their knowledge and experience with the Microsoft Excel. To do that, they present candidate with the test, typically a simulator test where people are being asked to complete certain activities based on the conditions and criteria that are given. Below Excel Tutorial helps candidate learn Excel quickly or refresh their knowledge.

Following Excel topics are covered in the tutorial:

 

Please take a look at below image, which shows source data we will be using in this tutorial (You can download source XLSX file here to follow along). The data in this table has a title which is product sales data and then it has a header which represents a lot of different columns. So we have a product information, we have units sold, manufacturing price, sales price, gross sales, manufacturing cost and profit.

You also see that the data doesn't have any borders and the reason for that is because one of the activities is to create borders around this table as you typically do in Microsoft Excel so the data would look similar to this table.

We will be to completing 25 activities; which are represented as the steps 1 through 25.

get ready for excel interview

Excel Tutorial - Learn or Refresh Excel Skills in 25 simple steps

Expand Columns B and C to Fit the Content

Expand Columns B and C to Fit the Content

  • Put the cursor on the line between Column B and C
  • Expand or Double-Click on the line

Change Font Style in the Row 3

Expand Columns in excel

  • Highlight the information between cells B3 and H3
  • Click Cell Styles tab to pick a style

Change Font Size in the Header To 12

Change Font Size in the Header in excel

  • Highlight the information between cells B3 and H3
  • Click Increase Font Size button

In other way,

Change Font Size in the Header in excel

  • Highlight the information between Cells B3 and H3
  • Right-Mouse-Click on the selected Cells
  • Click Increase Font Size button

Format Price And Sales Columns As Currency

Format Price And Sales Columns As Currency

  • Highlight data in Column D to F
  • Select the currency sign

Calculate Manufacturing Costs (Units Sold * Manufacturing Price)

Calculate Manufacturing Costs (Units Sold * Manufacturing Price)

  • Type = in Cell G4
  • Select Cell C4
  • Type *
  • Select Cell D4
  • Hit Enter
  • Select Cell G4 and drag downward

Calculate Profit (Gross Sales - Manufacturing Costs)

Calculate Profit (Gross Sales - Manufacturing Costs)

  • Type = in Cell H4
  • Select Cell F4
  • Type -
  • Select Cell G4
  • Hit Enter
  • Select Cell H4 and drag downward

Calculate Profit (Gross Sales - Manufacturing Costs)

NB: The values in Parenthesis are negative

Save File with Different File Name

Save File with Different File Name

  • Click on the file tab
  • Click on Save As
  • Type the name of the file
  • Click Save

Center Data in Rows D through G

Center Data In Rows excel

  • Highlight Rows D through G
  • Click Center button

Change Color For The Header Row

Change Color For The Header Row in excel

  • Highlight the header
  • Select Fill Color
  • Select a preferred color

Add Borders to the Table

Add Borders to the Table in excel

  • Highlight the table
  • Click borders tab
  • Select All Borders

Make Text in Header Row Bold

Make Text in Header Row Bold in excel

  • Highlight the header row
  • Select bold button in the font group

In other way;

Make Text in Header Row Bold in excel

  • Right Mouse Click on the highlighted
  • Select bold button

Insert Clustered Column Chart to Show Unit Salt Per Product

Insert Clustered Column Chart excel

  • Select columns B and C
  • Click on recommended charts
  • Select the first recommended chart which is the clustered column chart
  • Click OK

Change Charts Title to Product Sales

Change Charts Title excel

  • Click on the Title
  • Double-Click on the Title
  • Erase Unit Sales
  • Type Product Sales
  • Click anywhere outside the chart

Change Chart Type to Bar Chart

Change Chart Type

  • Select the Chart
  • Go To Chart Design Tab which shows up as soon as you select the chart itself
  • Click on Change Chart Type

Change Chart Type excel

  • Select Bar Chart
  • Click OK

Change Chart Styles

Change Chart Styles

  • Select the Chart
  • Click Chart Design
  • Select a preferred Chart Style

Wrap Text in Cell D3

Wrap Text in Cell D3

  • Select the text
  • Click Wrap Text

Duplicate Current Worksheet into a New One

Duplicate Current Worksheet into a New One

  • Right-Click on the sheet
  • Select Move Or Copy

Duplicate Current Worksheet into a New One excel

  • Select the sheet itself
  • Click Create a Copy
  • Click OK

Merge and Center “Product Sales” Title

Merge and Center title in excel

  • Select all the values in the Range B2 through H2
  • Click Merge And Center button

Sort Data Descending Based On Units Sold

Sort Data Descending Based On Units Sold

  • Select the entire Table
  • Select Sort And Filter
  • Select Custom Sort

Sort Data Descending Based On Units Sold excel

  • Select Units Sold as Sort By criteria
  • Select Largest to Smallest as order
  • Click OK

Select Print Area to Print Only Data Table

Select Print Area to Print Only Data Table

  • Highlight and Select the data
  • Go To Page Layout
  • Select Print Area
  • Select Set Print Area

Change Page Orientation to Landscape

Change Page Orientation to Landscape

  • Go To Page Layout
  • Select Orientation
  • Select Landscape

Run Spell Check

Run Spell Check in excel

  • Click On Review Tab
  • Click On Spelling
  • Follow the prompts

Set Narrow Margins

Set Narrow Margins in excel

  • Go To Page Layout
  • Click on Margins
  • Select Narrow

Print Worksheet to Fit One Page

Print worksheet fits one page by default because the orientation is changed to landscape

Save Excel Document as PDF File

Save Excel Document as PDF File

  • Go To File Tab
  • Click Save As

Save Excel Document as PDF File

  • Select PDF
  • Click Save

About the Author

Vadim Mikhailenko, MBA

Vadim lives in Milwaukee, Wisconsin and works as an Information Technology Consultant, Coach and Educator. Vadim is very passionate about Milwaukee community and teaches classes to underprivileged students at local community college to help them get employed. Throughout his consulting career Vadim studied a lot of tools and technologies and learned hiring process by helping organizations to hire candidates and also supported students to get prepared and to pass interview and assessment tests.

Vadim loves to share his knowledge with and enjoys teaching  new skills to help you get hired for your dream job.

Next Step: Download PDF EBook

Top 50 Excel Assessment Test Questions and Answers

Top 50 Excel Assessment Test Questions and Answers PDF EBook teaches you everything you need to get ready for Basic and Intermediate Microsoft Excel Interview and prepare for Excel Assessment Test. You will practice most frequently asked questions on the exam and will learn what to do when you arrive at the exam testing center,  how to manage your time when taking the exam, tips to manage your time during assessment test, tricks for answer questions in different formats and much much more.

 

Download NOW!

Download Top 50 Excel Assessment Test Multiple Choice Questions with Answers by clicking the button below to get read for the Interview and get hired for your Dream Job!

Regular Price: $69.00

Limited Time SALE - $17.00 US

Customers Also Purchased

Excel Assessment Test

(Single Test Prep)

 

Top 50 Microsoft Excel Assessment Test questions with Answers and Explanations. Items Included (Instant PDF Download):

Excel Practice Test PDF: $17.00

Regular Price: $69.95

Limited Time SALE: $17.00

 

Microsoft Office Value Bundle
(Most Popular)

 

Everything you need to prepare for the most common Employment Assessment Test. Items Included (Instant PDF Download):

Excel Practice Test PDF : $17.00
Word Practice Test PDF: $17.00
PowerPoint Practice Test PDF: $17.00

Regular Price: $209.85

Value Bundle SALE:
Only $37.00

Assessment Test Super Value Preparation Pack
(Best Value)

 

Comprehensive Preparation Pack to get you Prepared for variety of Assessment Tests. Items Included (Instant PDF Download):

Excel Practice Test PDF:  $17.00
Microsoft Word Test PDF: $17.00
PowerPoint Practice Test PDF:  $17.00
LinkedIn Excel Quiz PDF:  $17.00
Aptitude Practice Test PDF: $17.00
IQ Practice Test PDF: $17.00

Regular Price: $349.75

Super Value Pack SALE:
Only $57.00