Would first time home purchase be a easy topic to meet the following workbook requirements? IF NOT what topic would you suggest? Start this project with a new “Blank Workbook” A minimum of TWO worksheets a. One of the two worksheets must be a chart b. At least 10 rows of data c. At least 4 columns of data Worksheet and Chart Titles Worksheet Tab Names Worksheet headers and/or footers Format a. Use 3 different Number formatting categories in your workbook other than General (i.e. text, number, currency, etc.) Use at least two functions other than what you see when you click on the arrow at AUTOSUM (i.e. COUNTIF, PMT FV, NOW, etc.) Must use the “IF function” to examine specific conditions and for assigning a value to a cell based on a logical test Apply Conditional Formatting to a range of cells Insert a background image or graphic on your chart (on your chart sheet) – NOT AS AN OBJECT IN THE SHEET Insert a comment on a worksheet Apply a style format to either a sheet or chart Column width should fit all the data so all data is displayed
Would first time home purchase be a easy topic to meet the following workbook requirements? IF NOT what topic would you suggest?
Start this project with a new “Blank Workbook”
A minimum of TWO worksheets
a. One of the two worksheets must be a chart
b. At least 10 rows of data
c. At least 4 columns of data
Worksheet and Chart Titles
Worksheet Tab Names
Worksheet headers and/or footers
Format
a. Use 3 different Number formatting categories in your workbook other than General (i.e.
text, number, currency, etc.)
Use at least two functions other than what you see when you click on the arrow at AUTOSUM
(i.e. COUNTIF, PMT FV, NOW, etc.)
Must use the “IF function” to examine specific conditions and for assigning a value to a cell
based on a logical test
Apply Conditional Formatting to a range of cells
Insert a background image or graphic on your chart (on your chart sheet) – NOT AS AN OBJECT
IN THE SHEET
Insert a comment on a worksheet
Apply a style format to either a sheet or chart
Column width should fit all the data so all data is displayed
Step by step
Solved in 2 steps with 2 images
