Staffing Solutions Inc - St Louis Based Staffing Firm

Spreadsheets - Microsoft Excel

Bold Text	Select cell to be bolded, then click on the B on the Formatting toolbar or Control+B
Center on Page	File/Page Setup/Margins tab - Select horizontal or vertical centering by clicking in the appropriate box
Change Alignment	Select cells Format/Cells/Alignment - select desired alignment or use alignment buttons on the formatting toolbar
Change Borders	Select the cell range to be changed. Format/Cells/Borders tab - change as desired or use the border button on the toolbar. There are more options available through the menu than the toolbar
Change Column Width	Format/Column/Column Width - Type the column size in the highlighted box or Get the sizing handle at the right edge of the column heading (dark line with two horizontal arrows)/double click to size to fit or drag the sizing handle to the appropriate width
Change Font (typeface)	Select the cell range to be changed, then Format/Cells/Fonts tab - select font from preview by scrolling up and down font list or click on the drop down arrow next to the font name on the Formatting toolbar and select font name
Change Headers and Footers	File/Page Setup/Headers and Footers. Adjust using the preformatted headers and footers, or make a custom header/footer
Change Page Orientation	File/Page Setup/Page tab - Select portrait or landscape orientation
Change Row Height	Format/Row/Height - Type the row height in the highlighted box or Get the sizing handle at the bottom edge of the row heading (dark line with two horizontal arrows)/double click to size to fit or drag the sizing handle to the appropriate line height
Close Document	File/Close or Control+F4
Compress/Scale	File/Page Setup/Page tab - Select number of pages to fit or enlarge spreadsheet by percentage
Copy/Paste and Cut/Paste	Select the cell range to be cut or copied. Click on File/Edit/Cut or File/Edit/Copy or use the buttons on the toolbar. Position the cursor in the space where the selection is to be cut/copied. Click on File/Edit/Paste or on the clipboard button on the tool bar
Find	Edit/Find - type word to be found and click on Find Next
Format Cells - Number Type, Alignment, Font, Border, Pattern, Protection	Format/Cells - This tabbed dialogue box has several options. Select the cell(s) and then select the appropriate formatting changes
Freeze Panes (Titles)	To keep the column headings at the top of the screen while doing data entry, click in the cell that is in the row below, and to the right , or any column/row headings to be frozen. Click on Window/Freeze Panes. To remove, click on Window/Unfreeze Panes
Italicize Text	Select text to be italicized, then click on the I on the Formatting toolbar or Control+I
New Document	File/New/Blank Document or Control+N or click on the New button on the Standard toolbar
New Page	Control+Enter or Insert/Break/Page
Print Preview	File/Print Preview or use the button on the tool bar
Replace	Edit/Replace - type word to be found in first box and word to replace it in the second box. Click on Replace or Replace All
Save File	File/Save - Select appropriate folder and name document. Click on Save
Select Text	Click in the cell to be selected and drag the mouse to the last cell in the range to be selected (using the fat cross cursor) or navigation keys (arrows, page-up, page-down, home, end) to select cells or click in the first cell of the range to be selected, hold shift key, click in the last cell in the range to be selected
Set Margins	File/Page Setup/ Margins tab - Change numbers by typing in box or by using the up and down arrows
Set Print Area	File/Page Setup/Sheet - Click in Print Area box, select print range
Set Print Titles	File/Page Setup/Sheet - Click in Rows to Repeat at Top or Columns to Repeat at Left
Spell Check	Tools/Spelling or press F7 or use spell-check button on the toolbar
Spreadsheet Operators/Simple Formulas	Addition + Subtraction - Multiplication * Division / Use these symbols to set up formula using the cell addresses as the variables
Underline Text	Select text to be underlined, then click on the U on the Formatting toolbar or Control+U
Undo/Redo	To undo the last action, click undo button on the Standard toolbar or Control+Z. To redo an action, click the redo button on the Standard toolbar or Control+Y

Word Processing- Word

