# Custom Calculations With Formula Edito

## Quiz by Support - BusinessPromoted .com

### Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

10 questions
• Q1
What is the main feature introduced in Zebra BI version 4.5?
Pre-built reports
Customizable dashboard
Formula editor
New data set connector
30s
• Q2
How can you add a custom row that is not in your data set to a Zebra BI table?
By adding a formula in the formula editor
By connecting to an external database
By manually entering the data
30s
• Q3
Which of the following is NOT a step involved in adding a custom calculated row using the formula editor?
Formatting the row
Naming the row
Selecting the data elements to be used in the formula
30s
• Q4
What does the autocomplete feature in the formula editor do?
Suggest elements already in your data set
Search for online resources
Provide recommendations for complex formulas
Edit the formula syntax
30s
• Q5
How can you format a custom row as a percentage in Zebra BI?
By selecting the formatting option after adding the row
By using a specific formula function
By clicking on the percent symbol (%) in the formula editor
By choosing the data type as percentage while creating the custom row
30s
• Q6
Which of the following cannot be included in a formula in the Zebra BI formula editor?
Text strings
Mathematical symbols (+, -, *, /)
Zebra BI functions
Data elements from other tables
30s
• Q7
What is the purpose of adding custom calculated rows to a Zebra BI table?
To connect to external data sources
To improve the visual appeal of the table
To perform calculations on existing data and display the results as new rows
To hide irrelevant data elements
30s
• Q8
In the video, what was the first custom calculated row added to the table?
Absolute variance
Relative variance
Net income percent of revenue
Gross profit percent of revenue
30s
• Q9
Besides adding new rows, what other functionalities does the formula editor provide in Zebra BI?
It allows editing existing data in the table
It allows filtering data based on specific criteria
It cannot perform any other functions
It can be used to create new tables
30s
• Q10
How does Zebra BI ensure that the custom calculated rows are applied to all the measures in the table?
Zebra BI does not support applying custom calculations to all measures
The formula editor automatically references all relevant measures
Custom calculated rows are only applicable to the data used in the formula
The user needs to manually specify which measures to include
30s

Teachers give this quiz to your class