# data[].attributes.body
How do you change line spacing to 2/double spacing? Home, Paragraph, Line and Paragraph Spacing (see blue box on picture)

# data[].attributes.body
Given a  template, how do I save a file as "Plain Text"?

File, Save As, Save as type:  scroll to find "Plain Text"

# data[].attributes.body
How do you merge a cell in a table? How do you repeat headers?

# data[].attributes.body
Turn Off Compatibility Mode?
File, Inspect Document, Check for Issues, Check Compatibility

# data[].attributes.body
Table of Contents, display 2nd level heading only.
References tab, Table of Contents section, Table of Contents, Customize Table of Contents, Options (delete and levels not needed)

# data[].attributes.headline
In Word How To Modify Cell Spacing in a Table

# data[].attributes.subject
In Word How To Modify Cell Spacing in a Table

# data[].attributes.attachment_link.readable_text
If you want more spacing around the cells of your table, Microsoft Word can accommodate you. Because the setting is a bit hidden, we'll show you where to find it and how to adjust the cell spacing for your table.

Although tables are wonderful tools for structuring data, they can also become packed and hard on the eyes. By adding spacing around the cells, you can make your data easier to read or simply give your table a unique appearance.

Adjust the Table Cell Spacing in Word

The nice thing about the cell spacing setting is that you can use it for a table you insert or a custom table that you draw.

RELATED: How to Draw a Custom Table in Microsoft Word

Select the table and right-click a cell or the table handle. Choose "Table Properties" from the shortcut menu.

In the Table Properties window that opens, go to the Table tab. Then, choose "Options" on the bottom right.

In the center of the Table Options window, you'll see Default Cell Spacing. As you'll see, the default is zero. Check the box for Allow Spacing Between Cells and enter a number in the box to the right. Alternatively, use the arrows to move up or down in small increments.

Click "OK" to save the spacing change and "OK" again the Table Properties window. You'll then see your table update to the new cell spacing measurement.

You can continue to use these steps to adjust the spacing further if you wish to get just the right look.

If you're adjusting the cell spacing for an improved appearance, you can then select the table and head to the Shading section of the Table Design tab.

This lets you apply shading to the cell spacing and pick a color for the cells that makes them pop.

No matter what you're using a table for in Microsoft Word, you do have options to give it the exact appearance you want or the best way to make your data easy to read.

RELATED: How to Create a Table Using the Keyboard in Word

With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage. Sandy Writtenhouse
Read Full Bio "

# data[].attributes.attachment_link.title
How to Adjust Cell Spacing for a Table in Microsoft Word

# data[].attributes.attachment_link.description
If you want more spacing around the cells of your table, Microsoft Word can accommodate you. Because the setting is a bit hidden, we'll show you where to find it and how to adjust the cell spacing for your table.

# data[].attributes.body
Sort multiple columns

# data[].attributes.body
Word defaults to check compatability. Here' s how to turn it off. To turn off Word Compatability Mode:
File, Info, Check for Issues, Check Compatability (Turn off check mark!)

# data[].attributes.headline
Excel Review W/Eckelman and Objective Examples

# data[].attributes.subject
Excel Review W/Eckelman and Objective Examples

# data[].attributes.body
In Each Tab, copy/paste the video link to see each section covered from sections 1.5 to 5.3. There are 5 videos to watch :0)

# data[].attributes.body
Fast-forward video to 26:00

# data[].attributes.attachment_link.description
Get access to files anywhere through secure cloud storage and file backup for your photos, videos, files and more with Google Drive.

# data[].attributes.headline
Using the SAM program practice and demonstrate the performance objectives for your program via Certiport (Word/Excel/PowerPoint/Access or Outlook).  Take the industry certification exam and score 80% or higher to obtain your program certificate.

# data[].attributes.subject
Using the SAM program practice and demonstrate the performance objectives for your program via Certiport (Word/Excel/PowerPoint/Access or Outlook).  Take the industry certification exam and score 80% or higher to obtain your program certificate.

# data[].attributes.body
Watch Videos under #5

# data[].attributes.attachment_link.title
MOS Industry Cert Prep Review Just Before MOS Test 9/17/20

# data[].attributes.attachment_link.readable_text
Certified individuals will establish their ability to perform a number of Word tasks, such as creating and managing documents, formatting text, paragraphs and sections, creating tables and lists, applying references and inserting and formatting objects.

The straightforward Word evaluation challenges individuals to complete a comprehensive project that depicts real-world functionality with project and standards-based outcome testing.

An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry entry-level and is ready to enter into the job market.

Exam objectives

Word 2016

Word Expert 2016

Word 2013

Word Expert 2013

Word 2010

Word Expert 2010

Exam details

# data[].attributes.attachment_link.title
MOS Word :: MOS Certifications :: Microsoft Office Specialist :: Certiport

