Excel
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
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
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
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
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.
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
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
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
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
a
QN=43 (12447) VLOOKUP cannot search the LEFT column and HLOOKUP cannot search the ABOVE row. a. True b. False
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
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
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
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=1 (12459) You can filter right in a pivot chart. a. True b. False
d
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
b
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.
c
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
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
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
a
QN=15 (12477) Which of the following equation is CORRECT: a. MOD(n,d)= n - d*INT(n/d) b. MOD(n,d)= n + d*INT(n/d) c. MOD(n,d)= n - d*INT(n:d) d. None of the others
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
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
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
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
a
QN=20 (12470) There is NO searching box when filtering in Excel 2007 a. True b. False
b
QN=21 (12466) You can ONLY sort A to Z using Sort&Filter in MS Excel 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
c
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
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
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
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
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
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!
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
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
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=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
b
QN=52 (12478) What is the result of =AND(TRUE,FALSE)? a. True b. False c. 1 d. Not
a
QN=54 (12483) The result of this function: =MONTH("6-June") is: a. 6 b. June
d
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
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
c
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
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
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
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
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.
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. #########
b
QN=68 (12469) You cannot define your own rule when using Conditional Formatting. a. True b. False
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.
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
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
a
QN=8 (12439) "Ctrl" + "->" will get you to the last column. a. True b. False
b
QN=9 (12494) You CANNOT change a chart title by anymean. a. True b. False