Learning Goal - Assesment
.
Questions and Answers
- 1.
Which of the below formula is valid only on Google spreadsheet?
- A.
Unique
- B.
Index Match
- C.
Countif
- D.
Filter
Correct Answer(s)
A. Unique
D. FilterExplanation
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:
-
- 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
Correct Answer
D. Gemini UI - Native & Search Brightroll DSP - DSPExplanation
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:
- 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
Correct Answer
D. All of the aboveExplanation
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:
-
- 4.
Which among them are case sensitive?
- A.
Search
- B.
Find
- C.
All of the above
Correct Answer
B. FindExplanation
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:
-
- 5.
In Store, The desired Age range can be selected only for the Yahoo user data.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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:
-
- 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
Correct Answer
D. 300x600 and 970x250Explanation
Oath has formally shifted from using the ad formats 300x250 and 728x90 to using the ad formats 300x600 and 970x250.Rate this question:
-
- 7.
In Native & Search Marketplace how many sites can be blocked in total by advertisers?
- A.
100
- B.
300
- C.
50
- D.
500
Correct Answer
D. 500Explanation
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:
-
- 8.
INDEX MATCH allows you to look up values in a table based off of other rows and columns.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
INDEX MATCH is a combination of two functions in Excel, INDEX and MATCH. The INDEX function allows you to retrieve a value from a specific row and column in a table, while the MATCH function allows you to find the position of a value in a range of cells. By using these two functions together, you can look up values in a table based on criteria from other rows and columns. Therefore, the statement that INDEX MATCH allows you to look up values in a table based off of other rows and columns is true.Rate this question:
-
- 9.
Oath Ad Platforms DSP buyers may run political ads.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Oath Ad Platforms DSP buyers may not run political ads.Rate this question:
-
- 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
Correct Answer
C. Campaign levelExplanation
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:
-
- 11.
Which of the below excel functions helps to get the date in any desired format?
- A.
Date
- B.
Today
- C.
Text
- D.
Left
Correct Answer
C. TextExplanation
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:
-
- 12.
I want the last day in the report. Which formula do I use?
- A.
Today
- B.
Now
- C.
Max
- D.
Count
Correct Answer
C. MaxExplanation
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:
-
- 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
Correct Answer(s)
A. Filter
B. Unique
E. ImportrangeExplanation
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:
-
- 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
Correct Answer
B. AffinityExplanation
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:
-
- 15.
What is the migration from premium to store called?
- A.
1AS
- B.
1PS
- C.
1SA
- D.
1SP
Correct Answer
A. 1ASExplanation
The migration from premium to store is called 1AS.Rate this question:
-
- 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
Correct Answer
C. More than 256 character and Index-Match is the SolutionExplanation
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:
-
- 17.
What targeting yields the best result for Brand Awareness?
- A.
Selected Targeting
- B.
No Targeting
Correct Answer
B. No TargetingExplanation
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:
-
- 18.
How many parameters does the function OFFSET have?
- A.
3
- B.
5
- C.
4
- D.
6
Correct Answer
B. 5Explanation
The function OFFSET has 5 parameters.Rate this question:
-
- 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
Correct Answer
A. COUNT give the count of numeric values whereas COUNTA give you the count of data in a datasetExplanation
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:
-
- 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
Correct Answer
C. TRIMExplanation
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:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 15, 2023Quiz Edited by
ProProfs Editorial Team -
Sep 28, 2018Quiz Created by
Manjunaath
What's Your VARK Learning Style? Uncover Your Preferred Way to Learn!
What's Your VARK Learning Style? Uncover Your Preferred Way to Learn!
AWS Machine Learning - Specialty (MLS-C01 – 2020)
AWS Machine Learning - Specialty (MLS-C01 – 2020)
- Academic Quizzes
- Adult Learning Quizzes
- Blended Learning Quizzes
- Coaching Quizzes
- College Quizzes
- Communication Quizzes
- Curriculum Quizzes
- Distance Learning Quizzes
- E Learning Quizzes
- Early Childhood Education Quizzes
- GCSE Quizzes
- Grade Quizzes
- Graduation Quizzes
- Kindergarten Quizzes
- Knowledge Quizzes
- Literacy Quizzes
- Online Assessment Quizzes
- Online Exam Quizzes
- Online Test Quizzes
- Physical Education Quizzes
- Qualification Quizzes
- Religious Education Quizzes
- School Quizzes
- Special Education Quizzes
- Study Quizzes
- Subject Quizzes
- Teaching Quizzes
- Theory Quizzes
- Thesis Quizzes
- University Quizzes
Back to top