# data[].attributes.attachment_link.description
Certified individuals will establish their ability to perform a number of Word tasks, such as creating and managing documents, formatting text, paragraphs and sections, creating tables and lists, applying references and inserting and formatting objects. The straightforward Word evaluation challenges individuals to complete a comprehensive project that depicts real-world functionality with project and standards-based outcome testing.

# data[].attributes.attachment_link.readable_text
Our interactive PowerPoint certification program provides candidates with performance-based scenarios to measure their ability to manage essential, day-to-day tasks.

Certification requires individuals to demonstrate their ability to create and manage presentations, insert and format shapes and slides, create slide content, apply transitions and animations and manage multiple presentations.

The unique benefit for candidates taking the new PowerPoint exam is the comprehensive, project-based testing format. This requires individuals to complete a project that depicts real-world functionality with project and standards-based outcome testing.

An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry entry-level and is ready to enter into the job market.

Exam objectives

PowerPoint 2016

PowerPoint 2013

PowerPoint 2010

Exam details

# data[].attributes.attachment_link.title
MOS PowerPoint :: Microsoft Office Specialist :: Certiport

# data[].attributes.attachment_link.description
Our interactive PowerPoint certification program provides candidates with performance-based scenarios to measure their ability to manage essential, day-to-day tasks. Certification requires individuals to demonstrate their ability to create and manage presentations, insert and format shapes and slides, create slide content, apply transitions and animations and manage multiple presentations.

# data[].attributes.attachment_link.readable_text
Our cutting-edge Excel certification program gives testing candidates practical, performance-based scenarios to gauge their real-world capabilities with project and standards-based outcome testing.

Certification candidates will demonstrate the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions and creating charts and objects.

To make the exam more helpful, we've replaced individual tasks with comprehensive, project-based testing. This live-in-the-application environment confirms that certified individuals have demonstrated the ability to complete a realistic Excel project.

An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry entry-level and is ready to enter into the job market.

Exam objectives

Excel 2016

Excel Expert 2016

Excel 2013

Excel Expert 2013

Excel 2010

Excel Expert 2010

Exam details

# data[].attributes.attachment_link.title
MOS Excel :: Certifications :: Microsoft Office Specialist :: Certiport

# data[].attributes.attachment_link.description
Our cutting-edge Excel certification program gives testing candidates practical, performance-based scenarios to gauge their real-world capabilities with project and standards-based outcome testing. Certification candidates will demonstrate the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions and creating charts and objects.

# data[].attributes.attachment_link.description
Create a new document and edit with others at the same time -- from your computer, phone or tablet. Get stuff done with or without an internet connection. Use Docs to edit Word files. Free from Google.

# data[].attributes.body
www.certiport.com
User Name:  school email
Password: student ID #

# data[].attributes.body
50 minutes; 6-7 Projects (approximately 5 tasks per project; some projects just have 1 task)

# data[].attributes.body
Check your email the day before your sign-up date.  Mrs. E will be sending  you an email  with a link to click on just before your exam.
Monday--12:55 p.m. link will work;
Tues-Friday--2:55 p.m. link will work.

# data[].attributes.headline
 What will the MOS Exam sign-in be like with remote testing at home? Start video at  1:15

# data[].attributes.subject
 What will the MOS Exam sign-in be like with remote testing at home? Start video at  1:15

# data[].attributes.body
Be on a Chromebook, PC or Apple computer to take a MOS exam.
Click on the Certiport icon below and watch the video to see what to expect in signing in the for the MOS exam.  Have no other programs running on your device when you launch the exam; except your email with the link provided to launch the test.  When you have the link, then close your email. Have your cell phone available with your school email to communicate technical issues with Mrs. E

# data[].attributes.attachment_link.title
Certiport Exams from Home - Test Candidate

# data[].attributes.attachment_link.description
User guide to the Certiport Exams from Home solution for Test Candidates.

# data[].attributes.body
If you need a mouse to check-out from AMHS for your Chromebook, email Mrs. Eckelman.  You can then pick-up a mouse loaner from Mrs. Curtain at AMHS (7:30 a.m. - 2:00 p.m.)

# data[].attributes.headline
Pace Yourself on MOS Exam--Skip Option "Flag for Review"

# data[].attributes.subject
Pace Yourself on MOS Exam--Skip Option "Flag for Review"

# data[].attributes.body
Try not to spend too much time on one question. When you are confident with a task click "Mark Complete"; if you would like to see this question again at the end of your test click "Mark for Review". At the end of your test you can go back and click the questions you have flagged for review.

# data[].attributes.body
There is a tutorial at the start of your exam about how to navigate through the exam. Read your directions carefully as your time does not start until after you finish the tutorial.

# data[].attributes.body
Use keyboard shortcuts and right mouse clicking.  Select images holding shift key/control key for nonadjacent items (right click “group”)
Chromebooks, use two fingers on pad to "right-click"

# data[].attributes.headline
Find A Quiet Place To Take Your Exam--no distractions!

# data[].attributes.subject
Find A Quiet Place To Take Your Exam--no distractions!