Bold Text	Select text to be bolded, then click on the B on the Formatting toolbar or Control+B
Bullet and Numbered Lists	Format/Bullets and Numbering - Select desired bullet or numbering format or click on the bullet or numbered list button on the Formatting toolbar
Center a line	Select text to be centered, then click on center button on the Formatting toolbar or Format/Paragraph/Alignment/Center or Control+E
Change Font (typeface)	Select the text to be changed, then Format/Fonts - select font from preview by scrolling up and down font list or click on the drop down arrow next to the font name on the Formatting toolbar and select font name
Change Justification	Format/Paragraph/Alignment - Change Alignment or use buttons on Formatting tool bar
Change Line Spacing	Format/Paragraph - Click on drop down arrow next to the Line Spacing control. Select line spacing desired. Click OK
Change View	View/Normal or View/Page Layout
Close Document	File/Close or Control+F4
Find	Edit/Find - type word to be found and click on Find Next
Grammar Check	Tools/Grammar
Header and Footer	View/Header and Footer - Type and format text of Header in the header area. Use toolbar to switch to the Footer area. Type and format footer text. Close Header/Footer toolbar
Indent Text	Select paragraph to be indented. Format/Paragraph - Select the indention desired or click on the Increase Indent button on the Formatting toolbar
Insert Date	Insert/Date and Time - Change to appropriate format, click OK
Italicize Text	Select text to be italicized, then click on the I on the Formatting toolbar or Control+I
New Document	File/New/Blank Document or Control+N or click on the New button on the Standard toolbar
New Page	Control+Enter or Insert/Break/Page
Print Preview	File/Print Preview or View/Page Layout, then View/Zoom/Full Page
Replace	Edit/Replace - type word to be found in first box and word to replace it in the second box. Click on Replace or Replace All
Save File	File/Save - Select appropriate folder and name document. Click on Save
Select Text	Click at the beginning of the text to be selected and drag the mouse to the end of the text to be selected or Hold the shift key and use the navigation keys (arrows, page-up, page-down, home, end) to select text or click at the beginning of the text to be selected, hold shift key, click at the end of the text to be selected
Set Margins	File/Page Setup/ Margins - Change numbers by typing in box or by using the up and down arrows
Set Tabs	Format/Tabs - Set tabs as desired or use the ruler bar to set tabs in the desired position
Spell Check	Tools/Spelling or press F7
Tables	Table/Insert Table - Set number of columns and rows/click OK. Use auto format if desired
Underline Text	Select text to be underlined, then click on the U on the Formatting toolbar or Control+U
Undo/Redo	To undo the last action, click undo button on the Standard toolbar or Control+Z. To redo an action, click the redo button on the Standard toolbar or Control+Y

Presentations - Microsoft PowerPoint

