on tap pre201
34
14. =MID(1234567,3,2) give number is
FALSE
35. What will result the expression =AND(OR(5=5,7=7,11>12),FALSE)?
123hello
37. Input into B1 a number:123 Input into B2 a text:hello Input into B3 a formula:= B1&B2 What is the result in B3:
24
38. =IFERROR(value, value if error) is used to prevent the output to result an error warning. What is the result of: =IFERROR(15+9, "Hello")
T
39. Given the two formulas: =COUNTIF(Range,Criteria) and =SUMIF(Range,Criteria,SumRange). The first two fields RANGE and CRITERIA in these two work exactly the same.
FAlSE
4.The expressions =(1=TRUE), =(0=TRUE), =(1=FALSE) and =(0=FALSE) are all
T
40. In counting how many numbers there are in a list (which contains only numbers), COUNT() and COUNTA() are both usable.
T
Both Advanced Filter and Pivot table can be used to remove duplicated values in a table
T
Both Normal Filter (Ctrl Shift L) in a table and Advance Filter can be used to SEE the UNIQUE values of an array.
Circular reference warning
If we enter the formula =IF(D5="","A", "B") in the cell in D5, it will result error
T
The expression =Sheet5!B7 will show a data in cell B7 of sheet named Sheet5.
3
The function =COLUMN(C1) results
T
The nature of some complicated functions such as COUNTIF or SUMPRODUCT is actually a combination of two other functions. (I.e. COUNTIF is IF then COUNT, SUMPRODUCT is PRODUCT then SUM)
T
The result the function =INDEX(B3:E10,4,3) will be the data inside the cell D6, because D6 is at row 4 and column 3 in the range B3:E10.
T
Ticking the "Unique records only" in Advanced Filter will remove all the duplicated data in that table.
T
MATCH, VLOOKUP and SEARCH are the 3 different functions in Excel. But these are all shared the same mechanic. They STOP after finishing the search for the first value.
-5,-6
ROUND(-5.2,0) = , and INT(-5.2) = .
Line Chart
The BEST chart type to use in Stock Analysing is
T
The COUNTBLANK function is used to count empty cells in a given range
T
The COUNTIF and SUMIF are available. But THERE ARE NO MINIF or MAXIF in Excel. However we can find a minimum/maximum value in an array with a specific condition by combine these functions with the IF function..
T
The HYPERLINK tool in Excel can actually help in making a web-interface spreadsheet
T
The VLOOKUP and HLOOKUP function are created to reduce the number of nested If(s) using in equally comparing.
T
Using RANK() function, the same values will get the same rank.
T
We can unmerge a cell.
T
We cannot use HLOOKUP to search for data in the UPPER row of the reference table.
Column chart
What is the DEFAULT chart type when you draw a chart in Excel is
T
When TRUE added to a number, it is considered as 1, thus =20+TRUE results 21 When FALSE added to a number, it is considered as 0, thus =20+FALSE results 20 How ever if we compare 1 with TRUE the result will be FALSE.
F2
When you press the key...., you can edit the content of current cell.
1
MATCH(B5,B5:B10,0) and =MATCH(B5,B5:F5,0) always gives result....
T
Every sorting method or formulas in Excel has 2 different orientation: ASCending and DESCending.
12/31/2015
In B1 input the date 12/10/2015. Then the result of =EOMONTH(B1,0) will always be....
T
In Excel dates are counted as numbers so they are right-aligned
T
In Pivot table, dragging a TEXT column into a Total Values Field will always display a COUNT() formula instead of a default SUM() because the SUM operation cannot be applied to text field.
T
In a column Chart in Excel, ticking the "VARY COLORS BY POINTS" will change the output of the default Legends (or the Captions) of that chart.
T
In filtering data, Pivot table is a very useful tool by allowing users to drag and drop columns in an original table. However it CANNOT solve some complicated filterings without making additional columns.
T
In functions =MATCH(value,array,0) and =VLOOKUP(value, table, column index, 0) the 0 (zero) in work EXACTLY the same.
