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
Formula
Filtering

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer