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. In Excel, which one denoted a range from B1 through E5? B1:E5
B1 - E5
B1 to E5
B1 $ E4

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer