Lesson 1 Microsoft Excel Basics practice test with complete verified solutions 2024.

Active Cell The cell in the worksheet in which you can type data. Active Worksheet The worksheet that is displayed in the work area. Brainpower Read More Previous Play Next Rewind 10 seconds Move forward 10 seconds Unmute 0:07 / 0:15 Full screen Adjacent Range A range where all cells touch each other and form a rectangle. Cell The insertion of a column and a row in a table or worksheet. Cell Reference A unique identifier for a cell, which is formed by combining the cell's column letter and row number. Column Appears vertically in the worksheet; identified by letters at the top of the worksheet window. Formula An equation that calculates a new value from values currently in a worksheet. Formula Bar The box to the right of the Name Box that displays a formula when the cell of a worksheet contains a calculated value (or the results of the formula). Landscape Orientation A page or worksheet rotated so it is wider than it is long. Microsoft Excel 2010 (Excel) The spreadsheet program in Microsoft Office 2010. Name Box The cell reference area located below the Ribbon, which displays the cell reference of the active cell. Nonadjacent Range A range that includes two or more adjacent ranges and selected cells. Portrait Orientation A page or worksheet rotated so it is longer than it is wide. Range A group of selected cells. Range Reference The unique identifier for a range, which is the cell in its upper-left corner and the cell in its lower-right corner, seperated by a colon. Row The horizontal placement of cells in a table or worksheet. Sheet Tab The name of each worksheet at the bottom of the worksheet window. Spreadsheet A grid of rows and columns in which you enter text, numbers, and the results of calculations. Workbook The file used to store worksheets; usually a collection of related worksheets. Worksheet A computerized spreadsheet in Excel.