Learning Goal - Assesment

20 Questions | By ManjunaathMP | Updated: Mar 15, 2022 | Attempts: 60

Questions

Settings

Create your own Quiz

Questions and Answers

1.

Which of the below formula is valid only on Google spreadsheet?
- A.
  
  Unique
- B.
  
  Index Match
- C.
  
  Countif
- D.
  
  Filter
2.
What is the below tool renamed as?
- Gemini UI
- Brightroll DSP
- A.
  
  Gemini UI - Native Brightroll DSP - Brightroll
- B.
  
  Gemini UI - Gemini Brightroll DSP - DSP
- C.
  
  Gemini UI - Gemini Native Brightroll DSP - BR DSP
- D.
  
  Gemini UI - Native & Search Brightroll DSP - DSP
3.

In DSP, Predictive Audiences is now available for which of the below countries?
- A.
  
  Japan
- B.
  
  France
- C.
  
  Australia
- D.
  
  All of the above
4.

Which among them are case sensitive?
- A.
  
  Search
- B.
  
  Find
- C.
  
  All of the above
5.

In Store, The desired Age range can be selected only for the Yahoo user data.
- A.
  
  True
- B.
  
  False
6.

Oath has formally shifted from the 300x250 and 728x90 to which of the following ad formats?
- A.
  
  300x250 and 160x600
- B.
  
  728x90 and 1440x1024
- C.
  
  728x90 and 970x250
- D.
  
  300x600 and 970x250
7.

In Native & Search Marketplace how many sites can be blocked in total by advertisers?
- A.
  
  100
- B.
  
  300
- C.
  
  50
- D.
  
  500
8.

INDEX MATCH allows you to look up values in a table based off of other rows and columns.
- A.
  
  True
- B.
  
  False
9.

Oath Ad Platforms DSP buyers may run political ads.
- A.
  
  True
- B.
  
  False
10.

Native and Search Conversion Counting Controls are enabled at which level?
- A.
  
  Ad group level
- B.
  
  Account level
- C.
  
  Campaign level
- D.
  
  Ad level
11.

Which of the below excel functions helps to get the date in any desired format?
- A.
  
  Date
- B.
  
  Today
- C.
  
  Text
- D.
  
  Left
12.

I want the last day in the report. Which formula do I use?
- A.
  
  Today
- B.
  
  Now
- C.
  
  Max
- D.
  
  Count
13.

Which of the below formulae, when applied in one cell gets data for the entire table?
- A.
  
  Filter
- B.
  
  Unique
- C.
  
  CountA
- D.
  
  Sumif
- E.
  
  Importrange
14.

What is the term used for the discrepancy between selected users and Baseline users, in Audience insights?
- A.
  
  Variance
- B.
  
  Affinity
- C.
  
  Segment
- D.
  
  Percent Deviation
15.

What is the migration from premium to store called?
- A.
  
  1AS
- B.
  
  1PS
- C.
  
  1SA
- D.
  
  1SP
16.

When does Vlookup not work? And what is the solution to it?
- A.
  
  More than 200 characters and Index-Match is the solution
- B.
  
  More than 150 character and filter function is the solution
- C.
  
  More than 256 character and Index-Match is the Solution
- D.
  
  More than 256 character and Filter function is the solution
17.

What targeting yields the best result for Brand Awareness?
- A.
  
  Selected Targeting
- B.
  
  No Targeting
18.

How many parameters does the function OFFSET have?
- A.
  
  3
- B.
  
  5
- C.
  
  4
- D.
  
  6
19.

Difference between COUNT and COUNTA
- A.
  
  COUNT give the count of numeric values whereas COUNTA give you the count of data in a dataset
- B.
  
  COUNT give the count of data in a dataset whereas COUNTA give you the count of numeric values
- C.
  
  COUNT is for numbers and COUNTA is for text
- D.
  
  They are the same
20.

My Vlookup formula is throwing an error because the lookup values are different but they look alike with the naked eye. What function could possibly help to overcome this issue?
- A.
  
  RIGHT
- B.
  
  LEFT
- C.
  
  TRIM
- D.
  
  SUBSTITUTE