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 for data entry and a worksheet is for charts

Answer

They are the same thing with different names

Answer

A worksheet can contain multiple workbooks

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

Right-click the cells and select Name Range

Answer

Press Ctrl+N while cells are selected

Answer

Go to Insert tab and click Named Range

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

To change the color of the worksheet background

Answer

To create custom number formats

Answer

To format text as a painting or image

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

Error Checking

Answer

Formula AutoComplete

Answer

Smart Lookup

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 are slower; absolute references calculate faster

Answer

Relative references work only on the current sheet; absolute references work across sheets

Answer

There is no practical difference between them

Question 6

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

Accepted Answer

Press Ctrl+; (semicolon)

Answer

Press Ctrl+D

Answer

Type =DATE()

Answer

Press F5