In: Accounting
3.) What type of formatting is completed based on a certain criteria/conditions being met?
Conditional Formatting
Bold Formatting
Color Formatting
Criteria Formatting
4.) In a 2 variable data table, which cell location is the formula found?
Northwest Corner
Southwest Corner
Northeast Corner
Southeast Corner
5.) If instructed to create a 1 variable data table using a column input cell starting in cell A5, which cell is the first variable found in?
A6
A5
B5
B6
6.) If instructed to create a 1 variable data table using a column input cell starting in cell A5, which cell is the first formula found in?
B5
A5
B6
A6
7.) How many ifs are found in a nested if statement with 7 outcomes possible?
6
5
7
8
8.) In a vlookup function, which column in the lookup table is the lookup value compared to when the table has 4 columns?
1
2
3
4
9.) In the following formula, which is referring to the rate?
=-PMT(K13/12,K14*12,K15)
K13/12
-PMT
K14*12
K15
10.) In the following formula, which is referring to the principle value of the loan?
=-PMT(K13/12,K14*12,K15)
K15
-PMT
K13/12
K14*12
11.) If instructed to Sort a database by Last Name in Ascending Order, how many levels are used in this sort?
1
2
3
4
12.) What function is used to Average a certain field found in a database?
DAVERAGE
DSUM
AVERAGE
SUM
13.) What function is used to find the largest value in a database field based on certain criteria?
DMAX
SUM
MAX
DSUM
14.) How many ifs are used in a nested if in which there are 5 outcomes?
4
2
3
5
15.) In the following OR statement, what is the minimum that have to be correct to be TRUE?
=OR(A1>1,A2<5.A3=10,A4<20)
1
2
3
4
3) Option-A Conditional Formatting
Conditional Formatting formats the cells that meet the criteria specified by us. For example Duplicate Values, Top 10 values, etc.
4) Option-A North West Corner
In a 2 variable data table, the formula must be present in top left corner i.e., North West Corner
5) Option-A A6
In a single variable data table, the first row contains the formula and no variable. Variables start from first column, second row of the data table. Hence Data table starting from cell A5 has first variable from cell A6
6) Option-A B5
In a single variable data table, the formula is present at first row, second column of the data table. Hence for data table starting from A5, the formula is present in Cell B5
7) Option-A 6
An If function can generate 2 outcomes i.e., value_if_true and value_if_false.
In the case of nested ifs one value of the if function is used to write another if function. However the last if function generates two outcomes. Hence the total outcome in nested ifs is n+1 where n is the number of if functions used.
Hence for 7 outcomes, the number of if functions used is 6
8) Option-A 1
Vlookup function searches the first column of a table array and returns the data present in the corresponding row for the specified column. Hence the lookup value should be present in the first column of table array.
9) Option-A K3/12
The syntax for PMT function is =PMT(rate,nper,pv,[fv],[type]). The first variable is the rate.
10) Option-A K15
The syntax for PMT function is =PMT(rate,nper,pv,[fv],[type]). The third variable is the present value or principal value of the loan.
11) Option-A 1
Since we are using only one criterion i.e., last name to sort only one level sorting is done.
12) Option-A DAVERAGE
For Databases, we use D Functions. For finding the average of certain field in Database we need to use the DAVERAGE function.
13) Option-A DMAX
For Databases, we use D Functions. For identifying maximum value in a database, we use DMAX function.
14) Option-A 4
An If function can generate 2 outcomes i.e., value_if_true and value_if_false.
In the case of nested ifs one value of the if function is used to write another if function. However the last if function generates two outcomes. Hence the total outcome in nested ifs is n+1 where n is the number of if functions used.
Hence for 5 outcomes, the number of if functions used is 4
15) Option-A 1
An OR function return true if one or more of the inputs is true. Hence the minimum inputs required to be correct for an OR function to be true is 1.