.png){kind=logo}
1. Explain the following terms for a reader who is not familiar with Excel: • Worksheet – The term that Excel uses to refer to a spreadsheet. • Workbook – A collection of one or more worksheets. • Cell – Found at the intersection of a row and a column. • Row – A record in the spreadsheet. • Column – A field in the spreadsheet. • Range – A selected cell, contiguous sequence of cells, or non-contiguous selection of cells. 2. How do you quickly navigate to the last row in a worksheet that contains data? Press End+  What happens when you press End in Excel? The End key is used for keyboard navigation. In combination with the arrow keys () it is used to move the active cell as follows: if the currently active cell is not blank, End +arrow shifts the active cell to the last contiguous nonblank cell in the arrow direction. If the currently active cell is blank, End +arrow shifts the active cell to the first nonblank cell in the arrow direction. In combination with CTRL and SHIFT it is used to select contiguous cell ranges. How do you move from one worksheet to another in Excel? Press Ctrl+Page Up to move one worksheet to the left or press Ctrl+Page Down to move one worksheet to the right. What purpose does the Go To dialog box serve? It allows the user to navigate quickly to a specific location. I
.png)