Excel
Word
Outlook
PowerPoint
100

You do this to insert a row.

What is: Right-click the whole row above which you want to insert the new row, and then select Insert Rows.

100

To save a document as a PDF, you do this

What is: 

Select the File tab.

Select Save As . ... 

Scroll down to PDF

100

To send auto replies, you do this

What is: In Outlook, select the File tab within the top-left corner. Select Automatic Replies. Select the date range. Compose your reply. Then Select the Outside My Organization and compose your reply.

100

Death by PowerPoint is occurs when these things happen

What is: Overly wordy slides, hard-to-understand graphics or a speaker monotonously reading off their PowerPoint slides

200

To get a Sum total, you do this

What is: Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter

If you want to sum up a column in Excel and keep the result in your table, you can employ the AutoSum function. It will automatically add up the numbers and will show the total in the cell you select

200

To get a word or character count, you do this

What is: Click the Review tab on the ribbon. Click the Word Count or Character Count button in the Proofing group. 

200

To create a folder you do this

What is: Right-mouse-click on your account name in the Folder List and select New Folder... 2. Type in the name of your new folder and press enter on your keyboard to complete the creation

200

To add animation to a presentation slide, do this

What is: Select the object or text on the slide that you want to animate. On the Animations tab of the ribbon, open the gallery of animations, and select the one you want. On the Animations tab, open the Effect Options list to select from among the available options.

300

You do this to freeze a row or column

What is: Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Then Select View > Freeze Panes > Freeze Panes.

300

You should do this to insert a photo in a word document

What is: Click the location in your document where you want to insert a picture. On the Insert tab, click Pictures. Select the option you want to use for inserting pictures.

300

You do this to find a specific email

What is: Select the search bar, located above the Outlook ribbon. Type a name, subject, or phrase which is included in the email message that you want to find.

300

To create slide transition styling, do this

What is: 

  • Select the slide you want to add a transition to.
  • Select the Transitions tab and choose a transition. ... 
  • Select Effect Options to choose the direction and nature of the transition. ... 
  • Select Preview to see what the transition looks like
400

You do this to run a spell check in Excel

What is: Click the Select All button then Press F7 on your keyboard to run the spell check

400

You should do this to find and replace a word or phrase

What is: Go to Home > Replace.

-Enter the word or phrase you want to replace in Find what.

-Enter your new text in Replace with.

-Choose Replace All to change all occurrences of the word or phrase. .

400

If you want a template response, do this

What is: On the Home menu, click New E-mail. ... 

In the message body, enter the content that you want.

In the message window, click File > Save As.

In the Save As dialog box, in the Save as type list, click Outlook Template.

In the File name box, type a name for your template, and then click Save.

400

The 5 5 5 rule states this

What is: No more than five words per line of text, five lines of text per slide, or five text-heavy slides in a row

500

To combine worksheets from different workbooks, you do this

What is: Copy data: Right-click on any selected worksheet. Choose Move or Copy, then select the target workbook. You then have the option of making a copy of the original worksheets to consolidate your data. Confirm: Confirm the transfer by clicking OK.


500

You do this to shrink one page in a word document.

What is: On Windows, click File > Options > Customize Ribbon or Quick Access Toolbar. ... 

-In the drop-down box on the left, pick All Commands.

-Scroll through the commands to Shrink One Page. ... 

-Click OK.

500

You create a rule by doing this

What is: Right-click the email, and then select Advanced actions > Create rule.

By default, Outlook will prompt you to create a rule to move emails from the sender to a designated folder. To customize your rule, click More options in the Create a rule window, and then click OK

500

You do this to embed a video into a presentation

What is: In Normal view, click the slide that you want the video to be in. On the Insert tab, click the arrow under Video, and then click Video on My PC. In the Insert Video box, click the video that you want, and then click Insert