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. You can complete a cell entry by pressing? shift+tab
enter
An arrow key
tab

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer