Transcript Course Name - CCI Learning

Key Applications
A Quick Review Of
Unit 5 – Using Microsoft
Office Excel 2007
© CCI Learning Solutions Inc.
#1
What is the difference between
a workbook and a worksheet?
Review
A workbook is a file that may contain one
or more worksheets of related data.
Use worksheets for reports or
documents to track numerical information.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#2
How should you organize the
information in a new Excel file?
Review
Organize information in a way that will
be clear to you and anyone else
who may be using the content.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#3
How can you use design
elements in worksheets?
Review
Use these to emphasize data areas
although use discretion as these
may cause the data to become
hard to read.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#4
How does Excel name a file when
you create a new blank one?
Review
By default, Excel assigns each new
blank workbook with “Book#” where #
represents the number of new books
created in this session of Excel.
Be sure to save with a more descriptive
file name for your reference.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#5
How can you open an Excel file?
Review
Click Office Button, then Open,
press Ctrl+O, from the Recent Documents
list, or from the file management tool
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#6
What is a template and when
might you save with this format?
Review
A template is a combination of
pre-designed formats and styles for a
specific type of report that you can then
customize and save for future use.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#7
What are the three types of
data you can insert into cells?
Review
Labels (text), Values (numbers or dates)
Formulas (composed of cell references,
arithmetic operators, and functions
that operate on data)
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#8
After entering the data, how
can you go to another cell?
Review
Click in another cell, or
press Enter or Tab
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#9
What happens if a label is longer
than the width of the cell?
Review
The label will display past the column border
as long as the adjoining cells are empty.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#10
What determines the format
for dates in Excel?
Review
Regional Settings in the Control Panel.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#11
How can you move quickly
to a cell reference?
Review
On the Home tab, in the Editing group,
click Find & Select, Go To or Go To
Special, or press Ctrl+G or F5
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#12
Where can you edit
the contents of a cell?
Review
In the same cell, or
within the Formula bar
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#13
What can a range of cells be?
Review
Single cell, row, column,
multiple adjacent cells/rows/columns,
or multiple non-adjacent
cells/rows/columns
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#14
When might you use
the Paste Special feature?
Review
To modify the effects of the
paste option as when pasting
content only, formats only,
or to insert a formula result
as a value.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#15
How can you use the Fill feature?
Review
To fill in data based on the original
contents where there is a pattern or
trend that exists.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#16
How wide can you
make a column?
Review
A column can be from
0 to 255 characters wide.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#17
What is AutoFit?
Review
AutoFit sets an automatic height
based on largest entry in a row, or
sets the width automatically for
the longest entry in a column.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#18
When inserting a new column,
where should the cursor be?
Review
The new column is inserted to left of the
selected column.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#19
Why do you need to take
caution when deleting cells?
Review
To ensure you do not
automatically delete
valuable data not
currently displayed on
the screen.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#20
How can renaming a
worksheet tab help you?
Review
Naming a worksheet tab helps
identify the different types
of data in each tab.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#21
Why be cautious when
deleting worksheets?
Review
You cannot undo the deletion of a worksheet,
and if there are links between the
worksheets, these are broken until you reset
them or copy the worksheet from a backup
copy of the report.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#22
What is a formula?
Review
A calculation using numbers
(or other data) in a cell or
from other cells.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#23
Why would you want to link
formulas between worksheets?
Review
So that when values or amounts in
the active worksheet change, dependent
cells in the other worksheet
automatically update.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#24
How can you begin a formula?
Review
Type = in the cell for the formula.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#25
How can you edit a formula?
Review
Press F2, click in the cell or the
Formula bar containing the formula,
or retype the formula.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#26
What does natural order
refer to in Excel?
Review
This is how formulas calculate: exponents
first, then multiplication and division, and then
addition and subtraction. The order can be
altered using brackets around parts of the
formula, e.g., =1+2+3*5 has a different result
than =1+(2+3)*5.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#27
What is the format to
enter a function?
Review
=Function(numbers or values, or cell reference)
Examples:
=sum(250,262,b6:b18)
=average(c8,c9,d11,d15)
=count(f41:f83)
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#28
How can you select the cells
to include in a formula?
Review
Type the cell references directly, or
click and drag to select the cell range.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#29
What is a relative cell reference?
Review
Most formulas entered are relative, which
means that if you copy a formula with a
relative cell address and paste it to another
cell, Excel automatically adjusts that address
to reflect the new location.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#30
How do you make a cell
address absolute or fixed?
Review
Type $ before the column and
row reference, or press F4 after
entering the cell address.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#31
How would you make just the row
reference absolute?
Review
Each time you press F4 in a formula, you
change which part of the cell is absolute.
Pressing F4 once makes the entire cell
reference absolute, the next makes the row absolute,
the next makes the column absolute, and the next
removes any absolutes.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#32
Why is it important to verify
your formulas are correct?
Review
This can be crucial when major
decisions are made based on the
analysis of the data.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#33
What is a circular reference?
Review
When the cell where the formula was
entered is included as part of the
formula, e.g., if the formula is in cell B5,
and the formula shows as =sum(b3:b5).
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#34
Why would you want to
review formulas for trends?
Review
Depending on the information, the
results can identify areas where more
information is needed, or if there is an
error in the data or a formula.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#35
What does formatting refer to?
Review
Changing the appearance of data to
draw attention to parts of the worksheet,
or make the data easier to read.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#36
Which category would you use
to show $12,894.767?
Review
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#37
Which buttons enable you to
align cell contents vertically?
Review
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#38
What is the difference between
Wrap text and Merge cells?
Review
Wrap text wraps text in a cell based on
the width of the column; you will need to
adjust the row height to show the contents.
Merge cells combines selected cells
into one cell and aligns the contents in that
merged cell with the alignment you chose.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#39
How many fonts should you
use in a worksheet?
Review
Try to keep the number of fonts in a
worksheet to one or two, as too many
can be distracting to the reader.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#40
What do these buttons do?
Review
Enable you to turn on or off the
border from that side of the
selected cell range so you can
preview how the borders will
appear once you click OK.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#41
When might you apply
a pattern style?
Review
Patterns can draw attention to
certain parts of your worksheet. Use
caution as patterns can make it
harder to read the data especially if
using a dark or dense pattern.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#42
When would you apply a cell
style versus a table style?
Review
Apply a cell style to selected cells only
in the worksheet, whereas a table style
formats the entire table using a
pre-designed theme for colors,
fonts, borders and patterns.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#43
When might you double-click
the Format Painter?
Review
When you want to apply formatting
features from one cell range to multiple
cell ranges in the worksheet.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#44
What does the spell check
feature look for in Excel?
Review
Only text labels; it cannot verify the
accuracy of numbers, dates, or time
values. You should still proof these
items in your worksheet.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#45
Why sort data?
Review
Sorting makes data more readable by
reorganizing data based on the values
in the selected columns or rows.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#46
How was the following
data sorted?
Review
Data is sorted by Expense
type first, then by
Percentage, and then by
the Difference.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#47
Why use the AutoFilter tool?
Review
The AutoFilter tool can find rows where
a cell is equal to a specific value or set of
values, values that are not equal, greater
than, less than, greater than or equal
to, less than or equal to, and between.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#48
Where can you save a
chart in a workbook?
Review
It can be an embedded chart on the
same worksheet as the data, or you
can create charts on their worksheets.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#49
What does the axis on
a chart consist of?
Review
The X-axis is the horizontal line that
shows what data is being charted,
and the Y-axis is the vertical line
that indicates how the data
is being charted.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#50
If the chart does not match what
you want, what should you do?
Review
The chart is created based on the cells
you selected prior to activating the chart
feature. If the data in the chart does not
match your analysis of the data, you need
to check the series used in the chart.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#51
What is the difference between
using Column and Bar charts?
Review
The Column chart type displays the
series in vertical bars, whereas the
Bar chart type displays the series in
horizontal bars.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#52
To add a title to a chart,
which tab would you use?
Review
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#53
Why might you want to add
a data table to the chart?
Review
This displays the actual values for the
data beneath the chart as quick reference.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#54
Why consider previewing the
worksheet before printing?
Review
This displays it on the screen so you
can make any required changes
before distributing the report to others.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#55
How does the chart
in a worksheet print?
Review
The chart prints based on where it is in
the worksheet. For instance, if the chart
is on its own worksheet, it prints on a
separate piece of paper. If it is embedded
on the same worksheet as the data,
both will print on the page.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#56
Where should the cursor be
when you insert a page break?
Review
The cursor should be in the cell
immediately below where the page
break is to be placed.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#57
When might you use
Page Break Preview?
Review
Use Page Break Preview for a special
view of the worksheet with the page
numbers highlighted on the screen.
You can then drag the page breaks to
where you want them to be.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#58
Why would you use Scaling
instead of Fit to?
Review
Scaling enables you to enlarge or
shrink the size of the worksheet
proportionally, whereas Fit to uses
automatic scaling to fit the worksheet
onto a specified number of pages.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#59
What do the margin options set?
Review
The amount of white space from the
edges of the page around the printed
area of the worksheet.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#60
What displays when you click
the arrow for Footer?
Review
It displays a list of standard types of
footer text you can apply to the report.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#61
Which icon inserts the total
number of pages in the report?
Review
Number
of Pages
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
#62
What is the difference between
Print area and Print Titles?
Review
Print area sets the portion of the
worksheet to print, whereas Print
Titles repeats the column or row
titles on each printed page.
Show
© CCI Learning Solutions Inc.
Mark for Review
Next
Congratulations!
Good job on completing
the Review!
End
© CCI Learning Solutions Inc.
Review