Skip to main content
iRubric: Excel in Accounting rubric

iRubric: Excel in Accounting rubric

find rubric

(draft) edit   print   share   Copy to my rubrics   Bookmark   test run   assess...   delete   Do more...
Excel in Accounting 
Excel in Accounting
Excel Spreadsheet: Open and save a workbook, enter labels and values, edit cell entries, enter formulas, create complex formulas, use Excel functions, format values, use fonts and font sizes, adjust column widths, generate totals with AutoSum, display and print formula contents, preview and modify a worksheet.
Rubric Code: UX55C84
By AAAtrainer
Draft
Public Rubric
Subject: Accounting  
Type: Project  
Grade Levels: Undergraduate

Powered by iRubric Technology-Excel
Creating, formating and printing spreadsheet.
  Highly Competent

3 pts

Competent

2 pts

Not Competent

1 pts

Correct data entered

Data and labels are accurate and located in the appropriate cells.
Highly Competent

All of data is entered correctly.
Competent

Some of data is entered correctly.
Not Competent

Most of data is not entered correctly.
Formulas are correct.

AutoSum, appropriate use of perenthesis, and Min, Max, Subtraction functions are correct.
Highly Competent

All of the formulas used are applied correctly.
Competent

Some of the formulas are applied correctly.
Not Competent

Most of the formulas used are applied incorrectly.
Column headings and formats.

The column headings are formatted in bold, as well as totals.
Highly Competent

All of the data is formatted correctly, including applying bold to all of the column headings and to Totals.
Competent

Some of data,column headings, and totals. are in appropriate size and font.
Not Competent

Most of data, column headings and totals are not in appropriate size and font.
Titles are merged & centered

Highly Competent

Title is merged and centered, underlined, bold.
Competent

Title is not merged and centered, or underlined, or bold and 12 point font were not applied. but one of the two is present.
Not Competent

Title is not merged and centered, and appropriate formatting is not present.
Spread sheet Formatting & Printing

Correct print area & print features showing. Reveal formulas function used and column widths allow for complete viewing of the contents.
Highly Competent

Correct print area, Gridlines, and Row and Column Headings features. Reveal formulas function used and column widths adjusted so that entire formulas are visible. Paper set to print in Landscape, or Portrait as appropriate.
Competent

Partially correct print area, Gridlines, or Row and Column Headings used. Reveal formulas feature partially used. Some column widths not adjusted to reveal all formulas. Paper may not be set properly.
Not Competent

Incorrect print area, no Gridlines, or Row and Column Headings selected. Reveal formulas function not present. Majority of column widths not adjusted to print entire formulas. Paper not set properly.
Chart / Graphs

The appropriate Graph or Chart is shown to display data in most efficient manner
Highly Competent

Excellent choice of Chart/Graph to display this type of information.
Competent

Reasonable choice of a Chart/Graph to display this type of information.
Not Competent

Improper choice of Chart/Graph to display this type of information.



Keywords:
  • cell, row, column, merge and center, format



Discuss this rubric




Do more with this rubric:
Preview

Preview

Preview this rubric.
Edit

Edit

Modify this rubric.
Copy

Copy

Make a copy of this rubric and begin editing the copy.

Print

Print

Show a printable version of this rubric.
Categorize

Categorize

Add this rubric to multiple categories.
Bookmark

Bookmark

Bookmark this rubric for future reference.
Assess
This rubric is still in draft mode and cannot be scored. Please change the rubric status to ready to use.
Share
Publish

Publish

Link, embed, and showcase your rubrics on your website.
Email

Email

Email this rubric to a friend.
Discuss

Discuss

Discuss this rubric with other members.
 

Do more with rubrics than ever imagined possible.

Only with iRubrictm.


Copyright © 2024 Reazon Systems, Inc.  All rights reserved.
n16