How can we help?

You can also find more resources in our Help Center.

533 terms

cgs exam2

STUDY
PLAY
Which of the following methods does not save changes in a PowerPoint presentation?
press f1
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?
full slide
While displaying a slide show, which of the following will display a list of shortcuts for navigating?
f1
The predefined slide formats in PowerPoint are:
slide layouts
If you need to add an object such as clip art or a picture to a slide, which tab would you select?
insert
The open command
brings a presentation from a storage device into RAM memory
The save command
stores the presentation in RAM memory to a storage device
Which of the following provides a ghost image of a toolbar for use in formatting selected text?
Mini toolbar
Which of the following is a true statement?
the design theme can be changed after all of the slides have been created
Microsoft Clip Organizer searches
all of the above
Which of the following views is best for reordering the slides in a presentation?
slide sorter view
Normal view contains which of the following components?
tabs pane, slide pane, and notes pane
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
What is an animation effect the controls how one slide changes to another slide
transition
A file that incorporates a theme, a layout, and content that can be modified is known as a:
template
To create a presentation based on an installed template, click the:
office button and then new
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
Which of the following is true?
The slide layout can be changed after the template has been chosen
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?
tab
The Increase List Level and Decrease LIst Level commands are available from which tab?
home
Which of the following formats cannot be imported to use as an outline for a presentation?
.tiff
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
Which of the following is not a field in the Header and Footer dialog box?
file name
To add existing content to a presentation, use which of the following features?
all of the above
Shapes are:
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.
The relationship between the height and width of a shape is referred to as:
aspect ratio
Which of the following is a reason for grouping shapes?
To move or modify the objects as one
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?
regroup
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
A Microsoft Windows Metafile (.wmf) is a vector object created by:
mathematical formulas
Which of the following features does not help with arranging objects on a slide?
Cascade
Which of the following is not available from the SmartArt gallery?
periodic table
Which of the following SmartArt graphics displays objects in a continual process?
cycle
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?
snap to
Which of the following file formats is best for photographs?
bitmap
Which of the following is not a Windows graphics file format?
PICT
Which of these is a feature that can be used to identify a photograph on a slide?
captions
All of the following are forms of multimedia except?
placeholders
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?
.jpg
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?
contrast
Which of the following is permitted for a student project in a class?
all of the above uses are permitted
The Photo Album dialog box enables you to make all but this edit to pictures:
crop
Which of the following are included in the Clip organizer?
animated GIF files (.gif)
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
Which of the following sound formats may be embedded in a slide show?
windows audio file (.wav)
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?
record narration
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
references the active cell in the worksheet
name box
displays the contents of the active cell
formula bar
area where you can manipulate data
working area of doc
displays info about commands or operations taking place in excel.
status bar
toggle on/off the task pane
ctrl+f1
a grouping of horizontal cells 1,048,576 of them
rows
a grouping of vertical cells 16,384 of them
column
1 Excel spreadsheet
worksheet
at the bottom of the screen. They allow you to switch between worksheets
worksheet tabs
What an excel file is referred to as...contains multiple worksheets
workbook
allows you to edit the selected cell (in addition to double-clicking or using the formula bar)
F2
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.
screen split
on the top left hand corner gives you a smart tag, drop menu gives you options
green triangle
The green triangle on the top left hand corner gives you a _____, drop menu gives you options.
smart tag
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.
esc
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.
red x
right aligned
numbers
left aligned
text
select entire worksheet
ctrl+A
moves to the 1st column in the same row
home
moves to beginning of document (cell A1)
ctrl+home
CTRL+____ arrow key- moves the selected cell to the very last column (column IV) while staying in the same row
right
CTRL+____ arrow key- moves the selected cell to the very first column (column A) while staying in the same row
left
CTRL+_____ arrow key-moves the selected cell to the very last row (row 65536) while staying in the same column
down
CTRL+_____ arrow key-moves the selected cell to the very first row (row 1) while staying in the same column.
up
CTRL+_____- brings to bottom, right most cell of the spreadsheet where there is info entered
end
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.
CTRL+SHIFT+
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.
CTRL -
bring up the format cells dialogue box
CTRL+1
switches between normal and formula views
CTRL+`
shortcut for setting cell references
F4
select the cell in the formula and press F4 once-______ reference
absolute
$A$1
absolute reference
select the cell in the formula and press F4 twice- the anchor will be on the _____
row
A$1
row anchor
$A1
column anchor
select the cell in the formula and press F4 three times- the anchor will be on the _____
column
select the cell in the formula and press F4 four times-_____ reference. (default)
relative
A1
relative reference
automatically inserts a column to the left of the column the focus is currently on
insert sheet columns
right click the column header click insert
insert sheet columns to left of column in focus
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
automatically inserts the row above the row the focus is currently on
insert sheet row
right click the row header => click insert=>
insert row above row in focus
right click the cell => click insert=>insert dialogue box appears =>select entire row=>
insert row above row in focus
select the row header=> press CTRL and Shift and +=>
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 the column header=> click delete
deletes the entire column
right click a cell in the column you wish to delete=> click delete=> delete dialogue box appears=> select entire column
deletes the entire column
select the column header=> press CTRL and -
deletes the entire column
right click the row header => click delete
deletes the entire row
right click a cell in the row you wish to delete => click delete=> delete dialogue box appears=> select entire row =>
deletes the entire row
select the row header=> press CTRL AND -
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.
scaling
the small black square at the bottom right of the currently selected cell
autofill handle
Press CTRL+1
CTRL+SHIFT+F
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
Shift+left click
will select any worksheet that you click on in addition to the current selected worksheet...sheets do not have to be consecutive
CTRL+left click
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
an incorrectly formed formula...."Not a value error"
ex: =A1+"Hello"
#VALUE!
divide by zero error or referencing a blank cell
Ex: =45/0
#DIV/0!
name error...occurs when Excel does not recognize text in a formula
Ex: =IF(A2=A2, go gators)
#NAME?
invalid cell reference error...occurs when a formula refers to an invalid cell
#REF!
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
circular reference
a number that is to wide to display in the cell
#####
is the process that enables you to keep headings on the screen as you work with large worksheets, rows and columns.
freezing
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.
freeze
is the process of making rows, columns, and sheets invisible.
hidden
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.
hide
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.
protect
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.
workbook
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.
automatic
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.
manual
manually recalculate. Click this in the calculation group on the Formulas tab, or press F9.
calculate now
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.
page breaks
To change this:
1. Click Orientation in the Page Setup group on the Page Layout tab.
2. Select Portrait or Landscape
page orientation
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
order
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.
table
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.
table
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
table
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
table
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.
Format
this contextual tab provides a variety of formatting options for tables.
Table Tools Design
Table Style Option, turns on or off the header or top row of a table.
header row
Table Style Option, turns on or off the totals or last row of a table.
totals row
Table Style Options, shows special formatting for the first column of a table.
first column
Table Style Options, shows special formatting for the last column of a table.
last column
Table Style Options, displays banded rows where even rows are differently formatted than odd rows.
banded rows
Table Styles Options, displays banded columns where even columns are differently formatted than odd columns.
banded columns
arranges records in a table by the value of one or more fields within a table.
sorting
puts lists in ascending or descending order according to specified sort fields.
sort commands
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.
sort
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
refer to facts about a specific record or sets of records.
data
is data that have been arranged in some form and are viewed as useful.
information
You can use AutoFilter to set a _____ to display a subset of data from a table.
filter
is a condition that displays a subset of data meeting your specifications.
filter
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.
filtering
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.
column
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.
summary report
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.
summary chart
is a graphic representation of data.
chart
is a numeric value that describes a single item on a chart.
data point
is a group of related data points.
data series
describes a group of data points in a chart.
category label
displays data comparisons vertically in columns.
column chart
depicts categorical labels on a graph
x or horizontal axis
depicts numerical values on a graph
y or vertical axis
contains graphical representation of values in data series.
plot area
contains the entire chart and all of its elements.
chart area
compares two or more sets of data in one chart.
multiple data series
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
identifies the format or color of each data series.
legend
are most effective when they are limited to small numbers of categories-generally seven or fewer.
column chart
is basically a column chart that has a horizontal orientation.
bar chart
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.
pie chart
separates one or more slices of the pie chart for emphasis.
exploded pie chart
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.
line chart
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.
doughnut chart
shows a relationship between two variables. They are used to represent the data from scientific or educational experiments that demonstrate relationships.
scatter chart
shows the high, low, and close prices for individual stocks over a period of time.
stock chart
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.
chart style
to select, click the cell or press the arrow keys to move to the cell.
single cell
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, click the select all button
To select, you can press Ctrl+A
all cells on a worksheet
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
text
To format this, use the formatting buttons in the Font group on the Home Tab.
text
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.
chart
is the value or name of a data point.
data label
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.
data labels
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.
color
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.
shape
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.
link
performs mathematical operations that produce a calculated result.
formula
uses the mouse or arrow keys to select the cell directly when creating a formula.
pointing
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
pointing method
Another powerful copying tool in Excel, is a small black solid square in the bottom-right corner of a selected cell.
fill handle
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
fill handle
is a typical cell reference that changes when copied.
relative cell reference
when you copy a formula containing a relative cell reference over multiple columns, the changes.
column letter
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
key toggles through relative, absolute, and mixed references
F4
a preconstructed formula that makes difficult computations less complicated.
function
represented by sigma, adds up or sums the numeric entries within a range of cells.
SUM function
refers to the rules for constructing the function
syntax
are values as input that perform an indicated calculation, and then return another value as output.
arguments
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.
sum function
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
AutoSum is located in the Function Library Group in this tab or in the Editing group on this tab
Formulas Tab
Home Tab
calculates the arithmetic mean, or average, for the values in a range of cells.
AVERAGE function
Type an AVERAGE function from C6 to C16
=AVERAGE(C6:C16)
determines the smallest value of all cells in a list of arguments, such as determining the lowest score on a test.
MIN function
Type a MIN function from C6 to C16
=MIN(C6:C16)
analyzes an argument list to determine the highest value.
MAX function
Type a MAX function from C6 to C16
=MAX(C6:C16)
counts the number of cells in a range that contain numerical data.
COUNT function
Type a COUNT function from C6 to C16
=COUNT(C6:C16)
counts the number of cells in a range that are not blank.
COUNTA function
Type a COUNTA function from C6 to C16
=COUNTA(C6:C16)
finds the midpoint value in a set of values
MEDIAN function
is a date-related function that places the current date in a cell.
TODAY function
TODAY function is expressed as
=TODAY()
uses the computer's clock to display the current date and time side by side in a cell.
NOW function
The NOW function is expressed as
=NOW()
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.
IF function
allows the Excel user to look up an answer from a table of possible answers.
VLOOKUP function
calculates the payment of a loan
PMT function
returns the future value of an investment
FV function
PMT function
PMT(rate,nper,pv,fv,type)
FV function
FV(rate,nper,pmt,pv,type)
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.
IF function
IF function
IF(condition,value_if_true,value_if_false)
=
equal to
<>
not equal to
<
less than
>
greater than
<=
less than or equal to
>=
greater than or equal to
=IF(A1=A2,1000,2000)
10 is equal to 10, True
1000
=IF(A1<>A2,1000,2000)
10 is not equal to 10, false
2000
VLOOKUP function
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
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.
VLOOKUP function
is the value to look up in a reference table
lookup value
is a range of cells containing the reference table.
lookup table
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.
breakpoint
requires three arguments:
the interest rate per period, the number of payment periods, and the amount of the loan.
PMT function
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.
cell references
Is the computerized equivalent of a ledger, contains rows and columns of data.
spreadsheet
is a single spreadsheet consisting of a grid of columns and rows that often contain descriptive labels, numeric values, formulas, functions, and graphics.
worksheet
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.
workbook
is the cell you are working in, the cell where information or data will be input.
active cell
an active cell cell reference appears in this box
name box
active cell's contents appear in the
formula bar
appears below the ribbon and above the workbook screen and shows the active cell's contents.
formula bar
displays the contents of the cells; you can enter of edit cell contents here or directly in the active cell.
formula bar
is another name for the cell reference of the cell currently used in the worksheet.
name box
appears to the left of the formula bar and displays the active cell's address (D4) or a name it has been assigned.
name box
are located at the bottom left of the Excel window and tell the user what sheets of a workbook are available.
sheet tabs
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.
status bar
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
Excel identifies columns by
letters
Excel identifies rows by
numbers
Clipboard group
home tab
font group
home tab
alignment group
home tab
number group
home tab
styles group
home tab
cells group
home tab
editing group
home tab
tables group
insert tab
illustrations group
insert tab
charts group
insert tab
links group
insert tab
text group
insert tab
themes group
page layout tab
page setup group
page layout tab
scale to fit group
page layout tab
sheet options group
page layout tab
arrange group
page layout tab
function library group
formulas tab
defined names group
formula tab
formula auditing group
formula tab
calculation group
formula tab
Get external data group
data tab
connections group
data tab
sort and filter group
data tab
data tools group
data tab
outline group
data tab
proofing group
review tab
comments group
review tab
changes group
review tab
workbook views group
view tab
show/hide group
view tab
zoom group
view tab
window group
view tab
macros group
view tab
moves active cell up one screen
PgUp
moves active cell down one screen
PgDn
moves active cell to column A of current row.
home
moves active cell to cell A1
ctrl+home
moves to the rightmost, lowermost active corner of the worksheet.
ctrl+end
displays the GoTo dialog box to enter any cell address.
F5 or ctrl+G
To insert a line break press
Alt+enter
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
values
are the combinations of constants, cell references, arithmetic operations, and/or functions displayed in a calculation.
formula
For excel to recognize a formula it must always start with an
equal sign =
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
addition formula
=C1+C2
Subtraction formula
=C2-C1
multiplication formula
=C1*C2
Division formula
=C1/C2
exponentiation symbol
^
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
The quickest way to display cell formulas is to press
ctrl ` or ~
rows are always inserted ____ the selected cell
above
columns are always inserted _____ the selected cell.
to the left
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.
To insert a row or column
click the insert down arrow in the cells group on the home tab
is a rectangular group of cells that can be as small as a single cell or as large as an entire worksheet.
range
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.
move operation
removes all content from a cell or from a selected cell range.
delete operation
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
autofill
is a small black square appearing in the bottom right corner of a cell.
fill handle
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
You can copy a worksheet by pressing and holding this as you drag the worksheet tab
ctrl
option centers an entry across a range of selected cells
merge and center cells
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.
autofit
changes the column width of the selected columns to fit the contents of the column.
AutoFit column width
changes the row height of the selected row to fit the contents of the row.
AutoFit row height
operation controls formatting for numbers, alignment, fonts, borders, colors and patterns.
format cells
format dialog box and commands are on this tab
home tab
alignment in a cell can be changed by going to this dialog box in the alignment group in this tab
format cells dialog box
home tab
insert page number
&(Page)
insert number of pages
&(Pages)
insert date
&(Date)
insert time
&(Time)
insert file path
&(Path)&(File)
Insert file name
&(File)
insert sheet name
&(Tab)
insert picture
&(Picture)
format picture under header/footer
opens the format picture dialog box
you can right click on the cell requiring a comment and select insert comment from this
shortcut menu
software that is used primarily with text to create, edit, and format documents is known as:
word processing software
which office feature displays when you rest the mouse pointer on a command?
an enhanced screentip
if you wanted to locate every instance of text in a document and have it temporarily highlighted which command would you use
find
the meeting point b/n computer software and the person using it is known as
an interface
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?
insertion point
which elements of the ribbon looks like folder tabs and provides commands that are task oriented?
tabs
which office 2007 element provides commands that work with an entire document or file and displays by default in the title bar?
office button
if you needed the entire screen to read a document, which document view would you use?
full screen reading
the default four letter extension for word documents that do no contain macros is
.docx
before you can cut or copy text, you must first do which of the following?
select the text
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?
clipboard
word flags misspelled words by marking them with which one of the following?
a red wavy underline
which of the following displays when you select text in a document?
the mini toolbar
Formatting text enables you to change which of the following text attributes?
All of the above
when entering text within a document, you normally press enter at the end of every:
paragraph
How do you display the print dialog box?
click the office button, and then click the print command
which view removes all tabs from the screen?
full screen reading
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?
size
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 feature adds organization to your documents?
page numbers
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?
Show/hide
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.
Which of the following can be stored within a paragraph style?
All of the above
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
which feature analyzes a document and formats it for you?
autoformat
which of the following is used to create a conventional outline?
a numbered list
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.
orphan
WHat is the keyboard shortcut to mark and index entry?
Alt Shift x
Which of the following is true regarding the formatting within a document?
columns are implemented at the section level
which tab contains the table of contents and index features?
references
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
Which of the following is not a predefined word style that is available in every doc?
special 1
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 are not set at the paragraph level?
columns
which of the following is a true statement regarding indents?
the insertion point can be anywhere in the paragraph when indents are set.
The default tab stops are set to:
left indents every 1/2"
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?
crop
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
Which wrap style allows text to wrap around the graphic frame that surrounds the image?
square
What provides legal protection to the author for a written or artistic work?
copyright
Microsoft WordArt cannot be used to:
insert a copyright symbol
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)?
8
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)
What option enables you to see the document appearance if you accept all tracked changes?
Final
Which of the document elements listed below can you find using the Go To command?
Bookmark
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
document map
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?
thumbnails
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?
cross-reference
A table of figures is generated from what type of entries?
captions
What does a table of authorities display?
A list of cases, rules, treaties, and other documents citied in a legal document.
What comprises a master document?
Subdocuments
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?
compare documents
Spreadsheet
Computerized equivalent of a ledger
Excel
A computerized spreadsheet application used to build and manipulate worksheets and workbooks
Worksheet
Spreadsheet that may contain data, values, formulas, and/or charts
Workbook
Collection of related worksheets within one file
Uses of Spreadsheets
Business applications (accounting), "what if" analysis in business planning, scientific applications (ex: voting results, geologic activity)
Plan out data...
before putting it into Excel
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
Excel is designed for...
Automatic calculation
Make sure the results are what you expect by...
testing multiple times
You know if your result is correct by...
knowing what the results should be
Worksheets should be formatted...
so they look appealing
You should document the worksheet
as thoroughly as possible
Navigate the worksheets using....
the keyboard or mouse
Active Cell
Cell you are working in; where data will be input
Formula Bar
Shows the active cell's contents
Name box
Displays the active cell's address or name it has been given
Sheet tabs
What sheets of workbook are available
Status bar
Displays information about a selected command or operation in progress
Select All Button
Used to select all elements of the worksheet; not used often, only for deleting all things
Ribbon
Primary replacement for menus and toolbars made up of tabs, groups, and commands
What must you do before entering data?
Create a workbook
Three types of data
Text, values, formulas
Text
Letters, numbers, symbols, and spaces
Values
Numbers that represent a quantity, an amount, a date or time
Formulas
Combination of numbers, cell references, operators, and/or functions
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)
Mathematical Operations
Are the backbone of Excel
Formulas
used to perform mathematical operations and arrive at a calculated result, must begin with an equal sign
Operator symbols
Plus minus times divide exponents (+ - * / ^ )
Order of Precedence
Controls the sequence in which arithmetic operations are performed
Basic Rules of Order of Preference
Please Excuse My Dear Aunt Sally
Displaying formulas in a worksheet
CTRL ~
Insert a new row
Click on the row number where you want a new row
Insert a new column
Click on the column number where you want a new column
Insert a new cell
Home Tab, "Insert"
Delete a Cell
Home Tab, "Delete"
Notes Taking Up Multiple Cells
Register only in the first cell
Inserting columns or rows from the ribbon
Home tab->insert->Insert sheet rows/columns
Range
Rectangular groups of cells in a worksheet; can include one cell or an entire worksheet
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
Move
Removes the contents from one location to another
Methods of moving
Drag and drop; cut and paste
Delete
Removes all contents from the cell or range of cells
Deleting
Select the range and click delete
Copy
Makes a duplicate of the contents in the selected range and places it on the Clipboard
Paste
Places the contents of the clipboard in the selected range
Paste Special
Allows users several different options
Autofill
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
Autofilling
Drag the fill handle over an adjacent cell or range of cells
Fill handle
Small black square appearing in the bottom right hand corner of a cell
Renaming Worksheets
Right click the sheet tab and click "Rename", type the new name and press Enter
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
Purpose of formatting worksheets
Draws attention to important areas of the worksheet
What should be done with labels?
Cells should be merged and centered
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
Orientations
Portrait prints vertically, landscape horizontally
Margins
Left, Right, Top, Bottom
Headers and Footers
Headers appear at the top of every page, footers appear at the bottom of every page
Sheet options
Show gridlines, row and column headings
Print Preview
See how the spreadsheet will print
Cell Comments
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
Formulas
Used to perform mathematical operations and arrive at a calculated result
Use of formula
Using an alternative method that involves minimal typing
Pointing
Uses the mouse or arrow keys to select the cell directly when creating a formula
Relative Cell References
Change relative to the direction in which the formula is copied
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
Use of the F4 key
Toggle between relative and absolute references
Function
Predefined formula that can be selected from a list; already has cell function, just requires cell references; doesn't replace all formulas?
Most commonly used function
SUM, represented by sigma, adds values within a specified range
Syntax
Grammatical structure of a formula; must adhere to stated structure of formula
Arguments
Values used as input and returned as outpu
Function Wizard
Automates entering the function formulas
Basic Statistical Functions
Average, min, max, count, median
Argument in Bold
Means that a function is required