Microsoft Office Tutorials and References
In Depth Information
Chapter Summary
2
Tap or click the Sign out link, which displays the Remove Account dialog box. If a Can’t
remove Windows accounts dialog box appears instead of the Remove Account dialog
box, click the OK button and skip the remaining steps.
Why does a Can’t remove Windows accounts dialog box appear?
If you signed in to Windows using your Microsoft account, then you also must sign out
from Windows, rather than signing out from within Excel. When you are nished using
Windows, be sure to sign out at that time.
3
Tap or click the Yes button (Remove Account dialog box) to sign out of your Microsoft
account on this computer.
Should I sign out of Windows after signing out of my Microsoft account?
When you are nished using the computer, you should sign out of your account for
maximum security.
4
Tap or click the Back button in the upper-left corner of the Backstage view to return
to the worksheet.
To Save the Workbook and Exit Excel
With the workbook complete, the following steps save the workbook and exit Excel.
1
Tap or click the Save button on the Quick Access Toolbar.
2
Tap or click the Close button on the upper-right corner of the title bar.
3
Sign out of your account and shut down the computer as directed by your instructor.
Chapter Summary
In this chapter you have learned how to enter formulas, calculate an average, nd the highest and lowest numbers in
a range, verify formulas using Range Finder, add borders, align text, format numbers, change column widths and row
heights, and add conditional formatting to a range of numbers. In addition, you learned to spell check a worksheet,
print a section of a worksheet, and display and print the formulas version of the worksheet using the Fit to option. The
items listed below include all the new Excel skills you have learned in this chapter, with the tasks grouped by activity.
Enter Formulas
Enter a Formula Using the Keyboard (EX 73)
Enter Formulas Using Point Mode (EX 76)
Enter Functions
Determine the Highest Number in a Range of
Numbers Using the Insert Function Box (EX 82)
Determine the Lowest Number in a Range of
Numbers Using the Sum Menu (EX 84)
Determine the Average of a Range of Numbers
Using the Keyboard (EX 86)
Verify Formulas
Verify a Formula Using Range Finder (EX 89)
Format a Worksheet
Change the Workbook Theme (EX 91)
Change the Background Color and Apply a Box
Border to the Worksheet Title and Subtitle (EX 93)
Format Dates and Center Data in Cells (EX 96)
Apply an Accounting Number Format and Comma
Style Format Using the Ribbon (EX 97)
Apply a Currency Style Format with a Floating Dollar
Sign Using the Format Cells Dialog Box (EX 98)
Apply a Percent Style Format and Use the Increase
Decimal Button (EX 99)
Apply Conditional Formatting (EX 100)
Change Column Width (EX 103)
Change Row Height (EX 106)
Spell Check a Worksheet
Check Spelling on the Worksheet (EX 108)
Print a Worksheet
Change the Worksheet’s Margins, Header, and
Orientation in Page Layout View (EX 110)
Print a Section of the Worksheet (EX 114)
Display the Formulas in the Worksheet and Fit the
Printout on One Page (EX 116)
 
Search JabSto ::




Custom Search