ASSESSMENT

COMPUTER PROFICIENCY
Challenge Exam: Spreadsheet

GUIDELINES

Using Microsoft Excel, each student must be able to:

• Create, modify and print (in both portrait and landscape orientation showing and/or hiding row and column headings and gridlines) a single spreadsheet file (given the necessary information). Within that file, students must produce and print two separate reports/layouts and one chart;
• Format cells/fields as appropriate and as indicated in the test directions including:
• adjusting row height and column width;
• configuring plain, bold, italic or underlined text in any required size of font
• entering dates using various formats;
• positioning centered, left or right justified (aligned) text;
• displaying numbers rounded to the proper decimal value and using commas, dollar signs and/or percents as necessary;
• Apply spreadsheet functions and/or formulas to derive all calculated values including counts, sums, differences, products, quotients, minimums, maximums, and averages;
• Enter calculated values in appropriate cells in accordance with the specified format;
• Display cells showing values (numbers) and formulas;
• Sort records by any field, both alphabetically and/or numerically in ascending or descending order;
• Use the filtering option of the program to select some records without deleting others;
• Hide/Delete specific columns;
• Create and print a report/layout that shows only selected fields and records without deleting other fields and records;
• Create and print a chart based on data included in the spreadsheet.

Calculators and mental calculations may not be used.