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 format of the data entered must watch with the _________ format. System date
calendar
Year
Month

View Answer

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

View Answer

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

View Answer

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

View Answer

5. What is the intersection of a column and a row on a worksheet called ? Value
Coloumn
address
Cell

View Answer

6. Which function converts a number to text format and also adds a currency symbol. Fixed()
Dollar()
Number()
Rupees()

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

12. What type of chart is useful for comparing values over categories ? Pie chart
Graph
Line chart
Column Chart

View Answer

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

View Answer

14. __________ refers to the current time for executing an activity. Formula
Text()
TimeStamp
Trigger

View Answer

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

View Answer

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

View Answer

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

View Answer

18. __________ is a valuation method used to evaluate the worth or value of a possible investment. Financial Calculations
Financial Banking Model
Annuity Cash Flows
Discounted Cash Flow

View Answer

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

View Answer

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

View Answer