Add a slide	Click on Common Tasks Toolbar, New Slide
Alignment - Change (Right, Left, Center, or Full)	Select the text information. Format/Alignment - select desired alignment or use alignment buttons on the formatting toolbar
Bold Text	Select cell to be bolded, then click on the B on the Formatting toolbar or Control+B
Change Font (typeface)	Select the text to be changed, then Format/Fonts. Select font from preview by scrolling up and down font list or click on the drop down arrow next to the font name on the Formatting toolbar and select font name
Change Headers and Footers	View/Master Slide. Change the headers and footer here and it will effect your entire presentation. Or, select the footer on the individual slide you wish to change and make the changes. This will effect only that slide
Close a presentation	File/Close or Ctrl + W or Ctrl + F4
Copy/Paste and Cut/Paste	Select the text information to be cut or copied. Click on Edit/Cut or Edit/Copy or use the buttons on the toolbar or use the Control-C or Control-X shortcut keystrokes. Position the cursor in the space where the selection is to be cut/copied. Click on Edit/Paste or on the clipboard button on the tool bar or Control-V
Display the Find dialog box	Edit/Find or Ctrl F
Display the Print dialog box	File/Print or Ctrl P
Go to first slide	Ctrl + Page Up or pick it from the Slide Sorter View (lower left-hand corner)
Go to last slide	Ctrl + Page Down or pick it from the Slide Sorter View (lower left-hand corner)
Go to next slide	Page Down or pick it from the Slide Sorter View (lower left-hand corner)
Go to previous slide	Page Up or pick it from the Slide Sorter View (lower left-hand corner)
Italicize Text	Select text to be italicized, then click on the I on the Formatting toolbar or Control+I
Move between slide objects or placeholders	Click on each object or Control-Enter
Open a new presentation	File/New or Ctrl + N
Open an existing presentation	File/Open or Ctrl + O
Print Preview	View/Slide Show
Save a presentation	File/Save or File/Save As or Ctrl S or Shift + F12
Select Text	Hold the Shift Key and use the arrow keys to highlight the text
Spell-Check	Tools/Spelling or F7
Underline Text	Select text to be underlined, then click on the U on the Formatting toolbar or Control+U
Undo/Redo	To undo the last action, click undo button on the Standard toolbar or Control+Z or Edit/Undo. To redo an action, click the redo button on the Standard toolbar or Control+Y
View All Slides	View/Slide Sorter

Internet Glossary

Browser:	See Web Browser
Database:	A repository of related information (records) accompanied by a set of tools for searching, sorting , and retrieving those records. As relates to a search engine, the database is the body of information in which a search engine seeks matches to a user-submitted query term. Search engine databases vary greatly
Download:	The transfer of data or files from a server computer to a client computer via a network. (see Upload)
Frames:	A convention by which a Web page can be split into multiple panes. An individual Web page can be split into as few as two frames and as many as dozens of frames. Some frames are scrollable, whereas others are not. Frames at the edge of a Web page that cannot be scrolled are called ledges
Hit list:	The result of a search engine query that is displayed to a user as an ordered (and often relevancy ranked) list. The individual hits may contain hyperlinks to the resources identified
Hyperlink:	A hypertext or hypermedia navigational anchor within a Web page that can be either 1) a text block, 2) an image, or 3) multiple anchors within a single image (image map). Hyperlinks, or links for short, allow the user to move from one source to another by clicking on the anchors (hot spots)
Hypertext:	A system of organizing and navigating information used on the Web. Hypertext information is organized into an interconnected matrix of linked text and images. Hypertext documents (called Web pages) contain navigational anchors (called hyperlinks or links) that allow you to navigate to another part of the same document or to a different hypertext document with a mouse click. Web-based hypertext documents are created with the Hypertext Markup Language or HTML
Link:	(see Hyperlink)
Query input form:	The user interface of a search engine into which you enter and submit a request (query term) to a search engine database
Query term:	The information submitted to a search engine. A query term may consist of up to three basic elements, including one or more keywords, logic operators, and switches
Search engine:	An Internet-based search tool that provides an automated result (hit list) to a user-submitted query term (see Query term). Search engines comprise four discrete elements: 1) query term, 2) user interface, 3) search algorithm, and 4) database
URL (Uniform Resource Locator):	The address of any Internet-based information resource when accessed via a Web browser. Neither Navigator nor IE require the entry of the transfer protocol http:// as part of a Web page URL
Web browser:	A universal Internet software application that runs on a client computer. The browser performs five basic functions: 1) locates Internet resources, 2) requests the resources from a server, 3) downloads data, 4) interprets data, and 5) displays the information to the user. Browsers can download and display information from Web servers, Gopher servers, and FTP servers
World Wide Web (Web, WWW, or W3):	A global hypertext and hypermedia-based service of the Internet that is known simply as "the Web." The Web was conceived in 1990 by Tim Berners-Lee and Robert Cailliau at CERN in Geneva, Switzerland and was officially introduced to the Internet community in 1992. Today the Web is the fastest-growing service of the Internet, offering over 440 million pages. It is estimated that 1.5 million pages are added to the Web each day