You are logged in as customer LOG OUT

Kenexa Prove It Excel Test Preparation Example

JobTestPrep offers the most complete and thorough Excel preparation online. The preparation is on your own PC, working on your Microsoft Excel software, whether the edition is 2010, 2013, 2016, or even 2019.

Here is an example of how the software looks like:

Kenexa Excel Test Practice Example


IBM Kenexa Excel Assessment 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.

Maker (A1) Type Class Full Model Name Year Annual Sales (mil.)
Missam SLX Business Missam SLX 2014 55
Dubaru Double Van   2015 60
Tia Jet Van   2013 76
ZMV Cruise Compact   2016 75
Fonda Life Compact   2015 60

Basic Level Questions

  1. Set the Text Alignment to "Right".
  2. Insert a new row between "Missam" and "Dubaru".
  3. Change the Page Orientation to Landscape.

1. Align the Text to the right.

a) Click on cell A1 (1), hold down shift and click on cell F6 to select the entire table (2).

b) Under Home tab, click on the “Align Text Right” button (3).

 Kenexa Excel Test Answer 1

 

2. Insert a new row between Missam and Dubaru.

a) Select the row above where you want to insert the row, by clicking on the number of the row. In this case, row 3, Dubaru (1).

b) Under Home tab, under Cells group, click on Insert (2).

c) In the opened menu click on Insert Cells (3).

Kenexa Excel Test Answer 2

 

3. Change the Page Orientation to Landscape.

a) Click on the Page Layout tab (1).

b) Under Page Setup group, click on Orientation (2).

c) In the opened menu, click on Landscape (3).

Kenexa Excel Test Answer 3

Intermediate-Advanced Level Questions

  1. Highlight every cell with Annual Sales over 70 (mil. $).
  2. Under “Full Model Name”, combine “Maker” and “Type” (like in cell D3) using a function.
  3. Create a PivotTable for Annual Sales per Year.

1. Highlight every cell with Annual Sales over 70 (mil. $).

a) Click on cell F2, hold down Shift and click on cell F6 to select all cells under Sales (1 & 2).

b) In Home tab under Styles group, Click on Conditional Formatting (3).

c) In the opened menu, move the mouse cursor over Highlight Cells Rules and click on Greater Than… (4 & 5)

d) In the opened dialog box enter 70 under Format cells that are Greater Than: (6)

e) Click OK (7).

Kenexa Excel Test Answer 4

2. Under “Full Model Name”, in cell D3, write a function that combines the “Maker” and the “Type” (like in cell D2).

a) Click on cell D3 (1).

b) In the Formula Bar write: =CONCATENATE(A3,” “,B3). Notice the space added in the formula between the two cells (2).

c) Click Enter (3).

Kenexa Excel Test Answer 5

3. Create a PivotTable for Annual Sales per Year.

a) Click on cell A1. Hold shift and click on Cell F6 to select the entire table (1+2).

b) In Insert tab, under Tables Group, click on PivotTable (3).

c) In the open dialog box don’t change anything, and click OK. A new SpreadSheet will be opened (4).

Kenexa Excel Test Answer 6

d) Under PivotTable Field list click and drag ‘Year’ to Row Labels (5). Drag ‘Annual Sales’ to Values (6).

e) Under Values click on the newly appeared entry. In the opened menu click on Value Field Settings… (7)

f) In the opened dialog box click on Sum (8) and then click OK (9).

Kenexa Excel Test Answer 7

 

Multiple Choice Excel 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.

Basic Level Excel Questions

1. How would you select non-contiguous cells?





 

2. Which of the following commands doesn't affect the text font?





 

3. How should the following formula be written: Multiply Cell A1 by 6, and divide that by 4?





 
 

Intermediate Level Questions

4. Fill Handle will generate content based on the following: 





 

5. The “Save As” command will NOT allow you to… 





 

6. The Conditional Formatting feature is used to: 





 

Excel Assessment Test Tips

 

Improve Your Hiring Chances by 73%

Get Our Full-Length Excel Practice Tests

 

IBM, Kenexa, Prove It, Microsoft, Excel, 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?
?
Need Help question mark
minimize close
Need Help question mark
Please fill out the form below and we will contact you soon.
Your message was sent. We will contact you shortly.
There was a problem sending your message. Please try again in a few minutes.