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. Labels are aligned at the ________ edge of the cell left
Top
Right
Bottom

View Answer

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

View Answer

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

View Answer

4. Which excel file format can be used on another windows operating system with the correct interpretation? All of them
csv
dif
xlsx

View Answer

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

View Answer

6. __________ refers to the current time for executing an activity. TimeStamp
Text()
Trigger
Formula

View Answer

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

View Answer

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

View Answer

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

View Answer

10. What type of chart is useful for comparing values over categories ? Graph
Line chart
Column Chart
Pie chart

View Answer

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

View Answer

12. __________ is a valuation method used to evaluate the worth or value of a possible investment. Financial Calculations
Discounted Cash Flow
Annuity Cash Flows
Financial Banking Model

View Answer

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

View Answer

14. Which function calculates the Internal Rate of Return for a series of cash occurring at irregular intervals? IRR()
ABCS()
IPMT()
XRR()

View Answer

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

View Answer

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

View Answer

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

View Answer

18. The Greater Than sign (>) is an example of _____ operator. Logical
Greater
Arithmatic
conditional

View Answer

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

View Answer

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

View Answer