Answer:
Explanation:
To enter the reference to the total estimated cost in the appropriate location for the second data table and apply a custom number format to display Total Sq Ft in that cell, and apply Blue font and bold to that cell, you can follow the steps below:
Select the cell where you want to display the Total Sq Ft.
In the formula bar, type the formula "=SUM(D2:D10)" (assuming the data range is D2:D10). This will calculate the total square footage of the listed properties.
Press Enter to apply the formula and display the Total Sq Ft value in the selected cell.
With the cell still selected, go to the Home tab in the Ribbon and click on the Font Color dropdown arrow.
Choose the blue color from the color palette to apply the blue font color to the cell.
With the cell still selected, press the keys "Ctrl+B" or click on the Bold button in the Ribbon to apply bold formatting to the cell.
To apply a custom number format to the cell, right-click on the cell and select "Format Cells" from the context menu.
In the Format Cells dialog box, go to the Number tab and select "Custom" from the Category list.
In the Type field, type the following custom number format: "#,##0 Sq Ft"
Click OK to apply the custom number format to the cell.
Now the cell should display the Total Sq Ft in blue font and bold formatting with the custom number format applied.