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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer