FRANKLIN UNIVERSITY PROFICIENCY EXAM (FUPE)
-31753175PF 106 PROFICIENCY EXAM (FUPE) STUDY GUIDECourse Title:Introduction to Spreadsheets (PF 106)Recommended Textbook:Gaskin, S. and Vargas, A. (2020).?GO! With Microsoft Office 365, Excel 2019 Comprehensive, ISBN: 9780135442685 (print), 9780135442289 (eText)Number & Type of Questions:48 multiple choice (worth 1 point each), 32 true/false (worth 1 point each), 20 short answer/essay (worth 1 point each) for a total of 100 points. Questions are publisher questions taken from the book.Permitted Materials:NoneRequired Materials:NoneTime Limit: 1 hours, 30 minutesMinimum Passing Score: 75%Description of the Test:This exam covers the use of Microsoft Excel 2019/365. The questions cover creating a worksheet and charting data; using functions, creating tables, and managing large workbooks; analyzing data with pie charts, line charts, and what-if analysis tools; creating pivot tables and pivot charts; managing large workbooks and using advanced sorting and filtering; creating charts, diagrams, and templates; using financial and lookup functions, defining names, validating data, auditing worksheets; using the data analysis, solver, and scenario features, and building complex formulas. The purpose of this exam is to demonstrate that you have knowledge equivalent to what is taught in the course. Typically, students who take this exam have used Excel 2019/365 at work or have taken prior courses that use this application.Knowledge & Skills Required:Students taking this exam should be able to: Describe the appropriate use of a spreadsheet application.Identify and apply the basic operations of a spreadsheet.Apply formatting to enhance worksheets.Apply formulas in a spreadsheet.Use What-if and Seek functions to solve problems.Apply functions in a worksheet.Create appropriate charts to represent data.Summarize and organize data using multiple worksheets. ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- hardening microsoftoffice 365 proplus office 2019 and
- office 365 agency playbook det home
- office 365 for small businesses datasheet
- franklin university proficiency exam fupe
- introduction to spreadsheets with microsoft excel
- sharepoint configuration pickit the world s simplest
- outline template microsoft word
- communications guide for m365 2 17 21 oregon
Related searches
- franklin county senior options brochure
- franklin county senior options program
- franklin county municipal court records
- marriott hotels franklin ma
- franklin financial services corp
- ford motor credit franklin tn
- franklin ma hotels
- residence inn franklin ma
- franklin regional logo
- franklin ma teacher contract
- franklin covey mission statement
- franklin county auditor property search