Choose the correct answer:
1) Excel contains different formulas codes which called ______.
a) functions
b) equations
c) procedures
d) otherwise
2) Excel contains over ______ different formula codes.
a) 100
b) 200
c) 300
d) otherwise
3) The most common function in Excel is ______.
a) average
b) SUM
c) Count
d) otherwise
4) Most Excel users only use a ______of available functions.
a) small percentage
b) large percentage
c) both a and b
d) otherwise
5)The most common function in Excel is used to ______ a range of cells.
a) subtract
b) divide
c) multiply
d) total
6) The function wizard is accessible via __ on the formula tab.
a) insert function button
b) upsert function button
c) both a and b
d) otherwise
7) The function wizard is called __ in Excel.
a) formula demolisher
b) formula destructor
c) both a and b
d) formula builder
8) For use in business analysis, the most functions fall into _____.
a) financial
b) logical
c) aggregation
d) all of the above
9) The most useful functions of business analysis include which one of the following.
a) financial
b) logical
c) a and b
d) lookup
e) all of the above
10) __ are used when you need to evaluate a condition.
a) logical function
b) aggregation function
c) lookup function
d) financial function
e) otherwise
11) __ are helpful when there's a lot of data arranged that must be added together.
a) logical function
b) aggregation function
c) lookup function
d) financial function
e) otherwise
12) Functions such as (IF, AND, etc.) are examples of __, while (SUMIF, COUNTIF, etc.)
are ______.
a) logical, aggregation
b) financial, logical
c) lookup, financial
d) otherwise
13) Sum function can be done using __.
a) traditional sum function
b) auto sum function
c) both a and b
d) otherwise
14) Which one of the following represent the first step of Traditional sum function.
a) Select Auto sum button in the Toolbar
b) Select Formula button in the Toolbar
c) Select Home button in the Toolbar
d) none of the above is true
15) Which one of the following is the last step of Auto sum function.
a) Writing the formula of the sum function.
b) Highlight the range of data you entered
c) Activate the cell that you want the results appear in
d) none of the above is true
16) __ represent first step in traditional sum function in the toolbar, while ___ represent first
in auto sum function.
a) Select Home button, Select Formula button
b) Select Auto sum button, Select Formula button
c) Select Home button, Activate cells
d) otherwise
17) The last step in traditional sum function is __, while is __ in the auto sum function.
a) Highlight the range of entered data, writing the sum function
b) Activate cells' result, writing the formula
c) writing the sum function, Highlight the range of entered data
d) none of the above is true
18) In Max function you can enter ___.
a) a range of cells
b) individual cells separated by commas
c) both a and b
d) none of the above is true
19) The syntax for Max function is very similar to ____
a) SUM()
b) COUNT()
c) AVERAGE()
d) otherwise
20) ___helps to identify the maximum value, whilst ___ gives the least value in the list.
a) Count function, Min function
b) Max function, Count function
c) Max function, Min function
d) otherwise
21) The Max function will return an error if ______.
a) arguments have some text
b) arguments have some numbers
c) both a and b
d) otherwise
22) In Max function if the arguments do not have any numbers, the function returns______.
a) zero
b) one
c) both
d) otherwise
23) The limitations on inputs and the results of Min function are___ the MAX() function.
a) different from
b) similar to
c) both a and b
d) otherwise
24) ______ gives the least value in the list.
a) Count function
b) Average function
c) Min function
d) otherwise
25) The average function counts the total number of entries in a series.
a) True
b) False
26) The count function counts items in __.
a) a series
b) individual cells
c) both a and b
d) otherwise
27) The count function counts which one of the following.
a) logical expressions
b) text expressions
c) both a and b
d) numerical values
e) all of the above