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. What is the intersection of a column and a row on a worksheet called ? Value
Coloumn
Cell
address

View Answer

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

View Answer

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

View Answer

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

View Answer

5. Excel includes the _______ to calculate maturities. Date()
Edate()
NPV()
TimeValue()

View Answer

6. In Excel, which one denoted a range from B1 through E5? B1 $ E4
B1 - E5
B1 to E5
B1:E5

View Answer

7. Which excel file format can be used on another windows operating system with the correct interpretation? xlsx
All of them
csv
dif

View Answer

8. To calculate the financial quarter for a specified date, the ________ function. Day()
Edate()
Month()
Choose()

View Answer

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

View Answer

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

View Answer