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. A features that displays only the data in column (s) according to specified criteria? Sorting
Pivot
Filtering
Formula

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

9. Which function is provides serial number of the current date and time. Now()
Day()
Today()
Date()

View Answer

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

View Answer