=IF(A51="Red","Yes","No") 15) If the formula in Cell D49 is copied to Cells E49:F49, what sequence of values would be generated in Cells D49:F49? D E F 42 Conference Room Location Staff ID 43 D East 19106 a. =B92/C92 Which formula can you type in Cell D92 to do this? 14) Based on the values in Cells A51:A55, what formula can you copy and paste into Cells B51:B55 to return the values shown? A B 51 Red Yes a. '=RIGHT(B23,C26) '=CONCATENATE(ITEM," ",TYPE) '=LEFT(B23,C23) '=CONCATENATE(B23,C23) '=CONCATENATE(B23," ",C23)ġ3) You need to divide the number of cars by the number of people to calculate cars per person on Day 1 A B C D 91 Day Cars People Cars per Person a. #VALUE 48 =COUNTIFS(C30:C34,"South",D30:D34,"19104")ġ2) Which tools would you use to make Chart 1 look like Chart2 Excel 2016 Test Topics: Tell Me Search Box in Excel - People Graph Add-In Excel - Map Chart in Excel - Quick. 26 Desk 11) What value would be returned based on the formula in Cell D49? D E F 42 Room Location Staff ID a. 22 Item F Door F =CONCATENATE(B23," ",C23) b. =Floor() 9) Which tools would you use to make Chart 1 look like Chart 2? Select all that apply. 4 47 norp =COUNTIF(B9:B13,"NP*")' 7) Which tools would you use to make header 1 look like Header 2? Select all that apply.Ĩ) Based on the values in Cells B77:B81, which function can automatically return the value in Cell C77? A B 2 Sales =MIN(A2:A6 3 $794 $721 ) a. Copy the formula to another cell $1,020 6) What value would be returned based on the formula in Cell A49? A a.
Move this cell to another location $854 d. Copy this number to other cells $721 $58 c. =Highest() 13 $1,020 5) What does clicking and dragging the fill handle indicated by the cursor do? Sales Tax $64 a. =’ALPHA’A1 4) Based on the values in Cells B77:B81, what function can automatically return the value in Cell C77? A 8 Sales 9 $794 $1,020 =MAX(A9:A13)' a. CTRL + V 3) In a new worksheet, what’s the correct formula to reference Cell A1 from the ALPHA worksheet? a.
Adds a new Column 2) What is the correct keyboard shortcut to cut a cell value? a. What’s the correct sorting function to list Colors in alphabetical order (A to Z) Color Number A to Z = ASCENDING Blue 120 Z to A = DESCENDING Green 85 EQUAL to A to Z Orange 112 Red 100 Yellow 90 1) What does clicking the + sign below do? a.
0 kommentar(er)
