Quizzes

© Saylor Academy 2010-2024 except as otherwise noted. Excluding course final exams, content authored by Saylor Academy is available under a Creative Commons Attribution 3.0 Unported license. Third-party materials are the copyright of their respective owners and shared under various licenses. See detailed licensing information. Saylor Academy®, Saylor.org®, and Harnessing Technology to Make Education Free® are trade names of the Constitution Foundation, a 501(c)(3) organization through which our educational activities are conducted.

Course Syllabus

PRDV006: Spreadsheets II: Formatting and Functions

COURSE INTRODUCTION

Course Syllabus

Unit 1: Formatting Spreadsheets

1.1: Formatting Cells and Numbers

1.2: Formatting Worksheet Tabs

1.3: Conditional Formatting

Unit 2: Mathematical Computations

2.1: Formulas

2.2: Statistical Functions

2.3: Functions for Personal Finance

Unit 3: Logical Functions

3.1: Logical Functions

3.2: Statistical IF Functions

Unit 4: Lookup Functions

4.1: Lookup Functions

4.2: Web Queries

4.3: Goal Seek

4.4: Printing Formulas and Functions

Unit 5: Multi-Page Spreadsheets

5.1: 3D Formulas

5.2: Formulas Across Workbooks

Course Feedback Survey

Certificate Final Exam

Quizzes