Microsoft Excel Questions and Answers 2

Question 1

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

Accepted Answer

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

Answer

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.

Question 2

How do you create a named range in Excel?

Accepted Answer

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

Answer

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.

Question 3

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

Accepted Answer

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

Answer

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.

Question 4

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

Accepted Answer

Trace Precedents and Trace Dependents

Answer

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.

Question 5

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

Accepted Answer

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

Answer

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.

Excel Practice Test

Excel Practice Test

Microsoft Excel Questions and Answers 2