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. Functions in MS Excel must begin with ___? Plus sign
An () sign
A > Sign
An Equal Sign

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer