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 _________ function is used to calculate the net present value from a series of unseen cash flows. NPV()
XNPV()
XRR()
None of these

View Answer

2. Functions in MS Excel must begin with ___? An Equal Sign
An () sign
Plus sign
A > Sign

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer