In cell n2, enter a formula using the if function and a structured reference to determine if allison simoneau is eligible for tu
ition remission
1 answer:
Question is incomplete (See complete question below)
In cell N2, enter a formula using the IF function and a structured reference to determine if Alison Simoneau is eligible for tuition remission.
a. The IF function should first determine if the staff member's Service Years is greater than 1. Remember to use a structured reference to the Service Years column.
b. The function should return the text Eligible if the staff member's Service Years is greater than 1.
c. The function should return the text Not Eligible if the staff member's Service Years is not greater than 1.
Answer:
See attachment
Explanation:
Here, the name of the cell is N2.
In order to write the required query, we need to first get a table name.
For the purpose of this query, we'll assume the table name to be STAFF_TABLE.
Taking the above condition into consideration, the formula is as follows;
--- See attachment-----
The above formula test for the conditions listed out above and displays "ELIGIBLE" or "NOT ELIGIBLE", without the quotes depending on the outcome of the condition of SERVICE_YEAR > 1
You might be interested in
Answer:
Check the explanation
Explanation:
To solve the question above, we will be doing some arithmetic and bit wise operations on enum values. in addition to that, we are asserting the array with INTCOUNT and also printing the size of array i.e 12 and we are adding BIG_COUNT enum value to 5 and the result is 25.
#include<stdio.h>
enum EnumBits
{
ONE = 1,
TWO = 2,
FOUR = 4,
EIGHT = 8
};
enum Randoms
{
BIG_COUNT = 20,
INTCOUNT = 3
};
int main()
{
// Basic Mathimatical operations
printf("%d\n",(ONE + TWO)); //addition
printf("%d\n",(FOUR - TWO)); //subtraction
printf("%d\n",(TWO * EIGHT)); //multiplication
printf("%d\n",(EIGHT / TWO)); //division
// Some bitwise operations
printf("%d\n",(ONE | TWO)); //bitwise OR
printf("%d\n",(TWO & FOUR)); //bitwise AND
printf("%d\n",(TWO ^ EIGHT)); //bitwise XOR
printf("%d\n",(EIGHT << 1)); //left shift operator
printf("%d\n",(EIGHT >> 1)); //right shift operator
// Initialize an array based upon an enum value
int intArray[INTCOUNT]; // declaring array
// Have a value initialized be initialized to a static value plus
int someVal = 5 + BIG_COUNT; //adding constant and BIG_COUNT variable
printf("%d\n",someVal); //value will be 25
printf("%d",sizeof(intArray)); //value will be 12
return 0;
}
Kindly check the attached image below for the Code and Output Screenshots:
