Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

7. Match each custom date format to its example. FORMATS A. mmmm d, yyyy B. m/d C. mmm d D. ddd, mmm dd, yyyy

image text in transcribed

7. Match each custom date format to its example. FORMATS A. mmmm d, yyyy B. m/d C. mmm d D. ddd, mmm dd, yyyy RESULTS 1. Fri, Apr 20, 2019 2. April 20, 2019 3. Apr 20 4. 4/20 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Paul M. Fischer, William J. Tayler, Rita H. Cheng

11th edition

538480289, 978-0538480284

More Books

Students also viewed these Accounting questions