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. In Excel, which one denoted a range from B1 through E5? B1 to E5
B1 $ E4
B1 - E5
B1:E5

View Answer

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

View Answer

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

View Answer

4. Which function in Excel tells how many numeric entries are there ? Num
CheckNum
Count
Sum

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer