Tuesday, September 3, 2019 admin Comments(0)

Microsoft. Excel. EXAM Joan Lambert. MOS Study Guide .. The Microsoft Office Specialist (MOS) certification program has been designed to vali- Portable Document Format (PDF) A fixed-layout document format created by. Demonstrate your expertise with Microsoft Office! Designed to help you practice and prepare for the Excel Expert Microsoft Office. note this content also published as mos study guide for excel expert microsoft word pdf download or read online ebook study guide mos excel .

Language:English, Spanish, French
Published (Last):26.06.2015
ePub File Size:18.76 MB
PDF File Size:13.25 MB
Distribution:Free* [*Register to download]
Uploaded by: LYLA

Microsoft. Excel Expert. EXAMS. & Mark Dodge. MOS Study Guide. See all our titles at: MOS Study Guide. Microsoft W ord. Exam. Lambert. Microsoft. Excel Expert. EXAMS. & Mark Dodge. MOS Study Guide. to guide you in studying the types of tasks you are likely to be required to demonstrate in Exam seeking Microsoft Office Specialist certification in Excel MOS exams for .mhtml, PDF (Portable Document Format),

View Larger Image. This eBook includes the following formats, accessible from your Account page after download:. EPUB The open industry format known for its reflowable content and usability on supported mobile devices. This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours. Also available in other formats. Register your product to gain access to bonus material or receive a coupon.

The Start screen and New page display thumbnails of popular templates and templates that are specific to the season or an upcoming holiday. If you create custom templates and save them in your Personal Templates folder, Featured and Personal links appear below the search box. You can click these links to switch between viewing program- supplied templates and your own.

If you save templates in a location other than your Personal Templates folder, you can create documents based on those templates either from File Explorer or from the Open page of the Backstage view.

Throughout this book, we refer to this utility by its Windows 8 name. If your computer is running Windows 7 or an earlier version of Windows, use Windows Explorer instead.

MOS 2013 Study Guide for Microsoft Excel

Clicking the thumbnail of a program-supplied template displays a preview and descrip- tion of the document that will be created by the template, along with ratings provided by people who have downloaded the template. Opening non-native files directly in Word Word creates files in Office Open XML formats, which support a greater range of access and reuse options and produce a smaller file than earlier Word document for- mats.

The default file format for a document created in Word is the.

Guide expert microsoft 2013 mos for study pdf excel

A Word You can open a PDF file in Word exactly as you would any other type of file. When you do so, Word converts the file to an editable Word document. If the file contains complicated formatting and layout, the Word version of the document might not be a perfect replica of the PDF file, but most simple files convert quite cleanly. On the Open page of the Backstage view, navigate to the file location. In the Open dialog box, in the file type list to the right of the File name box, click All Files to display all the files in the folder, or click the specific type of file you want to locate.

In the Open dialog box, click the file you want to open, and then click Open. Save the results of the tasks in the same folder. From the Start screen, create a new document based on the built-in Blank Document template.

Save the document as MyBlankDoc. Locate the online template for a fax cover sheet that uses the Equity theme. Create a fax cover sheet based on this template. Save the document as MyFaxCover. Save the document as MySummerDoc. The Results page of the Navigation pane displays the search results in context, whereas the Find page locates only one instance of the search term at a time but allows you to define more search criteria.

You can narrow the search results that are shown on the Results page of the Navigation pane by specifying search parameters. You can perform an even more specific search from the Find And Replace dialog box, in which you can specify many formatting options and also include special characters within your search term. Scroll through the document to display the highlighted results or click any result in the Navigation pane to move directly to that occurrence. Click the Next and Previous buttons to move among the results or to redisplay the results on the Results page.

Click More in the lower-left corner of the dialog box to display additional search options. In the Find what box, enter the text you want to search for, or click the Special button and then click the symbol or formatting symbol you want to locate. Tip The two most common wildcard characters are? For a list of the available wildcards, select the Use Wildcards check box and then click the Special button.

While creating a hyperlink to a document or a webpage, called the target, you can spec- ify whether the target information should appear in the same window or frame as the active document or in a new one. You can also make a particular setting the default for all hyperlinks.

You can jump to the target of the hyperlink by holding down the Ctrl key and clicking the link.

MOS – Study Guides (PDF) |

After you click the hyperlink, its color changes to the color specified for followed hyperlinks. Select the text or graphic object to which you want to attach the hyperlink. Tip You can change the selected text from within the Insert Hyperlink dialog box by changing it in the Text To Display box.

In the Look in area, browse to the target file.

Exam 77-418- MOS 2013 Study Guide for Microsoft Word (1)

Or In the Address box, enter the absolute path to the target file. Click Target Frame. In the Set Target Frame dialog box, specify where the hyper- link target will be displayed, and then click OK. In the Insert Hyperlink dialog box, click OK. Select the text or graphic object to which you want to attach the hyperlink, and then open the Insert Hyperlink dialog box.

On the Link to bar, click the Place in This Document button.

MOS 2013 Study Guide for Microsoft Excel Expert

In the Select a place in this document box, click the heading or bookmark you want to link to. On the Link to bar, click the E-mail Address button. In the E-mail address box, enter the email address to which you want to address the message. Or In the Recently used e-mail addresses list, click the email address to which you want to address the message. In the Subject box, enter the subject of the message.

