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. A features that displays only the data in column (s) according to specified criteria? Filtering
Formula
Sorting
Pivot

View Answer

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

View Answer

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

View Answer

4. __________ refers to the current time for executing an activity. TimeStamp
Formula
Trigger
Text()

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

9. You can complete a cell entry by pressing? shift+tab
An arrow key
enter
tab

View Answer

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

View Answer