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. Which excel file format can be used on another windows operating system with the correct interpretation? dif
All of them
xlsx
csv

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer