Friday, October 27th

October 27, 2017 8:26 AM

Landon and Charles will present news articles today.

Any questions on Criterion B?

Formula Auditing, Ctrl + `
Working with mutliple sheets - formatting cells, stretching, autosum, autofill, formulas - Watch the Lynda.com video - Excel 2013: Advanced Formulas and Functions with Dennis Taylor - Chapter 1 - Creating 3D Formulas to gather data from multiple sheets

Excel Quiz #1

Complete Excel Exercises Part 1

What if analysis - goal seek, scenarios and data tables - Begin Excel Exercises Part 2

What If - data table demo, VLOOKUP function

Review of Absolute References (F4), Formula Auditing(ctr +`), Numbers vs Labels('), Inserting a line break in a cell (alt + enter), #######
What if Functions - Scenarios, Goal Seek
Review of Spreadsheet options - working with natural language formulas, naming cells, multiple sheets

Begin Excel Exercises Part 2

Homework

Key terms—cell, cell format (number, text, value, function, calculation, date, currency), row, column,
label, macro, replicate, template, worksheet, “what if” questions, range, absolute and relative reference

Continue work on Criterion B - Analysis - did you find the speed of your home connection? The specs of your home PC? What will you use for backup of your files? This will be due Wednesday.

Review Excel terms and concepts

What

3.8 Spreadsheets, modelling and simulations - pages 35-36

The increasing capabilities of computers have allowed individuals and organizations to develop software
that can be used to test “what-if” scenarios and create simulations and models of real-world events.
Spreadsheets, through the use of worksheets and graphs, can be used to manage, predict using a series of
“what-if” scenarios, and display financial details of businesses.

Theoretical and practical concepts for spreadsheets
• Cell types: for example, text, number, date, currency, hyperlinks
• Formulas: relative and absolute cell references
• Sorting, filtering and replicating data
• Types of charts
• Formatting and presentation: for example, text (fonts), background, paragraphs, pages
• Data validation, verification and testing
• Functions: maths, text, logic, date
• Protection for sheets and workbooks, cell locking
• Advanced functions: for example, lookup, pivot tables, macros
• Worksheet modelling: “what-if” analysis (scenarios, goal seek tool)

Why

Understanding what your operating system allows you to take full advantage of all of the features it offers. Being able to make use of different interfaces allows greater access to the capabilities or your computer.

How

By being able to install hardware devices and the required drivers for that hardware.