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 type of chart will you use to compare performance of two employees in the year 2016 ? Pie Chart
Graph
Coloumn Chart
LineChart

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer