Questions and Answers Flashcards

What is the difference between a workbook and a worksheet in Excel?

Answer: A workbook is the entire file containing one or more worksheets; a worksheet is a single tab within that file

A workbook is the Excel file itself (the .xlsx or .xlsm file), while a worksheet is an individual sheet (tab) within that workbook. One workbook can contain many worksheets.

How do you create a named range in Excel?

Answer: Select the cells, then type a name in the Name Box to the left of the formula bar

The fastest way to create a named range is to select the cells, click in the Name Box (which shows the cell reference), type your desired name, and press Enter.

What is the purpose of the Format Painter tool in Excel?

Answer: To copy formatting from one cell and apply it to other cells

Format Painter copies all formatting (font, color, borders, number format, etc.) from a source cell and applies it to destination cells with a single click or drag.

Which Excel feature helps you identify errors in formulas by showing which cells are referenced?

Answer: Trace Precedents and Trace Dependents

Trace Precedents shows arrows pointing from cells that feed into a formula, while Trace Dependents shows arrows pointing to cells that use the selected cell's value.

What is the difference between relative and absolute cell references in Excel?

Answer: Relative references change when copied to another cell; absolute references stay fixed

Relative references like A1 adjust based on the formula's new position when copied. Absolute references like $A$1 remain fixed regardless of where the formula is copied.

How can you quickly insert the current date into a cell in Excel?

Answer: Press Ctrl+; (semicolon)

Ctrl+; inserts the current date as a static value that does not update. Ctrl+Shift+; inserts the current time.