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. The format of the data entered must watch with the _________ format. calendar
System date
Year
Month

View Answer

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

View Answer

3. A features that displays only the data in column (s) according to specified criteria? Pivot
Sorting
Filtering
Formula

View Answer

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

View Answer

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

View Answer

6. The Greater Than sign (>) is an example of _____ operator. conditional
Arithmatic
Greater
Logical

View Answer

7. Labels are aligned at the ________ edge of the cell left
Right
Bottom
Top

View Answer

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

View Answer

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

View Answer

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

View Answer