Test Bank 5. What is the result when you enter =A1-B1 in cell C1? A. 3/16/2018 A 1/4/2018 71 B C B. 1 3/16/2018 1/4/2018 3/11/1900 A B C C. 1 3/16/2018 1/4/2018 =A1-B1 A B C D. 3/16/2018 1/4/2018 $71.00 6. How does the date 11-19-19 appear after entered in a cell? A. 11-19-19 B. Nov-19 C. 19-Nov D. November 19, 2019 E. 11/19/2019 7. Match each custom date format to its example. FORMATS RESULTS A. mmmm d, yyyy 1. Fri, Apr 20, 2019 B. m/d 2. April 20, 2019 C. mmmd 3. Apr 20 D. ddd, mmm dd, yyyy 4. 4/20 Enter Times 8. What do you enter before an AM or PM designation in a time entry? A. Colon. B. Semicolon C. Space D. Nothing 9. Josie types 6:00 in a cell and completes the entry without including an AM/PM designation. What appears in the cell? A. Jun-00 B. 6:00 AM C. 6:00 PM D. $6.00 10. How does Excel determine how the time is stored? A. It divides the day by 24 and calculates the percentage. B. It starts with a serial number, as with dates, and then subtracts the actual time. C. It divides the day by 1,440 and calculates the number of minutes. D. The time is stored exactly as entered. Excel 2019 & 365 Page 2 of 5