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 International Formula
Data Input Format
Data Interchange format
None of These

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

9. The format of the data entered must watch with the _________ format. Year
Month
System date
calendar

View Answer

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

View Answer