Right-click the hyperlink, and then click Edit Hyperlink. In the Edit Hyperlink dialog box, make the necessary changes, and then click OK. Word automatically creates bookmark names for headings down to the fourth level by duplicating the heading; removing articles, spaces, and punctuation; and capitalizing the first letter of each word.

Guide for pdf microsoft excel 2013 expert study mos

You can move to bookmarked locations within a doc- ument either by creating hyperlinks to the bookmarks or by navigating to them. Place the cursor at the location in which you want to insert the bookmark, or select the text or object to which you want to attach the bookmark. On the Insert tab, in the Links group, click the Bookmark button. In the Bookmark dialog box, enter a name for the bookmark in the Bookmark name box, and then click Add.

Tip Bookmark names cannot contain spaces. If you include a space, the Add button becomes inactive. Open the Bookmark dialog box, and then click the bookmark you want to move to. Click Go To, and then click Close. In the Enter bookmark name list, click the bookmark you want. Moving to specific locations and elementsFrom the Go To page of the Find And Replace dialog box, you can quickly move be-tween pages, sections, lines, bookmarks, comments, footnotes, endnotes, fields, tables,graphics, equations, objects, or headings in a document.

In the Go to what list, click the type of element you want to locate. In the Enter element box, select or enter the identifier of the specific element you want to locate. Then click Go To to move to that element. Or Click the Next or Previous button to move among instances of the selected element in the document.

Then modify the search to locate all instances of toy. Move between the search results by using the navigation buttons. Insert a hyperlink from each heading in the table of contents to the corresponding heading in the document.

Change the display text of the hyperlink from www. In the document, verify that clicking the hyperlink displays the Microsoft website home page in your default browser. Click the hyperlink to create the message, and then send the message to yourself. You can change the margins, orienta- tion, and size of the document pages.

Tip The document page size is unrelated to the paper size, which you set in the printer settings. You can format text in multiple columns, and manually divide a document into pages or sections. When you define sections, you can set up the pages within an individual sec- tion differently from other pages of the document. When appropriate to the document type, you can preface each line of text in the docu- ment with a line number.

Line numbers can span the length of a document, restart at the beginning of each page or section, or skip text that you specify. By default, Word breaks lines between words and after punctuation. You can stop Word from breaking a line between two words that you want to keep together by inserting a nonbreaking space between the words. On the Margins menu, click Custom Margins. On the Margins page of the Page Setup dialog box, specify the individual margins, the gutter width and position, the configuration of multiple pages, and the area of the document to which you want to apply the custom margins.

Then click OK. On the Size menu, click More Paper Sizes.

On the Paper page of the Page Setup dialog box, select Custom size in the Paper size list, define the width and height of the page, and then click OK.

On the Columns menu, click More Columns. In the Columns dialog box, specify the number of columns, column width, and spacing, and then click OK. Position the cursor at the beginning of the content with which you want to start the new section. In the Hyphenation dialog box, specify whether you want Word to automatically hyphenate the document or to hyphenate uppercase words, the maximum distance of a hyphen from the document margin the hyphenation zone , and how many consecutive lines of a paragraph may be hyphenated.

For each hyphenation suggested in the Manual Hyphenation dialog box, click Yes or No. Tip The No button is active only for existing hyphens. The theme is a combination of coordinated colors, fonts, and effects that visually convey a certain tone. By default, Word applies the Office theme to all new, blank documents.

To quickly change the appearance of a docu- ment, you can apply a different theme. To change the appearance of all new documents, you can make a different theme the default. If you like the background elements of one theme but not the colors or fonts, you can mix and match theme elements.

Pdf mos excel study microsoft expert for 2013 guide

In addition to colors and fonts, you can control more subtle elements such as paragraph spacing and visual effects that are associated with a theme. If you create a combination of theme elements that you would like to be able to use with other documents, you can save the combination as a new theme. In the corresponding gallery, click the color scheme, font set, paragraph spacing, or combination of effects you want.

Adjust the colors, fonts, or effects of the current theme to suit your needs. In the Themes gallery, click Save Current Theme. In the Save Current Theme dialog box, enter a name for the theme in the File name box, and then click Save. Select the theme you want to use as the default, or modify the current theme. Strategy The objective domain for Exam includes coverage of applying existing themes, color schemes, font sets, paragraph spacing, and effects to documents. Creating those elements is part of the objective domain for Exam , Word Expert.

More importantly, you can structure a document by applying paragraph styles that are linked to outline levels. In doing so, you build a document outline that is reflected in the Navigation pane and can be used to create a table of contents.

Styles can include character formatting, paragraph formatting, or a combination of both. Styles are stored in the template that is attached to a document. By default, blank new documents are based on the Normal template.

PDF The popular standard, which reproduces the look and layout of the printed page. This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours. About eBook formats. Demonstrate your expertise with Microsoft Office! Download the sample content.

Microsoft Excel Expert Chapter 1: Manage and Share Workbooks Chapter 2: Apply Custom Formats and Layouts Chapter 3: Create Advanced Formulas Chapter 4: Create Advanced Charts and Tables. We've made every effort to ensure the accuracy of this book and its companion content. Any errors that have been confirmed since this book was published can be downloaded below. Download the errata. If you find an error, you can report it to us through our Submit errata page.

Sign in.