Use Our Free Kenexa Excel Test Questions

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).

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).

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).

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).

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).

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).

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).