Create an account
The Quick Access Toolbar, containing commands you may need at any time regardless of what tab is active, includes which of the following commands?
undo and redo
You have created a very complex table with great detail on a slide. You want to give the audience a printout of the slide showing all the detail so they can review it with you during your presentation. Which of the following print methods would show the necessary detail?
While displaying a slide show, which of the following will display a list of shortcuts for navigating?
If you need to add an object such as clip art or a picture to a slide, which tab would you select?
Which of the following provides a ghost image of a toolbar for use in formatting selected text?
Which of the following is a true statement?
the design theme can be changed after all of the slides have been created
Which of the following cannot be used to focus audience attention on a specific object on a slide during a slide show?
apply a transition to the object
A file that incorporates a theme, a layout, and content that can be modified is known as a:
What advantage, if any, is there to collapsing the outline so only the slide titles are visible?
more slides are displayed at one time, making it easier to rearrange the slides in the presentation
How do you insert identifying information on every slide in a presentation?
click the interest tab and click headers and footers
Which of the following is true?
PowerPoint supplies many different templates, and each template in turn has multiple color schemes
Which of the following is the fastest and most efficient method for reusing a slide layout you have customized in another presentation?
Save the custom slide layout and reuse it in the new presentation
You own a small business and decide to institute an Employee of the Month award program. Which of the following would be the fastest way to create the award certificate with a professional look?
Access Microsoft Office Online and download an Award certificate template.
Which of the following moves a bullet point from the first level to the second level in an outline?
You create a presentation for a local volunteer organization. When you arrive to present at its office, you find the room you are presenting in has many windows. Which of the following procedures should you follow?
any of the above
Which of the following statements is a true text design guideline?
title text should be 36 pts or larger
A collection of graphical shapes, such as lines, arrows, and squares, that you add by using the Shapes gallery.
You insert a lightning bolt shape on your slide and want to rotate it. You:
Drag the green handle at the top of the image.
Which of the following is a reason for ungrouping a clip art object?
to be able to individually change shapes used to create the composite image
Which of the following features would you use on an ungrouped clip art image after completing your modifications?
You have inserted a clip art image of the ocean with a palm tree on the right side of the beach. If you flip the image vertically, what would the resulting image look like?
the image would be upside down with the palm tree pointing down
Which of the following might be a reason for changing the stacking order of shapes?
all of the above
You stack three shapes on top of each other on a slide by inserting a large square on the page, then a small circle, and then a large triangle. Which shape will be on the top of the stacking order?
The triangle because it was added last
In the above example, how would you move the triangle to the bottom of the stacking order?
in the arrange group, click send to back, and then select send to back
You are trying to align a shape directly on top of another, but it always jumps above or below where you need to place it. What feature should you deactivate in order to accomplish this task?
Which of the following file formats supports 16 million colors, is optimized for photographs and complex graphics, and is the format of choice for most photographs on the web?
Which procedure would you follow to change the resolution of a movie clip?
click the size and position dialog box launcher in the size group on the movie tools options tab
Which of the following Picture Tools would help you adjust a scanned photograph that appears muddy and does not show much difference between the light and dark areas of the image?
Which of the following is permitted for a student project in a class?
all of the above uses are permitted
Which of the following statements is not true?
objects linked to a PowerPoint slide show automatically move with the slide show when its location is changed
All of the following can be used to play a sound clip for preview except:
click the clip on the slide
Which of the following options for inserting sound is available under the Slide Show tab rather than the Insert tab?
Which of the following is a true statement regarding recording a narration?
the slide timings are recorded with the voice narration for use in a self-running presentation
you can split the screen by grabbing the little line to the right of the horizontal scroll bar. Double click the split to make it go away.
The green triangle on the top left hand corner gives you a _____, drop menu gives you options.
if you click this on the formula bar, the data is accepted and the same cell remains the active cell.
green check markup
if you are typing over data already entered into a cell, and press this or click the red x on the formula bar, the data you are typing will be canceled and the data will go back to what was previously entered.
if you are typing over data already entered into a cell, and press esc or click this on the formula bar, the data you are typing will be canceled and the data will go back to what was previously entered.
CTRL+____ arrow key- moves the selected cell to the very last column (column IV) while staying in the same row
CTRL+____ arrow key- moves the selected cell to the very first column (column A) while staying in the same row
CTRL+_____ arrow key-moves the selected cell to the very last row (row 65536) while staying in the same column
CTRL+_____ arrow key-moves the selected cell to the very first row (row 1) while staying in the same column.
inserts a row or column when a column or row header is selected..brings up the insert dialogue box when a cell or group of cells is selected.
deletes a row or column when a column or row header is selected...brings up the delete dialogue box when a cell or group of cells is selected.
automatically inserts a column to the left of the column the focus is currently on
insert sheet columns
right click the cell=> click insert=>insert dialogue box appears=>select entire column
insert sheet columns to left of column in focus
select the column header=>press CTRL and Shift and + =>
insert sheet columns to left of column in focus
right click the cell => click insert=>insert dialogue box appears =>select entire row=>
insert row above row in focus
1. Click the insert=> insert cells
2. Right click on a cell or group of selected cells=>click insert
3. Select a cell or group of cells=> press =CTRL AND SHIFT AND +
bring up insert dialogue box
right click a cell in the column you wish to delete=> click delete=> delete dialogue box appears=> select entire column
deletes the entire column
right click a cell in the row you wish to delete => click delete=> delete dialogue box appears=> select entire row =>
deletes the entire row
1. Delete=> delete cells
2. right click a cell or group of cells=> click delete
3. select a cell or group of cells=> press CTRL AND -
brings up delete dialogue box
a dialogue box appears where you can enter the numerical size you would like the column or row to be..how?
right click the column/row header
select column width/row height
radio button that allows you to scale your workbook so that it fits to a specified number of pages.
right click, format cells
home tab=> click the right corner of the font, alignment or number ribbons
open the format cells dialogue box
will select all consecutive worksheets or cells between the current selected worksheet and the worksheet that is left clicked
will select any worksheet that you click on in addition to the current selected worksheet...sheets do not have to be consecutive
1. Right click on a sheet tab=>select insert=>select worksheet=> click OK
2. Select home tab=>insert=>select worksheet
3. To delete a worksheet, right click sheet tab=>delete
insert/delete a worksheet
instead of moving the select worksheet to the location you choose, this check box makes it so Excel creates a copy of the selected worksheet in the location you choose
create a copy check box
name error...occurs when Excel does not recognize text in a formula
Ex: =IF(A2=A2, go gators)
when a formula refers to the cell it is located in its formula. If you try to make a cell a circular reference it will give a 0 as the result of the formula
is the process that enables you to keep headings on the screen as you work with large worksheets, rows and columns.
To do this to rows and columns:
1. Select the cell below the row(s) and to the right of the column(s) you want to freeze.
2. Click the View tab and click Freeze Panes in the Window Group.
To do this to a particular row or column in a worksheet:
1. Select the row or column you want to hide.
2. Click the Home Tab
3. Click Format in the Cells group and point to Hide & Unhide.
4.Click Format in the Cells group and point to Hide & Unhide.
4. Select the appropriate hide option.
To allow data to be entered in this:
1. Select the cells where entering or changing data will be allowed.
2. Click the Home Tab, click Format in the Cells group, and select Format Cells to open the Format Cells dialog box.
3. Select the Protection tab, clear the Locked check box, click OK.
4. Click the Home tab, click Format in the Cells group, and click Protect Sheet.
5. Select a password if desired and clear the Select locked cells check box.
some cells but not all
To do this to a worksheet:
1. Click the Home tab and click Format in the Cells group.
2. Click Protect Sheet.
3. Select a password if desired and click the options that users will be permitted in the worksheet.
4. Click OK.
To protect this:
1. Click the Review tab and click Protect Workbook in the Changes group.
2. Click the boxes for the protection desired.
3. Enter a password if desired in the Protect Workbook dialog box.
4. Click OK.
All dependent formulas recalculate every time a change is made to a value, formula, or name. Click this under Calculation Options in the Calculation group.
All dependent formulas recalculate except data tables, every time a change is made to a value, formula, or name. Click this under Calculate Options in the Calculation group.
Automatic Except for Data Tables
Turn off automatic recalculation and recalculate open workbooks only when desired. Click this under calculate options in the Calculation group.
manually recalculate. Click this in the calculation group on the Formulas tab, or press F9.
shows where page breaks occur and gives you the opportunity to change where the page breaks.
Page Break preview
To see and adjust this:
1. Click Page Break Preview on the status bar.
2. A watermark shows the page numbers.
3. Move the dashed blue lines as appropriate to adjust the page breaks.
To change this:
1. Click Orientation in the Page Setup group on the Page Layout tab.
2. Select Portrait or Landscape
Print this of a worksheet:
1. Select the portion of the worksheet you want to print.
2. Click the Page Layout Tab, and then click Page Setup Dialog Box Launcher in the Page Setup Group.
3. Click Print, and then click Selection in the Print what section.
4. Verify the selection using Preview.
5. Click Print in the Print group on the Print Preview tab.
selection or range
To change this of the printing pages:
1. Click the Page Setup Dialog Box Launcher on the Page Layout tab.
2. Click the Sheet tab.
3. Change the Page order options, as appropriate.
4. Click OK
Known as a list in previous versions of Excel; is an area in the worksheet that contains rows and columns of related data organized in such a way to facilitate data management and analysis.
filter drop-down lists for efficient sorting and filtering, predefined table styles to format table rows and columns with complementary fill colors, ability to create and edit calculated columns, calculated total row enabling the user to choose from a variety of functions, use of structured references instead of cell references in formulas, ability to export the table data to a SharePoint list.
To create without data:
1. Select a range of cells on a sheet.
2. Click the Insert tab and click Table in the Tables group. The Create Table dialog box opens, asking for the range of data for the table. If the table has (or will have) field names at the top of the columns, select the My table has headers check box.
3. Click OK
to create from already existing data:
1. Select the range of cells on the sheet that contains the data.
2. Click the Insert tab and click Table in the Tables group. The Create Table dialog box opens.
3. Click OK
some of these options, such as cell height and width, are available in the Format down arrow in the Cells group on the home tab.
Table Style Options, displays banded rows where even rows are differently formatted than odd rows.
Table Styles Options, displays banded columns where even columns are differently formatted than odd columns.
You can do this for both ranges and table data:
Click Sort & Filter in the Editing group on the Home tab.
Click Sort A to Z, Sort Z to A, and Sort in the Sort & Filter group on the Data tab.
Right-click the field to sort, select Sort from the shortcut menu, and select the type of sort you want.
To perform this:
1. Click in any cell in the table
2. Click Sort in the Sort & Filter group on the Data tab. This opens the Sort dialog box.
3. Choose the primary sort level from the Sort by drop-down list, and then select the sort order from the Order drop-down list
4. Click the Add Level button and choose the second sort level from the Then by drop-down list, and then select the sort order from the Order drop-down list.
5. Continue to click the Add Level button and add sort levels until you have entered all desired sorts.
multiple level sort
If the header row with filter drop-down arrows is not visible or if you are filtering a range of data instead of a table:
1. Select the data table.
2. Click Sort & Filter in the Editing group on the Home tab.
3. Select Filter to show the filter arrows in each column header.
To insert these totals:
1. Ensure a cell in the table is selected so the Table Tools Design tab is available.
2. Click the Total Row check box in the Table Style Options group on the Design tab. Excel inserts a total row and totals the last column using the SUBTOTAL function.
3. Click in the total cell to see a drop-down arrow.
4. Click the drop-down arrow to select another function, such as Average, or select None to remove the total if it is not relevant to that column.
5. Click in other cells on the total row and repeat step 4 to apply totals to other columns.
To create this:
1. To make sure the data are a list and not a table, Click Convert to Range in the Tools group on the Design tab as necessary, and click Yes in the message box.
2. Click in the range of data, and then click Subtotal in the Outline group on the Data tab.
3. Select the appropriate options in the Subtotal dialog box, and click OK.
To create this:
1. Select data fields to be charted.
2. Click the Insert tab and select the type of chart appropriate for the data.
3. Format and move the chart as appropriate.
groups similar data in columns, making visual comparison easier to determine.
clustered column chart
places (stakes) data in one column with each data series a different color for each category.
stacked column chart
are most effective when they are limited to small numbers of categories-generally seven or fewer.
is the most effective way to display proportional relationships. It is the type of chart to select whenever words like percentage, or market share appear in the message to be delivered.
may be created in exploded or unexploded format, contains a three-dimensional view.
three-dimensional pie chart
shows trends over a period of time, a line connects data points, and is used frequently to show stock market or economic trends. The X-axis represents time, such as ten-year increments, whereas the vertical axis represents the value of a stock or quantity.
displays values as percentages of the whole; is similar to a pie chart in that it shows relationship of parts to a whole, but can display more than one series of data, and it has a hole in the middle.
shows a relationship between two variables. They are used to represent the data from scientific or educational experiments that demonstrate relationships.
1. Specify the data series.
2. Select the range of cells to chart.
3. Select the chart type.
4. Insert the chart and designate the chart location.
5. Choose chart options.
6. Change the chart location and size.
create a chart
In the Charts group on the Insert tab, do one of the following:
1. Click the chart type, and then click a chart subtype that you want to use.
2. To see all available chart types, click a chart type, and then click All Chart Types to display the Create Chart dialog box.
3. Click the arrows to scroll through all available chart types and chart subtypes, and then click the one that you want to use.
to select, click the first cell in the range, and then drag to the last cell, or hold down Shift while you press the arrow keys to extend the selection.
You can also select the first cell in the range, and the press F8 to extend the selection by using the arrow keys. To stop extending the selection, press F8 again.
a range of cells
to select, click the first cell in the range, and then hold down Shift while you click the last cell in the range. You can scroll to make the last cell visible.
a large range of cells
to select, select the first cell or range of cells, and then hold down Ctrl while you select the other cells or ranges.
non adjacent cells or cell ranges
to select, select the first cell or range of cells, and then press Shift+F8 to add another, to stop adding press Shift+F8 again.
nonadjacent cells or cell ranges
to select, click the row or column heading
You can also select cells by selecting the first cell and then pressing Ctrl+Shift+Arrow key
entire row or column
to select, drag across the row or column headings. Or select the first row or column, then hold down Shift while you select the last row or column.
Adjacent rows or columns
to select, click the column or row heading of the first row or column in your selection, then hold down Ctrl while you click the column or row headings of other rows or columns that you want to add to the selection.
noncontiguous rows or columns
1. Click the embedded chart or the chart sheet to select it and to display the chart tools.
2. Click Move Chart in the Location group on the Design tab.
3. In the Choose where you want the chart to be placed section, do one of the following: Click New Sheet to display the chart in its own chart sheet.
Click Object In, click the drop-down arrow, and select a worksheet to move the chart to another worksheet.
change location of a chart
when you create a chart the Design, Layout, and Format tabs are available on this tab
Chart tools contextual tab
1. In the Illustrations group on the Insert Tab, select the medium where the graphic will come from (Picture, Clip Art, Shapes, or SmartArt 1)
2. Search for and insert the graphic
3. Size and move the graphic on the chart as desired.
add a graphic to chart
To format this, select it, and then click the formatting options that you want on the Mini Toolbar
To format this, right click the selected text, select Format Chart TItle, Format Axis Title, or Format Data Labels on the shortcut menu, and then select the formatting options that you want.
title or data label
The options for formatting this may be approached in two ways, either by using the tabs or by selecting the chart and then right-clicking and using the various format commands on the shortcut menu.
to add this to chart:
1. Select the chart that will have data labels added.
2. Click Data Labels in the Labels group on the Layout tab.
3. Select the location for the data labels on the chart.
To change this of a data series in a column chart:
1. Right-click on any column to open the shortcut menu.
2. Select Format Data Series
3. Select Fill in the left pane, select Solid fill, and then select a color from the Color list.
To insert this use the Layout Tab:
1. Click the Shapes down arrow on the Layout Tab.
2. Click on the shape you want to insert.
3. Place the crosshair pointer over the location on the chart where the graphic is to be located and drag the pointer to place the shape.
4. Release mouse button.
The steps to do this to a chart are:
1. Click on the chart in Excel to select it.
2. Click Copy in the Clipboard group on the Home Tab.
3. Open the appropriate Word or PowerPoint document.
4. Click the Paste down arrow in the Clipboard group on the Home tab and select Paste Special.
5. Select Microsoft Office Excel Chart Object, click the Paste Link option, and click Ok.
Click on the cell where the formula will be entered
Type an equal sign to start a formula
Click on the cell with the value to be entered in the formula
Type a mathematical operator
Continue clicking on cells and typing operators to finish the formula
Press enter to complete formula
Another powerful copying tool in Excel, is a small black solid square in the bottom-right corner of a selected cell.
Click on the cell (or drag through the cells) to be copied.
Position the mouse pointer directly over the fill handle on the cell or cells to be copied. The pointer changes to a thin crosshair.
Click and hold down the left mouse button while dragging over the destination cells. Note that using this only works with contiguous or adjacent cells.
Release the mouse button
when you copy a formula containing a relative cell reference over multiple columns, the changes.
in a formula, indicated by dollar signs before the column letter and row number, stays the same regardless of where a formula is copied.
absolute cell reference
are used when the value in the cell seldom changes but the formula containing the absolute cell reference is copied.
absolute cell reference
occurs when you create a formula that combines an absolute reference with a relative reference.
mixed cell reference
are values as input that perform an indicated calculation, and then return another value as output.
Click either Insert Function to the left of the formula bar or click Insert Function in the Function Library group on the Formulas tab to display
Insert Function dialog box
enables you to select the function to be used from the complete list of functions and specify the arguments to be used in the function
Insert Function dialog box
using this function simplifies this operation and improves the accuracy of the addition.
To use this click the cell where you want to see the results and then click this. Drag to select the cell range or values to be summed and press Enter to see the total.
AutoSum is located in the Function Library Group in this tab or in the Editing group on this tab
determines the smallest value of all cells in a list of arguments, such as determining the lowest score on a test.
is the most basic logical function in that it returns one value when a condition is met and returns another value when the condition is not met.
Has three arguments
1. a condition that is tested to determine if it is either true or false
2. the resulting value if the condition is true, and
3. the resulting value is the condition is false.
has three required arguments
1. a lookup value stored in a cell
2. a range of cells containing a lookup table, and
3. the number of the column within the lookup table that contains the value to return.
indicated by col_index_num in the function, refers to the number of the column in the lookup table that contains the return values.
column index number
is the lowest numeric value for a category or series in a lookup table to produce a corresponding result for a lookup function.
requires three arguments:
the interest rate per period, the number of payment periods, and the amount of the loan.
instead of using specific values you should use this in PMT function arguments, so that you can easily change the input values in the individual cells instead of editing the values in the function itself.
is a single spreadsheet consisting of a grid of columns and rows that often contain descriptive labels, numeric values, formulas, functions, and graphics.
is a collection of related worksheets contained within a single file. Storing multiple worksheets within one workbook helps organize related data in one file. In addition it enables you to perform calculations among the worksheets, within this.
appears below the ribbon and above the workbook screen and shows the active cell's contents.
displays the contents of the cells; you can enter of edit cell contents here or directly in the active cell.
appears to the left of the formula bar and displays the active cell's address (D4) or a name it has been assigned.
are located at the bottom left of the Excel window and tell the user what sheets of a workbook are available.
is located at the bottom of the excel window. It is below the sheet tabs and above the Windows task bar and displays information about a selected command or operation in progress.
is the square at the intersection of the rows and column headings and you can use it to select all elements of the active worksheet.
select all button
are numbers entered in a cell that represent a quantity, an amount, a date, or time. Can be used as the basis of calculation, are right-aligned by default, text is left-aligned
are the combinations of constants, cell references, arithmetic operations, and/or functions displayed in a calculation.
The three ways to edit the contents of a cell.
first is to select the cell you want to edit, click in the formula bar, make changes, press enter
second you double click in the cell, make the edits, press enter
third you select the cell press F2, and edit
The two options to clear the contents of a cell
first, click on a cell and press delete
second, click the clear arrow in editing group on home tab
are rules that control the order or sequence in which arithmetic operations are performed, which in turn will change the result reported in Excel.
order of precedence
To delete a column either
click the column letter and click delete in the cells group or click in any cell in the column you want to delete, click the delete arrow in the cells group, and select delete sheet columns.
is a rectangular group of cells that can be as small as a single cell or as large as an entire worksheet.
transfers the content of a cell or cell range from one location in the worksheet to another, with the cells where the move originated becoming empty.
To display the paste special dialog box
click the paste arrow in the clipboard group on the home tab, and then select paste special
enables you to copy the content of a cell or a range of cells by dragging the fill handle over an adjacent cell or range of cells
to rename a workbook sheet
Right click a sheet tab to show shortcut menu
Select Rename, and the sheet tab name is highlighted
Type new sheet name press enter
to change workbook sheet colors
right click the sheet1 tab
point to tab color
select theme colors, standard colors, no color, or more colors
to merge cells and center a title across columns A through L you would
Enter the title in cell A1
select cells A1:L1
Click merge and center in the alignment group on the home tab
is an important command used when formatting a spreadsheet to automatically adjust the height and height of cells.
changes the column width of the selected columns to fit the contents of the column.
AutoFit column width
operation controls formatting for numbers, alignment, fonts, borders, colors and patterns.
alignment in a cell can be changed by going to this dialog box in the alignment group in this tab
format cells dialog box
you can right click on the cell requiring a comment and select insert comment from this
software that is used primarily with text to create, edit, and format documents is known as:
word processing software
if you wanted to locate every instance of text in a document and have it temporarily highlighted which command would you use
which of the following is true about the office ribbon?
the ribbon is the main component of the office 2007 interface
what is the name of the blinking vertical line in a document that designates the current location in the document?
which elements of the ribbon looks like folder tabs and provides commands that are task oriented?
which office 2007 element provides commands that work with an entire document or file and displays by default in the title bar?
if you needed the entire screen to read a document, which document view would you use?
full screen reading
what is the name of the memory location that holds up to 24 items for you to paste into the current document, another document, or another application?
you want to add bold and italic to a phrase that is used several times in a document. What is the easiest way to make this update?
Use the find and replace feature and specify the format for the replacement.
you are the only person in your office to upgrade to word 2007. Before you share documents with you co-workers you should?
run the compatibility checker
A document has been entered into word using the default margins. What can you say about the number of hard and soft returns if the margins are increased by 0.5" on each side?
the number of hard returns is the same, but the number and/or position of the soft return increases.
which of the following is detected by the contextual spell checker?
use of the word hear when you should use here
Which option on the page layout tab allows you to specify that you are printing on an envelope?
you need to insert a large table into a report, but it's too wide to fit on a standard page. Which of the following is the best option to use in this case?
insert section breaks and change the format of the page containing the table to landscape orientation.
What might cause you to be unsuccessful in finding a specific block of text in your document?
all of the above.
Which action below is the result of using the AutoText feature?
you start typing the date, a ScreenTip displays the date on the screen, and you press Enter to insert it.
If you cannot determine why a block of text starts at the top of the next page, which toggle switch should you invoke to view the formatting marks in use?
If you use the margins feature frequently, what action should you take to make it more accessible?
use the customization category of word options and add margins to the quick access toolbar
you are on page 4 of a five page document. Which of the following is not a way to move the insertion point to the top of the first page?
press PageUP on the keyboard one time
What visual clue tell you a document is not in word 2007 format
the title bar includes (Compatibility Mode) after the file name.
What is the easiest way to change the alignment of five paragraphs scattered throughout a document, each of which is formatted with the same style?
change the format of the existing style, which changes the paragraphs
A(n) __ occurs when the first line of a paragraph is isolated at the bottom of a page and the rest of paragraph continues on the next page.
Which of the following is true regarding the formatting within a document?
columns are implemented at the section level
after you create and insert a table of contents into a document,
you can right click, then select Update field to update the table of contents
Which of the following is a false statement about the outline view?
it is used to create a conventional outline
What is the best way to create a conventional outline in a word document?
use the multilevel list command in the paragraph group in print layout view
what happens if you modify the body text style in a word document?
only those paragraphs formatted with the body text style will be changed
which of the following is a true statement regarding indents?
the insertion point can be anywhere in the paragraph when indents are set.
The spacing in an existing multipage doc is changed from single to double spacing throughout the doc. What can you say about the number of hard and soft page breaks before and after the formatting changes?
The number of hard page breaks is the same, but the number and/or position of the soft page breaks is different.
which of the following is not a valid use of the format painter?
view formatting codes assigned to a paragraph
if you want to be sure the phone number 555-1234 does not word wrap what should you do?
use a non-breaking hyphen in place of the hyphen
You have created a table containing numerical values and have entered the SUM(ABOVE) function at the bottom of a column. You then delete one of the rows included in the sum. Which of the following is true?
The sum will be updated provided you right click the cell and click the update field command
which process below is the best option to change the size of a selected object so that the height and width change in proportion to one another?
enter the height and allow word to establish the width
how do you search for clip art using the clip organizer?
by entering a keyword that describes the image you want
what guideline should you remember when inserting graphics into a document?
graphic elements should enhance a document, not overpower it
which of the following commands in the picture tools format tab would you use to remove portions of a graphic that you do not wish to see in you document?
Which of the following is not an example of how to use the symbols feature in a document?
You can insert WordArt from the symbol dialog box
Which of the following is true regarding objects and their associated tabs?
Clicking a WordArt object displays the WordArt Tools tab
What happens when you press Tab from within the last cell of a table?
Word inserts a new row below the current row
What happens when you type more than one line of text into a cell?
the row gets taller as word wrapping occurs to display the additional text
Assume you created a table with the names of the months in the 1st column. Each row lists data for that particular month. The insertion point is in the first cell on the third row-this row lists goals for April. You realize that you left out the goals for March. What should you do?
display the table tools layout tab and click the insert left command
You have a list of people who were sent an invitation to a wedding. You are responsible for monitoring their responses to the invitation, whether they will attend or not, and to determine the grand total of those attending. Using skills learned in Chapter 3, what would be a good way to track this information?
convert the list of names to a table; add columns that allow you to mark their response, including the number who will attend, and use a formula to add up the numbers when all responses are received.
if cell A1 contains the value 2, and A2 contains the value 4, what value will be displayed if cell A3 contains the formula =PRODUCT(ABOVE)?
what option would you use if you were given a lengthy list of items that are separated by tabs and that would be easier to format in a table?
convert text to table
which option should you use to add color to improve the attractiveness and readability of a table?
borders and shading
which of the following statements about comments is false?
you cannot print comments with the rest of the document
which dialog box gives you the ability to enter the name of the person using the computer so that person's name appears in ScreenTips for tracked changes and markup balloons?
word options (located in office menu)
Which procedure is a method used to view and edit footnote text?
By double-clicking the footnote reference mark and typing from within the footnotes pane in print layout view
when you use the styles feature to format headings, you can use this feature to view an outline of you document and click on a heading in the outline to relocate he insertion point in your document
What navigation tool do you use to display images of document pages that you can click to move the insertion point to the top of a particular page?
Which option is not true about plagiarism?
It only applies to written words; ideas, spoken words, or graphics are not included.
What document item directs a reader to another location in a document by mentioning its location?
What does a table of authorities display?
A list of cases, rules, treaties, and other documents citied in a legal document.
Which feature enables you to attach information to a document such as author name, subject, title, keywords, and comments?
document information panel
Select the sequence of events you undertake to include a bibliography in your document.
insert a citation, select writing style, insert bibliography
Which feature enables you to display the differences in two documents in a separate document?
Uses of Spreadsheets
Business applications (accounting), "what if" analysis in business planning, scientific applications (ex: voting results, geologic activity)
Steps to ensures a good design
Decide on the purpose of the spreadsheet and how it will be constructed; make it obvious where data is to be entered; enter data and set up formulas where possible
Select All Button
Used to select all elements of the worksheet; not used often, only for deleting all things
3 Most Common Methods to Edit Cell Data
1.Select cell, click in formula bar 2. Double click on a cell 3. Select cell, hit F2-(All-Make changes, hit enter)
used to perform mathematical operations and arrive at a calculated result, must begin with an equal sign
Selecting a range
Click and hold left mouse button and drag from beginning of range to end; select first cell, hold shift and click the last cell; ranges can be contiguous or noncongitguous
Enables you to copy the content of a cell or range of cells; use to repetitively copy contents of one cell; use to complete a sequence like a month or a year
Changing Sheet Tab Color
Right click the sheet tab and select tab color, select theme colors/standard colors/no color/more colors
Moving, deleting, copying, or adding worksheets
Right click sheet tab and select the desired operation
Adjusting cell height and width
Drag the border between two column headings; double click on the border between two column headings; or AutoFit will automatically adjust
Applying Borders and Shading
Select a cell border from "Borders" in the Font group on the "Home" tab; Use the "Border" tab in the "Format Cells" dialog box
On Inserting Clipart
Used to represent imortant aspect of spreadsheet content; use sparingly since it can be distracting or take up lots of disk space
Uses for formatting cells
Control formatting for numbers, alignment, font, borders, colors, and patterns
Headers and Footers
Headers appear at the top of every page, footers appear at the bottom of every page
Adds documentation to the cell; provided to clarify thoughts and define formulas; red triangle appears in the cell containing the comment; comment is visible when you point at the cell
Absolute cell references
Are exact; they do not change when a formula is copied; indicated by dollar signs in front of the column letter and row number; most often used as a sales tax percentage
Predefined formula that can be selected from a list; already has cell function, just requires cell references; doesn't replace all formulas?
Please allow access to your computer’s microphone to use Voice Recording.
Having trouble? Click here for help.
We can’t access your microphone!
Click the icon above to update your browser permissions and try again
Reload the page to try again!Reload
Press Cmd-0 to reset your zoom
Press Ctrl-0 to reset your zoom
It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.
Please upgrade Flash or install Chrome
to use Voice Recording.
For more help, see our troubleshooting page.
Your microphone is muted
For help fixing this issue, see this FAQ.
Star this term
You can study starred terms together