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? Formula
Sorting
Filtering
Pivot

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer