šŸ·ļø LIMITED TIME OFFER: GET 20% OFF GRADE+ YEARLY SUBSCRIPTION ā†’
Log in
Computer Science
11
answers
0
watching
265
views
1 Sep 2018

4. Assume an Excel 2010 worksheet contains the grades (in percentage) for Test 1 of students in EECS1520. We are asked to use an Excel function to count the number of students who scored more than 60%. Assuming there is one grade per student in the worksheet which Excel function do you use? a) SUM b) COUNTIF X c) AVERAGE d) MAX e) None of the above

word_media_image1.png
Watch
11
answers
0
watching
265
views

For unlimited access to Homework Help, a Homework+ subscription is required.

Unlock all answers

Get 1 free homework help answer.
Already have an account? Log in
Share
Already have an account? Log in
Share
Already have an account? Log in
Share
Already have an account? Log in
Share
Already have an account? Log in
Share
Already have an account? Log in
Share
Already have an account? Log in
Share
Already have an account? Log in
Share
Already have an account? Log in
Share
Already have an account? Log in
Share
Deanna Hettinger
Deanna HettingerLv2
2 Sep 2018
Already have an account? Log in
Share

Related questions

1.Create a list that contains 10 successive integers starting with the value in the variable start. For example, ifĀ startĀ is 7, the resulting list should be [7, 8, 9, 10, 11, 12, 13, 14, 15, 16]. Store the list in a variable namedĀ my_list. Assume that the value ofĀ startĀ has already been set.
Ā 
2.Create a list that is made up of the first half of the elements of a list called original_list. Store the new list in a variable calledĀ half_list. Assume that the original list has already been initialized and contains an even number of elements.
Ā 
Ā 
3. Write a predicate function called same_endsĀ that accepts a list of integers and an integer (n) as arguments. ReturnĀ TrueĀ if the first n numbers in the list are the same as the last n numbers in the list, andĀ FalseĀ otherwise. For example, if the list was [1, 2, 3, 4, 99, 1, 2, 3, 4], the function would returnĀ TrueĀ if n is 4 andĀ FalseĀ if n is 3. Assume that n is between 1 and the length of the list, inclusive.
Ā 
4.Write a function calledĀ highest_valuesĀ that accepts as arguments a list of numeric values and a single integer (n). The function should return a list made up of the largest n values from the argument list in order from lowest to highest. For example, if the argument list is [46, 82, 25, 61, 70, 33, 54] and n is 3, the return value should be [61, 70, 82]. Assume that the argument list contains at least n elements.
Ā 
5.Assume that a list of integers stored in a variable named originalĀ contains exactly two elements that are zero. Write code that creates a separate list that contains the elements fromĀ originalĀ that are between the two zeros. Do not include the zeros in the new list. Store the list in a variable namedĀ between_zeros.
Ā 
6. Write a function called price_rangeĀ that accepts a list of floating-point numbers representing prices as an argument and returns the the difference between the highest price and the lowest price. Do NOT use the built-in functionsĀ maxĀ orĀ minĀ in your solution. Assume that all prices are positive values and that none of them exceed 10,000.00.
Ā 
7. Write a function calledĀ count_vowelsĀ that accepts a string argument that represents a word and returns the number of vowels that are in the word. The vowels are A, E, I, O, and U (ignore the 'sometimes Y' rule). Count both uppercase and lowercase vowels.
Ā 
8.
Assume that the variableĀ tableĀ holds a two-dimensional list of integers. Write code that computes the sum of all elements in the table, assigning the result to the variableĀ table_sum.

Ā 

Related Documents

KINE 2049 Lecture Notes - Syphilis, Urban Legend, Nuremberg Code
lavenderbeaver438
EECS 1520
Final Exam
Study Guide
EECS 1520 Study Guide - Lanthanum Hexaboride, Sports League, Literacy Test
salmongoose71
EECS 1520 Chapter Notes - Chapter 6: Lookup Table, Literacy Test, Lanthanum Hexaboride
emeraldmoose978

Weekly leaderboard

Home
Homework Help 3,900,000
Computer Science 2,000
Start filling in the gaps now
Log in