Excel 2016 (MOS) 77-727 Exam

Explore completing project one in Excel 2016 MOS by creating a forecast worksheet, adjusting tab colors, auto-fitting columns, moving sheets, adding a hyperlink, hiding data, and updating document properties.

Import more cars.csv into the car worksheet using comma delimiter and auto fit; then unhide scholarship, hide rows, delete column I, and repeat column A on every page.

Master managing data in Excel 2016 by inserting and formatting data in cells and ranges, autofilling formulas without changing formatting, merging and wrapping text, and creating spark lines and subtotals.

Explore the Excel 2016 project 3 tutorial to merge across without changing alignment, replace colors, wrap text, apply conditional formatting, copy ranges between sheets, and use subtotals with page breaks.

Learn to create and manage Excel tables in MOS 77-727 by converting structured ranges, applying table styles, and using filter, sort, total row, and remove duplicates.

Explore Excel functions and formulas to summarize data with max and average, perform conditional logic with IF, COUNTIF, and SUMIF, and use LEFT to modify text in sales data.

Master text functions in Excel 2016 MOS 77-727, including proper case, upper and lower, concatenation with spaces or hyphens, and left/right substring operations using the insert function dialog.

Learn how to summarize data in Excel using count, counta, average, max, and min, with practical examples like counting students and computing exam averages, highs, and lows.

Master conditional functions in Excel for the MOS 77-727 exam by using if, sumif, countif, and averageif to analyze Alberta sales data, test formulas, and display results.

Learn five updated excel functions for the 2016 MOS exam, including if for inventory alerts below 15 percent, upper around left, count blanks, concatenate emails, and absolute references for multiplication.

Learn to create and format charts and insert objects in Excel, including switching row and column data, adding series, formatting elements, moving charts to sheets, inserting pictures with alt text.

Format charts in Excel by applying layout eight, adding a right legend, and labeling the vertical axis, then insert a Pareto chart on a chart sheet named T Sales.

Master seven Excel chart tasks for the MOS exam, including creating a clustered column chart from nonadjacent ranges, swapping axes, and adding titles and data labels.

Discover how to master the updated Excel 2016 MOS practice exam by applying conditional formatting, filtering data, using the if and max functions, and quickly building totals and name ranges.