Scribd
Upload
71 views8 pages

Colsulcide Evaluation 1

The sales department of ABC Company wants to provide discounts on customer purchases based on the following thresholds: - Purchases over $200,000 receive a 5% discount - Purchases over $400,000 receive a 7% discount - Purchases over $600,000 receive a 10% discount - Purchases below these thresholds receive a 0% discount. Nested conditional functions should be used to calculate the discounts.

Uploaded by

ScribdTranslations
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
71 views8 pages

Colsulcide Evaluation 1

The sales department of ABC Company wants to provide discounts on customer purchases based on the following thresholds: - Purchases over $200,000 receive a 5% discount - Purchases over $400,000 receive a 7% discount - Purchases over $600,000 receive a 10% discount - Purchases below these thresholds receive a 0% discount. Nested conditional functions should be used to calculate the discounts.

Uploaded by

ScribdTranslations
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

The sales department of ABC Company wants to give a

punctual solution for the settlement of discounts according


to the amount of a customer's purchases as follows: over
$200,000, 5%; over $400,000, 7%; over $600,000, 10%; if
these conditions are not met, 0% should appear. What type of
function should you use to solve this case?

Question 1 options:

Nested conditional functions

Multiple conditional functions

Search functions SearchV

Combined conditional functions

Question 2(0.5 points)

The sales department of the company ABC, requires to make


a series of controls so that when the user enters the values
or information, he avoids to the maximum the errors and
that Excel indicates him in case of committing them. Which
Excel tool would we use in this case?

Question 2 options:

Data validations By list, By integer, By date, By text length, custom.

Conditional formats

Data Search
Messages in each of the headings indicating that you must type in

Question 3(0.5 points)

ABC's accounts receivable department needs to find the


customer's name, the quantity of products purchased, the
description of the product and the invoice total; only the
customer's Nit number is available. Which of the following
functions is the most appropriate to know the information?

Question 3 options:

Searchav

Searchv

Find

Consult

Question 4(0.5 points)

The payroll department of ABC Company wishes to reward


employees who meet the following conditions, who live
outside Bogota, with children, with incomes of less than
$1,500,000 and with monthly sales of more than
$25,000,000, if you meet all these conditions you will get an
extra bonus of $250,000 and it will be reflected in the next
payroll payment. What function or functions could we use to
solve this case?

Question 4 options:
Using nested conditionals

Use Data Search and Validation Functions

Use Conditional If - OR Functions

Use Conditional If - And Functions

Question 5(0.5 points)

In the company they have different versions of Office on


their computers, they have developed a table formulated
with vertical searches, for the 2010 version, what is the
function to be used?

Question 5 options:

BuscaraV

QueryV

FindV

Consult

Question 6(0.5 points)

The following image represents a data validation. What type


of validation is being applied?
Question 6 options:

Allows you to type text of any size.

Limits text input to 25 characters.

Allows text input up to 25 characters plus numbers without any limit.

Limits number entry only.

Question 7(0.5 points)

7. Creating a custom rule with the function =ESTEXT, as


shown in the image, allows us to:
Question 7 options:

Limit input to text only in cell A1.

It does not allow text input.

Limits the input to number only.

It is not an allowed validation.

Question 8(0.5 points)

Applying the
formula

in the tuition discount column as shown in the image, the


student will receive a discount of
Question 8 options:

40%

80%

25%

No Scholarship

Question 9(0.5 points)

Elaborating the formula

in the rating column as shown in the image the result is


EXCELLENT:
Question 9 options:

True
False

Question 10(0.5 points)

Running the formula

According to the image the correct answers would be:


Question 10 options:

Fail, Pass, Pass, Merit, Outstanding.

Pass, Fail, Merit, Outstanding.

Fail, Outstanding, Pass, Merit.

None of the above.

You might also like