Font size
S
M
L
XL
WorksheetsAdvanced Excel
Total questions: 89
Worksheet time: 1hrs 29mins
Name
Class
Date
1.
XML stands for
a)
Expansion
Markup Language
b)
Expansion Makeup Language
c)
EXtensible Markup Language
d)
EXtensible Makeup Language
2.
XML is a Recommendation
a)
W3C
b)
W1C
c)
W2C
d)
W4C
3.
XML is a language that’s very similar to
a)
C
b)
HTML
c)
C++
d)
JAVA
4.
DTD stands for
a)
Direct to Direct
b)
Document Type
Definition
c)
Data Type
Definition
d)
Data to Data
5.
XML Tools would be available in
a)
Add-Ins
b)
Developer
c)
Data
d)
Review
6.
XML data file extension is
a)
(.xsd)
b)
(.xml)
c)
(.mlx)
d)
(.xlm)
7.
XML group available in_ _Tab.
a)
Review
b)
Add-Ins
c)
Developer
d)
Data
8.
XML tags are predefined
a)
TRUE
b)
FALSE
9.
Schema files extension is _.
a)
(.xml)
b)
(.xsd)
c)
(.xlm)
d)
(.mlx)
10.
VBA stands for
a)
Visual Basic for
Application
b)
Visual Basic for
Applets
c)
Visual Basic for
Apple
d)
Visual Basic for
Auto Mobile
11.
Macro written in_
a)
Java
b)
Visual Basic
c)
V++
d)
C++
12.
Macro enabled workbook file extension is .
a)
.xlsx
b)
.xlsm
c)
.xlsv
d)
.xlsw
13.
ANOVA stands for
a)
Analysis of Value
b)
Analysis of Varity
c)
Analog of
Variance
d)
Analysis of
Variance
14.
function doesn’t require an argument.
a)
DATE()
b)
TODAY()
c)
MONTH()
d)
YEAR()
15.
SLN function is used
a)
For calculation of depreciation as per Sum of Years’ Digit Method
b)
For calculation of depreciation as per Straight Line Method.
c)
For calculation of depreciation as per Variable Declining Balance Method
d)
For calculation of depreciation as per Double Declining Balance Method
16.
SYD function is used .
a)
For calculation of depreciation as per Sum of Years’ Digit Method
b)
For calculation of depreciation as per Straight Line Method.
c)
For calculation of depreciation as per Variable Declining Balance Method
d)
For calculation of depreciation as per Double Declining Balance Method
17.
DB function is used .
a)
For calculation of depreciation as per Sum of Years’ Digit Method
b)
For calculation of depreciation as per Straight Line Method.
c)
For calculation of depreciation as per Declining BalanceMethod.
d)
For calculation of depreciation as per Double Declining Balance Method
18.
DDB is used to
a)
calculate depreciation as per Sum of Years’ Digit Method
b)
calculate depreciation as per Straight Line Method.
c)
calculate depreciation as per Declining BalanceMethod.
d)
calculate depreciation as per Double Declining Balance Method
19.
VDB function is used .
a)
calculate depreciation as per Variable Declining Balance Method
b)
For calculation of depreciation as per Straight Line Method.
c)
For calculation of depreciation as per Declining BalanceMethod.
d)
For calculation of depreciation as per Double Declining Balance Method
20.
PV Ratio stands for
a)
Point Volume
Ratio
b)
Point Varaiance
Ratio
c)
Profit Volume
Ratio
d)
Profit Variance
Ratio
21.
BEP stands for
a)
Balance sheet
Even Point
b)
Break Even Point
c)
Balance sheet
Equal Point
d)
Break Equal
Point
22.
Excel provides a readymade template for preparation of personal monthly budget
a)
TRUE
b)
FALSE
23.
Discounting Factor formula is
a)
= n / (1+a) - r
b)
= 1 + (1/r) * n
c)
= 1 / (1+a) ^ 2
d)
= 1 / (1+r) ^ n
24.
In excel-Protect sheet option, Password is not optional.
a)
TRUE
b)
FALSE
25.
In which tab, Data Validation is available?
a)
Formulas
b)
Insert
c)
Data
d)
Developer
26.
Which of the following function categorie is not available in excel
a)
Statistical
b)
Engineering
c)
Math & Trig
d)
Trignometrical
27.
is the area under the normal curve that is outside of the region of certinty
a)
Region of uncertainty
b)
Region of curve
c)
Region of certainty
d)
None of the
Above
28.
Normally bank transactions are also considered in cash budget.
a)
TRUE
b)
FALSE
29.
Budget stands for
a)
planning for
Expenditure.
b)
planning for future.
c)
planning for
Event.
d)
planning for
Meeting.
30.
is considered as non cash expenditure and occupies a prominent place in Profit & Loss Account.
a)
Cash Flow
b)
Depreciation
c)
Fund flow
d)
Expenditure
31.
what function is used for Sum of Years’ Digits?
a)
SOYD
b)
Digits of the Year
c)
SYD
d)
None
32.
method of depreciation is one of the accelerated depreciation techniques which are based on the assumption that assets are generally more productive when they are new and their productivity decreases as they become old.
a)
SLN
b)
DB
c)
VDB
d)
Sum of the years' digits
33.
method uses a fixed rate to calculate depreciation
a)
declining balance
b)
VDB
c)
SYD
d)
SLN
34.
VDB stands for
a)
Virtual Declining
Balance
b)
Variable Discounting Balance
c)
variable declining balance
d)
None
35.
The VDB function uses the method by default.
a)
Double Declining
Balance
b)
Variable Decling
Balance
c)
Straight Line
Method
d)
Costing Method
36.
stands for change in the total cost that arises when the quantity produced has an increment by unit.
a)
marginal cost
b)
Fixed Cost
c)
Variable cost
d)
Contribution
37.
Excel can also be used for taking decision on
a)
Fixed Cost
b)
Marginal cost
c)
Both A& B
d)
None
38.
is prepared for planning for future as far as movement of cash is concerned.
a)
Capital Budgeting
b)
Cash budget
c)
Both A& B
d)
Actual Budget
39.
is an estimate of pupulation Standard Deviation from data taken from a samples
a)
Standard
Deviation
b)
Standard Error
c)
Standard population deviation
d)
none of the above
40.
is the process of determining the present value of a payment or a stream of payments that is to be received in the future.
a)
Marginal costing
b)
Capital Budgeting
c)
Discounting
d)
None
41.
is one of the core principals of finance and is the primary factor used in pricing a stream of cash flows, such as those found in a traditional bond or annuity.
a)
Marginal costing
b)
Discounting
c)
PMT
d)
None
42.
Which function is used to calculate the principal portion in every installment
a)
IPMT
b)
PPMT
c)
PMT
d)
None
43.
is a process used in statistical analysis in which a predetermined number of observations will be taken from a larger population.
a)
Snowball sampling
b)
Sampling
c)
Systematic sampling
d)
Simple random sampling
44.
In this Method, Individuals are selected at regular intervals from a list of the whole population.
a)
Clustered sampling
b)
Sampling
c)
Systematic sampling
d)
Simple random sampling
45.
In this case each individual is chosen entirely by chance and each member of the population has an equal chance, or probability, of being selected.
a)
Snowball sampling
b)
Convenience sampling
c)
Systematic sampling
d)
Simple random sampling
46.
is the area under the normal curve that corresponds to the required level of confidence.
a)
Region of uncertainty
b)
Region of curve
c)
Region of confidence
d)
None of the above
47.
This method is commonly used in social sciences when investigating hard to reach groups.
a)
Quota Sampling
b)
Sampling
c)
Snowball sampling
d)
Simple random sampling
48.
It is a process in which a business determines whether projects such as building a new plant or investing in a long-term venture are worth pursuing.
a)
Business
Investment
b)
Capital Budgeting
c)
IRR
d)
NPV
49.
Popular methods of capital budgeting include payback period and
.
a)
discounted cash flow
b)
internal rate of return
c)
net present value
d)
All the above
50.
is the value of all future cash inflows less future cash outflows as on today.
a)
Net present value
b)
Working capital
c)
IRR
d)
PMT
51.
is the process of defining and analyzing the dangers to individuals, businesses and government agencies posed by potential natural and human-caused adverse events.
a)
Sensitivity analysis
b)
Risk analysis
c)
Qualitative risk analysis
d)
Scenario analysis
52.
which is used more often, does not involve numerical probabilities or predictions of loss.
a)
Sensitivity analysis
b)
Risk analysis
c)
Qualitative risk analysis
d)
Scenario analysis
53.
are generally used to present information in a simple and better way and also be used to analyse the risk in a better way.
a)
Graphs
b)
Sparklines
c)
Both A& B
d)
Charts
54.
It is a technique used to determine how different values of an independent variable will impact a particular dependent variable under a given set of assumptions.
a)
Decision Tree analysis
b)
Sensitivity analysis
c)
Both A& B
d)
Neither A &B
55.
involves computing different reinvestment rates for expected returns that are reinvested during the investment horizon.
a)
Scenario analysis
b)
Sensitivity analysis
c)
Decision Tree
Analysis
d)
None
56.
A typical value that represents all the data points is called as
a)
Median
b)
Arithmatic Mean
c)
all the above
d)
None
57.
is a computerized mathematical technique that allows people to account for risk in quantitative analysis and decision making.
a)
Finanical Planning
b)
Monte Carlo simulation
c)
Corporate
Planning
d)
Personal Finance planning
58.
is the process of meeting the financial goals through the proper management of finances.
a)
Corporate planning
b)
Monte Carlo simulation
c)
Financial planning
d)
Personal Finance planning
59.
can be defined as the process of setting the procedures in the organization for achieving the predefined goals.
a)
Monte Carlo simulation
b)
Corporate planning
c)
Decision Tree analysis
d)
Sensitivity analysis
60.
Add_in is default Tab in Excel
a)
TRUE
b)
FALSE
61.
By default all the cells in any excel sheet are locked.
a)
TRUE
b)
FALSE
62.
NPER stands for
a)
Total Principal
Value
b)
Per value
c)
Total Interest
Value
d)
Total Number of
Periods
63.
A is a series of commands and functions that are stored in a Microsoft
Visual Basic module and can be run whenever the user need to perform the task
a)
Pivot Table
b)
Solver
c)
Scenario
d)
Macro
64.
Consolidate is a What-If Analysis Tool.
a)
TRUE
b)
FALSE
65.
Which function that is used to calculate the payment for specific loan terms
a)
sumif
b)
pmt
c)
countif
d)
none of the above
66.
are not allowed in a macro name
a)
spaces
b)
wild card characters
c)
symbols
d)
none of the above
67.
The wizard that is used to create and edit charts
a)
pivot table wizard
b)
chart wizard
c)
convert text to columns wizard
d)
tip wizard
68.
Which one of the following will be the tool that provides a way to view and compare the results of all the different variations together on the worksheet ?
a)
Goal seek
b)
Pivot table
c)
Solver
d)
Data table.
69.
The generates a summarised report in tabular form in an interactive manner
a)
Data table
b)
Pivot table
c)
Scenario
Manager
d)
Solver
70.
The wizard separates contents in a cell into different cells
a)
text import wizard
b)
convert text to columns wizard
c)
tip wizard
d)
function wizard
71.
A cell reference that does not change during a copy operation is known as
.
a)
absolute
b)
relative
c)
mixed
d)
constant
72.
Circle Invalid Data option is available in
a)
Consolidate
b)
What-if Analysis
c)
Calculate Sheet
d)
Data Validation
73.
The wizard that is used to import text files is
a)
text import wizard
b)
convert text to columns wizard
c)
tip wizard
d)
function wizard
74.
A is a summary of the financial position of a business at a specific point in time, showing all assets, liabilities, and equity.
a)
Balance Sheet
b)
Profit & Loss
c)
Income & Expenditure
d)
None
75.
This ratio shows ability of company to pay back long term loans along with interest or other charges from generation of profit from its operations
a)
Debt Assets Ratio
b)
Interest
Coverage Ratio
c)
Total Fund
Ration
d)
None
76.
Which ratio indicate efficiency with which company used its capital ( Equity as well as debt)
a)
Return on
Investment
b)
Interest
Coverage Ratio
c)
Total Fund
Ration
d)
Net Profit
Margin Ratio
77.
It is the simplest method of comparing different stocks at a point of time to make investment decisions
a)
Earnings Per share
b)
Fixed Asset Over ratio
c)
Price Earnings
Multiple
d)
Gross Profit
Ratio
78.
helps to break down the Return on Equity
a)
Du Point Analysis
b)
Return on
Investment
c)
Profitability
Ration
d)
None
79.
is a common method for financing property, facilities, and equipment.
a)
Mortagage
b)
Leasing
c)
Rent
d)
All the above
80.
xml schema file extention is
a)
.xml
b)
.xmd
c)
.xsd
d)
None of the
Above
81.
In hypothesis test, when we can reject the H0(Null Hypothesis)
a)
p-value> a
b)
p-value>=a
c)
p-value< a
d)
p-value<= a
82.
In Hypothesis test, when we can reject the H1 (alternate hypothesis)
a)
Test statistic >=
critical value
b)
Test statistic
<=critical value
c)
Test statistic <
critical value
d)
p-value<= a
83.
A product is purchased for Rs 400000, the salvage value of the product is 50000 after 10 years. Now I want to findout the depreciation value of first 4 years. In the given following which would be the currect function.
a)
VDB(400000,500
00,10,1,4)
b)
VDB(400000,500
00,1,4)
c)
VDB(50000,400
000,10,4)
d)
VDB(50000,4000
00,10,1,4)
84.
In VDB function what is the "factor" if it is omitted?
a)
4
b)
1
c)
3
d)
2
85.
When VDB function calculate the depreciation by using Stright line method?
a)
when the stright line depreciation is greater than the declining balance calculation.
b)
"no_switch" argument is
'FALSE'
c)
Both A and B
d)
either A or B
86.
A machine was purchased for Rs.1000000 in EMI at 8% interest rate. Planned to repay the loan in 5 Years. In total cost Rs.100000 paid at the time of purchase . What is the correct function to calculate the monthly installment amount.
a)
PMT(8%,5,-
1000000,100000,
1)
b)
PMT(8%,60,1000
000,100000,0)
c)
PMT(8%/12,60,1
000000,-
100000,1)
d)
PMT(8%,60,-
1000000,100000
,0)
87.
A businessman planned to get a loan Rs.1800000. If he get a loan at 8% interest for
6 years, Monthly Installment will be Rs.31599.83. he calculate the same for various interest rates and loan repayment periods. Which Excel option will you suggest to him to make it easy.
a)
Goal seek
b)
scenario manager
c)
Data Table
d)
None of the
Above
88.
In Data table, at a time how many arguments maximum can be used for analysis?
a)
3
b)
1
c)
4
d)
2
89.
In a business, Intial cost of investment one year from today is Rs.10000, return from
1st yeare is 3000, from 2nd year Rs.4200 and from third year Rs.6800. Annual discount rate is 10%. Then to find Net Present Value of this investment what would be the correct function in the given following?
a)
NPV(10%,10000,3
000,4200,6800)
b)
NPV(10,-10000,-
3000,-4200,-
6800)
c)
NPV(10%,-
10000,6800,420
0,3000)
d)
NPV(10%,-
10000,3000,420
0,6800)
Reset
