2

.pdf

School

San Diego Miramar College *

*We aren’t endorsed by this school

Course

143

Subject

Computer Science

Date

May 5, 2024

Type

pdf

Pages

8

Uploaded by bluestar8292 on coursehero.com

10/23/2019 2.2 Quiz 2: Fall 2019 - CBTE 143 (15064 - online) https://sdccd.instructure.com/courses/2367155/quizzes/4888882?module_item_id=39022904 1/8 2.2 Quiz 2 Due Oct 24 at 11:59pm Points 20 Questions 20 Available until Dec 13 at 11:59pm Time Limit 60 Minutes Instructions Attempt History Attempt Time Score LATEST Attempt 1 37 minutes 19 out of 20 Score for this quiz: 19 out of 20 Submitted Oct 23 at 10:49pm This attempt took 37 minutes. Do not start the quizzes until you're ready. You will be given 1 hour to complete each quiz. You will have 1 attempt. 1 / 1 pts Question 1 Which of the following is not a valid lookup function? VLOOKUP LLOOKUP Correct! Correct! HLOOKUP LOOKUP 1 / 1 pts Question 2
10/23/2019 2.2 Quiz 2: Fall 2019 - CBTE 143 (15064 - online) https://sdccd.instructure.com/courses/2367155/quizzes/4888882?module_item_id=39022904 2/8 The default calculation using the PMT function will produce a negative number. True Correct! Correct! False 1 / 1 pts Question 3 How many functions does Excel provide? Over 4,000 Over 40 Unlimited Over 400 Correct! Correct! 1 / 1 pts Question 4 When entering functions, the square brackets, [], indicate required values. True False Correct! Correct! 1 / 1 pts Question 5
10/23/2019 2.2 Quiz 2: Fall 2019 - CBTE 143 (15064 - online) https://sdccd.instructure.com/courses/2367155/quizzes/4888882?module_item_id=39022904 3/8 Which of the following would not produce the correct monthly payment on a loan of $13,000 which will be paid off in 5 years with an annual interest rate of 6%? =PMT(.5%,60,-13000) =PMT(6%,60,-13000) Correct! Correct! =PMT(.5%,5*12,-13000) =PMT(6%/12,60,-13000) 1 / 1 pts Question 6 In the HLOOKUP function, the third argument is the column index number. True False Correct! Correct! 1 / 1 pts Question 7 What describes a function's purpose? Name Correct! Correct! Category Variables Arguments
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help