QN=16 In cell A1, input the data: REGISTER
In cell A2, input the function: =
LEFT(A1,1)&MID(A1,2,1)&MID(A1,5,1)&MID(A1,4,1)&MID(A1,6,1)
The result of the function in A2 is:
a. REST
b. RESIT
c. RESTI
d. An Error
QN=17 In cell A1, input the function: =ROW(). Drag this function DOWN, we will get:
a. 1,1,1,1,1,1,1,1,1,....
b.
1,2,3,4,5,6,7,8,9,....
c. ROW(),ROW(),ROW(),ROW()....
d. None of the others
QN=18 In cell A1, input the function: =ROW().
Drag this function to the RIGHT, we will get:
a. 1,1,1,1,1,1,1,1,1,....
b. 1,2,3,4,5,6,7,8,9,....
c. ROW(),ROW(),ROW(),ROW()....
d. None of the others
QN=56 In A1 is a number: 1234 What is the result of:
=MID(A1,1,1)+MID(A1,2,1)+MID(A1,3,1)+MID(A1,4,1)
a. 10 because
1+2+3+4=10
b. #VALUE because 1,2,3,4 in TEXT type cannot be summed together.
This function returns the value in a table or a range by row.
The V in VLOOKUP stands for Vertical. It searches for a value in the first column of a table or an array of values, and then returns a value in the same row from a column you specify in the table or array.
Syntax: VLOOKUP (Lookup Value, Table/Array, Column Index Number, Range Lookup)
-Lookup_Value: The value to be found in the first row of the table. Lookup_value can be a value, a reference, or a text
string.
-Table_Array: A table of information in which data is looked up. Use a reference to a range or a range name.
~The values in the first column of the table_array can be text, numbers or logical values.
~If range_lookup is TRUE, the values in the first column of table_array must be placed in ascending order:...-2, -1, 0, 1, 2,...,A-Z, FALSE, TRUE; otherwise, VLOOKUP may not give the correct value. If range_lookup is FALSE table_array does not need to be sorted.
~Uppercase and lowercase text are equivalent.
~Sort the values in ascending order left to right.
-Row_Index_Num: The row number in table_array from which the matching value will be returned.
~A row_index_num of 1 returns the first row value in table_array, a row_index_num of 2 returns the second row value in table_array, and so on.
~If row_index_num is less than 1, VLOOKUP returns the #VALUE! error value.
~If row_index is greater than the number of rows on table_array,
VLOOKUP returns the #REF! error value.
-Range_Lookup: A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match.
~ If TRUE or omitted; an appropriate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned.
~If FALSE: VLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.
Ex.
=VLOOKUP(H2,$C$2:$D$18,2,FALSE)
Bc we need an exact match range_lookup ...the fourth parameter of the function is kept as FALSE.
- Assume a score has been entered in cell D2.
- A letter grade can be assigned to the score with an IFS function:
- =IFS(D2>=90,"A",D2>=80,"B",D2>=70,"C",D2>=60,"D",D2<60,"F")
- If the score is greater than or equal to 90, the first logical test is TRUE and a grade of A is displayed. The IFS function ends.
- If the score is not greater than or equal to 90, the next logical test runs. If the
score is greater than or equal to 80, the IFS function ends, and the result cell displays a B.
- If the score is not greater than or equal to 80, the next logical test runs. The process is continued until a logical test is TRUE.
- enter TRUE for the final logical_test argument
- the IFS example would be re-written as:
> =IFS(D2>=90,"A",D2>=80,"B",D2>=70,"C",D2>=60,"D",TRUE,"F")
> if the score is not greater than or equal to 90,
80, 70, or 60, then an "F" is returned
Aaron will only go outside if the temperature is between 62 and 78 degrees inclusive. If cell B2 contains the current temperature, write a formula that will display "may go outside" if the temperature is within the range; otherwise, it will display "will not go outside".
=IF(OR(B2>=62, B2<=78), "may go outside", "will not go outside")
=IF(AND(B2>=62, B2<=78), "may go outside", "will not go outside")
=IF(B2>=62, IF(NOT(B2<=78), "may go outside"), "will not go outside")
=IF(AND(B2<=62, B2>=78), "may go outside", "will not go outside")
Elina has a GPA given in cell G6. If Elina has a GPA greater than 3.0, then she is in Good Standing. If Elina has a GPA less than or equal to 3.0, but greater than 2.0, then she is in OK Standing. Otherwise, she is in Bad Standing. The result should ONLY SHOW either "Good Standing", "OK Standing" or "Bad Standing". Which formula correctly shows this?
=IF(G6 > 3.0, "Good Standing"), IF(G6 > 2.0, "OK Standing", "Bad Standing")
=IF(G6 > 3.0, IF(G6 > 2.0, "OK Standing", "Bad Standing"), "Good Standing")
=IF(G6 > 3.0, "Good Standing", IF(G6 > 2.0, "OK Standing", "Bad Standing"))
None of the choices listed are correct.