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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

15. __________ refers to the current time for executing an activity. Text()
Trigger
TimeStamp
Formula

View Answer

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

View Answer

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

View Answer

18. A features that displays only the data in column (s) according to specified criteria? Pivot
Sorting
Formula
Filtering

View Answer

19. In Excel, which one denoted a range from B1 through E5? B1 $ E4
B1 - E5
B1:E5
B1 to E5

View Answer

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

View Answer