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. Which function in Excel tells how many numeric entries are there ? Count
Sum
CheckNum
Num

View Answer

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

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. Which function is provides serial number of the current date and time. Day()
Date()
Now()
Today()

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

9. What does the DIF format of excel stand for? Data International Formula
None of These
Data Input Format
Data Interchange format

View Answer

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

View Answer