KEY PRE201 - 2

QN=27 (8163) =LEN() is used to measure the length of a cell (calculate the number of characters inside a cell). The question is: does the LEN() function count the " " (space) value? a. True b. False

A

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

A

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

A

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

A

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

A

QN=19 (8163) 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=20 (8163) 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=21 (8163) 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=22 (8163) CTRL+1 is the hotkey to open a property of a cell. a. True b. False

A

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

A

QN=1 (8153) You CANNOT customize the status bar at the bottom of the Excel Interface to show simple statistic functions. a. True b. False

B

QN=11 (8167) 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 above

B

QN=16 (8163) 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

B

QN=18 (8163) =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=2 (8157) 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=28 (8163) 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 above

B

QN=30 (8163) 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=31 (8163) You can ONLY sort A to Z using Sort&Filter in MS Excel a. True b. False

B

QN=32 (8163) 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=34 (8163) You cannot define your own rule when using Conditional Formatting. a. True b. False

B

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

B

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

B

QN=49 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=5 (8149) 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=51 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=54 You CANNOT filter in a Pivot Table. a. True b. False

B

QN=57 You CANNOT change a chart title by anymean. a. True b. False

B

QN=59 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=6 (8150) We CANNOT use nested functions in Excel. I.e. =HOUR(NOW()) will return the result ERROR. a. True b. False

B

QN=33 (8163) 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.

A

QN=35 (8163) 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=36 (8163) 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=4 (8143) "Ctrl" + "->" will get you to the last column. a. True b. False

A

QN=42 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 above

A

QN=47 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=48 The result of this function: =MONTH("6-June") is: a. 6 b. June

A

QN=53 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=55 Pivot table somehow can only solve some easy filtering cases. a. True b. False

A

QN=56 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=58 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=60 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=8 (8155) 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=13 (8171) Today is Friday 20-02-2014. What result will we have after entering a function: =TEXT(TODAY(),"dd") a. Friday b. Fri c. 20 d. An error

C

QN=14 (8163) 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=23 (8163) 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 above

C

QN=29 (8163) 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 above

C

QN=38 "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=40 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=45 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=46 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 above

C

QN=52 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=56 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 above

C

QN=9 (8165) 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 above

C

QN=17 (8163) 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=25 (8163) 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=26 (8163) 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=37 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 above.

D

QN=39 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=44 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=50 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

QN=56 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=7 (8141) 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