Question

In: Accounting

3.) What type of formatting is completed based on a certain criteria/conditions being met? Conditional Formatting...

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

Solutions

Expert Solution

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.


Related Solutions

What criteria must be met in order to consider a practice, evidence-based? Provide examples. Explain the...
What criteria must be met in order to consider a practice, evidence-based? Provide examples. Explain the role quality plays in evidence-based practice?
1. What are examples of instances when you might use conditional formatting in an Excel spreadsheet?...
1. What are examples of instances when you might use conditional formatting in an Excel spreadsheet? Try to come up with an example that is not used in the chapter. 2.Provide an example of when you would use the COUNTIF function and one of when you would use the COUNTIFS function. Which of the following functions identified in this or the previous chapter do you think will be the most useful? Why? 3.Why you might want to use tables in...
Name and describe the 3 criteria that must be met before a casual claim can be...
Name and describe the 3 criteria that must be met before a casual claim can be made. Then explain how/why quasi-experimental designs differ from experimental designs with respect to their ability to make casual claims.
1, what are the criteria that must be met in order to recognize revenue from the...
1, what are the criteria that must be met in order to recognize revenue from the sale of goods? (200 words) 2, what are the type of difference that exist between IFRS and U.S GAAP ?(200 words)
What are the advantages of using the modified approach and what conditions must be met in...
What are the advantages of using the modified approach and what conditions must be met in order to use the modified approach?
1. What conditions need to be met to be mental health arrested?
Case Study #3: SchizophreniaS: Marshall is a 22-year-old diagnosed with schizophrenia, paranoid type. He was just admitted today, his parents had him mental health arrested (MHA). He has been observed to be carrying on a conversation with someone, but then this morning there was a stand-off in the kitchen where Marshall was just yelling at his parents “Don’t come near me! – I will have to defend myself, I know how to defend myself!” He then grabbed a knife from...
SEC Accounting and Auditing Enforcement Release (AAER) No. 108 specifies certain conditions or criteria that a...
SEC Accounting and Auditing Enforcement Release (AAER) No. 108 specifies certain conditions or criteria that a bill and hold transaction of a public company should meet in order to qualify for revenue recognition. The AAER also specifies certain factors that should be considered in evaluating whether a bill and hold transaction meets the requirements for revenue recognition. AAER No. 108 states that a “bill and hold” transaction should meet the following conditions: The risks of ownership must have passed to...
what criteria must be met to bill a Medicare patient as an inpatient and observation patient?
what criteria must be met to bill a Medicare patient as an inpatient and observation patient?
Thermodynamics Concepts a. What physical or chemical requirements must be met to satisfy the conditions for...
Thermodynamics Concepts a. What physical or chemical requirements must be met to satisfy the conditions for understanding standard free energy of formation? b. How does the free energy of reaction differ from the standard free energy of reaction? c. What is the purpose of deriving the standard free energy of formation, standard free energy of reaction, and free energy of reaction?
Finally, analyze what conditions should be met for the UN to become a supranational organization and...
Finally, analyze what conditions should be met for the UN to become a supranational organization and what consequences such a change might have. In order to write nuanced answers, it is necessary to answer from different perspectives. To do objective reasoning showing things from different directions. A consequence can be positive for one party but negative for someone else. Or positive in a short-term perspective but negative in the long run. It usually depends only on how to look at...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT