Flashcards › Excel - Changing the Apperance of a Wordksheet

T/F: Wrapping will create a new line of text within a cell. True T/F: Rotating will move text from the right side of the cell to the left side of the cell. False T/F:Text in a cell may be aligned by clicking toolbar buttons or by choosing the Cells command on the Format menu. True T/F: The color of the text in a cell may not be changed. False T/F: Borders may be placed on any or all sides of a cell or range. True T/F: You can widen a column by using the Column Width dialog box. True T/F: The Merge and Center alignment button is commonly used to center a title across the top of a worksheet. True T/F: In order to change a cell’s appearance, you must first select the cell you want to change. True T/F: To paint a format, you must highlight the cell that you want to format. True T/F: You can remove the formats you apply to a cell by choosing Clear on the Tools menu. False When data is wider than the column, Excel will display the ____ symbol. ########## The ____ tab in the Format Cells dialog box contains the options for wrapping and rotating text. Alignment The ____ button on the Formatting toolbar is represented by a bucket of paint. Fill Color Which of the following occurs when a format is painted in a cell or range? The Format, but not the data, of the source cell is copied ot the destination cell. You would use the ____ to copy a cell’s format to another cell. Format Painter Formats that have already been created within Excel are called ____. AutoFormats The AutoFit Selection option is found on the Column submenu of the _?_ menu. Format Excel automatically _?_aligns a text entry in a cell. Left Arial and Times New Roman are examples of _?_ Fonts and Typefaces The _?_format displays data in a format designed by the user. Custom A(n) _?_icon identifies the Format Painter button on the toolbar. Paintbrush Displays numerical data that will not be used for calculation Text Displays either text or numerical data as keyed General Displays numerical data that requires a specific format Special Displays numerical data with a fixed number of places to the right of the decimal point Number Displays numerical data in exponential notation Scientific Begins a new line within the cell Wrapped Displays text at an angle Rotated Moves the text several spaces to the right Indented Places text in the middle of the cell Centered Excel Lesson 2