BYSEX21C07SA
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
Correct!
Review the section "Applying Custom Date Formatting."
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.
Correct!
Review the section "Date Serial Numbers."
The serial number for a day is counted as 1; therefore, 12 hours, or half a day, is counted as 0.5.
Correct!
Review the section "Entering Time Information."
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.
Correct!
Review the section "Using Date Functions."
Sharon wants to automatically add eight days to her customer’s order dates to calculate the expected delivery date. If the order date is in cell B7, the formula will be =B7+8.
Correct!
Review the section "Calculations Using Date and Time."
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.
Correct!
Review the section "Using the Conditional Formatting Rules Manager."
If the serial number 1207 is a Tuesday, what day of the week would serial number 1210 be?
Correct!
Review the section "Date Serial Numbers."
What is the result of this formula in hours and minutes?
Cell A1: 6:00, cell B1: 8:30, cell C1: =B1-A1
Correct!
Review the section "Calculations Using Date and Time."
Which date will the formula =DATE(2017,7,2) return?
Correct!
Review the section "Using Date Functions."
To find the difference between two dates listed in years instead of days, use the _____ function.
Correct!
Review DYS E6-D4, step #14.
Which of these is FALSE regarding the Conditional Formatting Rules Manager?
Correct!
Review the section "The Conditional Formatting Rules Manager."
The Difference column is calculated as budget minus actual amount. If the actual rent increases to 26,000, which conditional formatting graphic(s) will change?
Portion of a worksheet with four columns, in which the first column shows the heading “Expenses” and three types of expenses: Bank, Insurance Fees, and Rent. The next three columns display actual, budget, and difference values with these conditional formatting applied: Data Bars displayed in the Actual column, color scales in the Budget column, and icons in the Difference column (green checkmarks for 0 and 100, and a red X for the negative value).
Correct!
Review the section "Conditional Formatting with Graphics."