FINTECH ROLE APTITUDE TEST
Please enter your full name:
*
First Name
Last Name
Please enter your active email address
*
example@example.com
Back
Next
BASIC EXCEL SECTION
1. Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,2,FALSE) return?
*
The price for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.
The price for the product in column A if the exact product number corresponding to A25 can be found, or the price for the closest product if the exact product number can't be found
The number for the product in column A if the exact product number corresponding to A25 can be found, or #N/A if not.
Don’t know
2. Suppose cells A2:B20 contain a table with product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,1,FALSE) return?
*
The price for the product found in column A (or #N/A if the exact product number can't be found).
The price for the product found in column A (or the closest product if the exact product number can't be found).
The number for the product in column A (or #N/A if the exact product number can't be found).
I don`t know
3. Suppose cells A2:B20 contain a table with sorted product numbers in column A and product prices in column B. What does the formula =VLOOKUP(A25,A2:B20,2) return?
*
The price for the product found in column A (or #N/A if the exact product number can't be found)
The product number for the product in column A (or the closest product if the exact product number can't be found)
The price for the product found in column A (or the closest product if the exact product number can't be found)
Both 1 and 3
None of the Above
4. In the Image below, which of the following VLOOKUP formulas returns the 66 score by Mulenga in a Physics test?
*
=VLOOKUP(G4,A3:E10,MATCH(G4,A2:E2,0),0)
=VLOOKUP(G4,A3:E10,MATCH(H3,A2:E2,0),0)
=VLOOKUP(G2,A3:E10,MATCH(H3,A2:E2,0),0)
None of the above
5. In the image below, using a Vlookup, write the formula that calculates the score for Raymond in a Biology test.
*
6. During a Mock Exam, Mosho scored a 99. Which of the formulas below is correct?
*
=VLOOKUP(H2,CHOOSE(IF(G4 = "Unit Test",1,IF(H2="Mock Exam",2,3)),A3:E9,A13:E19,A23:E29),MATCH(H3,A2:E2,0),0)
=VLOOKUP(G4,CHOOSE(IF(G4 = "Unit Test",1,IF(H2="Mock Exam",2,3)),A3:E9,A13:E19,A23:E29),MATCH(H3,A2:E2,0),0)
=VLOOKUP(G4,CHOOSE(IF(H2 = "Unit Test",1,IF(H2="Mock Exam",2,3)),A3:E9,A13:E19,A23:E29),MATCH(H3,A2:E2,0),0)
None of the above
7. What characteristics are required in the source data to create a Pivot Table? Check the image below.
*
A list or table with values in it
A contiguous data range with headers
The data is housed in an Excel table or covered by a named range
None of the above
8. How do you remove an item from a Pivot Table?
*
Delete it from the source data, and then refresh the Pivot Table
Drag it back from the Pivot fields into the field well
Both 1 and 2
None of the above
9. Suppose you change something in your Pivot Table's source data. What are the implications?
*
You must manually refresh your Pivot Table in order to see the change show up there
The Pivot Table will update automatically
You must close your workbook and re-open it to get the Pivot Table to update
None of the above
10. If you wanted to look in a range and find the text 'peaches', then look in the range adjacent and total only the values where there is a match to peaches, what would be the formula?
*
=SUM(A1:A10,'peaches',B1:B10)
=SUMIF(A1:A10,peaches,B1:B10)
=SUMIF(A1:A10 & peaches & B1:B10)
=SUMIF(A1:A10,''peaches'',B1:B10)
11. Which formula would you use to capture the first 4 characters of the data string located in B4?
*
=Left(B4,4,4)
=Right(B4,4)
=Left(B4,4)
=Left(4,0,B4)
=Mid(B4,4)
12. What does the term concatenate mean?
*
To Join
To Link
To Combine
To Merge
All of these answers are correct
13. The text in A1 is Johnny. The text in A2 is Johnson. What would be the result of the following formula? =concatenate(A1,'' '',A2)
*
JohnnyJohnson
Johnny Johnson
Johnny,Johnson
Johnson, Johnny
Johnson Johnny
14. Under which menu and grouping of commands will you find the Filter tool? Choose Two.
*
Page Layout>Sheet Options
Data>Sort & Filter
Insert>Tables
Home > Sort & Filter
Formulas > Filter & Sort
15. What happens to the header row when you click on the filter command?
*
A filter dialogue box will open with options.
Nothing happens.
Drop-down arrows appear for the header cell in each column.
None of these answers are correct.
Back
Next
16. Where will you find the Conditional Formatting command?
*
Home>Format
Home>Alignment
Home>Number
Home>Styles
File > Options
17. Which statement best describes Conditional Formatting?
*
Adding decimal places to numbers.
Adding a preceding dollar sign to numbers.
Applying a rule to a cell or range of cells.
Changing the font color
18. What formula should be entered in cell A3 to display the results as shown below?
*
="Income Statement"&A1
="Income Statement "&A1
19. Company A is looking into four potential projects and will accept them if the IRR is 10% or above, as shown in cell E2. What is the formula used in cell C2, which can be copied down to cell C3 through C5, to generate the results shown below?
*
=IF(B2>=E2,"Accept","Reject")
=IF(B2>=$E2,"Accept","Reject")
=IF(B2>=E$2,"Accept","Reject")
=IF(B2>=$E$2,"Accept","Reject")
20. Which of the following is the correct formula to calculate the weighted average score in cell C8 as shown below?
*
=SUMPRODUCT(C2:C4,B2:B4)
=AVERAGE(B2:B4)
=AVERAGE(B2:B4)
=SUMPRODUCT(C2:C5,B2:B5)
21. What formula can be used in cell G2 to create a dynamic date which shows the last day of each month?
*
=EOMONTH($B$2,B1)
=EOMONTH($B$2,G1)
=EOMONTH($B$2,C1)
=MONTH($G$2)
22. A block of cells in an Excel worksheet
*
Area
Range
Cell
Active cell
23. Correct format for a SUMIF statement is
*
=SUMIF(range, critera,sum_range)
=SUMIF(range,sum_range,critera)
=SUMIF(sum_range,critera,range)
None of the above
24. What function offers you the possibility to view different results depending on the entered condition?
*
=If()
=Sum()
=SumIf()
=TrueFalse()
Back
Next
BASIC IT QUESTIONS
25. What type of memory is short term; where data, information, and program instructions are stored temporarily?
*
Random access memory
Read any memory
Read only memory
Read only memory
26. What type of memory is long term; where the specific instructions that are needed for the computer to operate are stored?
*
Read any memory
Random access memory
Read only memory
Run always memory
27. Which type of software is frequently used by people who work with numbers, formulas, and data to perform calculations?
*
Database
Spreadsheet
Clip art
Word processor
28. What is a software program that can be used to retrieve documents from the World Wide Web and to display them in a readable format?
*
Browser
File Retrieval
Public domain
Security software
29. What are the instructions that tell the computer what to do called?
*
Hardware
Input
Software
Storage
30. Which is NOT an example of hardware?
*
Cables
Disk drive
Monitor
Windows XP
CLICK SUBMIT BELOW
Make sure you have answered all 30 question before submitting.
Submit
Should be Empty: