Answer:
The operation that will occur first is D5*C6 (multiplication).
Explanation:
Excel’s default order of operator precedence mandates that Excel perform multiplication before addition and substraction. If you want the addition or substraction to be performed before multiplication or division, they must be in parentheses.
The order of operations in exel is:
1. Evaluate items in parentheses.
2. Evaluate ranges (:).
3. Evaluate intersections (spaces).
4. Evaluate unions (,).
5. Perform negation (-).
6. Convert percentages (%).
7. Perform exponentiation (^).
8. Perform multiplication (*) and division (/), which are of equal precedence.
9. Perform addition (+) and subtraction (-), which are of equal precedence.
10. Evaluate text operators (&).
11. Perform comparisons (=, <>, <=, >=).
Answer:
#include <math.h>
#include <stdio.h>
#include <string.h>
#define BASE 3
#define NRQUESTIONS 15
void toABC(int n, char* buf, int base, int size) {
memset(buf, 'A', size);
buf[size] = 0;
while (n && size) {
buf[--size] = 'A' + (n % base);
n /= base;
}
}
int main()
{
char buf[16];
for (int i = 0; i < pow(BASE, NRQUESTIONS); i++) {
toABC(i, buf, BASE, NRQUESTIONS);
printf("%s\n", buf);
}
}
Explanation:
Assuming 3 is the number of possible answers to choose from for each question.
I tackled this by having an integer counter enumerate all values from 0 to 3^15, and then convert each integer to a base-3 representation, using ABC in stead of 012.
