Sharpen your Microsoft Excel skills by identifying and correcting common statement errors with these beginner-friendly practice exercises.
A student says that a worksheet is a collection of workbooks. Identify and fix the mistake.
Issue: The student confused the relationship between workbook and worksheet.
A worksheet is a single spreadsheet, and a workbook is a collection of worksheets.
Someone describes rows as vertical divisions in Excel. Identify and fix the mistake.
Issue: Rows are horizontal, not vertical.
Rows are horizontal divisions; columns are vertical divisions in Excel.
A user says the cell reference includes only a number. Identify and fix the mistake.
Issue: A cell reference must include both a column letter and a row number.
A proper cell reference includes both the column letter and the row number, like A1 or B2.
A user refers to the active cell as the last cell in a worksheet. Identify and fix the mistake.
Issue: The active cell is the currently selected cell, not the last one.
The active cell is the one that is currently selected, not necessarily the last one in the worksheet.
Someone says the Title Bar displays the contents of the active cell. Identify and fix the mistake.
Issue: The Title Bar displays the workbook name, not cell content.
The Title Bar shows the workbook name; the Formula Bar displays the content of the active cell.