I.T REGIEWER VLOOKUP

I.T REGIEWER VLOOKUP
9問 • 2年前
  • nicollette claire
  • 通報

    問題一覧

  • 1

    looks up a value in the first column of a given range and returns a value in the same row from another column. it searches for the value you specify and returns a matching value from another column.

    VLOOKUP Function

  • 2

    •It is the value to search for. •This can be a value (number, date or text), cell reference (reference to a cell containing a lookup value), or the value returned by some other function.

    Lookup_value (required)

  • 3

    It is the range of cells where to search for the lookup value and from which to retrieve a match.

    Table_array (required)

  • 4

    It is the number of the column from which to return a value. This specifies the column number from where we need to return the value.

    Col_index_num (required)

  • 5

    It determines whether to search for approximate or exact match

    Range_lookup (optional)

  • 6

    approximate match. If an exact match is not found, the formula searches for the largest value that is smaller than the lookup value. Requires sorting the lookup column in ascending order.

    TRUE or omitted (default)

  • 7

    - exact match. The formula searches for a value exactly equal to the lookup value. If an exact match is not found, a #N/A value is returned.

    FALSE

  • 8

    powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. allows you to extract the significance from a large, detailed data set.

    Pivot Table

  • 9

    It is the section that calculates the data.

    Values

  • Quiz I.T Week 3

    Quiz I.T Week 3

    nicollette claire · 34問 · 2年前

    Quiz I.T Week 3

    Quiz I.T Week 3

    34問 • 2年前
    nicollette claire

    Quiz I.T. Week 4

    Quiz I.T. Week 4

    nicollette claire · 29問 · 2年前

    Quiz I.T. Week 4

    Quiz I.T. Week 4

    29問 • 2年前
    nicollette claire

    Quiz I.T. Week 5

    Quiz I.T. Week 5

    nicollette claire · 7問 · 2年前

    Quiz I.T. Week 5

    Quiz I.T. Week 5

    7問 • 2年前
    nicollette claire

    midterm exam FAR

    midterm exam FAR

    nicollette claire · 40問 · 2年前

    midterm exam FAR

    midterm exam FAR

    40問 • 2年前
    nicollette claire

    midterm qui

    midterm qui

    nicollette claire · 20問 · 2年前

    midterm qui

    midterm qui

    20問 • 2年前
    nicollette claire

    CFAS CHAPTER 1

    CFAS CHAPTER 1

    nicollette claire · 41問 · 2年前

    CFAS CHAPTER 1

    CFAS CHAPTER 1

    41問 • 2年前
    nicollette claire

    CFAS CHAPTER 2

    CFAS CHAPTER 2

    nicollette claire · 28問 · 2年前

    CFAS CHAPTER 2

    CFAS CHAPTER 2

    28問 • 2年前
    nicollette claire

    CFAS CHAPTER 3

    CFAS CHAPTER 3

    nicollette claire · 9問 · 2年前

    CFAS CHAPTER 3

    CFAS CHAPTER 3

    9問 • 2年前
    nicollette claire

    I.T FINALS R3VIEWER EXCEL 1

    I.T FINALS R3VIEWER EXCEL 1

    nicollette claire · 35問 · 2年前

    I.T FINALS R3VIEWER EXCEL 1

    I.T FINALS R3VIEWER EXCEL 1

    35問 • 2年前
    nicollette claire

    I.T FINALS REVIEWER SORTING DATA

    I.T FINALS REVIEWER SORTING DATA

    nicollette claire · 20問 · 2年前

    I.T FINALS REVIEWER SORTING DATA

    I.T FINALS REVIEWER SORTING DATA

    20問 • 2年前
    nicollette claire

    chapter 4

    chapter 4

    nicollette claire · 30問 · 1年前

    chapter 4

    chapter 4

    30問 • 1年前
    nicollette claire

    chapter 5

    chapter 5

    nicollette claire · 10問 · 1年前

    chapter 5

    chapter 5

    10問 • 1年前
    nicollette claire

    Chapter 6

    Chapter 6

    nicollette claire · 20問 · 1年前

    Chapter 6

    Chapter 6

    20問 • 1年前
    nicollette claire

    chapter 7

    chapter 7

    nicollette claire · 15問 · 1年前

    chapter 7

    chapter 7

    15問 • 1年前
    nicollette claire

    chapter 9

    chapter 9

    nicollette claire · 10問 · 1年前

    chapter 9

    chapter 9

    10問 • 1年前
    nicollette claire

    Chapter 14

    Chapter 14

    nicollette claire · 5問 · 1年前

    Chapter 14

    Chapter 14

    5問 • 1年前
    nicollette claire

    chapter 14

    chapter 14

    nicollette claire · 24問 · 1年前

    chapter 14

    chapter 14

    24問 • 1年前
    nicollette claire

    Chapter 16

    Chapter 16

    nicollette claire · 20問 · 1年前

    Chapter 16

    Chapter 16

    20問 • 1年前
    nicollette claire

    chapter 24

    chapter 24

    nicollette claire · 25問 · 1年前

    chapter 24

    chapter 24

    25問 • 1年前
    nicollette claire

    chapter 25

    chapter 25

    nicollette claire · 10問 · 1年前

    chapter 25

    chapter 25

    10問 • 1年前
    nicollette claire

    chapter 17

    chapter 17

    nicollette claire · 20問 · 1年前

    chapter 17

    chapter 17

    20問 • 1年前
    nicollette claire

    chapter 18

    chapter 18

    nicollette claire · 15問 · 1年前

    chapter 18

    chapter 18

    15問 • 1年前
    nicollette claire

    問題一覧

  • 1

    looks up a value in the first column of a given range and returns a value in the same row from another column. it searches for the value you specify and returns a matching value from another column.

    VLOOKUP Function

  • 2

    •It is the value to search for. •This can be a value (number, date or text), cell reference (reference to a cell containing a lookup value), or the value returned by some other function.

    Lookup_value (required)

  • 3

    It is the range of cells where to search for the lookup value and from which to retrieve a match.

    Table_array (required)

  • 4

    It is the number of the column from which to return a value. This specifies the column number from where we need to return the value.

    Col_index_num (required)

  • 5

    It determines whether to search for approximate or exact match

    Range_lookup (optional)

  • 6

    approximate match. If an exact match is not found, the formula searches for the largest value that is smaller than the lookup value. Requires sorting the lookup column in ascending order.

    TRUE or omitted (default)

  • 7

    - exact match. The formula searches for a value exactly equal to the lookup value. If an exact match is not found, a #N/A value is returned.

    FALSE

  • 8

    powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. allows you to extract the significance from a large, detailed data set.

    Pivot Table

  • 9

    It is the section that calculates the data.

    Values