Business 91L

Business Productivity Tools

Office 2010

 

Challenge Exam file� challengeF14.xlsx

 

Office 2003 Textbook����������� Office 2007 Textbook

Office 2010 Textbook ���������� Excel Fundamentals

 

The schedule is found at the bottom of this webpage. It includes links to the syllabi.

 

Challenge Exam

A challenge exam is given at the start of each semester.

You must be enrolled in the course before taking the challenge exam.

Students are NOT required to take the exam - the exam is voluntary.

Students who are proficient in Excel should take the exam.

Students who pass the exam will receive course credit and will not attend classes.

Students who fail the exam attend classes. There is no penalty for failing the exam.

Challenge exams will only be offered during the first weekend of the semester.

We do not offer individual challenge exams.

 

Spring 2015 Exam Dates: January 31 or February 1

Both exams will be given using Office 2010 software.

 

Exam Information

 

�To register for the exam, send an email to mike.splane@sjsu.edu

Use �Exam Registration� as the title of the email.

In the email include your name, section number and student ID number.

Important: If you have a disability that would require extra time for the exam - do not sign up through email.

Go to the Accessible Education Center in ADM110 to arrange for an alternative time and place to take the exam�

 

Study Guide for Excel Challenge Exam

Formulas and Formatting Tools

Write simple formulas (equations) using both numbers and cell references (variables).

Replace formulas with their values using Paste Special.

Add comments to cells.

Freeze columns and rows so they remain on screen at all times.

Use the AutoSum icon functions SUM, AVERAGE, COUNT, MINIMUM, and MAXIMUM.

Create a macro. Create a button to run a macro.

Functions

Define a name for a range of cells and use it in a function.

Write an IF Function to select between two formulas based on a variable.

Use the SUMIF, COUNTIF, and AVERAGEIF functions.

Create a LOOKUP Function and combine it with a data validation list.

Create a VLOOKUP Function and an HLOOKUP Function

Use statistical functions: Mode, Median, StdDev

Use rounding functions.

Use the RAND function to create a list of random numbers.

Data Tools

Sort data numerically and alphabetically, using either single or multiple levels.

Apply, modify, customize, and remove a filter.

Apply, modify and remove subtotals.

Pivot Tables

Create a Pivot table in a new worksheet.

Use the Pivot Table Fields dialog box. Use the Value Field Settings dialog box.

Add slicers and or filters to a pivot table.

Create a pivot table sub-report.

Visual Data Display

Use conditional cell formatting to visually represent data.

Create charts. Select ranges from different areas on the worksheet using the control key.

Use the tools on the chart tools design and charts tools layout tab.

Add textboxes, clip art, and graphics to charts.