Lernkarten

Marco Wernli
Karten 43 Karten
Lernende 2 Lernende
Sprache English
Stufe Universität
Erstellt / Aktualisiert 23.01.2021 / 28.01.2021
Lizenzierung Keine Angabe
Weblink
Einbinden
0 Exakte Antworten 1 Text Antworten 42 Multiple Choice Antworten
Fenster schliessen

Descriptive analytics ...

... can predict risk and find relationships in data not readily apparent with traditional analyses.

... helps companies classify their customers into segments to develop specific marketing campaigns.

... helps detect hidden patterns in large quantities of data to group data into sets to predict behavior.

... can use mathematical techniques with optimization to make decisions that take into account the uncertainty in the data.

Fenster schliessen

Which of the following is an example of a measure of continuous metrics? 

four errors revealed in an invoice

a delivery delayed by seven days

weight and volume of a sheet of steel

three incomplete orders on a day

Fenster schliessen

Which of the following is the mathematical model for deriving total cost of only manufacturing? 

TC = VC + (C × Q)

TC = F + (C × Q)

TC = F + C

TC = F + (V × Q)

Fenster schliessen

Which of the following ways would 102 × 53/100 - 73 be represented in an Excel spreadsheet?

10(2) * 5(3) / 100 ^ 73

10(2) ^ 5(3) / 100 - 73

10^2 * 5^3 / 100 - 73

10*2 ^ 5*3 / 100 - 73

Fenster schliessen
Lizenzierung: Keine Angabe

Below is the spreadsheet for demand prediction of a company that sells chocolates.

Given that D = a-bP, where D, is demand, "a" and "b," are linear constants, and P, is price, from the below spreadsheet, how will the formula in B9 be represented in Excel using relative addressing? 

B4-B5*A9

C5-C6*A10

B4-B5*A10

B5-B6*A10

Fenster schliessen

Which EXCEL function is used to find the largest value in a range of cells?

SUM(range)

COUNT(range)

MAX(range)

COUNTIF(range, criteria)

Fenster schliessen

________ is a logical function that returns one value if the condition is true and another if the condition is false.

OR(condition 1, condition 2…)

AND(condition 1, condition 2…)

TO(value if true, value if false)

IF(condition, value if true, value if false)

Fenster schliessen

 If cell G7 contains the function ________, it states that if the value in cell C3 is 9, the number 7 will be assigned to cell G7; if the value in cell C3 is not 9, the number 4 will be assigned to cell G7.

=IF(G7=9)(G7=7)=OR(G7=4)

=IF(G7=7)=THEN(C3=9)=OR(C3=4)

=IF(C3=9)(C3=7)=OR(C3=4)

=IF(C3=9,7,4)