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. Functions in MS Excel must begin with ___? An () sign
A > Sign
Plus sign
An Equal Sign

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer

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

View Answer