INFO15C
Module 15C: Spreadsheets C (Core)
Outcome
Create and manipulate spreadsheets using a variety of functions and formats for various purposes.
Indicators
(a) Demonstrate basic data entry and manipulation in spreadsheets.
(b) Describe the benefits of a separate number pad when working in a spreadsheet program.
(c) Generate spreadsheets that contain cells with all three types of information (label, value, formula) to build documents such as invoices, gradebooks or scoresheets.
(d)

Apply basic cell and document formatting features such as:

  • changing font attributes (e.g., size, style, colour, underline, bold, italics);
  • changing cell attributes (e.g., number category, alignment, fill, borders);
  • adding or removing headers and footers; and,
  • changing the page layout (e.g., margins, orientation, paper size).
(e)

Edit simple spreadsheets by:

  • making corrections;
  • applying the text to columns function;
  • inserting and deleting rows or columns;
  • combining multiple columns into one;
  • moving and copying formulas, rows and columns; and,
  • performing calculations and recalculations.
(f) Identify common error values (e.g., ######error, #Name?error, #VALUE!error, #REF!error) and how to fix them.
(g) Differentiate between absolute and relative cell references.
(h) Explain how an IF function can be used to solve a problem on a spreadsheet.
(i) Compare characteristics of different views (e.g., print view, frozen panes) of a spreadsheet.
(j) Change the print orientation and margins of a worksheet for optimal viewing and information retrieval.
(k) Print a specific set of cells or a segment of a worksheet.
(l) Perform actions such as printing, copying, pasting and undoing, using keyboard shortcuts.
Loading...
R012546
Excel 2019 in Easy Steps
This resource offers information about Excel 2019 for introductory to advanced levels. It can serve as a reference book to guide learners to use the functions and features of Excel by following the basic instructions and visual supports provided.
Media and Formats : Book
Price : $23.95
Record posted/updated: December 8, 2021
R022403
Office 2019 in Easy Steps
The key features of five Microsoft Office 2019 programs - Word, Excel, Access, PowerPoint and Outlook - are presented in this resource. Instructions for creating and managing files and data in all programs, as well as time-saving shortcuts, provide a good introduction to effectively using the core applications in Microsoft Office 2019.
Media and Formats : Book
Price : $23.95
Record posted/updated: February 22, 2022
R012465
Microsoft Excel 2019 Bible
This book sequences beginner to advanced skills using Excel. The resource offers many supportive graphics and concise language to explain tutorials on specific topics. An extensive table of contents and index are included.
Media and Formats : Book
Price : $66.00
Record posted/updated: December 7, 2021
R012466
Microsoft Excel 2019: Data Analysis and Business Modeling(6th ed.)
This resource provides advanced and comprehensive information about Microsoft Excel 2019 in the context of business. It contains concise directions to use the various functions and offers problems for practice at the end of each chapter. There are practice and solution files available on a companion website. An extensive table of contents and index are included.
Media and Formats : Book
Price : $58.40
Record posted/updated: December 7, 2021
R014656
Microsoft Excel 365 Complete in Practice 2019
This resource provides complete guide to becoming proficient is using the Microsoft Excel 365 program. Students could use this as a textbook, or the teacher could incorporate sections into a course.
Media and Formats : Book
Price : See publisher.
Record posted/updated: June 16, 2022
R012545
Microsoft Office 365 and Office 2019 Introductory
This book goes through very detailed instructions of three projects in each of the following programs: Word, Excel, Access, and PowerPoint. Many graphics and screenshots are provided to accompany the text. It would be most suited for a student or teacher who was unfamiliar with these programs.
Media and Formats : Book
Price : $149.95
Record posted/updated: December 7, 2021
R022893
Your Office. Microsoft Office 365 Excel 2019 Comprehensive
This spiral bound reference book provides a thorough exploration of Microsoft Excel 2019 and its features. Each chapter offers accessible online projects that use real world and business scenarios. The step-by-step tutorials provide hands-on learning. Supplemental instructor resources are available.
Media and Formats : Book
Price : $199.99 USD
Record posted/updated: December 8, 2021
R011308
Microsoft Office 365 Excel 2016. Introductory
This concise spiral-bound resource can be used as a tutorial to learn about the features of Microsoft Excel 2016 at an introductory to intermediate level. It starts with the basics of Excel 2016 and then guides the user on how to begin a spreadsheet, working with formulas and functions, formatting, working with charts and analyzing data using formulas within Excel. There are opportunities to practise, review and apply skills at the end of each module.
Media and Formats : Book
Price : $95.95 USD
Record posted/updated: December 8, 2021
R022895
Go! with Microsoft Office 365: Getting Started(2019 ed.)
This guide provides an overview of how to use Word, Excel, Access and PowerPoint at introductory and intermediate levels, using real life projects to practice and learn the software features. It functions as a step-by-step visual tutorial and has features such as chapter summaries and reviews, project guides, and a glossary. There are instructional components available on the publisher’s website.
Media and Formats : Book
Price : $174.99
Record posted/updated: December 8, 2021
R014931
Microsoft Office 365: A Skills Approach(2019 ed.)
This spiral bound reference book provides a thorough exploration of Microsoft Office 365 and its features. There are sections dedicated to Office, Word, Excel, Access and PowerPoint. Each one has chapters that explore the basics of how to get started and how to format and apply some of the features of the programs in a progression from beginner to advanced levels. Detailed instructions with visual support are provided throughout the resource. There are chapter summaries, guided practice, and independent and challenge projects. Practice files are available on the publisher's SIMnet online platform.
(More information)
Media and Formats : Book
Price : $175.33 USD
Record posted/updated: December 8, 2021