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
- 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
- True
- False
- 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.
- True
- False
- The serial number for a day is counted as 1; therefore, 12 hours, or half a day, is counted as 0.5.
- True
- False
- 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.
- True
- False
- 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.
- True
- False
- 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.
- True
- False
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
