You are logged in as customer LOG OUT

 

Free Kenexa Sample Questions

Below is a selection of sample questions similar to the Kenexa questions you might face on your Kenexa test. To get a real full preparation for the Excel Exam, simply click Get The Full Preparation Pack below. 

 Practice Test Questions

Before proceeding to the questions, copy the table below to a new Excel spreadsheet. Validate that the cell marked with (A1) is located in cell A1 on the spreadsheet. Once the table has been copied, continue to the questions.

Employee (A1) ID Position Referance Seniority Salary
(th. USD)
Michael 201693 HR Michael 201693 10 69
Amber 225845 Salesperson   8 60
Jenna 195455 HR   16 60
Jeremy 114114 Tech   17 75
Lindsay 245451 Manager   25 80

Basic Level Questions

  1. Set the Text Alignment to "Right".
  2. Insert a new row between "Michael" and "Amber".
  3. Set the Page Orientation to "Narrow".

Intermediate-Advanced Level Questions

  1. Highlight every cell under "Salary" higher than 70 (th. $).
  2. Under “Reference”, in cell D4, combine “Employee” and “ID” (like in cell D3) using a function.
  3. Create a PivotTable for "Salary" per "Seniority".

Multiple Choice Test Questions

Submit your answers to the questions below and fill the consequent form. A PDF file with answers and explanation for all questions will be sent to the email provided by you.

 Click below for the 2016 Kenexa Prove It Microsoft Office Test Excel test to get a real full preparation for the Excel exam.

 

 IBM, Kenexa, Kenexa Prove It and other trademarks are the property of their respective trademark holders. None of the trademark holders are affiliated with JobTestPrep or this website.

Not what you were looking for?
?