Learning Goal - Assesment

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Manjunaath
M
Manjunaath
Community Contributor
Quizzes Created: 1 | Total Attempts: 70
| Attempts: 72
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/20 Questions

    INDEX MATCH allows you to look up values in a table based off of other rows and columns.

    • True
    • False
Please wait...
About This Quiz

This quiz assesses knowledge on specific digital marketing tools and platforms, including unique features and updates in ad formats, audience targeting, and tool rebranding.

Learning Goal - Assesment - Quiz

Quiz Preview

  • 2. 

    Oath Ad Platforms DSP buyers may run political ads.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Oath Ad Platforms DSP buyers may not run political ads.

    Rate this question:

  • 3. 

    What is the below tool renamed as?
    • Gemini UI
    • Brightroll DSP

    • Gemini UI - Native Brightroll DSP - Brightroll

    • Gemini UI - Gemini Brightroll DSP - DSP

    • Gemini UI - Gemini Native Brightroll DSP - BR DSP

    • Gemini UI - Native & Search Brightroll DSP - DSP

    Correct Answer
    A. Gemini UI - Native & Search Brightroll DSP - DSP
    Explanation
    The tool "Gemini UI" has been renamed as "Gemini UI - Native & Search". The tool "Brightroll DSP" has been renamed as "Brightroll DSP - DSP".

    Rate this question:

  • 4. 

    When does Vlookup not work? And what is the solution to it?

    • More than 200 characters and Index-Match is the solution

    • More than 150 character and filter function is the solution

    • More than 256 character and Index-Match is the Solution

    • More than 256 character and Filter function is the solution

    Correct Answer
    A. More than 256 character and Index-Match is the Solution
    Explanation
    Vlookup does not work when the range of data exceeds 256 characters. In this case, the solution is to use the Index-Match function instead.

    Rate this question:

  • 5. 

    What targeting yields the best result for Brand Awareness?

    • Selected Targeting

    • No Targeting

    Correct Answer
    A. No Targeting
    Explanation
    No Targeting yields the best result for Brand Awareness because it allows the brand's message to reach a wide and diverse audience. By not narrowing down the target audience, the brand has the potential to reach more people who may not have been previously aware of the brand. This can lead to increased brand exposure and recognition, ultimately enhancing brand awareness.

    Rate this question:

  • 6. 

    In DSP, Predictive Audiences is now available for which of the below countries?

    • Japan

    • France

    • Australia

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    Predictive Audiences in DSP is now available for all of the mentioned countries: Japan, France, and Australia. This means that advertisers can use predictive modeling techniques to target specific audiences in these countries. With Predictive Audiences, advertisers can leverage data and algorithms to predict user behavior and optimize their ad targeting strategies, leading to more effective and efficient advertising campaigns.

    Rate this question:

  • 7. 

    I want the last day in the report. Which formula do I use?

    • Today

    • Now

    • Max

    • Count

    Correct Answer
    A. Max
    Explanation
    The "Max" formula is the correct answer because it is used to find the maximum value in a given range or set of values. In this case, if you want to find the last day in the report, you would use the "Max" formula to determine the maximum date or day in the report, which would be the last day.

    Rate this question:

  • 8. 

    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?

    • RIGHT

    • LEFT

    • TRIM

    • SUBSTITUTE

    Correct Answer
    A. TRIM
    Explanation
    The TRIM function can help overcome the issue of the Vlookup formula throwing an error due to similar-looking but different lookup values. The TRIM function removes any leading or trailing spaces from the text, ensuring that the lookup values are cleaned up and consistent. This can help match the lookup values accurately, resolving the error in the Vlookup formula.

    Rate this question:

  • 9. 

    What is the term used for the discrepancy between selected users and Baseline users, in Audience insights?

    • Variance

    • Affinity

    • Segment

    • Percent Deviation

    Correct Answer
    A. Affinity
    Explanation
    In Audience insights, the term used for the discrepancy between selected users and Baseline users is "Affinity." Affinity refers to the level of correlation or similarity between two different groups of users. It measures how likely a selected group of users is to have a certain characteristic or behavior compared to the baseline group. Therefore, Affinity is the correct term to describe this discrepancy in Audience insights.

    Rate this question:

  • 10. 

    Difference between COUNT and COUNTA

    • COUNT give the count of numeric values whereas COUNTA give you the count of data in a dataset

    • COUNT give the count of data in a dataset whereas COUNTA give you the count of numeric values

    • COUNT is for numbers and COUNTA is for text

    • They are the same

    Correct Answer
    A. COUNT give the count of numeric values whereas COUNTA give you the count of data in a dataset
    Explanation
    The correct answer is "COUNT give the count of numeric values whereas COUNTA give you the count of data in a dataset." This explanation accurately describes the difference between COUNT and COUNTA functions. COUNT is used to count the number of cells that contain numeric values, while COUNTA is used to count the number of cells that contain any type of data, including text, numbers, and empty cells.

    Rate this question:

  • 11. 

    Oath has formally shifted from the 300x250 and 728x90 to which of the following ad formats?

    • 300x250 and 160x600

    • 728x90 and 1440x1024

    • 728x90 and 970x250

    • 300x600 and 970x250

    Correct Answer
    A. 300x600 and 970x250
    Explanation
    Oath has formally shifted from using the ad formats 300x250 and 728x90 to using the ad formats 300x600 and 970x250.

    Rate this question:

  • 12. 

    How many parameters does the function OFFSET have?

    • 3

    • 5

    • 4

    • 6

    Correct Answer
    A. 5
    Explanation
    The function OFFSET has 5 parameters.

    Rate this question:

  • 13. 

    Which among them are case sensitive?

    • Search

    • Find

    • All of the above

    Correct Answer
    A. Find
    Explanation
    The word "Find" is case sensitive, meaning that it differentiates between uppercase and lowercase letters. The words "Search" and "All of the above" are not case sensitive, as they do not distinguish between uppercase and lowercase letters.

    Rate this question:

  • 14. 

    Native and Search Conversion Counting Controls are enabled at which level?

    • Ad group level

    • Account level

    • Campaign level

    • Ad level

    Correct Answer
    A. Campaign level
    Explanation
    Native and Search Conversion Counting Controls are enabled at the campaign level. This means that these controls can be set and adjusted for each individual campaign within an advertising account. By enabling these controls at the campaign level, advertisers have the flexibility to track and measure conversions specific to each campaign, allowing for more accurate performance analysis and optimization.

    Rate this question:

  • 15. 

    Which of the below excel functions helps to get the date in any desired format?

    • Date

    • Today

    • Text

    • Left

    Correct Answer
    A. Text
    Explanation
    The "Text" function in Excel helps to get the date in any desired format. This function allows users to convert a date into a text string with a specified format. By using this function, users can customize the date format according to their preference, such as displaying the date in dd/mm/yyyy or mm/dd/yyyy format. This is useful when users need to present the date in a specific format for reporting or analysis purposes.

    Rate this question:

  • 16. 

    What is the migration from premium to store called?

    • 1AS

    • 1PS

    • 1SA

    • 1SP

    Correct Answer
    A. 1AS
    Explanation
    The migration from premium to store is called 1AS.

    Rate this question:

  • 17. 

    In Native & Search Marketplace how many sites can be blocked in total by advertisers?

    • 100

    • 300

    • 50

    • 500

    Correct Answer
    A. 500
    Explanation
    Advertisers in the Native & Search Marketplace can block a total of 500 sites. This means that they have the ability to prevent their ads from appearing on these specific websites, potentially due to reasons such as brand safety concerns or audience targeting preferences. By blocking certain sites, advertisers can have more control over where their ads are displayed and ensure that they are reaching their desired audience effectively.

    Rate this question:

  • 18. 

    In Store, The desired Age range can be selected only for the Yahoo user data.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because in a store, the desired age range can only be selected for Yahoo user data. This suggests that the store has access to user data from Yahoo and allows users to filter or target specific age groups for their products or services. This feature may not be available for other user data sources or platforms.

    Rate this question:

  • 19. 

    Which of the below formula is valid only on Google spreadsheet?

    • Unique

    • Index Match

    • Countif

    • Filter

    Correct Answer(s)
    A. Unique
    A. Filter
    Explanation
    The formula "Unique" is valid only on Google Spreadsheet as it is a built-in function that returns a list of unique values from a range of cells. Similarly, "Filter" is also a valid formula on Google Spreadsheet which allows you to filter data based on specified criteria. "Index Match" and "Countif" are not specific to Google Spreadsheet and can be used in other spreadsheet applications as well.

    Rate this question:

  • 20. 

    Which of the below formulae, when applied in one cell gets data for the entire table?

    • Filter

    • Unique

    • CountA

    • Sumif

    • Importrange

    Correct Answer(s)
    A. Filter
    A. Unique
    A. Importrange
    Explanation
    The formulae "Filter", "Unique", and "Importrange" are capable of retrieving data for the entire table. The "Filter" formula allows users to extract specific data based on certain criteria, returning a filtered range of values. The "Unique" formula eliminates duplicate values from a range, providing a list of unique values. The "Importrange" formula enables users to import data from one spreadsheet to another, allowing for the retrieval of data from an entire table.

    Rate this question:

Quiz Review Timeline (Updated): Mar 15, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 15, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 28, 2018
    Quiz Created by
    Manjunaath
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.