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:E5
B1 $ E4
B1 - E5
B1 to E5

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer