Java Games: Flashcards, matching, concentration, and word search.

Excel Test 3 (Chapters 4 & 5) Study Guide

AB
Wrap TextCell format that allows all text in a cell to be seen
Merge and CenterCombines cells and centers the data in the combined cells
OrientationAlignment option that allows text to be angled
CurrencyFormat appropriate for information about money
TextFormat used for numbers that label things and that should not be manipulated mathematically
BordersFormat style to outline cells or cell ranges
Cell StylePreset formatting options often used for titles, headings, and emphasis
Format as TableFormats a range of cells in an organized manner for better visibility and manipulation
FontSets the appearance and shape of the letters, numbers, and special characters in MS Excel
Font ColorDefines the color of the characters in an MS Excel Worksheet
Font Size drop-down listOn the Home Ribbon, this changes the size of the characters in a cell
Font Color drop-down listOn the Home Ribbon, this changes the text color of the characters in a cell
AccountingA quick-number style button that formats numbers to display as money in the worksheet
OrientationCommand on the Home Ribbon used to rotate text to a vertical or diagonal angle in a worksheet
Cell StyleCommand used to format a cell or selected cells quickly by choosing from a defined list of visual criteria
Format CellsThe Dialog Box in MS Excel used to set the rotation of text in a cell to a specific degree
Decrease IndentCommand in MS Excel used to reduce the margin between the border and text in an indented cell
Fill ColorCommand used to apply a background color to cells in a worksheet
ConditionalFormatting appearing only when the value in a cell meets conditions specified by a user
AutoFitFormatting that allows the full text in a cell to be displayed on one row
#####Indicates that the number is too long to fit into the cell
Print AreaPage setup option that specifies a certain range of cells to print
Print TitlesPage setup option that sets row(s) to repeat at the top of every page of a printed spreadsheet
HideKeeps selected data from appearing on the worksheet without permanently deleting the information
ScaleForces data to fit in a specified location (e.g. all on one page)
UnhideRestores hidden data back to visibility
FormattingUsed to emphasize certain entries and make the worksheet easier to read and understand
ThemeSet of formatting choices including colors, fonts, and effects that the user can apply to a worksheet to enhance its appearance
Normal ViewExcel's Default View
Page Break PreviewDisplays, and allows manipulation of page breaks
Page Layout ViewShows the page as it should appear in print
MarginsBlank portions of a page that fall outside the main body of the printed document
FormatCommand on the Home Ribbon used to adjust row height and column width, organize sheets, and protect or hide cells in a worksheet
DeleteCommand on the Home Ribbon that removes cells, rows, or columns from a worksheet or table
BreaksCommmand on the Page Layout Ribbon that marks where a new page will begin on a printed copy
Remove Page BreakCommand used to remove manual page breaks from a worksheet area
Sheet OptionsCommand group on the Page Layout Ribbon that controls the presence of gridlines or headings on a worksheet


Computer and Careers Teacher
Fuquay-Varina High School
Fuquay-Varina, NC

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities