Test Your Programming Skills with Safcode!

---

Here is all important interview / exams questions.
Student doing practice apptitude test on safcode platform.
Instruction: "Total Number of Questions: 20
Each question carry 10 mark , no negative marking"

---

Quiz Start

1. Which function calculates the Internal Rate of Return for a series of cash occurring at irregular intervals? IPMT()
IRR()
ABCS()
XRR()

View Answer

2. Which function converts a number to text format and also adds a currency symbol. Rupees()
Dollar()
Fixed()
Number()

View Answer

3. __________ is a valuation method used to evaluate the worth or value of a possible investment. Financial Banking Model
Discounted Cash Flow
Financial Calculations
Annuity Cash Flows

View Answer

4. What does the DIF format of excel stand for? None of These
Data Interchange format
Data International Formula
Data Input Format

View Answer

5. The format of the data entered must watch with the _________ format. System date
Year
Month
calendar

View Answer

6. What type of chart is useful for comparing values over categories ? Pie chart
Graph
Line chart
Column Chart

View Answer

7. Which function in Excel tells how many numeric entries are there ? CheckNum
Count
Sum
Num

View Answer

8. Which function is used to determine the number of days between two dates. Today()
Days()
Date()
Month()

View Answer

9. The _________ function is used to calculate the net present value from a series of unseen cash flows. XRR()
NPV()
XNPV()
None of these

View Answer

10. Select option that a user can use to protect data from tampering in excel? restrict access
digital signatures
restrict sharing
file encryption

View Answer