PRE 201

Which one of the following chart types can emphasizes differences between different sets of data over a period of time? a. Column chart. b. Line chart. c. Area chart. d. Pie chart.

A

In B1 input: 3 In B2 input: 3 =AVERAGE(B1:B2,5,7) will be A. 4 B. 3.5 C. 3 D. 2 E. 4.5

E

By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Select one: A. Both of above B. Click on Sheet 3 and from Edit menu choose Delete C. Right click on Sheet Tab of third sheet and choose Delete from the context menu D. None of above

C

To delete an embedded objects, first Select one: A. Double click the object B. Press the Shift + Delete keys C. Select it and then press the delete key D. Select the object by clicking it

C

To enter some text lines in one cell, keys must be pressed ..... a. Shift + Enter b. All of the others. c. Alt + Enter d. Ctrl + Enter

C

To remove the content of selected cells you must issue ______ command Select one: A. Data >> Delete B. Edit >> Clear >> All C. Edit >> Clear >> Contents D. Edit >> Delete

C

To show/hide the grid lines in Microsoft Excel Select one: A. Edit -> Grid lines -> View B. View -> Grid lines -> View C. Page Layout -> Grid lines -> View D. Insert -> Grid lines -> View

C

Weight refers to Select one: A. The height of the printed character B. The design and appearance of characters C. The print density of characters D. Upright or slanted shape

C

What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer. Select one: A. Word processor program B. Database program C. Spreadsheet program D. Desktop publisher program

C

What does "pivot" mean? a. Presenting concise, attractive, and annotated online or printed reports. b. Querying large amounts of data in many user-friendly ways. c. Moving rows to columns or columns to rows to see different summaries of source data. d. Subtotaling and aggregating large amounts of numeric data.

C

What does the following formula do? =COUNTIF(A2:E8,"COM?") Choose one answer. a. Count strings that end with COM and have random length in the range A2:E8 b. Count strings that end with COM and have 4 characters in the range A2:E8 c. Count strings that begin with COM and have 4 characters in the range A2:E8 d. Count strings that begin with COM and have random length in the range A2:E8

C

What function displays row data in a column or column data in a row? Select one: A. Index B. Hyperlink C. Transpose D. Rows

C

What is scope of the intSum variable in the following code? Sub MyMacro() Dim intSum As Integer intSum = 10 * 2 MsgBox intSum End Sub a. None of the others b. Module level c. Macro level d. Application level

C

What is the meaning of Option Base 2? a. That means array index in VBA must begin at a number greater than 0 b. That means you have to declare variable before use it c. Error raise d. That means array index in VBA must begin at a number greater than 1 e. That means array index in VBA must begin at 2

C

What is the meaning of number "0" in this following formula: =VLOOKUP(F1,A1:B10,2,0) Select one: a. Finding the relative value in F1 b. It does not have any meaning, just a part of the VLOOKUP syntax. c. Finding the exact value in F1 d. Finding the position value of number Zero in A1:B10

C

What is the meaning of the following code? Worksheets("Sheet1").Range("A1") = 75 a. Cell A1 contains 0 b. Error c. Cell A1 contains 75 d. Cells A1 contains a blank value

C

What is the result of the following code? MsgBox Sheets("Sheet1").Range("K4").Column a. 4 b. 10 c. 11 d. 5

C

Right clicking something in Excel: A. Deletes the object B. Opens a shortcut menu listing everything you can do to the object C. Nothing the right mouse button is there for left handed people D. Selects the object

B

Selecting the Column G & H then choose Insert->Columns. What will happen? Select one: 2 Columns will be inserted after Column I 2 Columns will be inserted after Column F 2 Columns will be inserted after Column G 2 Columns will be inserted after Column H

B

Status indicators are located on the Select one: A. Horizontal scroll bar B. Formula bar C. Vertical scroll bar D. Formatting toolbar

B

Suppose we are in November 2015. The result of the following function: =YEAR("TODAY") is 2015. A. TRUE B. FALSE

B

The ......... chart type allows user to choose Percentage in data displaying. a. Line b. Pie c. Scatter d. Column

B

The Paste Special command lets you copy and paste: a. Cell comments b. The resulting values of a formula instead of the actual formula c. Formatting options d. Multiply the selection by a copied value

B

The function FLOOR will ____ a. Round a number up. b. Round a number down, toward zero c. return the square root of a number. d. None of the others.

B

The function LOOKUP will ____ a. Add values in a vector or array. b. Look up values in a vector or array. c. None of the others. d. Multiply values in a vector or array.

B

The method to make a couple of rows ALWAYS visible when you scroll the spreadsheet down is called a. Text-to-Columns b. Freeze Panes c. Cosolidation d. Freeze Text

B

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) A. FALSE B. TRUE

B

The result of this function: =INDEX(B:B,4,2) will be the data inside cell: Select one: a. B4 b. Returns an error. c. B2

B

There are 4 types of error in Excel Select one: a. FALSE b. TRUE

B

There is NO rules in Conditional Formating to automatically highlight a MAXIMUM value of an array. A. TRUE B. FALSE

B

To activate the previous cell in a pre-selected range, press Select one: A. The Alt key B. None of the above C. The Enter key D. The Tab key

B

To create a formula, you first: Select one: A. Type the equals sign (=) to tell Excel that you're about to enter a formula B. Select the cell you want to place the formula into C. Enter the formula using any input values and the appropriate mathematical operators that make up your formula D. Choose the new command from the file menu

B

To enable Filter option in a table, the hotkey to use is Select one: a. Ctrl + Alt + Del b. Ctrl + Shift + L c. Ctrl + F1 d. Ctrl + Shift + F

B

To finish a work, 10 employees must work 10 hours/day for a whole 7 days. How many employees needed to finish that same work if the company only allow their staffs working 8 hours/day? To answer the question above, the BEST method is to use: A. None of the other choices B. =ROUNDUP() C. =ROUNDDOWN() D. =ROUND()

B

We CANNOT use HLOOKUP to search for data in the UPPER row of the reference table. Select one: a. False b. True

B

