Homework_1_Answer_Key

pdf

School

Clark University *

*We aren’t endorsed by this school

Course

250

Subject

Electrical Engineering

Date

Apr 3, 2024

Type

pdf

Pages

Uploaded by CorporalGiraffePerson967

9/20/23, 10 : 23 PM Quizzes - Build Page 1 of 9 https://newhaven.quiz-lti-iad-prod.instructure.com/build/8171 ? Multiple Choice 0.2 points Questions 1 Why would you use VLOOKUP instead of XLOOKUP ? You need to search horizontally instead of vertically. You are working with an old Excel version. You require more flexibility in your lookup. 1

9/20/23, 10 : 23 PM Quizzes - Build Page 2 of 9 https://newhaven.quiz-lti-iad-prod.instructure.com/build/8171 ? Multiple Choice 0.2 points Questions 2 How would you fill the remainder of column C with the formula in cell C2 ? Edit the formula to include references to cells in column C Double-click on the column header. Click on the bottom-right corner of cell C2 and drag the length of the column. Copy and paste the formula into the remaining cells of the column. 2

9/20/23, 10 : 23 PM Quizzes - Build Page 3 of 9 https://newhaven.quiz-lti-iad-prod.instructure.com/build/8171 ? Multiple Choice 0.2 points Questions 3 What does =VLOOKUP(Lucas,B:E,4,FALSE) return from this sheet? (177) 816-3420 Hawaii Idaho Inactive 3

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

9/20/23, 10 : 23 PM Quizzes - Build Page 4 of 9 https://newhaven.quiz-lti-iad-prod.instructure.com/build/8171 ? Multiple Choice 0.2 points Questions 4 When would XLOOKUP("test",J:J,A:A,"Result",0,1) return a value of Result? when A is longer than J when there is no match when the function executes successfully 4 Multiple Choice 0.2 points Question 5 How would you specify the entire column of telephone numbers as the return array in the XLOOKUP function for this sheet? 5

9/20/23, 10 : 23 PM Quizzes - Build Page 5 of 9 https://newhaven.quiz-lti-iad-prod.instructure.com/build/8171 ? C C0:C* C:C C1-C999

9/20/23, 10 : 23 PM Quizzes - Build Page 6 of 9 https://newhaven.quiz-lti-iad-prod.instructure.com/build/8171 ? Multiple Choice 0.2 points Question 6 What is the potential problem with specifying columns in a function call such as XLOOKUP("test",J:J,A:A,"Result",0,1) ? The columns may be too long. The column headers may be included in the ranges. The columns are not in left-to-right order. 6 Multiple Choice 0.2 points Question 7 Which formula returns " Alaska " from this sheet? 7

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

9/20/23, 10 : 23 PM Quizzes - Build Page 7 of 9 https://newhaven.quiz-lti-iad-prod.instructure.com/build/8171 ? =XLOOKUP("Inactive",F:F,E:E,0,0,0) =XLOOKUP("active",F:F,E:E,1,0,1) =XLOOKUP("Inactive",F:F,E:E,0,-1,1) =XLOOKUP("Inactive",F:F,E:E,0,0,1)

9/20/23, 10 : 23 PM Quizzes - Build Page 8 of 9 https://newhaven.quiz-lti-iad-prod.instructure.com/build/8171 ? Multiple Choice 0.2 points Question 8 When would you use a PivotTable ? When you need formulas that are conditional and help summarize your data. When you need to summarize a bunch of data. When you need several charts that all pivot around conditional formulas you type yourself. When you need to create a bunch of formulas that help you pivot the data. 8 Multiple Choice 0.2 points Question 9 What is the primary reason to turn your data into a Table prior to creating a PivotTable ? A table is an excellent target for a PivotTable to leverage. The table is what allows you to filer your data. The colored rows make the data easier to read. 9

9/20/23, 10 : 23 PM Quizzes - Build Page 9 of 9 https://newhaven.quiz-lti-iad-prod.instructure.com/build/8171 ? Multiple Choice 0.2 points Question 10 By default, where will Excel put a new PivotTable ? On a new sheet, to the left of the current sheet. On a new sheet, at the very end of the sheets. On the current sheet. On a new sheet, to the right of the current sheet. 10

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version