Excel
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.
To save a document as a PDF, you do this
What is:
Select the File tab.
Select Save As . ...
Scroll down to PDF
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.
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
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
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.
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
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.
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.
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.
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.
To create slide transition styling, do this
What is:
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
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. .
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.
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
To combine worksheets from different workbooks, you do this
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.
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
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