| Creating an Excel Spreadsheet |
| (2 pts) Research a topic which will provide a source of numeric facts. Below the spreadsheet each source is to be documented (eg. Web URL, last updated, Keyword or link used, author, etc) (2 pts) Create a title for the entire spreadsheet that explains its subject. Include the use of Merge and Center. (14 pts) Key in numeric data to fill 6 rows by 8 columns (8 rows by 6 columns) This data does not include formulas, titles or column and row descriptions. The spreadsheet data may contain subsections to make up one worksheet. (4 pts) Identify data with row and column headings/descriptions (8 pts) Include 4 different (types) formulas (3 pts) Include an "If" statement (3 pts) Include a pointer (2 pts) Adjust column and row widths to display all information (full text) (2 pts) Use one numeric format ($, %, etc) in the spreadsheet (2 pts) Apply vertical/horizontal borders to enhance the appearance without relying on color printing. (2 pts) Select and insert a graphic which is hyperlinked to www.microsoft.com (2 pts) Print entire spreadsheet in normal view--fit on one page (2 pts) Print in formula view--fit on one page (2 pts) Print a selected portion of the spreadsheet in normal view--fit on one page |