Excel Pre-Training Assessment

Excel Pre-Training Assessment
Personal Details
Firstname*
Please enter your First Name
Surname*
Please enter your Last Name
Email*
example@example.com
Contact Number

Area CodePhone Number
Location*
If 'Other', please specify*
Your Area (e.g. Durban, PMB)
Has your company requested that you complete this test?*

YesNo
Company Name
(optional if answered 'No' to previous question)
Instructions

For this to be an accurate reflection of your ability, please don’t make any wild guesses; rather just leave out the question. You are also encouraged to use Excel to help verify your answers if need be.

Question numbers marked with a star* are basic formula related questions. These are key in determining your recommended course.

There is no time limit, however, the time taken to complete the Test will be recorded and the Assessment will auto-submit after 3 hours.

You can end the test at any point. Simply scroll down to the end of the last question and click submit.

Click the Button to Start the Test. Enjoy!

Please Note: The relating image is positioned above each question.
1. Which combination of Commands would have been used to format D1?

a) 1 and 3b) 2 and 3c) 1 and 4d) 2 and 4
2. What is the Keyboard Shortcut for clicking this arrow?

a) ctrl + Sb) ctrl + Ac) ctrl + Bd) ctrl + Z

3. Match the click and drag actions of a-d, (as indicated by the red arrows), to the respective outcomes of 1-4.

Rows	Answer
a)
b)
c)
d)

3. Calculation
3. Calculation_Final
4. Which Number Formatting option was used to Format D2?

a) Generalb) Numberc) Accountingd) Currency
5*. Which of the following, when entered in C1, would sum the numbers in A1 and B1?

a) A1+B1b) =A1+B1c) sum(A1,B1)d) Both a and c
6. Which of the 2 following options could you use to prevent Excel from hijacking the leading zero of an entered phone number?

a) Change the Format of column A to Phoneb) Preformat Column A as Textc) Resize the column to the exact width of the numberd) Prefix the Number with an apostrophe (')
6. Calculation
6. Calculation_Final
7. How would you fix the error in cell C5?

a) Increase the height of Row 5b) Widen Column Cc) Correct the Formula to: =SUM(C2:C4)d) Corrent the Formula to: =SUM(C2,C4)
8. The Date 17 April 2020 has been entered 4 times. Select those that have been entered as a genuine date.

a) Ab) Bc) Cd) D
8. Calculation
8. Calculation_Final
9*. The result of the formula in E1 would be?

a) 10b) 6c) 5d) It will throw an Error
10*. What would the value in E1 be if the zero in C1 was Deleted?

a) 3b) 4c) 6d) #VALUE!
11*. If you had to do a standard Copy and Paste of the Formula from C2 to C3 what would be displayed in C3?

a) 18b) 20c) R 18.00d) R 20.00
12. To insert a Column between B and C one would…

a) Left-click on Column B and select Insertb) Left-click on Column C and select Insertc) Right-click on Column B and select Insertd) Right-click on Column C and select Insert
13*. If a New Column was inserted between B and C, what would the Formula change to respectively?

a) =SUM(A1:D1) and =A2+B2+C2b) =SUM(A1:D1) and =A2+B2+C2+D2c) =SUM(A1:D1) and =A2+B2+D2d) They will both stay the same
14. Which Workbook view would enable you to Add or Edit a Header within the Worksheet itself?

a) Normalb) Page Break Previewc) Page Layoutd) Custom View
15. Setting this as indicated will…

a) Repeat content of Rows 1 and 2 at the top of each printed Pageb) Alternate the printing of Rows 1 and 2 at the top of each Pagec) Only print Rows 1 and 2d) Freeze Rows 1 and 2, so that when you scroll they are always visible
16. How would you get to the Dialogue Box shown to change the default decimal symbol used in Excel?

a) Windows > System > Date and Number Formatb) Windows > Control Panel > Region > Additional Settings…c) Excel > File > Options > Advanced > Number Formatd) Excel > Home > Number Format > Custom Format
17. How could you get the value of 5,5 in cell F2 to be included in the Total in F4?

a) Change the decimal symbol from a comma to a point. (i.e. from 5,5 to 5.5)b) Right align cell F2 by clicking on the command that is circledc) Change the Format of cell F2 from General to Numberd) Change the formula in cell F4 to =SUM(F1:F2:F3)
18. If you had to click and drag the Autofill handle down 1 row as shown, what would the resultant Values be in Row 4?

a) 2018-01-01 and 56b) 2018-01-04 and 67c) 2018-01-05 and 76d) 2018-01-03 and 66
19. You Copy and Paste content from Sheet1 to Sheet2 as shown. How do you get the Sheet2 column widths to be exactly the same as Sheet1?

a) Double click between any two columns on Sheet2b) Highlight all columns on Sheet2 and then double click between any two columnsc) Do a second Copy and Paste Special and select Column Widthsd) Arrange the Sheets one underneath the other and select snap-to-grid
20. How could you modify the Formula in cell C4 so that when you replicate it down to C10 it always references cell B1 to calculate the commission for each Rep.

a) =B4*B$1$b) =B4*$B$1c) =B4*B%1%d) =B4*%B%1
21. The Formula in C1 is replicated to C2. What will the resultant values be in C1 and C2 respectively?

a) #ERROR! and #VALUE!b) 31 and Week 4c) 31 and #VALUE!d) #VALUE! and Week 4
22. If you clicked on the command that is circled, which Value would be shown in C2?

a) R 25b) R 11c) R 81d) R 102
23. What will be the result of the Formula in cell C1

a) #NUM!b) 1c) 0d) #N/A
24. What has been used to visually represent the data as shown.

a) Column Chartb) Bar Chartc) Rectangular Shapes with gradient filld) Conditional Formatting
25. What has enabled this Total row with in cell drop-downs of standard aggregations?

a) Converting the Range to a Tableb) The Subtotal command under the Data Ribbonc) A Macrod) The SUBTOTAL Function
26. You create a Formula to calculate the VAT amount and then use Autosum to get the Total VAT as shown. You then use a Calculator to check the Total and get R 40.02. How do you get Excel to calculate the same result as your Calculator?

a) Redo the Autosum. Sometimes Excel gets it wrong the first time.b) Change the Formatting from Currency to Accounting.c) Use the Custom Format option to round the decimal to the nearest cent.d) Use the ROUND function to round each VAT calculation to 2 decimal places.
27. How has this Data been Filtered and Sorted?

a) Filtered by Region and Date and Sorted by Categoryb) Filtered by Region and Date and Sorted by Salesc) Filtered by Region and Sorted by Categoryd) Filtered by Sales and Sorted by Region
28. Clicking on Replace All as shown will affect...

a) No Contentb) Content in Column B onlyc) Content in Column C onlyd) Content in both Column B and C
29. How would you set up your worksheet so that you could toggle between the two views shown?

a) Select Auto Outline under the Grouping Toolb) Hide Columns B-E and then drag the Expand and Colapse option to column Fc) Highlight Column F and select the Expand and Colapse Option under the View Ribbond) Use the the Income & Expenses by Quarters Excel Template
30. How would you get the actual Totals to display on the Bar Chart as Shown?

a) Drag and drop Total Values from the Table to the Chartb) Right click on the Chart and select Show Totalsc) Click on the green plus sign and select the Data Labels Chart Elementd) They are added by default. You just need to resize the Bars to make them visible.
Date

YearMonthDay
DateHourMinutesAM/PM Option
Score
SenderEmail
for email
SenderName
for email
sender e-mail
example@example.com
Should be Empty: