9. When a field does not show the type of data that you need, what transformation will you perform?

Select an answer:

Replace the values to fit.

Duplicate the field and change the data type.

Change the field name.

Change the data type.

10. The leadership of an organization has commissioned a study on data about the sales team. The goal of the project is to determine top performers and their attributes. After gathering data and establishing basic rules and requirements, what is the most reasonable question to explore first?

Select an answer:

Who are the top performing suppliers?

Who are the top performing salespeople for any given point in time?

What is the overall cost of a product?

What are the top performing products?

11.You need to create a field that provides the value "over" or "under" for sales, depending on whether the amount is greater than or equal to 15,000. Which type of function can you write to create this data?

Select an answer:

logical functions, such as IF, CONDITIONAL COLUMN, or IIF

lookup functions, such as XLOOKUP, VLOOKUP, or HLOOKUP

string functions, such as CONCAT, MERGE, or REPLACE

12. The monthly payroll system contains every pay period from the start of the year and is updated weekly. This data will be used to write a weekly payroll report. However, when working with the data, the date field for payroll date does not appear to have a date hierarchy. What is most likely?

Select an answer:

The payroll date needs to be converted to weekly values.

The data for the payroll date is missing.

The payroll date can be transformed to show the year.

The data type for the payroll date is not set to a date data type.

13. here is a "Full Name" field with last name and first name separated by a comma. How can you parse the field into "Last Name" and "First Name" fields?

Select an answer:

=LEFT(Full Name, 10)

=Right(Full Name, 10)

Text to Columns

=Concat(Full Name, Full Name)