+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 excel file format can be used on another windows operating system with the correct interpretation?
dif
All of them
xlsx
csv
View Answer
2. What does the DIF format of excel stand for?
Data Input Format
Data International Formula
Data Interchange format
None of These
View Answer
3. Which function is provides serial number of the current date and time.
Day()
Date()
Today()
Now()
View Answer
4. In Excel, which one denoted a range from B1 through E5?
B1 $ E4
B1:E5
B1 - E5
B1 to E5
View Answer
5. Functions in MS Excel must begin with ___?
Plus sign
A > Sign
An Equal Sign
An () sign
View Answer
6. Which function is used to determine the number of days between two dates.
Today()
Month()
Days()
Date()
View Answer
7. What type of chart will you use to compare performance of two employees in the year 2016 ?
LineChart
Pie Chart
Graph
Coloumn Chart
View Answer
8. Which function converts a number to text format and also adds a currency symbol.
Number()
Fixed()
Rupees()
Dollar()
View Answer
9. A features that displays only the data in column (s) according to specified criteria?
Pivot
Filtering
Formula
Sorting
View Answer
10. Excel includes the _______ to calculate maturities.
Edate()
NPV()
TimeValue()
Date()
View Answer