Answer:
Option is b is correct answer. Excel performs exponentiation, then multiplication and division, then addition, and subtraction, it is correct order of operation in Excel. It is important to remember when you write any formula in Excel having different mathematical operators like +/ -/ ^/ etc, it follows a specific order and performs calculations in specific order which is termed as order of operator precedence. Each of mathematical operator has its precedence and executes in a special order set by Excel.
Explanation:
- As we already know order of precedence of each mathematical operator is different in Excel. The order of operations for Excel is as follows:
- Evaluate elements in parentheses.
- Evaluate 'ranges' ().
- Evaluate 'intersections' (empty spaces).
- Evaluate 'unions' (,).
- Perform negation (-).
- determine percentages (%).
- Perform exponentiation (^).
- Perform multiplication (*) and division (/), both are of equal precedence.
- Perform addition (+) and subtraction (-), both are of equal precedence.
- Evaluate text operators like (&).
- Perform comparisons like (=, <>, <=, >=).
Answer details
Grade: Middle
Subject: Computers and Technology
Chapter: Order of precedence of mathematical operators
Keywords: precedence in Excel, operators precedence etc
Link a GPO to the Marketing OU. In the GPO, edit the Enable client-side targeting policy and specify the Marketing Computers group.
In the WSUS console, edit the options for Computers and specify Use Group Policy or registry settings on computers.
In the WSUS console, create a Marketing Computers group.
Answer:
3. Granularity
Explanation:
Granularity's concept is representing the level of how do we store the data in our database.
If the data are detailed, we can resume the data until get a granularity more strong for our analysis.
For example:
We could store data year by year of our costumers, if want to get more granularity, we could store data month by month, also we could get specific data like how often our customers visit the business or how often our customers buy in a category product.
