Manipulate page setup options for worksheetsĬonfiguring page orientation managing page scaling configuring page margins changing header and footer sizeĪpplying cell styles constructing new cell styles Hiding a column unhiding a column hiding a series of columns hiding a row unhiding a row hiding a series of rows Printing row and column headings printing rows to repeat with titles printing columns to repeat with titles configuring titles to print only on odd or even pages configuring titles to skip the first worksheet page

Using Merge & Centre, Merge Across, Merge Cells, and Unmerge Cells

Using paste special (formats, formulas, values, preview icons, transpose rows and columns, operations, comments, validation, paste as a link) cutting, moving and selecting cell dataĬopying data using AutoFill filling series using AutoFill copying or preserving cell format with AutoFill selecting from drop-down listĬreating a hyperlink in a cell modifying hyperlinks modifying hyperlinked-cell attributes removing a hyperlinkĪligning cell content applying a number format wrapping text in a cell using Format Painter Manipulating the Quick Access toolbar manipulating the ribbon tabs and groups manipulating Excel default settings importing data to Excel importing data from Excel demonstrating how to manipulate workbook properties manipulating workbook files and folders applying different name and file formats for different uses by using Save and Save As features Personalise environment by using Backstage Printing only selected worksheets printing an entire workbook constructing headers and footers applying printing options (scale, print titles, page setup, print area, gridlines)

This exam measures your ability to accomplish the technical tasks, also the questions on the test are not be limited to, the topics described in the below.

Mos excel 2013