Montgomery College 2017-2018 Catalog 
    Jun 20, 2024  
Montgomery College 2017-2018 Catalog [ARCHIVED CATALOG]

Add to Favorites (opens a new window)

CMAP 252 - Spreadsheet Applications

Provides study in the creation, design, and use of spreadsheets for business applications. Emphasis focuses on formatting and enhancing spreadsheets, maintaining workbooks, working with lists, using appropriate functions, interpreting data, and template design. PREREQUISITE(S): CMAP 120  or consent of department. Three hours each week. Formerly CA 252.

3 semester hours

Course Outcomes:
Upon course completion, a student will be able to:

  • Apply alignment and font style formatting.
  • Apply font color and fill color.
  • Create and print a Bar and a Pie Chart, using data from the spreadsheet.
  • Create and run a Macro within spreadsheets.
  • Create and save an income/expense spreadsheet for a business
  • Format the spreadsheet for currency, numbers, dates, and percentages.
  • Sort a column in a spreadsheet in ascending order
  • Write a formula using the IF, PMT, Sum, Average, Max, and Min Function.

View Schedule of Classes

Add to Favorites (opens a new window)