WorksheetsExcel-Audit Tool
Total questions: 59
Worksheet time: 59mins
Name
Class
Date
1.
file cannot be easily converted into Excel
a)
XML
b)
CSV
c)
PDF
d)
TEXT
2.
function is used to calculate the present values of all future cashflows.
a)
FV
b)
PV
c)
NPV
d)
IRR
3.
is the rate of discounting at which NPV=0
a)
FV
b)
PV
c)
NPV
d)
IRR
4.
If Guess parameter is not specified by the user in IRR,Excel assumes it to be
a)
9%
b)
14%
c)
10%
d)
13%
5.
In case if the cash flows occur unevenly,then we may use and in excel
a)
PV & IRR
b)
XNPV & XIRR
c)
NPV & IRR
d)
None of the above
6.
Function is used for calculating depreciation as per Written Down Value
Method
a)
SLN
b)
DB
c)
All the Above
d)
None of the above
7.
Function can be used while verifying depreciation expense claimed by the auditee
a)
DB
b)
SLN
c)
All the Above
d)
None of the above
8.
Function is used for calculationg maturity dates
a)
Date
b)
Month
c)
NetworkDays
d)
None of the above
9.
In EOMONTH() , if the second argument(months) is defined as 2 it will yield month end date
a)
before 2 months
b)
after 2 months
c)
#N/A
d)
None of the above
10.
Will the EOMONTH() will take the leap year factor into account?
a)
YES
b)
NO
11.
EDATE() returns the date with the which is specified number of months before and after the start date.
a)
Next day
b)
previous day
c)
same day
d)
None of the above
12.
EDATE() can be used to derive schedule of dates at intervals
a)
unequal
b)
equal
c)
Either A or B
d)
Neither A or B
13.
Which of these is/are mandatory arguments in NETWORKDAYS()?
a)
start date
b)
end date
c)
Either A or B
d)
Both A & B
14.
In NETWORKDAYS(), holidays argument will contain the holidays list
a)
excluding Saturday & Sunday
b)
including Saturday & Sunday
c)
None of the above
15.
Which of these function can be used,If we had to calculate the working days where the weekends are treated as Friday and Saturday?
a)
NETWORKDAYS()
b)
NETWORK.INT()
c)
NETWORK.INTR(
)
d)
None of the above
16.
The output of WORKDAY() will be a
a)
Number
b)
Date
c)
Number or Date
d)
None of the above
17.
In WORKDAY(),if we want to go backwards and derive a date in the past,then we must specify days as
a)
Zero
b)
Positive
c)
Negative
d)
None of the above
18.
If you wish to obtain the days remaining after casting out completed weeks,then which of these function can be used?
a)
QUOTIENT()
b)
MOD()
c)
Either A or B
d)
None of the above
19.
If you wish to obtain the completed weeks,then which of these function can be used?
a)
QUOTIENT()
b)
MOD()
c)
Either A or B
d)
None of the above
20.
Which of these operator can be used for joining two or more text strings together?
a)
comma
b)
ampersand
c)
space
d)
hash
21.
Can we perform a non case-sensitive comparison?
a)
YES
b)
NO
22.
_searches for a value in first column of data/table array
a)
Hlookup
b)
Vlookup
c)
Match
d)
Index
23.
In VLOOKUP(),the search of the lookup value is performed in the most colum of the table array
a)
Left
b)
Right
c)
Either A or B
d)
Neither A or B
24.
Which of these is incorrect with respect to VLOOKUP()?
a)
Lookup value is the value which is to be searched in table array
b)
The search is always
performed in the leftmost column of the tavle array
c)
The column index number should be the relative position of the respect column
d)
All the four arguments are mandatory arguments
25.
In VLOOKUP(),if the lookup_value being searched in a slab/range of numbers then_ should be used
a)
EXACT MATCH
b)
APPROXIMATE MATCH
c)
Either A or B
d)
Neither A or B
26.
While using Approximate match type in VLOOKUP(),the table should be sorted in
on the basis of the leftmost column.
a)
ascending order
b)
descending order
c)
Either A or B
d)
Neither A or B
27.
Which of these is not an argument in HLOOKUP()?
a)
lookup_array
b)
col_index_numb er
c)
row_index_num ber
d)
Both A & B
28.
function returns the value or reference at the intersection of a specified row and column,from an array.
a)
Hlookup
b)
Vlookup
c)
Match
d)
Index
29.
Which of the following is an optional argument in MATCH()?
a)
Lookup value
b)
lookup array
c)
match type
d)
None of the above
30.
Lookup array means you can select
a)
Only one row
b)
Only one column
c)
one row or one column
d)
multiple rows or multiple
columns
31.
If we need to perform right to left lookup in a table,then can be used
a)
INDEX()
b)
MATCH()
c)
Both A or B
d)
Either A or B
32.
Which of the following is not an advantage of Index match combination?
a)
It performs left to right lookup
b)
The processing requirement is lower as compared to Vlookup
c)
It can also be used as Hlookup
d)
It avoids data redundancy
33.
returns the reference specified by a text
a)
INDEX()
b)
MATCH()
c)
INDIRECT()
d)
All the above
34.
IFERROR() is a brilliant function introduced in Excel
a)
2010
b)
2007
c)
2013
d)
2003
35.
In IFERROR(),value if error argument will be executed if value argument generates
a)
#REF!
b)
#VALUE?
c)
#N/A
d)
#DIV/0!
36.
Countblank function is the reverse of function
a)
COUNTA()
b)
COUNTIFS()
c)
COUNTIF()
d)
None of the above
37.
Countblank could be used in detectinig cells which have inadverently
a)
remained blank
b)
where data entry is incomplete
c)
Both A & B
d)
None of the above
38.
function returns the kth largest number from a list of numbers.
a)
MAX
b)
LARGE
c)
Either A or B
d)
None of the above
39.
Which of these helps us to understand the interelationship between the cells
a)
Trace Precedents
b)
Trace
Dependents
c)
Either A or B
d)
Both A & B
40.
If the cell is deleted without bothering about tracing its dependents,then the resultant cell will carry error
a)
#NAME?
b)
#N/A
c)
#REF!
d)
None of the above
41.
is a dedicated tool for tracking down the errors
a)
Go to special
b)
Trace
Dependents
c)
Trace
Precedents
d)
Error Checking
42.
Error checking feature will not identify errors in the _behind formula construction
a)
syntax
b)
logic
c)
Either A or B
d)
Both A & B
43.
If we want a quick evaluation of only one of the parts of the formula,we can make use of
a)
Evaluate formula
b)
F9
c)
Either A or B
d)
Both A & B
44.
Which of these operators will be executed 2nd in Excel?
a)
Brackets
b)
Addition
c)
Exponents
d)
Division
45.
By using Conditional Formatiing,you can hghlight cells containing values
a)
duplicate
b)
unique
c)
Either A or B
d)
Both A & B
46.
Remove Duplicates is introduced in Excel
a)
2010
b)
2007
c)
2003
d)
2013
47.
In Excel,Using Number Filters,We cannot extract values
a)
Top 10
b)
Bottom 10
c)
Above Average
d)
Below Average
48.
In Date Filter, all dates in the period option helps to obtain records for different
a)
months
b)
quarters
c)
years
d)
All the above
49.
For using Pivot tables,we need to have a dataset in format
a)
rectagular
b)
flat
c)
Either A or B
d)
Neither A or B
50.
In Excel,Which of the following is not a field in Pivot Table?
a)
Report Filter
b)
Column Labels
c)
Row Labels
d)
Filter field
51.
Which of the following cannot be computed in value fields of pivot table?
a)
large
b)
max
c)
min
d)
sum
52.
Say whether TRUE or FALSE
In Pivot table, we cannot eliminate blank cell from data section
a)
TRUE
b)
FALSE
53.
Which of the following is not a limitation of Pivot Table?
a)
We cannot insert rows or columns in between a
Pivot Table report
b)
If the number of records are very large,Pivot table may respond slowly
c)
Pivot Tables Update themselves,We neednot refresh them
d)
All the above
54.
If we want a list of the missing invoice numbers,we can make use of
a)
VLOOKUP()
b)
MATCH()
c)
INDEX()
d)
None of the above
55.
Benford's law was propounded by
a)
Dr.Mark Nigrini
b)
Frank Benford
c)
Mark Benford
d)
None of the above
56.
Benford's Law is also known as law of _digit
a)
second
b)
first
c)
third
d)
last
57.
Benford observed that the probability of 1st digit being 9 is the among all digits
a)
highest
b)
least
c)
most probable
d)
None of the above
58.
Stratification involves breaking data into groups called as strata
a)
heterogeneous,h omogeneous
b)
homogeneous,he terogeneous
c)
humongous,ho mogeneous
d)
None of the above
59.
Which of the following is not a result of descriptive statistics?
a)
MEAN
b)
MEDIAN
c)
MOD
d)
LARGE
100 %