What does "cell pointer" mean? Choose one answer. a. None of the others b. Where data will go to when user begins to type. c. A cell with fill-handler. d. First cell in the active worksheet.

B

What does the filter condition "KD*" mean? Choose one answer. a. Filter all 3-character long items that contain KD b. Filter all items that begin with KD c. Filter all 2-character long items that contain KD d. Filter all items that contain KD

B

What is meaning of the following code? MsgBox Cells(1, 3).Address Choose one answer. a. Show the address C$1 b. Show the address $C$1 c. Show the address C1 d. Show the address $C1

B

What is the CTR + END key used for? a. To move the active cell to the position of the first column in the last row of the data sheet. b. To move the active cell to the position of the last column in the last row of the data sheet. C. None of the others. d. To move the active cell to the position of the last column in the first row of the data sheet.

B

What is the extension of an excel file that contains macro a. .xlsb b. .xml c. .xlsm d. .xls

B

What is the hotkey to move the pointer to the LEFT of a current cell Select one: a. Ctrl + Tab b. Shift + Tab c. Alt + Tab

B

When a row of data is to be converted into columns Select one: A. Copy the cells in row, select the same number of cells in row and paste B. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK. C. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK D. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK

B

Which of the following is correct? Select one: A. =POWER(2#3) B. =POWER(2,3) C. =POWER(23) D. =POWER(2^3)

B

Which of the following setup options can not be set in the page setup dialog box? Select one: A. Orientation B. Printer selection C. Vertical or horizontal placement D. Row and column titles

B

Which of the following you can paste selectively using Paste Special command? Select one: A. Formulas B. All of above C. Validation D. Formats

B

Which one of the following line charts displays trend over time and presents many data points? a. Stacked line with marker. b. Line with marker. c. Stacked line. d. A plain line.

B

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Select one: A. Press Shift + Home B. Press Ctrl +Home C. Press Alt + Home D. Press Home

B

You can enter which types of data into worksheet cells? A. Values and formulas but not labels B. Labels, values, and formulas C. Formulas only D. Labels and values but not formulas

B

You can use the horizontal and vertical scroll bars to Select one: A. Edit the contents of a cell B. View different rows and columns C. Split a worksheet into two panes D. View different worksheets

B

=COLUMN(B1) is A. B1 B. 2 C. 1 D. #VALUE

B.

A company's stock value in day 1 was 1000$. In day 2, stock value raised by 20%. In day 3, it dropped by 20%. The company's stock value is now: Select one: a. More than 1000$ b. Less than 1000$ c. 1000$

C

A numeric value can be treated as a label value if it precedes with Select one: A. Ampersand (&) B. Apostrophe (') C. Hash (#) D. Exclamation (!)

C

An user's system clock is in the format "dd-mm-yyyy". In A1 of a spreadsheet he enters a date: 30-02-2014. Then in A2 he enter a following formula: =DATE(A1). What would be the result of A2? Select one: a. 02 b. An error c. 30

C

As default, which function is used in value area? a. AVERAGE b. MIN c. None of the others d. COUNT e. MAX

C

When you copy a formula Select one: A. Excel erases the original copy of the formula B. Excel adjusts absolute cell references C. Excel edits cell references in the newly copied formula D. Excel doesn't adjust relative cell references

C

Which function cannot be used as a subtotal in a Pivot Table? a. Count b. Average c. Sum d. Lookup

C

Which of the following is invalid statement? Select one: Sheet tabs can be colored You can set the column width automatically fit the amount of text The width of a row can be specified manually or fit automatically Some picture can be applied as a background of a sheet

C

The command Edit >> Fill Across Worksheet is active only when Select one: A. None of above B. One sheet is selected C. When no sheet is selected D. When many sheets are selected

D

The default alignment of True/False data in Excel is Select one: a. Right b. Left or Right depends on how the users input them. c. Left d. Mid

D

The formula =Sheet1!A3 will show A. An error B. A data in cell A1 of sheet 3. C. Random number D. A data in cell A3 of sheet 1. E. A data in cell A1 of sheet 1.

D

The method to select the WHOLE column C is: A. Typing in the cell address: C1:C100 B. Typing in the cell address: C1:C1000 C. Typing in the cell address: C1:ROW() D. Clicking in C1 and hit: Ctrl - Shift - Down Arrow

D

The numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this? A. None of these B. Select Format > Money from the menu C. You have to retype everything and manually add the dollar signs, commas, and decimals. D. Click the Currency Style button on the formatting toolbar

D

There are 2 bacteria in the beginning. After 3 hours, each bacteria will be duplicated. The question is, to make a template with 1 input (number of hours passed) to automatically calculate how many bacteria at that time, we have to use Select one: a. =ROUND() b. =MOD() c. =ROUNDUP() d. =ROUNDDOWN()

D

There is a table with full data in an Excel file. That table address is A1:B100. Clicking into cell A5 then hit Ctrl +A. The result will be: Select one: a. Nothing b. The whole column A is selected c. The whole spreadsheet is selected d. The whole table is selected

D

To copy cell contents using drag and drop press the Select one: A. End key B. Ctrl key C. Shift key D. Esc key

D

To view a cell comment Select one: A. click the display comment command on the window menu B. click the comment command on the view menu C. click the edit comment command on the insert menu D. position the mouse pointer over the cell

D

Typing: =A1=A2+A2 into cell A3. The result in A3 will be a. A blank b. An error c. A number d. Either TRUE or FALSE

D

What does it mean when a macro is stored in this workbook? a. None of the others b. We can run this macro whenever Excel is opened. c. We can run this macro when we create a new workbook d. We can only run this macro when this excel file is opened.

D

What is NOT a chart type in Excel? Select one: a. Line Chart b. Pie chart c. Column chart d. Graph Chart

D

What is the DEFAULT chart type when you hit ALT + F1 to draw a chart in Excel? A. Pie chart B. Line Chart C. Scatter Chart D. Column chart

D

In A:A input a list of Vietnamese Fullnames (I.e. Pham Phuong Ha). To separate only the lastnames of the list, we need to use Select one: a. =LEFT and =SEARCH only b. =SEARCH() only c. =LEN() only d. =SEARCH() and =LEN() only

A

Which function can return a serial number of the current date and time in Excel? a. Now () b. Time() c. Date() d. Today()

A

What is the NameBox? a. None of the others. b. Displaying the some values which are specified by user. c. List of inputted data d. Displaying the value or the formula entered in the active cell.

D

What will the following code do? Columns("D:D").Clear Choose one answer. a. Clear all the content and format of cell D1 b. Clear all the content and format of column D c. Clear all the content of cell D1 d. Clear all the content of column D

D

When you group worksheets Select one: b. You can print more than one worksheet at a time c. You can enter common data, formats, and formulas on multiple worksheets at one time a. You can enter variable data on multiple worksheets at one time d. b and c

D

Which of the following format you can decide to apply or not in AutoFormat dialog box? Select one: A. format B. Border format C. Number format D. All of above

D

Which of the following is an absolute cell reference? A. #a#1 B. !A!1 C. A1 D. $A$1

D

Which of the following is not a valid data type in excel Select one: A. Label B. Number C. Date/time D. Character

D

Which of the following is not a way to complete a cell entry? Select one: A. Pressing enter B. Clicking the Enter button on the Formula bar C. Pressing any arrow key on the keyboard D. Pressing spacebar

D

You can merge the main document with data source in Excel. In mail merge operation, Word is usually Select one: A. server B. source C. none D. client

D

You can use the drag and drop method to A. Copy cell contents B. Move cell contents C. Add cell contents D . a and b

D

You want to track the progress of the stock market on a daily basis. Which type of chart should you use? Select one: A. Coumn chart B. Pie chart C. Row chart D. Line chart

D

=IFERROR(value, value if error) is used to prevent the output to result an error warning. What is the result of: =IFERROR(7+8, "This is an error") A. This is an error B. #VALUE C. 7+8 D. None of the others E. 15

E

The result of this function: =INDEX(B:B,3,1) will be the data inside cell: A. B2 B. #VALUE C. B4 D. B1 E. B3

E

The result of: =1+TRUE is Select one: A. 3 B. An error C. 0 D. 1 E. 2

E

The result of the command =LOOKUP("bump", {"a", 1;"b", 2;"c", 3}) is ... a. 2 b. 3 c. 1 d. None of the others.

a

When you print preview a worksheet a, b and c c. the active portion of the worksheet is displayed a. the entire worksheet is displayed b. the selected range is displayed

a

A formula is a function Select one: a. FALSE b. TRUE

A

"Qtr 1, Qtr 2, Qtr 3" is an example of Select one: a. Function b. Series c. Syntax d. Formula

B

The result of: =1=TRUE is Select one: A. True B. False

B

What is the meaning of Option Explicit? a. That means all the variables must not be declared b. That means all variables must be declared c. That means all the variables must be variant type d. That means all the variables must not be variant type

B

A function inside another function is called a ....... function. Select one: a. Text b. Range c. Nested d. ROUND e. SUM

C

The format of one function in Excel is a. =FunctionName() b. =FunctionName(Argument1,Argument2...) c. All of the others

C

When you insert an excel file into a word document. The data are Select one: A. Hyperlinked placed in a word table B. Embedded C. Linked D. Use the word menu bar and toolbars

C

When you want to insert a blank imbedded excel object in a word document you can A. Click the create worksheet button on the formatting toolbar B. Click the import excel command on the file menu C. Click the object command on the insert menu D. Click the office links button on the standard toolbar

C

Which chart type requires at least three series of values in order High-Low-Close? Choose one answer. a. Scatter b. Bar c. None of the others d. Pie e. Column

C

Which of the following formulas is not entered correctly? A. =10+50 B. =B7+14 C. 10+50 D. =B7*B1

C

Which of the following is not true regarding Conditional Formatting? Select one: A. You can delete any condition from Conditional Formatting dialog box if it is not requried B. You can apply Font, border and pattern formats that meets the specified conditions C. You can set condition to look for Bold and apply Italics on them. D. You can add more than one condition to check

C

Which one is not a property of an object in the following? a. Value b. Save c. Saved d. Text

C

You can activate a cell by A. Pressing an arrow key B. Pressing the Tab key C. All of the above D. Clicking the cell

C

=AVERAGE("A", "B", "C","D") is A. 1 B. A C. 2 D. An error E. B

D

How many recent files you can display on File menu at maximum? Select one: a. 6 b. 12 c. 4 d. 9

D

How many times does the loop repeat? Sub LoopTesting() Dim iCounter As Integer Do While iCounter <= 5 MsgBox "Hello world!", , iCounter + 1 Loop End Sub Choose one answer. a. 5 times b. 1 times c. 0 times d. Loop forever

D

You can group noncontiguous worksheets with Select one: A. The group button on the standard toolbar B. The shift key and the mouse C. The alt+enter key D. The ctrl key and mouse

D

=AND(OR(2=2,3=3,5>6),FALSE) will result: A. TRUE B. #VALUE! C. A blank D. 5>6 E. FALSE

E

$A$1 and $A1 will share the same meaning if the function is about to be dragged DOWN. Select one: a. FALSE b. TRUE

A

Hiding the data in a table will change the ouput of its related chart. Select one: a. TRUE b. FALSE

A

How can we fill the selected range with value "a"? Choose one answer. a. Enter "a" in the selected range and then press Enter b. Enter "a" in the selected range and then press Shift+ Enter c. Enter "a" in the selected range and then press Ctrl+ Enter d. None of the others

A

How can you remove borders applied in cells? Select one: A. Choose None on Border tab of Format cells B. Choose Outline on Border tab of Format cells C. Choose No color on Fill tab of Format cells D. Choose Inside on Border tab of Format cells

A

How to quickly select an entire column a. All of the others. b. Go to that column; left-click to first cell and drag mouse to the end c. Type header of that colum in name box. d. Left-click to header of that column

A

If 4/6 entered in a cell without applying any formats, Excel will treat this as Select one: Date Number Fraction Text

A

If the cell B1 contains the formula = $A$1, which of the following statements is true Select one: A. There is an absolute reference to cell A1 B. There is a relative reference to cell A1 C. Further changes in value of B1 will affect the value of A1 D. Further changes in value of A1 will not affect the value of B1

A

$A$1 and A$1 will share the same meaning if the function is about to be dragged to the RIGHT. A. TRUE B. FALSE

B

Which symbol must all formula begin with? A. @ B. = C. ( D. +

B

=AND(OR(1>1,2<2,2>=2),TRUE) will result: Select one: a. FALSE b. #VALUE! c. TRUE d. 1>2

A

=MATCH(value,array,0) =VLOOKUP(value, table, column index, 0) The 0 (zero) in these two functions above work EXACTLY the same. A. TRUE B. FALSE

A

A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this? Select one: A. Right click on the spreadsheet tab and select DELETE B. Right click on the spreadsheet and select Insert - Entire Column C. Go to File-Save As - Save As Type - Excel worksheet D. None of above

A

Advanced Filter CAN be used to remove duplicated values in a table while Pivot table CANNOT. Select one: a. False b. True

A

An user's clock is in "dd-mm-yyyy" format. In C1 input: 30-02-2014 In C2 input: =DAY(C1) The result in C2 will be: A. #VALUE B. 02 C. 14 D. 30

A

Both of the functions =MATCH(A1,A1:A15,0) =MATCH(A1,A1:G1,0) result the same value. Select one: A. TRUE B. FALSE

A

Can you set 0.5 inch left indentation for a cell in Excel? Select one: A. Indentation can be set from Format Cells dialog box B. Excel does not have indentation feature C. The indentation can be specified only when printing D. You can specify indentation only if you turn the rulers on

A

Choose right order in Object model of VBE a. Application > Workbook > Worksheet > Range > Cell b. Application > Workbook > Worksheet > Cell > Range c. Application > Worksheet > Workbook > Range > Cell d. None of the others.

A

Choose the right statement about VBA (Visual Basic for Application) a. VBA is a language that exists within a host application. For a VBA macro to run, its host application must be open b. VBA is a language that allows you to create standalone executable applications that do not even require its users to have Office or Excel loaded onto their computers. c. VBA is a language that only exists within Excel application. For a VBA macro to run, its workbook in Excel must be open

A

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Select one: A. data sheet B. chart sheet C. work sheet D. module sheet

A

Edit >> Delete command Select one: A. Deletes selected cells B. Deletes the comment of cell C. Deletes the content of a cell D. Deletes Formats of cell

A

Entering this formula in A1: =IF(A1= "", "Hello", "World") Will result: A. An error B. World C. The content of the cell A1 will be an empty string ("") D. Hello

A

Excel probably considers the cell entry January 1, 2000 to be a A. Value B. Text string C. Label D. Formula

A

Except for the ....... function, a formula with a logical function will shows either TRUE or FALSE as a result. Select one: a. IF b. AND c. NOT d. OR

A

From B1 to B15, insert a list of number: 1 to 15. The result of: =INDEX(B:B,5,1) is equal to =MATCH(5,B:B,0) A. TRUE B. FALSE

A

Functions of the fill-handle is (are). . . Choose one answer. a. All of the others b. Delete data c. Auto-fill a serie data d. Copy data

A

Getting data from a cell located in a different sheet is called ... A. Referencing B. Functioning C. Updating D. Accessing

A

Given the two formulas: =COUNTIF(Range,Criteria) =SUMIF(Range,Criteria,SumRange) The first two fields RANGE and CRITERIA in these two work EXACTLY the same. A. TRUE B. FALSE

A

If you need a text to show vertically in a cell. How will you achieve this? Select one: A. Choose 90 Degrees in Orientation of Format Cells dialog box B. Choose Center Across Selection from Horizontal combo box in Format Cells dialog box C. Choose Vertical on Text alignment in Format Cells dialog box D. Choose Distributed from the Vertical drop down list of Format Cells dialog box

A

In =RANK() function, the same values will get the same rank. a. FALSE b. TRUE

A

In A1 input a number: -5.2 And in A2 input a formula: =ROUND(A1,0) Then in A3 input a formula: =INT(A1) The results in A2 and A3 will be (relatively): Select one: a. -5 and -6 b. -6 and -5 c. -6 and -6 d. -5 and -5

A

In A1 is a number: 1234 What is the result of: =MID(A1,1,1)+MID(A1,2,1)+MID(A1,3,1)+MID(A1,4,1) Select one: a. 10 because 1+2+3+4=10 b. #VALUE because 1,2,3,4 in TEXT type cannot be summed together.

A

In A1:A5 relatively input the series of number: 1,2,3,1,1. What would be the result of the following function when typed in A6: =MATCH("1",A1:A5,0) . Select one: a. 1 - because the MATCH function will find the value and show the position number of that value in the list. b. 1 - because 1 appears the most in the series. c. 1 - because 1 is the minimum value in the list. d. 1 - because the MATCH function will find the value and show that value afterward.

A

In COUNTIF and SUMIF functions: Select one: a. "*" means multiple characters and "?" means exactly 1 character b. "*" means multiple characters and "_" means exactly 1 character c. "?" means multiple characters and "*" means exactly 1 character d. "_" means multiple characters and "*" means exactly 1 character

A

In Excel, by default Numeric Values appears in Select one: A. Right aligned B. Left aligned C. Justify aligned D,Center aligned

A

In a worksheet you can select Select one: a. a, b, and c b. Rows a. The entire worksheet c. Columns

A

It is very easy to group data in Date&time format using Pivot Table Select one: a. FALSE b. TRUE

A

LOOKUP functions are divided into Horizontal (Hlookup) and Vertical (Vlookup) based on the dimensions of the original data table. A. TRUE B. FALSE

A

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. A. TRUE B. FALSE

A

MS Excel provides the default value for step in Fill Series dialog box Select one: A. 1 B. 0 C. 5 D. 10

A

Open a blank spreadsheet. In cell A1 of Sheet 1 enter: 1 In cell A2 of Sheet 2 enter: =Sheet1!A2 In cell A3 of Sheet 3 enter: =Sheet1!A1 + Sheet2!A2 What would be the result in A3? Select one: a. 1 b. A random number c. An error d. A data in cell A1 of sheet 2.

A

Select a range in a spreadsheet then hit Tab continuosly, a. The pointer will move from left to right scanning the whole table. b. The pointer will end up in the last column of the spreadsheet. c. It will cancel the range selection.

A

The HYPERLINK tool in Excel can actually help in making a web-interface spreadsheet A. TRUE B. FALSE

A

The VLOOKUP and HLOOKUP function is born to reduce the number of nested If(s) using in equally comparing. A. TRUE B. FALSE

A

The result of the following function: =YEAR(NOW) is 2014. Select one: a. FALSE - because this is nested function and the NOW function is missing its brackets b. TRUE - because NOW function returns both the current date and the current time.

A

The two formulas: =INT(C1) and =ROUNDDOWN(C1,0) ALWAYS share the same result. A. TRUE B. FALSE

A

There are EXACTLY 8 tabs in the Excel Ribbon. a. FALSE b. TRUE

A

There is NO way to insert a Phone Number, e.g. 0987654321, in an Excel file A. FALSE B. TRUE

A

There is a table with full data in an Excel file. That table address is B1:D100. Clicking into cell B5 then hit Ctrl +A. The result will be: A. The whole spreadsheet is selected B. The whole column B is selected C. The whole table is selected D. Nothing

A

Ticking the "Unique records only" in Advanced Filter will remove all the duplicated data in that table. A. TRUE B. FALSE

A

To create a formula, you can use: A. Values but not cell references B. Value and cell references C. Values or cell references although not both at the same time D. Cell references but not values

A

To drag a selected range of data to another worksheet in the same workbook, use the Select one: A. Ctrl key B. Shift key C. Alt key D. Tab key

A

To insert three columns between columns D and E you would A. Select column E B. Select columns D, E and F C. Select columns E, F and G D. Select column D

A

We CANNOT use HLOOKUP to search for data in the UPPER row of the reference table. A. TRUE B. FALSE

A

What Pivot Table button can be used to update the data if the source data has changed a. Refresh Data b. Show Detail c. Format Report d. Pivot Table

A

What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed Select one: A. Refresh B. Pivot Table C. Show Detail D. Format Report

A

What does the VLOOKUP function do? Select one: a. Finds related record between columns b. Looks up all the text contains "V" c. All of the others d. Checks whether text is the same in one cell as in the next

A

What does the filter condition "*NN" mean? a. Filter all items that end by NN b. Filter all items that begin with NN c. Filter all 3-character long items that contain NN d. Filter all items that contain NN

A

=IFERROR(value, value if error) is used to prevent the output to result an error warning. What is the result of: =IFERROR(9+9, "This is not an error") Select one: a. This is not an error b. 18 c. #VALUE d. 9+9

B

What is the Ribbon? a. A button that provides access to workbook-level features and program settings b. A window that display an excel workbook c. A button used to change how the workbook content is displayed d. The main set of commands organized by task into tabs and groups

A

What is the default summary function for numerical data in a PivotTable? Choose one answer. a. None of the others. b. Count c. Min d. Max

A

What would be the result of the following formula: =SUM(1,1,MAX(MIN(1,2),0)) Select one: a. 3 b. 4 c. 1 d. 2

A

When you start typing the same value as of some cells on same column, Excel automatically shows that text. This feature is known as Select one: A. AutoComplete B. AutoCorrect C. AutoFormat D. AutoFill

A

Which chart type is used to display trends over time? Choose one answer. a. Line b. Area c. None of the others d. Column

A

Which of the following action removes a sheet from workbook? Select one: A. Select the sheet, then choose Edit >> Delete Sheet B. Both of above C. None of above D. Select the sheet then choose Format >> Sheet >> Hide

A

Which of the following describtes how to select all the cells in a single column. Select one: a. Left click on the gray column title button b. None of the others c. Use Text-to-Columns d. Right click on that column and select Pick from list

A

Which of the following is correct syntax in Excel? Select one: A. =IF(LogicalTest, TrueResult, FalseResult) B. =IF(LogicalTest, (TrueResult, FalseResult)) C. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult) D. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)

A

Which of the following methods can not be used to edit the contents of a cell? A. Press the Alt key B. Pressing the F2 key C. Clicking the formula bar D. Double clicking the cell

A

Which of these following items are NOT allowed to assign a hyperlink in a. A picture b. A rectangle shape c. None of the others d. A text

A

Which one in the following is not correct about VBA(Visual Basic for Application)? a. To use VBA, you must be first a profestional programmer b. Many things that Excel does not allow you to do manually, you can do with VBA c. VBA helps you save time-consuming works or cumbersome works to do manually d. With VBA, you can do faster, minimized risk of human error

A

You can auto fit the width of column by Select one: Double clicking on column right border on column header Double clicking on the column left border of column header Double click on the cell pointer in worksheet double clicking on the column name on column header

A

You can copy data or formulas A. All of the above B. With commands on ta shortcut menu C. With buttons on the standard toolbars D. With the copy, paste and cut commands on the edit menu

A

You can edit a cell by A. Double clicking the cell to edit it in-place B. Selecting Edit>Edit Cell from the menu C. Clicking the formula button D. None of above

A

You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values? Select one: A. F9 B. F11 C. F8 D. F5

A

You can set Page Border in Excel from Select one: A. You can not set page border in Excel B. From Border tab in Format Cells dialog box C. From Line Style tool in Drawing toolbar D. From Border tool in Formatting toolbar

A

You can use the formula palette to A. Create and edit formulas containing functions B. Format cells containing numbers C. Copy a range of cells D. Enter assumptions data

A

You can use the formula pallette to A. Create and edit formula containing functions B. Format cells containing numbers C. Enter assumptions data D. Copy a range of cells

A

_______ is a conditional format that adds a horizontal bar to the background of a cell proportional in length to the cell's value. a. Data bar b. Line chart c. Column chart d. Sparklines

A

_______ is a graph that is displayed in a cell, contains data marker to identify the high and low points, negative points, first point, last point. a. Sparklines b. Data bar c. Line chart d. Bar chart

A

A function inside another function is called a ..... function. A. Round B. Nested C. Text D. Sum

B

A worksheet range is a A. A range of values such as from 23 to 234 B. A group of cells C. A command used for data modeling D. A group of worksheets

B

=COLUMN(B5) is Select one: a. 1 b. 2 c. Nothing

B

A:A is the list of all Students' names with the format: Lastname Midname Firstname (i.e: Tran Van Thu) To count how many students with firstname as 'Van', the BEST function to use is: A. =COUNTIF(A:A, "Van*") B. =COUNTIF(A:A, "*Van") C. =COUNTIF(A:A, "*Van*") D. =COUNTIF(A:A, "&Van*")

B

Advanced Filter CAN be used to remove duplicated values in a table while Pivot table CANNOT. A. TRUE B. FALSE

B

All worksheet formula A. Manipulate values B. Return a formula result C. Manipulate labels D. Use the addition operator

B

COUNTIF() can only count within 1 condition while COUNTIFS can do it with multiple conditions. Select one: A. FALSE B. TRUE

B

Choose equivalent command with =VLOOKUP(1,A2:C10,2) a. =VLOOKUP(1,A2:C10,,TRUE) b. =VLOOKUP(1,A2:C10,,FALSE) c. =VLOOKUP(1,A2:C10,2,TRUE) d. =VLOOKUP(1,A2:C10,2,FALSE)

B

Choose the correct answer for the formula = Sqrt(8+8). Choose one answer. a. 16 b. 4 c. 8 d. 64

B

Choose the correct answer for two statements below (1) The Workbook collection contains the references to every worksheet object that is open in the same instance of Excel (2) Using Workbook collection, you can activate a particular worksheet without knowing its name. The statement (1) is ___ and (2) is ___ a. False, false b. True, true c. True, false d. False, true

B

Choose the correct answer for two statements below: (1) Chart sheet is a worksheet (2) The sheets that we can work on it by entering text, formula, date time The statement 1 is ..., and 2 is ... a. false, true b. true, false c. true, true d. false, false

B

Choose the correct text(s), present for April 6, 2013, is (are) recognized by Excel as date format. Assume that the date format in your computer is mm/dd/yyyy. b. 4/6/13 c. 4/6/2013 d. 6-Apr-13 e. 4-6-2013

B

Consider following code: Dim intMyNumbers As Integer Sheets("Practice Sheet").Range("a2").Select For intMyNumbers = 1 To 10 ActiveCell.Value=intMyNumbers ActiveCell.Offset(0, 2).Select Next intMyNumbers Choose one answer. a. None of the others. b. This code will places intermittently the numbers 1 to 10 across cells A2 to S2. c. This code will places the numbers 1 to 10 across cells A2 to J2. d. This code will place intermittently the numbers 1 to 10 across cells A2 to J2.

B

Each excel file is called a workbook because A. You have to work hard to create it B. It can contain many sheets including worksheets and chart sheets C. It can contain text and data D. It can be modified

B

Every sorting method in Excel has 2 different orientation: ASCending (smallest to largest) and DESCending (largest to smallest) Select one: A. FALSE B. TRUE

B

How can you update the values of formula cells if Auto Calculate mode of Excel is disabled? Select one: A. F8 B. F9 C. F11 D. F10

B

How do you delete a column? A. Select the column heading you want to delete and select Insert Delete from the menu B. Right click the column heading you want to delet and select delete from the shortcut menu C. Select the column heading you want to delete and select the Delete Row button on the standard toolbar D. Select the row heading you want to delete and select Edit>Delete from the menu

B

How to move to next line within a cell? a. Use Ctrl+Enter b. Use Alt+Enter c. None of the others d. Use Enter

B

How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell. Select one: A. the Settings tab under the menu Format -> Conditional Formatting B. The Settings tab under the menu Data -> Data Validation C. The Settings tab under the menu Format -> Cells D. The Settings tab under the menu Data -> Filter -> Advanced Filter

B

If the sign "######" appears on a cell, what does it mean? Choose one answer. a. Syntax error of the formulas b. The cell is not wide enough to display data c. This cell can not contain a text d. The cell is not high enough to display data

B

In A1 to A5 input the same formula: ="" In A6 is the function: =COUNTBLANK(A1:A5) What is the result of A6 A. 2 B. 5 C. 1 D. An error E. 0

B

In B1:B12 input the MONTHs: 1 to 12. In C1:C12, we want to input a formula to show the QUARTERs of each month accordingly. The SHORTER method here is: Select one: A. =IF() B. =ROUNDUP()

B

In C1 input a number: -5.6 And in C2 input a formula: =ROUND(C1,0) Then in C3 input a formula: =INT(C1) The results in C2 and C3 will be (relatively): A. -5 and -5 B. -6 and -6 C. -5 and -6 D. -6 and -5

B

In Pivot table, dragging a TEXT column into a Total Values Field will always display a COUNT() formula instead of a default SUM(). Select one: A. FALSE B. TRUE

B

In cell A1, input the data: HELLOWORLD In cell B2, input the function: =LEFT(A1,1)&MID(A1,2,1)&MID(A1,5,1)&MID(A1,4,1)&MID(A1,6,1) The result of the function in B2 is: A. HELLO B. HEOLW C. HELLOW D. #VALUE E. HEOLLW

B

In cell A1, input the function: =ROW(). Drag this function DOWN, we will get: A. 1,1,1,1,1,1,1,1,1,.... B. 1,2,3,4,5,6,7,8,9,.... C. ROW(),ROW(),ROW(),ROW().... D. None of the others

B

In counting how many numbers there are in a list (which contains only numbers), COUNT() and COUNTA() are both usable. Select one: A. FALSE B. TRUE

B

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. A. FALSE B. TRUE

B

Insert number 1 into A1. Then number 2 into A2. What would be the result of this formula entering in A3: =A1+(A1<A2) a. An error. b. 2 c. 0 d. 1

B

There is 1 bacteria in a bottle. Every 6 hours, the bacteria will replicate itself and therefore double the number of them. How many bacteria are there after a WHOLE day? a. 8 b. 2 c. 16 d. 4

C

C1 contains a random DATE. To confirm C1 is in the weekends or not, the needed function is: Select one: A. =IF(OR(TEXT(C1, "dddd")= "Saturday",TEXT(C1, "dddd")= "Sunday"), "Weekend", "Weekday") B. =IF(OR(WEEKDAY(C1)=7,WEEKDAY(C1)=1), "Weekend", "Weekday") C. Both of the others are usable

C

Choose the incorrect way to format the number 10000 to 10,000 VND. Choose one answer. a. 0,000 "VND" b. # "VND" c. #,##0 "VND" d. #,### "VND"

C

Concatenation of text can be done using A. Exclamation (!) B. Apostrophe (') C. Ampersand (&) D. Hash (#)

C

Data can be arranged in a worksheet in a easy to understand manner using A. auto formatting B. changing fonts C. all of above D. applying styles

C

Entering this formula in A1: =IF(A1= "", "Insert value here please!", "It's ok now!") Will result: Select one: a. Insert value here please! b. It's ok now! c. An error.

C

Excel uniquely identifies cells within a worksheet with a cell name A. Cell locator coordinates B. Cell names C. Column letters and row numbers D. Column numbers and row letters

C

How do you select an entire column? A. Select Edit > Select > Column from the menu B. Hold down the shift key as you click anywhere in the column. C. Click the column heading letter D. Hold down the Ctrl key as you click anywhere in the column

C

If we enter 1+2 into a cell, where is it aligned in that cell by default? a. Error b. Center c. Left d. Right

C

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must Select one: Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard

C

If you want to sort your database . . . a. Must select entire database b. None of the others c. Just click anywhere in the column by which you want to sort. d. Just click entire column by which you want to sort

C

In A1 input a particular date. Which one is NOT the proper way to check whether that date is Sunday or not. Select one: a. Using WEEKDAY function (i.e =IF(WEEKDAY(A1)=1,....) b. Using TEXT function ( i.e =IF(TEXT(A1, "ddd") = "Sun"....) c. Changing A1 format to "ddd" then use IF(A1= "Sun",...)

C

In A1 input a random Date of a random year in September (I.e. ??-09-????) The result of =EOMONTH(A1,2) will always be: a. 28 b. 29 c. 30 d. None of the others.

C

In A1 input: 2 In A2 input: 2 =AVERAGE(A1:A2,5) will be a. 4.5 b. 2 c. 3

C

In A1,A2 and A3 relatively input these numbers: 1,2, and 3. What would be the result of the function: =SUM(A1:A3,4) a. 8 b. An error. c. 10

C

In B1 is a number: 12345 What is the result of: =MID(B1,1,2)+MID(B1,2,1)+MID(B1,3,1) A. 6 B. #VALUE C. 17 D. 16 E. #N/A

C

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 texts so they are left-aligned B. Dates are counted as logical values so they are middle-aligned C. Dates are counted as numbers so they are right-aligned

C

In Microsoft Excel, which of the following is NOT a cell address Select one: a. $A$10 b. A$10 c. $10$A

C

In Microsoft Excel, which of the following is the absolute reference Select one: a. A$10 b. None of the others c. $A$10 d. $10$A

C

In buiding a formula in Excel, the hotkey to change one cell address to absolute reference and vice versa is: Select one: a. F5 b. F3 c. F4 d. F2

C

In the default setting of Excel, assume that the selected cell is B2. What is the active cell if we press Shift + Enter? a. B2 b. A2 c. B1 d. B3

C

In the default setting of Excel. Assume that the cell A1 has value a and the cell A2 has value c. If we select A1:A2 and drag the fill handle down to the cell A5. What is the value of cell A5? Choose one answer. a. i b. a c. None of the others d. c

C

Input into B1 a number:2 Input into B2 a text:books Input into B3 a formula:= "You have "&B1&B2 What EXACTLY is the result in B3: A. None of the others. B. You have books C. You have 2books D. You have 2 books

C

Long text can be broken down into many lines within a cell. You can do this through Select one: A. Justify in Edit >> Cells B. All of above C. Wrap Text in Format >> Cells D. Text Wraping in Format >> Cells, Layout tab

C

Restricting one particular set of data to input in one cell can be done by using Select one: a. Macro b. Conditional Formating c. Data Validation d. Data entry e. Freeze Panes

C

Suppose we are in November 2015. Type in: =TODAY() into cell A1. Change A1's data into custom type: YY. The final result will be: A. . November B. 2015 C. 15 D. #VALUE

C

The =MAX(number1,number2,....) function is used to calculate the maximum number in an array. Suppose the value in the cell B1 is 8. What is the result of the function: =MAX(1,2,3, "B1") A. 8 B. 3 C. #VALUE D. 6

C

The INTERSECTION of a row and a column is called a a. range b. there is no proper name for that kind of selection c. cell d. table

C

The formula =$C3*D3 is located in cell B2. If this was copied and pasted into cell B3, what would the resulting formula be: A. =$C3*$D4 B. =$C$3*C3 C. =$C4*D4 D. =C4:D4 E. =$C4*E3

C

The only way to resize multiple columns to the same width is by a. Changing their sizes one by one b. Not possible to do that. c. Selecting all those columns and resize one of them.

C

Which of the following is not true regarding Conditional Formatting? Select one: A. You can delete any condition from Conditional Formatting dialog box if it is not requried B. You can apply Font, border and pattern formats that meets the specified conditions C. You can set condition to look for Bold and apply Italics on them. D. You can add more than one condition to check

C

While Finding and Replacing some data in Excel, which of the following statement is valid? Select one: A. Excel does not have option to match case for find B. Both are valid C. You can Find and Replace within the sheet or workbook D. None are valid

C

You can check the conditions against __________ when applying conditional formatting Select one: A. Cell value B. None of above C. Both of above D. Formula

C

You can move a sheet from one workbook into new book by Select one: From Edit menu choose Move of Copy then choose (Move to end) and click OK None of above From Edit menu choose Move or Copy then select (new book) from To Book list and click OK From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK

C

You can select a single range of cells by Select one: A. Pressing the Shift key and an arrow key B. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells C. Dragging over the desired cells D. Pressing the Ctrl key while dragging over the desired cells

C

A circular reference is A. A cell that points to a drawing object B. Geometric modeling tool C. Always erroneous D. A formula that either directly or indirectly depends on itself

D

A list of college students includes a code to indicate the student's gender (male or female) and a field to identify the student's major. We want to display values of major field in one column, how do you configure the Pivot table? Choose one answer. a. Drag major field in report filter area. b. Drag major field in values area. c. Drag major field in row labels area. d. Drag major field in column labels area.

D

A list of college students includes a code to indicate the student's gender (male or female) and a field to identify the student's major. Which tool would you use to count number of males and females in each major? Choose one answer. a. None of the others b. SubTotal c. Filter d. Sort e. PivoteTable

D

Assume that cell A1 contains the text "car", cell A2 contains the text "bicycle", cell A3 contains the text "truck". In cell A4 we enter the formula =Sum(Len(A1:A2)) , then press Enter. What is the value of cell A4? a. 7 b. 5 c. 15 d. #Value! e. 3

D

B1 and B2 are left blank intentionally. What is the result of the function in the cell B3 if the formula below is typed in it: =B1=B1+B1+B2+B2 Select one: A. An error B. FALSE C. The content of B3 is blank D. TRUE

D

Choose the wrong statement about module a. A single module may hold one or many macros b. A module is a container for your code c. A project can have one or many modules d. A single module is another name of macros

D

Comments put in cells are called A. Web tip B. Smart tip C. Soft tip D. Cell tip

D

Consider the data table and the following code. Which result will be returned? MsgBox Cells(Rows.count, 2).End(xlUp).Row a. 6 b. The end row of excel 1048576 c. 1 d. 2

D

Defining your database as a table, follow additional advantage(s) is (are) supported: a. Auto Filter is turned on automatically. b. You can easily apply a large inventory of formats to your database. c. As you scroll down a table with many records, its headings remain visible onscreen. d. All of the others e. You are enabled to install a Total row.

D

Formatting a cell in Number format you can't set Select one: A. Decimal Places B. Negative numbers C. Use 1000 separator D. Currency Symbol

D

Gridlines a. Maybe turned off for displaying but turned on for printing b. Maybe turned off for displaying and printing. c. Maybe turned on or off for printing d. All of the others

D

How do you insert a row? A. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar B. All of the above C. Select the row heading where you want to insert the new row and select Edit >Row from the menu D. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

D

How should you print a selected area of a worksheet, if you'll want to print a different area next time? Select one: A. All of above B. On the file menu, point to print area, and then click set print area. C. On the view menu, click custom views, then click add D. On the file menu, click print, and then click selection under print what

D

How to Excel understand your number as a text? a. None of the others b. Use a bracket at begin of your number c. Use a semi-colon at begin of your number d. Use a quotes at begin of your number

D

If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you: A. Press the Erase key B. Press the Edit Formula button C. Press the Enter button D. Press Esc

D

In A1 and B1 input a number: 1 In A2 and B2 input a number: 2 What is the result of: A1:B1+A2:B2? Select one: a. 6 b. None of the others c. {2,4} d. {3,3}

D

In A1,A2 and A3 relatively input these numbers: 1,2, and 3. What would be the result of the function: =MIN(A1:A3, "e") Select one: a. 2 b. 1 c. 3 d. An Error

D

In C1 input a random Date of a random year in August (I.e. ??-08-????) The result of =EOMONTH(C1,0) will always be: A. 28 B. 29 C. None of the others. D. 31

D

In cell A1, input the function: =ROW(). Drag this function to the RIGHT, we will get: Select one: A. None of the others B. ROW(),ROW(),ROW(),ROW().... C. 1,2,3,4,5,6,7,8,9,.... D. 1,1,1,1,1,1,1,1,1,....

D

Map the definition in number with the name in letter 1 - Is a rectangular area that indicates data marker associated with data series 2 - Is the part of the chart that contains graphical presentation of data series 3 - Is a descriptive label of a chart 4 - Use to identify the unit at regular interval on the chart axis A - Chart title B - Plot area C - Tick marks D - Legend a. 1D - 2B - 3A - 4C b. 1C - 2D - 3B - 4A c. 1A - 2B - 3C - 4D d. 1B - 2C - 3A - 4D

D

Rounding errors can occur Select one: A. When you use addition and subtraction in a formula B. When you show the results of formulas with different decimal places that the calculated results C. Because excel uses hidden decimal places in computation D. When you use multiplication, division, or exponentiation in a formula

D

Study the dollowing code: Dim myVal1 as Integer, myVal2, myVal3 as String The data type of the myVal2 variable is ______ Choose one answer. a. Integer b. None of the others c. String d. Variant

D

Text formulas: Select one: A. Replace cell references B. Return ASCII values of characters C. Show formula error value D. Concatenate and manipulate text

D

The INTERSECTION of a row and a column is a CELL. But what is the UNION of a row and a column? A. a cell. B. data. C. an equation. D. there is no proper name for that kind of selection

D

The autofill feature a. Applies a border around selected cells b. None of the others c. Automatically colors a range of cell values d. Extends a sequential series of data

D

The command Edit >> Fill Across Worksheet is active only when Select one: A. None of above B. One sheet is selected C. When no sheet is selected D. When many sheets are selected

D

Formatting a cell in Currency, you can specify Select one: a. Decimal Places b. Both of above c. Currency Symbol d. None of above

b

In A1:A5 input random numbers. To compare each of the item in that list with 1, the method we should use is selecting B1:B5 then type: a. =IF(A1<1, "Smaller than 1", "Greater or equal to 1") Ctrl Enter b. =IF(A1:A5<1, "Smaller than 1", "Greater or equal to 1") Ctrl Shift Enter c. All of the others are usable

c

What will be the result if you type =A1=B1 in cell C1? Select one: a. Value of A1 b. Yes or No c. True or False d. Value of B1

c