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

View Answer

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

View Answer

3. Select option that a user can use to protect data from tampering in excel? digital signatures
restrict sharing
restrict access
file encryption

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

10. Which functions does not have arguments. Now()
Month()
EDate()
NPV()

View Answer