Recent Lessons

Show all results for ""

ADM 1370 Week 5: Excel Formulas & Functions

17 Questions

1 Views

ADM 1370 Week 5: Excel Formulas & Functions

Choose a study mode

Play Quiz

Study Flashcards

Spaced Repetition

Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is a function in Excel?

A static number that cannot be changed
A cell reference in Excel
A random value generated by Excel
A named operation that returns a value (correct)

How are values passed to a function in Excel?

Through conditional statements
As cell references only
As literal values only
As parameters enclosed in brackets (correct)

What is the key difference between a value and a parameter in Excel functions?

Values refer to text while parameters refer to numbers
Values are static while parameters can change (correct)
Values are not used in functions, only parameters are
Parameters are defined within Excel, values are not

In Excel, what does the term 'Maximin' refer to?

A modeling approach to problem solving (B) Signup and view all the answers

Which of the following best describes the purpose of using functions in Excel?

To automate repetitive tasks and perform calculations (B) Signup and view all the answers

What is the purpose of Data Delivery functions in Excel?

Verifying data and delivering it from one point to another (B) Signup and view all the answers

In Excel, which function is used to filter and deliver unique values from a list?

Filter Unique Values function (A) Signup and view all the answers

Where are the compare values located in a lookup table?

In the first column or row (D) Signup and view all the answers

Which parameter in VLOOKUP and HLOOKUP functions is optional?

Range_lookup (B) Signup and view all the answers

What is the default assumption for the range_lookup parameter in VLOOKUP and HLOOKUP functions?

Closest match to the compare value (D) Signup and view all the answers

What does setting the range_lookup parameter to FALSE in VLOOKUP and HLOOKUP functions indicate?

You want an exact match to the compare value (C) Signup and view all the answers

What is the correct syntax for the AVERAGE function in Excel?

=AVERAGE(number1,number2,..) (D) Signup and view all the answers

Which function in Excel calculates the Pearson correlation coefficient?

=PEARSON(number1,number2,..) (B) Signup and view all the answers

What does the STDEV function do in Excel?

Calculates the standard deviation of a range of numbers (B) Signup and view all the answers

Why is it recommended to keep formulas simple in Excel?

To improve readability and ease of understanding (B) Signup and view all the answers

What is a good practice when using Excel functions?

Break formulas into smaller parts for better clarity (C) Signup and view all the answers

Which Excel function should be used to find the maximum value in a range of cells?

=MAX(range) (B) Signup and view all the answers