Summary
Summary Sam Cengage notes for excel
- Course
- Institution
Step by step instructions and information needed for all the functions and tasks for excel
[Show more]
Seller
Follow
Kirstiedavies
Content preview
Excel test notesIntroduction to excel:
1. The Accounting number format denotes financial data in a worksheet,
differentiating it from other types of data.
Position the mouse pointer over cell B5. Press and hold the left mouse button
as you drag the mouse pointer down until it is over cell B16, then release the
mouse button.
In the Number group, click the Accounting Number Format ($, dollar sign)
button.
Excel applies the Accounting number format to the selected cells.
2. Applying the Comma Style number format makes large numbers, such as
thousands, hundreds of thousands, and millions, easier to read.
Position the mouse pointer over cell C5. Press and hold the left mouse button
as you drag the mouse pointer down until it is over cell C18, then release the
mouse button.
In the Number group, click the Comma Style button.
Excel applies the Comma Style number format to the cells in the range.
3. Applying the Percentage number format allows you to see the cell value
displayed as a percentage.
Position the mouse pointer over cell C4. Press and hold the left mouse button
as you drag the mouse pointer right until it is over cell C15, then release the
mouse button.
In the Number group, click the Percent Style (%) button.
Excel applies the Percentage number format to the cells in the range.
4. If cell contents are too small or too large to fit neatly into your column, you can
autofit the column width to fit the contents.
Select the column heading.
The entire column will be selected.
In the Cells group on the Home tab, click the Format button.
Click AutoFit Column Width.
Excel adjusts the width of the column to AutoFit cell contents; all text in the
cell is now visible.
5. If your worksheet has too many columns to fit on one printed page, change to
Landscape orientation to accommodate the extra width. Similarly, use Portrait
orientation for worksheets with a lot of rows but fewer columns.
Click the Page Layout tab on the ribbon.
The Page Layout tab contains options for modifying themes, page setup,
worksheet scale, gridlines, and object arrangement.
In the Page Setup group, click the Orientation button.
The Orientation menu opens with the two orientation options.
On the Orientation menu, click Landscape.
The worksheet orientation changes to Landscape. Notice the dotted line
signifying the print area moves to the right, as pages in Landscape orientation
are wider than in Portrait orientation.
6. Renaming a worksheet can help identify the type of data it contains.
In the Cells group on the Home tab, click the Format button.
Click Rename Sheet.
The text in the sheet tab is selected.
Type Sales in the sheet tab.
, Press ENTER.
The sheet tab is renamed Sales.
7. Wrapping text is useful when column width is limited and cells contain long
names or titles you need to keep in view.
Click cell A6.
The text string in the cell is longer than the cell width, so part of the text is
hidden from view.
In the Alignment group, click the Wrap Text button.
Excel wraps the text in the cell, adjusting the row height to fit the additional
line of text. All text in the cell is now visible.
8. If you want to display all worksheet columns on one page or in a smaller
section of a worksheet, rotating cell contents fits longer titles into narrow cells
and columns.
Click and drag to select cells A3:D3.
In the Alignment group, click the Dialog Box Launcher.
The Format Cells dialog box opens with the Alignment tab active. In the
Orientation section, the Text handle is pointing to the middle marker on the
Orientation arc, which represents 0 (zero) degrees of rotation.
On the arc, click the marker three points up and to the left of the 0 (zero)
degree marker.
This marker represents 45 degrees of rotation. When you click the marker, it
turns red and Excel enters the value 45 in the Degrees box.
Click OK.
Excel rotates the text in the selected cells 45 degrees.
9. Use panes to navigate large worksheets so you can view and scroll through
data in different parts of the worksheet on a single screen.
Click cell B12.
The selected cell determines where Excel splits the worksheet and the
number of panes to create.
Click the View tab on the ribbon.
In the Window group, click the Split button.
Excel splits the worksheet window into four panes indicated by light gray lines.
The intersection of the panes is at cell B12, the active cell.
10. Freeze rows or columns, especially those with titles or other descriptive
content, so you can scroll through worksheet data past the first screen and
still understand the content.
Click cell B4.
To freeze both rows and columns in the worksheet, click the cell one row
below the last row you want to freeze, and one column to the right of the last
column you want to freeze.
Click the View tab on the ribbon.
In the Window group, click the Freeze Panes button.
The Freeze Panes menu opens. You can freeze both rows and columns, only
rows, or only columns.
On the Freeze Panes menu, click Freeze Panes.
The Freeze Panes command freezes both columns and rows based on the
position of the selected cell. Lines appear in the worksheet indicating that
column A and rows 1 through 3 are frozen. They will remain visible when the
worksheet is scrolled.
, 11. When you no longer need to scroll through multiple sections of a worksheet at
the same time, remove the panes.
Click the View tab on the ribbon.
In the Window group, click the Split button.
Excel clears the split from the worksheet window.
12. Freeze rows or columns to keep titles and other necessary data in view as
you scroll through a worksheet. Unfreeze rows and columns when you are
done.
Click the View tab on the ribbon.
In the Window group, click the Freeze Panes button.
Excel displays a list of choices for freezing and unfreezing panes.
Click Unfreeze Panes.
Excel unfreezes the rows and columns and removes the lines designating the
frozen panes.
13. Use the Currency number format when you want to display numbers as dollar
values. Choose two decimal places to show dollars and cents, or round
numbers to the nearest dollar by choosing no decimal places.
Click and drag to select range C4:C15.
In the Number group, click the Number Format arrow.
The Number Format menu opens.
On the menu, click Currency.
Excel applies the Currency format to the cells in the range. The numbers in
each cell are preceded by a $ (dollar sign) and display two decimal places.
14. Use Date number formats to display numeric values as dates. Improve how
your worksheet looks by consistently applying the same Date format to all
dates in your worksheet.
Select cell D4.
In the Number group on the Ribbon, click the Dialog Box Launcher.
The Format Cells dialog box opens, with the Number tab active. The Date
category is selected in the Type list, as the selected cell is currently formatted
with the Long Date number format. You will change this to a different date
number format.
In the Type list, click 03/14/12 to select a new date number format.
Click OK.
Excel applies the new date format to the cell.
15. Change the row height to fit larger fonts so data is easier to read, or to create
a uniform look to your worksheet.
Click cell A2.
You want to change the height of row 2 so the text in this cell is easier to read.
Point to the boundary at the bottom of the row selector for row 2 until the
pointer changes to a crosshair shape. Press the left mouse button as you
drag the boundary down until the ScreenTip indicates 27.00 (36 pixels), and
then release the mouse button.
Excel changes the row height to 27 points or 36 pixels.
16. Display one, two, or more decimal places for numbers that need to be precise,
like hourly wages or scientific calculations. Large numbers, such as annual
sales, are often displayed with no decimal places so they are easier to read.
Click and drag to select cells B3:B12, and then release the mouse button.
In the Number group, click the Increase Decimal button.
The selected values now display one decimal place.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Kirstiedavies. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $4.16. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
53068 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now