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 converts a number to text format and also adds a currency symbol. Dollar()
Fixed()
Number()
Rupees()

View Answer

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

View Answer

3. Which function is provides serial number of the current date and time. Now()
Day()
Date()
Today()

View Answer

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

View Answer

5. What is the intersection of a column and a row on a worksheet called ? Cell
address
Value
Coloumn

View Answer

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

View Answer

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

View Answer

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

View Answer

9. which function is return TRUE if the value refers to an empty cell. IsNumber()
IsBlank()
Minute()
Edate()

View Answer

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

View Answer