Free Kenexa Prove It! Excel Style Sample Questions Answers

3y ago
65 Views
2 Downloads
630.87 KB
10 Pages
Last View : 18d ago
Last Download : 4m ago
Upload by : Grady Mosby
Transcription

Answers to Kenexa Prove It! Style Excel Sample QuestionsHere are the answers to the free sample questions appearing on this page. The data and the phrasing might bedifferent from the questions appearing on the sample questions page, but the principles are the same.Please note that every question might have several ways to solving them. In this guide only one of theseways will be demonstrated. For more information and practice questions we recommend you check out ourProve It! Excel Normal User (hold Ctrl and click on the link in blue to access it) preparation packs or ourPower User packs.In the first part – Questions in the Style of the Interactive Test, the questions appear in black while the answers belowthem appear in red. Each explanation is accompanied by screenshots indicating where and how the commandsshould be performed. Within the explanations you will find numbers in brackets, these correspond to numbers in thescreenshots indicating where each part of the explanation should be done in Excel.Good luck!JobTestPrep is all about preparing people for their future tests. Ever since 1992, thousands of jobseekers and future students who have set goals to themselves, achieved them successfully withour professional practice tools.JobTestPrepCopyright: https://www.jobtestprep.com

Questions in the style of the Interactive 01675.00FondaLifeCompact201560.00Basic Level Questions:1. Align the Text to the right.a) Click on cell A1 (1), hold down shift and click on cell F7 to select the entire table (2).b) Under Home tab, click on the “Align Text Right” button (3).Copyright: https://www.jobtestprep.com

2. Insert a new row between Missam and Dubaru.a)Click on the number of the row that above it you want to insert the new row (1).b) Under Home tab, under Cells group, click on Insert (2).c) In the opened menu click on Insert Cells (3).Copyright: https://www.jobtestprep.com

3. Change the Page Orientation to Landsacpe.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).Copyright: https://www.jobtestprep.com

Intermediate-Advanced Level Questions:1. Highlight every cell with Annual Sales over 70 (mil. ).a) Click on cell F3, hold down Shift and click on cell F7 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).Copyright: https://www.jobtestprep.com

2. Under “Full Model Name”, in cell D4, write a function that combines the “Maker” and the “Type” (like in cellD3).1) Click on cell D4 (1).2) In the Formula Bar write: CONCATENATE(A4,” “,B4). Notice the space added in the formula betweenthe two cells (2).3) Click Enter (3).Copyright: https://www.jobtestprep.com

3. Create a PivotTable for Annual Sales per Year.1) Click on cell A1. Hold shift and click on Cell F7 to select the entire table (1 2).2) In Insert tab, under Tables Group, click on PivotTable (3).3) In the opend dialog box don’t change anything, and click OK. A new SpreadSheet will be opened (4).Copyright: https://www.jobtestprep.com

4) Under PivotTable Field list click and drag ‘Year’ to Row Labels (5). Drag ‘Annual Sales’ to Values (6).5) Under Values click on the newly appeared entry. In the opened menu click on Value Field Settings (7)6) In the opened dialog box click on Sum (8) and then click OK (9).Copyright: https://www.jobtestprep.com

Questions in the style of the Multiple Choice Questions TestBasic Level Questions:I)How would you select non-contiguous cells?a. Hold Ctrl left-click on each cellb. Hold Shift left-click on each cellc. Right-click on each celld. Hold Alt left-click on each cellII)Which of the following commands doesn't affect the text font?a. Boldb. Underlinec. Bordersd. ItalicsIII)How should the following formula be written: Multiply Cell A1 by 6, and divide that by 4?a. A1X6/4b. A1X6%4c. A1*6/4d. A1*6%4Intermediate-Advanced Level Questions:I)Fill Handle will generate content based on the following:a. Mathematical Seriesb. Alignment Patternc. Design Patternd. All of the AboveCopyright: https://www.jobtestprep.com

II)The “Save As” command will NOT allow you to a. Save as a PDFb. Save as a templatec. Save as a Word documentd. Save at a specific locationIII)The Conditional Formatting feature is used to:a. Set the default cell formatb. Format conditional statementsc. Format cells conditional on the text sized. Change the style of cells meeting a conditionCopyright: https://www.jobtestprep.com

Answers to Kenexa Prove It! Style Excel Sample Questions Here are the answers to the free sample questions appearing on this page. The data and the phrasing might be different from the questions appearing on the sample questions page, but the principles are the same. Please note that every question might have several ways to solving them.

Related Documents:

Excel 5.0 Excel 5.0 1993 Excel 5.0 1993 Excel 7.0 Excel 95 1995 Excel 8.0 Excel 97 1997 Excel 98 1998 Excel 9.0 Excel 2000 1999 Excel 2001 2000 Excel 10.0 Excel XP 2001 Excel v.X 2001 Excel 11.0 Excel 2003 2003 Excel 2004 2004 2.1.2 Worksheet Document Definition: Worksheet Document A worksheet document consists of a single sheet only.

4 IBM Kenexa BrassRing on Cloud: IBM Kenexa BrassRing on Cloud Release Notes July 2016. v Recr uiter hovers over the icon and views hover text. v Recr uiter then selects the multipr ofile icon. v A dialog opens that displays the candidate's other T alent Recor d pr ofiles.

As notified to all IBM Kenexa BrassRing clients in October 2017, IBM Kenexa discontinued support of IBM Kenexa BrassRing on Cloud Classic Talent Gateways and classic apply process on December 31st, 2017. Ending Support for Classic Talent Gateways Competition for top candidates is fierce and research has shown that employees designated as

8. the salary policy of the employer as to all employees . – Kenexa CompAnalyst Executive, Kenexa, Inc., www.kenexa.com. Willamette Management Associates 22 . Academic Practice Compensation and Production Survey for Faculty and Management, Medical Group

8. the salary policy of the employer as to all employees . Kenexa CompAnalyst Executive, Kenexa, Inc., www.kenexa.com. #aicpafvc . Academic Practice Compensation and Production Survey for Faculty and Management, Medical Group Management As

2 IBM Kenexa BrassRing on Cloud: IBM Kenexa BrassRing on Cloud Release Document January 2019. v Candidates can access their submitted applications acr oss all T alent Gateways of a client. (Curr ently in Staging envir onment only) v New city (Hong Kong) added to a location in Hong Kong country .

2 IBM Kenexa BrassRing on Cloud: IBM Kenexa BrassRing on Cloud and Lead Manager Release Document. in standalone BrassRing or via the "Enhanced Experience" option in Talent Suite. While the default settings for user types update to the new UI in May (staging) and August (production), the toggle .

Alfredo Chavero (1981) concluye que los anteojos no son otra cosa que ex-presiones de las nubes y en cuanto a los colmillos, . lo señala Alfredo López Austin (1990): .como creador, Tláloc lo fue de la luna, del agua y de la lluvia y fue también uno de los cuatro soles cosmogónicos que precedieron al actual. Además de esto, reinaba en su propio paraí-so, el Tlalocan, que se .