Question: If the date formatting code ddd mmm d is applied to a cell containing the date 2/4/2023 , the worksheet will display: Sat Feb 4

  1. If the date formatting code ddd mmm d is applied to a cell containing the date 2/4/2023, the worksheet will display: Sat Feb 4
    1. True
    2. False
  2. Using serial numbers for dates allows Excel to use dates to perform calculations, such as subtracting one date from another to find the number of days between the two.
    1. True
    2. False
  3. The serial number for a day is counted as 1; therefore, 12 hours, or half a day, is counted as 0.5.
    1. True
    2. False
  4. If you enter the formula =TODAY() on December 16 and reopen the Excel file the next day, the cell will show the date December 17.
    1. True
    2. False
  5. Sharon wants to automatically add eight days to her customers order dates to calculate the expected delivery date. If the order date is in cell B7, the formula will be =B7+8.
    1. True
    2. False
  6. Fred created two conditional formatting rules, one to highlight the top three salespeople for the month and another to show who sold more than $25,000 in the month. He wants to rearrange how the rules are applied so the top three are highlighted, even if they have also sold over $25,000. Fred should use the Conditional Formatting Rules Manager.
    1. True
    2. False

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!