EX

QN=1 (12459) You can filter right in a pivot chart. a. True b. False

a

QN=17 (12497) In A1 type in: 1 In A2 type in: 1 In A3 type in: =A1=A2 In A4 type in: =A1-A3 What would the result be in A4? a. 0 b. False c. An Error

a

QN=18 (12490) Pivot table somehow can only solve some easy filtering cases. a. True b. False

a

QN=22 (12456) Pivot Table is an update version of Advance Filter since it removes the complexity of filtering data in a table by allowing the users to drag and drop the data they want to appear into the axis. a. True b. False

a

QN=23 (12438) In Excel, the Sheet2!A1 means that you are using a cell A1 in sheet2. a. True b. False

a

QN=24 (12451) What would the result be? =IF(YEAR(TODAY())=2013,"Present",IF(YEAR(NOW())>=2013,"Future","Past")) a. Present b. Future c. Past d. An error

a

QN=28 (12454) (SUM,AVERAGE,COUNT,MAX and MIN are called Aggregate functions since they all share the same mechanic: Calculating many values but the output will always be only one value. a. True b. False

a

QN=29 (12457) CTRL+1 is the hotkey to open a property of a cell. a. True b. False

a

QN=31 (12493) Select A1:A5. Click Merge&Center. What is the new address of the new cell? a. A1 b. A5 c. A1:A5 d. None of the others

a

QN=33 (12482) A1 contains a number: 1. A2 contains another number: 0 A3 contains a formula: =IFERROR(A1/A2,"") What is the result displayed in A3. a. A blank b. A space c. An error d. 1

a

QN=37 (12495) In A1 type in: 1 In A2 type in: 1 In A3 type in: =A1=A2 What would the result be in A3? a. True b. False c. N/A

a

QN=38 (12445) In Excel, you can record a macro to create your own function. a. True b. False

a

QN=39 (12505) Filtering data (CTRL+SHIFT+L) does NOT actually DELETE the unrelated rows but only HIDE them. a. True b. False

a

QN=43 (12447) VLOOKUP cannot search the LEFT column and HLOOKUP cannot search the ABOVE row. a. True b. False

a

QN=45 (12488) What is the DEFAULT choice of chart type when you hit ALT + F1 (a hotkey to draw a chart) a. Bar chart b. Pie chart c. Line Chart d. Scatter Chart

a

QN=46 (12504) F4 is a hotkey to fix both a row and a column address (I.e: A1 -> $A$1) a. True b. False

a

QN=47 (12502) CTRL + SHIFT + ENTER is the hotkey for entering array formula. (I.e: A1:A5*B1:B5) a. TRUE b. FALSE

a

QN=48 (12508) =COUNTBLANK() will count all the cells which are DISPLAYED as blanks even if it contains a formula somehow. a. True b. False

a

QN=51 (12507) =SEARCH() is used to find a position of a specific text within a cell. Meanwhile, =MATCH() is used to find a position of a specific value within a range. a. TRUE b. FALSE

a

QN=54 (12483) The result of this function: =MONTH("6-June") is: a. 6 b. June

a

QN=57 (12471) Pivot Table is an update version of Advance Filter since it removes the complexity of filtering data in a table by allowing the users to drag and drop the data they want to appear into the axis. a. True b. False

a

QN=6 (12499) V in VLOOKUP stands for Vertical. H in HLOOKUP stands for Horizontal. a. TRUE b. FALSE

a

QN=60 (12455) Excel Charts are always dynamic. Which means that if the users hide some of the data in the related tables, the Charts will automatically update according to the change. a. True b. False

a

QN=63 (12443) In Excel, to recognize the data type of a single cell, we will look at the default ALIGNMENT of the data. Now choose the correct statement: a. Dates are counted as numbers so they are right-aligned b. Dates are counted as texts so they are left-aligned c. Dates are counted as logical values so they are middle-aligned

a

QN=7 (12450) COUNTA will count a cell contains a formula even if that formula can return a blank value. a. TRUE b. FALSE

a

QN=8 (12439) "Ctrl" + "->" will get you to the last column. a. True b. False

a

QN=11 (12468) MATCH function is used to find the position number of a value. But what happen when there are SAME values in an array? Choose the best answer. a. MATCH function will always find the first number it encounters. b. MATCH function can find either the FIRST or the LAST number.

b

QN=13 (12446) Entering random numbers into range A1:A5 To order those numbers from smallest to largest we need to use: a. Data Validation b. Sort & Filter c. Conditional Formating d. All of the others

b

QN=21 (12466) You can ONLY sort A to Z using Sort&Filter in MS Excel a. True b. False

b

QN=26 (12486) What is the BEST choice of chart type when comparing the percentages? a. Bar chart b. Pie chart c. Line Chart d. Scatter Chart

b

QN=3 (12476) The result of =AND(4>5,6<9,OR(2<1,3>2)) is a. True b. False c. 1 d. #Value!

b

QN=34 (12467) In a blank sheet, type in this formula in any cell: =INDEX(A:A,COUNTA(A:A)+COUNTBLANK(A1:A11),1) What would the result be? a. An error b. 0 c. 1048576 d. N/A

b

QN=36 (12484) In A1,A2,A3 input values: 1,2 and "e". What is the result of =MAX(A1:A3) a. 1 b. 2 c. E d. An error.

b

QN=4 (12489) You CANNOT filter in a Pivot Table. a. True b. False

b

QN=40 (12440) Entering into cell A1 the exact following data: 0123 And A1 will display: a. 123 stored as text b. 123 stored as number c. 0123 stored as text d. 0123 stored as number

b

QN=49 (12465) Designing a template to allow students to enter their own profile, one uses the following formula in B1: =IF(B1= "", "Input again", B1) Will he prevent NULL data? a. Yes b. No

b

QN=50 (12437) In cell A1 type in a formula: ="" In cell A2 type in another formula: =COUNTBLANK(A1) What would be the result in A2? a. 0 b. 1

b

QN=52 (12478) What is the result of =AND(TRUE,FALSE)? a. True b. False c. 1 d. Not

b

QN=53 (12503) Given a list of number in column A. There is absolutely NO way to format column A to a Vietnamese currency style. (I.e: 1000 đồng) a. TRUE b. FALSE

b

QN=61 (12463) In A1 type in a formula: =B$1 Copy cell A1, paste into A2. What would the result be? a. =A$1 b. =B$1 c. =A$2 d. None of the others

b

QN=64 (12496) In A1 type in: 1 In A2 type in: 1 In A3 type in: =A1=A2 In A4 type in: =A1=A3 What would the result be in A4? a. True b. False c. N/A

b

QN=65 (12501) In Excel, to recognize the data type of a single cell, we will look at the default ALIGNMENT of the data. Now choose the correct statement: a. TEXTs are right-aligned. NUMBERs and DATEs are left-aligned. TRUEs/FALSEs are in the middle. b. TEXTs are left-aligned. NUMBERs and DATEs are right-aligned. TRUEs/FALSEs are in the middle. c. TEXTs are in the middle. NUMBERs and DATEs are right-aligned. TRUEs/FALSEs are left-aligned. d. None of the others are correct.

b

QN=68 (12469) You cannot define your own rule when using Conditional Formatting. a. True b. False

b

QN=9 (12494) You CANNOT change a chart title by anymean. a. True b. False

b

QN=12 (12475) In A1 input a number: 0.006. And in A2 input a formula: =ROUNDUP(A1,2) What is the result displayed in A2? a. 0.006 b. 0.002 c. 0.01 d. 0.1

c

QN=14 (12487) What is the BEST choice of chart type to show the development of something a. Bar chart b. Pie chart c. Line Chart d. Scatter Chart

c

QN=16 (12498) A1 and A2 are left blank intentionally. In A3 type in: =IF(A1=A2,FALSE, "") a. A blank b. An error c. FALSE d. TRUE

c

QN=19 (12444) In cell A1, input the data: 1 In cell A2, input another data: 2 In cell A3, input a formula: =A1=A2 In cell A4, input a formula: =A1=A3 What would be a result in A4? a. An ERROR b. TRUE c. FALSE d. None of the others

c

QN=25 (12506) In cell A1, input the function: =INT(-2.2) What is the output? a. An error b. -2 c. -3 d. -4

c

QN=30 (12480) In A1 type in: Random Text What is the result of this formula: =LEN(A1) a. 2 b. 10 c. 11 d. 12

c

QN=35 (12464) A clock's setting is currently in dd-mm-yyyy format. In A1 there is a formula: =TODAY() What is the result of the following function? = TEXT(A1,"yy")) a. 13 in number format b. 2013 in number format c. 13 in text format d. None of the others

c

QN=41 (12473) "Legends" in a bar chart are used to show a. The chart title b. The data used for that chart c. The caption d. Nothing

c

QN=44 (12458) In cell A1, input a data: 1 In cell A2, input a data: 2 In cell A3, input a formula: =A1+A2+A3 What would a result be? a. 3 b. 6 c. An error d. None of the others

c

QN=55 (12491) Entering random numbers into range A1:A5 To automatically highlight all the positive numbers, we need to use: a. Data Validation b. Sort & Filter c. Conditional Formating d. All of the others

c

QN=56 (12449) In A1:A6 there are several customers' names. What can this function do: =COUNTIF(A1:A6,"*Lam*")? a. Count all the person names that start with "Lam" b. Count all the person names that end with "Lam" c. Count all the person names that contain the word "Lam" d. Return an Error

c

QN=70 (12481) What formula is needed in B2 to calculate the age if the Date of Birth is already given in A2? a. =YEAR(A2)-YEAR(DATE) b. =YEAR(A2)+YEAR(DATE) c. =YEAR(TODAY()) - YEAR(A2) d. None of the others

c

QN=10 (12492) Entering 1,2,3,4,5 into A1:A5 accordingly. Entering this formula into A6: =A1&A2&A3&A4&A5 What would the result be in A6? a. An error b. 3 c. 15 d. 12345

d

QN=2 (12474) When you are typing a formula into a cell the first thing that must be entered is a. the first cell referenced b. Parenthesis c. quotation marks d. an equal sign

d

QN=27 (12479) In A2:E2 input 1,2,3,4 and 5. What is the result of the following formula: =SUM(A2:E2,5)+AVERAGE(A2:E2,3) a. 20 b. 21 c. 22 d. 23

d

QN=32 (12472) The advantage of using a spreadsheet is: a. Calculations can be done automatically. b. changing data automatically updates calculations c. more flexibility d. All of the others

d

QN=42 (12460) In cell A1, input the function: =ROUNDUP(10.9,1) What is the output? a. An error b. 10 c. 11 d. 10.9

d

QN=5 (12442) To calculate the salary of an employee, the company has to convert their working days into working weeks and remaining days since weekly salary and daily salary are calculated differently. For example: 22 days equal to 3 weeks and 1 remaining day. To solve this problem in Excel, we can use the following types of functions: a. INT & MOD b. ROUNDDOWN c. INT d. All of the others

d

QN=58 (12461) Cell A1 contains the text: SB707.1 Which of the following formulas can extract the number part of A1 then convert it to the right format? a. = VALUE(MID(A1,3,5)) b. = --RIGHT(A1,5) c. = RIGHT(A1,4)+0 d. Both a. and b. e. Both b. and c. f. a. b. c. are all correct

d

QN=59 (12448) Today is Friday 29-02-2013. What result will we have after entering a function: =TEXT(TODAY(),"dd") a. Friday b. Fri c. 29 d. An error

d

QN=62 (12453) =COUNTIF(Range,Criteria) is a formula to count with a condition. What is a correct formula to find number of cells in column A which has the value of 1? Choose the best answer. a. =COUNTIF(A:A,"1") b. =COUNTIF(A:A,1) c. =COUNTIF(A:A,"=1") d. All of the others

d

QN=66 (12500) The clock is now showing: 3:05 PM, 26-11-2013. What is the result of this following formula: =LEFT(YEAR(NOW()),2) & RIGHT(YEAR(NOW()),2) a. 20 b. 13 c. 33 d. 2013

d

QN=67 (12452) If a cell contains a data which is longer than its size, it will be displayed as: a. #VALUE b. #DIV/0 c. #N/A d. #########

d

QN=69 (12485) In A1 and A2 input values: 1 and 2. What is the result of =MAX(A1:A2,"e") a. 1 b. 2 c. E d. An error.

d