77-727 Excel 2016 Core Practice Tests and Video Solutions

Learn how to import a text file with headers into Excel 2016, specify comma delimiter, and create, rename, and position a flights worksheet for project 1.

explore income analysis in Excel 2016 by completing project 2 tasks: link destinations with hyperlinks, apply blue data bar conditional formatting, and extend charts by expanding the data range.

Perform a workbook-wide replace from mods to cops, set repeating print titles for pages, and use countif to count destinations with total sales greater than three hundred and fifty euros.

Rename the worksheet to clients, remove duplicates by base reason, insert a picture, rotate text 10 degrees, and sort the post table by surname z to a.

Configure a Power Pivot worksheet with freeze panes, set destinations in workbook properties, define a print area, count destinations over 100000 with countif, and concatenate headings with plus signs.

Learn to build a marketing budget in Excel 2016 by enabling a total row, creating a 3D clustered column chart, styling the table, and calculating six-year averages.

practice project 7 in Excel 2016 core provides training on removing rows, filtering data for Access and Excel courses, and building forecasts using absolute references and sums based on condition.

Create a new workbook from the employee time card template, verify the correct file, apply conditional formatting, adjust views and themes, select multiple sheets, and save as a PDF.

Excel 2016 tests cover revenue and maintenance tasks. Learn range selection, currency formatting, centering, and sorting by destination and flight number, linking to Q15 and euro formatting with no decimals.

Project 3 flight worksheet covers inserting a column, removing document properties, using average function for Heathrow, creating a 3D pie chart, and concatenating four letters of airports to form code.

Create the monthly revenue solution in Excel 2016 by building a sparkline from B3 to M3, inserting an image, and adding a footer with file name, path, and page numbers.

Practice applied Excel 2016 skills by editing pictures and charts, inserting text, using concatenate and proper to format staff names, computing profit contribution, and creating a named table with styles.

Learn to use the concatenate function to build flight identifiers, manage custom views and page layout in Excel, apply table styles, and filter records by passengers between 75 and 150.

Practice Project 7 in Excel 2016 core: delete comments on two flight sheet cells, set landscape orientation, and extract three characters from the destination starting at the second character.

Complete exam 3 project 1 in Excel 2016, shade every other row, hide rows 2–4, add trend analysis worksheet, set workbook title to data analysis, and add a summary column.

Sort a merchandise sales table by destination (A–Z) then by total sales (largest to smallest), delete column G, use IF to show Yes when D2>6, and add a total row.

Calculate average sales, apply proper to model names, convert table to range, create a 3d clustered chart of sales by model, and use averageif for stock over 1500.

Excel 2016 tasks: set decimals to 3, repeat row 1 on every page, set row height to 80, rename inventory list to stock items, add a hyperlink to stock source.

Apply conditional formatting to the age discount column for above-average values with green fill and dark text; use max for luggage, if role selection, and merge surnames for landscape printing.

Rename chart to actual versus estimated, swap rows and columns for the x axis, resize and move to worksheet called work tracking; insert image from student resources folder at 0,2.

Practice-focused project teaches creating sparklines to illustrate expense trends, duplicating summary worksheets, importing staff data, building a 3D pie chart of expense totals, and copying values between worksheets.

Explore zipped practice exams and video solutions for Excel 2016 core concepts, helping learners prepare for the 77-727 exam.

Access and organize zipped student resource files for Excel 2016 core practice tests and video solutions.

Explore the PDF of all project tasks to reinforce core Excel 2016 practice tests and review video solutions.

Access the PDF of the Microsoft objective domain for the 77-727 exam, paired with Excel 2016 core practice tests and video solutions.

Unlock additional maths resources with Monash University webinars, access courses using the UDEMY 13 coupon, and join our YouTube and Facebook groups for math exam discussions.

Discover practical skills for Microsoft Office specialist exams with two course types: technique courses with instructional videos and exercises, plus exam prep with practice tests and video solutions.