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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer