We use the SUMIF function when we need to calculate Total sales Sales attributable to a certain salesperson Sales occurring on a certain day of the week Average sales per month To assign data types to individual fields in MS Access, we have to enter Sheet view Form view Design view PK view Submit Quiz 2 of 8 questions saved 2 2 N Question 4 (0.5 points) Saved Listen Once the word "Alec" is displayed in cell D4, what formula must be entered in cell E4 to display the word "Baldwin". =RIGHT(C4,(FIND(C4)-LEN(D4))) =MID(C4,(INDEX(C4)-LEN(D4))) =LEFT(C4,(LEN(C4)-LEN(D4))) 2 =RIGHT(C4,(LEN(C4)-LEN(D4)))