Question

1. When would you use the HLOOKUP function instead of a VLOOKUP?
2. What does the Subtotal dialog box do in addition to inserting subtotals?
3. Why do you have to select a range first to use the Quick Analysis tool?

Answer 1

Solution

1.When would you use the HLOOKUP function instead of a VLOOKUP?

VLOOKUP can be used if data has column header

it will search vertically across the column for matching condition

HLOOKUP can be used if the data has row header it will search horizontally across the row for matching condition

---

2.What does the Subtotal dialog box do in addition to inserting subtotals?

Subtitle dialog box contains various options

At Each Change in

It will identify the field that contain the item which you want to find the subtotal value sin the other column

Use Function

It will idenify the summary function used to calculate subtotals

Add Subtotal To

It will identify the field you want to calculate subtotal

Replace Current Subtotal

It will display the new subtotal rows

Page Break between Groups

it will insert the page break b/w each group

Summary below data

It will add the subtotal row belong the groupings

---

3.Why do you have to select a range first to use the Quick Analysis tool?

Quick Analysis is the tootls that will automatically appears in the lower right corner of the last selected cells

for using quick analysis tools first you need to select the range

---

all the best