# data[].attributes.body
You may want to limit the number of people on the Internet at the same time you are testing (if possible).

# data[].attributes.headline
Clicking on Image, Table--Highlights Correct Ribbons

# data[].attributes.subject
Clicking on Image, Table--Highlights Correct Ribbons

# data[].attributes.body
When selecting a table, graphic, chart notice that there are only one or two tabs to choose from.  This reduces “random searching”.

# data[].attributes.body
Word 2019:  (15 minutes) (SKIP Ads)
https://www.youtube.com/watch?v=rELw2yWkNlA

PowerPoint 2019: (18 minutes) (SKIP Ads)
https://www.youtube.com/watch?v=tQ9XcjdBrHI

Excel 2019: (17 minutes) (SKP Ads)
https://www.youtube.com/watch?v=jBApGqM5LiM

# data[].attributes.body
How Do I Make An Absolute Cell Reference?
Alt, F4 (places $ signs in front of a cell to make formulas stay stationary when copied)

# data[].attributes.body
Will I fail the class if I don't pass the MOS exam?  No.
Be ready to take the MOS exam with several attempts (if necessary).
Be Intentional with your study time to practice and best effort!

# data[].attributes.headline
What if I can't take my exam on the day I signed up for?

# data[].attributes.subject
What if I can't take my exam on the day I signed up for?

# data[].attributes.body
Please email Mrs. Eckelman asap at peckelman@auburn.wednet.edu

# data[].attributes.headline
Major Benefits of Getting Microsoft Office Certified

# data[].attributes.subject
Major Benefits of Getting Microsoft Office Certified

# data[].attributes.body
MOS industry certification:
1.  Enhances your resume.
2. Can be listed on your job applications to prove technical skills. Enhances job opportunities!
3. Enhances scholarships!

# data[].attributes.body
1. Microsoft Office Certifications are verifiable. No one will doubt your expertise.

2. Not everyone is certified. This will set you apart from other candidates and/or staff members.

3. Those that get certified often get a pay increase. Your employers know that your certification makes your resume stronger, and they will probably want to do all they can to keep you.

4. Those that get certified are able to do more in less time. If your employer didn’t give you a raise after getting certified, they may do so after seeing the increased value you bring to your organization.

5. Microsoft Office Suite can do more than most people ever imagined. Office managers and supervisors are often looking to spend money on new software that can do more for the office. However, many software products simply do what Microsoft programs already do quite well. The employee with a certification can show managers how to save money on new software by teaching others how to use their productivity software in new ways.

# data[].attributes.body
If making a change to a chart and don't see your chart on the sheet, please scroll your screen to find the chart. Remember data is used to make the chart and if they are asking for changes to a chart. Have the chart selected--two ribbons to troubleshoot (Chart Design/Chart Layout)

# data[].attributes.body
After your first exam you can take your second exam the next day (retake). If you don't pass both exams, Certiport makes you wait 48 hours to take your next exam.

# data[].attributes.body
700/1000

# data[].attributes.body
How do I merge cells? How do I repeat header rows?

# data[].attributes.body
https://exceljet.net/formula/return-blank-if

# data[].attributes.attachment_link.description
This formula is based on the IF function, configured with a simple logical test, a value to return when the test is TRUE, and a value to return when the test is FALSE. In plain English: if Value 1 equals 1, return Value 2.

# data[].attributes.headline
Excel IF Formula (Result example if False " " blank cells)

# data[].attributes.subject
Excel IF Formula (Result example if False " " blank cells)

# data[].attributes.headline
PowerPoint, Play Video Across Multiple Slides (Animation Pane, Effect Options)

# data[].attributes.subject
PowerPoint, Play Video Across Multiple Slides (Animation Pane, Effect Options)

# data[].attributes.attachment_link.title
Play a Video Across Multiple PowerPoint Slides

# data[].attributes.body
What is the purpose of Slide Master?
Skeletal background of PowerPoint designed to make large presentations uniform. For example if you wanted the company logo, you would place this image on the first slide (appears on all slides)

# data[].attributes.body
Word Review with Eckelman

# data[].attributes.body
How to Edit Charts in Ppt

# data[].attributes.attachment_link.title
PowerPoint 2016 - Chart Tutorial - How to Create Make & Edit Charts in MS Microsoft Power Point 365

# data[].attributes.body
Each project can have 1 or up to 5 tasks per project.
Word ~ 6 to 7 Projects
Excel~ 6 Projects
Ppt~6 Projects
Word Expert ~9 Projects
Excel Expert ~6 Projects
Outlook~ 35 tasks
Access ~

# data[].attributes.body
Slide Master

# data[].attributes.body
Adding Sections

# data[].attributes.body
SmartArt, Convert Text

# data[].attributes.body
Look at the Documents first to find your file. If not there go to the c:/drive and find Video or 3D folders.

# data[].attributes.body
If cells are equal to 300 use green fill with dark green text.

Conditional Formatting, Highlight Cell Rules, Equal to and choose green fill with dark green text.