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 is the intersection of a column and a row on a worksheet called ? address
Cell
Coloumn
Value

View Answer

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

View Answer

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

View Answer

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

View Answer

5. You can complete a cell entry by pressing? enter
An arrow key
tab
shift+tab

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer