Excel
A blank
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
False
The result of =AND(4>5,6<9,OR(2<1,3>2)) is a. True b. False c. 1 d. #Value!
6
The result of this function: =MONTH("6-June") is: a. 6 b. June
True
VLOOKUP cannot search the LEFT column and HLOOKUP cannot search the ABOVE row. a. True b. False
False
What is the result of =AND(TRUE,FALSE)? a. True b. False c. 1 d. Not
Future
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
an equal sign
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
MOD(n,d)= n - d*INT(n/d)
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
True
"Ctrl" + "->" will get you to the last column. a. True b. False
The caption
"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
All of the others
=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
True
=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
14 in text format
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. 14 in number format b. 2014 in number format c. 14 in text format d. None of the above
TRUE
COUNTA will count a cell contains a formula even if that formula can return a blank value. a. TRUE b. FALSE
True
CTRL+1 is the hotkey to open a property of a cell. a. True b. False
Both a. and b.
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
No
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
12345
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
123 stored as number
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
Conditional Formating
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
Sort & Filter
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
...
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
True
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
#########
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. #########
An error.
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.
0.01
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$1
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
0
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
False
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
True
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
11
In A1 type in: Random Text What is the result of this formula: =LEN(A1) a. 2 b. 10 c. 11 d. 12
2
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.
Count all the person names that contain the word "Lam"
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
23
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
True
In Excel, the Sheet2!A1 means that you are using a cell A1 in sheet2. a. True b. False
Dates are counted as numbers so they are right-aligned
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
True
In Excel, you can record a macro to create your own function. a. True b. False
0
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
1
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
An error
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
FALSE
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
10.9
In cell A1, input the function: =ROUNDUP(10.9,1) What is the output? a. An error b. 10 c. 11 d. 10.9
MATCH function can find either the FIRST or the LAST number.
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.
...
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
True
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
True
Pivot table somehow can only solve some easy filtering cases. a. True b. False
True
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
A1
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
All of the above.
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.
All of the others
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
20
Today is Friday 20-02-2014. What result will we have after entering a function: a. =TEXT(TODAY(),"dd") b. Friday c. Fri d. 20 e. An error
False
We CANNOT use nested functions in Excel. I.e. =HOUR(NOW()) will return the result ERROR. a. True b. False
=YEAR(TODAY()) - YEAR(A2)
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
Line Chart
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
Pie chart
What is the BEST choice of chart type when comparing the percentages? a. Bar chart b. Pie chart c. Line Chart d. Scatter Chart
Bar chart
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
False
You CANNOT change a chart title by anymean. a. True b. False
False
You CANNOT customize the status bar at the bottom of the Excel Interface to show simple statistic functions. a. True b. False
False
You CANNOT filter in a Pivot Table. a. True b. False
False
You can ONLY sort A to Z using Sort&Filter in MS Excel a. True b. False
True
You can filter right in a pivot chart. a. True b. False
False
You cannot define your own rule when using Conditional Formatting. a. True b. False
