Exam 18: Organizing and Enhancing Worksheets

When you delete the contents of a cell using the Delete key or the Backspace key, the formats for the cell remain in the cell.

When you split a worksheet horizontally, the panes appear side by side on the screen.

Case 18-1 Martha is a high school math teacher. She has created a worksheet to track her students' grades. She added two new students to the worksheet today and she wants to make sure the formatting is consistent. Which button should Martha use to add a black line to the bottom of a row of cells that contain the midterm exam grades?

By default, Excel aligns numbers at the left of the cell.

A ____ contains column headings or field names in a data source, such as a table or spreadsheet.

In Excel, the header row provides labels which identify the content in the worksheet columns.