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 does the DIF format of excel stand for? Data Input Format
Data Interchange format
Data International Formula
None of These

View Answer

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

View Answer

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

View Answer

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

View Answer

5. Which functions does not have arguments. Month()
EDate()
NPV()
Now()

View Answer

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

View Answer

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

View Answer

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

View Answer

9. What type of chart will you use to compare performance of two employees in the year 2016 ? Graph
Pie Chart
LineChart
Coloumn Chart

View Answer

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

View Answer