+923132835245
safcodeinstitute@gmail.com
Online Quiz
10000+ Questions!
Students Works
Ideas & Topics!
Live Coding
HTML & CSS
Home
(current)
About
Courses
CIT
Web Designing
Graphic Designing
Web Development
Digital Marketing
WordPress + SEO
Artificial Intelligence (AI)
Shopify + WordPress Development
Tutorials
Feedback
Programming Notes
Enroll Now
Contact
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. To calculate the financial quarter for a specified date, the ________ function.
Month()
Choose()
Day()
Edate()
View Answer
2. Which function calculates the Internal Rate of Return for a series of cash occurring at irregular intervals?
ABCS()
IRR()
XRR()
IPMT()
View Answer
3. In Excel, which one denoted a range from B1 through E5?
B1 $ E4
B1 - E5
B1 to E5
B1:E5
View Answer
4. The Greater Than sign (>) is an example of _____ operator.
Greater
Logical
conditional
Arithmatic
View Answer
5. The format of the data entered must watch with the _________ format.
calendar
Year
Month
System date
View Answer
6. Which excel file format can be used on another windows operating system with the correct interpretation?
xlsx
csv
All of them
dif
View Answer
7. Labels are aligned at the ________ edge of the cell
Top
Right
Bottom
left
View Answer
8. Functions in MS Excel must begin with ___?
A > Sign
An () sign
An Equal Sign
Plus sign
View Answer
9. Excel includes the _______ to calculate maturities.
TimeValue()
NPV()
Date()
Edate()
View Answer
10. Which functions does not have arguments.
Month()
EDate()
Now()
NPV()
View Answer