Microsoft Excel 2013 Expert Part 1 Questions and Answers
Question 1
Apply conditional formatting using a formula.
Cell range B5:I299
Apply if "Date" (column D) is a Saturday or Sunday
Function WEEKDAY (return MONDAY as 0)
Formatting Bold and Single Underline
Options:
Answer:
Answer:
Use the following steps in explanation.
Explanation:
Explanation:
Step 1:In the name box type B5:I299 (orClick cell B5, shift-clickcell I299).
Step 2:On the Home tab, select Conditional Formatting, and click New Rule
Step 3:In The Edit Formatting Rule dialog box select Use a formula to determine which cells to format, type the formula:=WEEKDAY($D5,2)>5, and click the Format button.
Step 4:In the Format Cells dialog box select bold, Underline Single, and click OK.
Step 5:In The Edit Formatting Rule dialog box click Ok.
