+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. Which function in Excel tells how many numeric entries are there ?
Num
CheckNum
Sum
Count
View Answer
2. Which functions does not have arguments.
Now()
Month()
EDate()
NPV()
View Answer
3. The _________ function is used to calculate the net present value from a series of unseen cash flows.
None of these
XRR()
NPV()
XNPV()
View Answer
4. Excel includes the _______ to calculate maturities.
Date()
Edate()
TimeValue()
NPV()
View Answer
5. Which function is provides serial number of the current date and time.
Date()
Today()
Day()
Now()
View Answer
6. In Excel, which one denoted a range from B1 through E5?
B1 to E5
B1 $ E4
B1:E5
B1 - E5
View Answer
7. Select option that a user can use to protect data from tampering in excel?
restrict sharing
restrict access
file encryption
digital signatures
View Answer
8. A features that displays only the data in column (s) according to specified criteria?
Formula
Filtering
Pivot
Sorting
View Answer
9. To calculate the financial quarter for a specified date, the ________ function.
Edate()
Day()
Month()
Choose()
View Answer
10. Which function calculates the Internal Rate of Return for a series of cash occurring at irregular intervals?
IPMT()
XRR()
ABCS()
IRR()
View Answer