PRE201
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 open the Sort dialog box by choosing Sort from the ..... menu Select one: a. Data b. Format c. Tools d. View
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
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
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
A
You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that? A) Custom List B) Auto Fill Options C) Fill Across Worksheet D) Fill Series
D
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
A
A circular reference is Select one: a. A formula that either directly or indirectly depends on itself b. Geometric modeling tool c. A cell that points to a drawing object d. Always erroneous
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
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
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. The content of B3 is blank b. FALSE c. An error d. TRUE
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
B
COUNTIF() can only count within 1 condition while COUNTIFS can do it with multiple conditions. Select one: A. FALSE B. TRUE
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
D
Comments put in cells are called A. Web tip B. Smart tip C. Soft tip D. Cell tip
C
Concatenation of text can be done using A. Exclamation (!) B. Apostrophe (') C. Ampersand (&) D. Hash (#)
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.
C
Ctrl + D shortcut key in Excel will A) Open the font dialog box B) Apply double underline for the active cell C) Fill down in the selection D) None of above
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
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
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
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
B
Formatting a cell in Currency, you can specify Select one: a. Decimal Places b. Both of above c. Currency Symbol d. None of above
D
Formatting a cell in Number format you can't set A) Decimal Places B) Use 1000 separator C) Negative numbers D) Currency Symbol
A
Hiding the data in a table will change the ouput of its related chart. Select one: a. TRUE b. FALSE
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
A
It is very easy to group data in Date&time format using Pivot Table Select one: a. FALSE b. TRUE
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.
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
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
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
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
B
MS Excel provides the default value for step in Fill Series dialog box A) 0 B) 1 C) 5 D) 10
C
MS Excel provides the default value for step in Fill Series dialog box Select one: A. 0 B. 5 C. 1 D. 10
A
MS Excel provides the default value for step in Fill Series dialog box Select one: A. 1 B. 0 C. 5 D. 10
C
The format of one function in Excel is a. =FunctionName() b. =FunctionName(Argument1,Argument2...) c. All of the others
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.
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 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
C
What will be the result if you type =A1=B1 in cell C1? Select one: a. Value of A1 b. Value of B1 c. True or False d. Yes or No
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
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
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 cell pointer indicate that you can move the content to other cell? A) Doctor's symbol (Big Plus) B) small thin plus icon C) Mouse Pointer with anchor at the tip D) None of above
D
Which of the following Excel screen components can NOT be turned on or off? A) Formula Bar B) Status Bar C) Tool Bar D) None of above
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
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
C
Which of the following formulas is not entered correctly? A. =10+50 B. =B7+14 C. 10+50 D. =B7*B1
B
"Qtr 1, Qtr 2, Qtr 3" is an example of Select one: a. Function b. Series c. Syntax d. Formula
A
$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
=AND(OR(1>1,2<2,2>=2),TRUE) will result: Select one: a. FALSE b. #VALUE! c. TRUE d. 1>2
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)
D
Edit >> Delete command A) Deletes the content of a cell B) Deletes Formats of cell C) Deletes the comment of cell D) Deletes selected cells
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
A
In Excel _______ may not contain in Formula Select one: a. Circular Reference b. Number Constant c. All of them d. Text Constant
A
Merge cells option can be applied from A) Format Cells dialog box Alignment Tab B) Formatting toolbar C) Both of above D) None of above
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
B
The default and maxium number of sheets for a new workbook in Excel 2003 is A) 3 and 255 B) 3 and 256 C) 1 and 255 D) 1 and 256
C
Special category of Number tab in Format Cells dialog box can be used to apply formats like A) Zip Code B) Phone Number C) Both of above D) None of above
A
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.
D
When a row of data is to be converted into columns A) Copy the cells in row, select the same number of cells in row and paste B) Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK C) Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK D) Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
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
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply A) Use =if() function to format the required numbers red B) Apply Conditional Formatting command on Format menu C) Select the cells that contain number between 0 and 100 then click Red color on Text Color tool D) All of above
C
Which one is not a property of an object in the following? a. Value b. Save c. Saved d. Text
D
when working in the page break preview, you can Select one: a. change the print area b. view exactly where each page break occurs c. add or remove page breaks d. all of above
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
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
C
Clear the contents by pressing "DELETE" key from a keyboard will clear Select one: a. Both Contents and Format b. Format Only c. Contents Only d. Text Only
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.
A
Each excel file is called a workbook because Select one: a. It can contain many sheets including worksheets and chart sheets b. It can contain text and data c. It can be modified d. You have to work hard to create it
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
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.
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
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
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 are data organized in a spreadsheet? Select one: a. Lines and spaces b. Layers and planes c. Height and width d. Rows and columns
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
C
How can you show or hide the gridlines in Excel Worksheet? A) Go to Tools >> Options >> View tab and mark or remove the check box named Gridline B) Click Gridline tool on Forms toolbar C) Both of above D) None of above
C
How do you change column width to fit the contents? Select one: a. All of above b. Press Alt and single click anywhere in the column c. Double click the boundary to the right of the column heading d. Single-click the boundary to the left to the column heading
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
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 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
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
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
B
How to specify cell range from A9 to A99 in Excel? Select one: a. (A9, A99) b. (A9 : A99) c. (A9 to A99) d. (A9 - A99)
B
If 4/6 entered in a cell without applying any formats, Excel will treat this as Select one: a. Number b. Date c. Fraction d. 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
B
If the cell B1 contains the formula = $A$1, which of the following statements is true Select one: a. Further changes in value of A1 will not affect the value of B1 b. There is an absolute reference to cell A1 c. There is a relative reference to cell A1 d. Further changes in value of B1 will affect the value of A1
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
C
If the values in A1 is "MCQ" and B1 is "Questions", which function will return "MCQ@Questions" in cell C1? Select one: a. =A1 $ "@" $ B1 b. =A1 # "@" # B1 c. =A1 & "@" & B1 d. =A1 + "@" + B1
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
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
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
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
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
A
In a worksheet you can select Select one: a. a, b, and c b. Rows a. The entire worksheet c. Columns
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
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
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,....
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
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.
D
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? A) Square B) Percentage C) Goal Seek D) Divide
B
Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc. can be applied from A) from Fromat >> Cells B) from Format >> Autoformat C) from Table >> Autoformat D) All of above
B
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
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
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.
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
B
Suppose we are in November 2015. The result of the following function: =YEAR("TODAY") is 2015. A. TRUE B. FALSE
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
B
Tab scroll buttons are place on Excel screen A) towards the bottom right corner B) towards the bottom left corner C) towards the top right corner D) towards the top left corner
C
Tab scroll buttons are place on Excel screen Select one: A. towards the top right corner B. towards the top left corner C. towards the bottom left corner D. towards the bottom right corner
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
B
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is Select one: a. B1;G10 b. B1:G10 c. G1-G10 d. B1.G10
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
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
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
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
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
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.
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.
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
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
E
The result of: =1+TRUE is Select one: A. 3 B. An error C. 0 D. 1 E. 2
B
The result of: =1=TRUE is Select one: A. True B. False
C
The short cut key Ctrl + R is used in Excel to A) Right align the content of cell B) Remove the cell contents of selected cells C) Fill the selection with active cells to the right D) None of above
A
The spelling tool is placed on ______ toolbar A) Standard B) Formatting C) Drawing D) Reviewing
A
The two formulas: =INT(C1) and =ROUNDDOWN(C1,0) ALWAYS share the same result. A. TRUE B. FALSE
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()
B
There are 4 types of error in Excel Select one: a. FALSE b. TRUE
A
There are EXACTLY 8 tabs in the Excel Ribbon. a. FALSE b. TRUE
C
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
B
There is NO rules in Conditional Formating to automatically highlight a MAXIMUM value of an array. A. TRUE B. FALSE
A
There is NO way to insert a Phone Number, e.g. 0987654321, in an Excel file A. FALSE B. TRUE
C
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
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
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
B
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
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
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
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
B
To edit data in an embedded Excel worksheet object in a Word document Select one: a. Edit the data in a Excel source application b. Use the Excel menu bar and toolbars inside the word application c. Edit the hyperlink d. Use the Word menu bar and toolbars b. Use the Excel menu bar and toolbars inside the word application
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
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
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()
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
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
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
C
To view a cell comment Select one: a. click the comment command on the view menu b. click the display comment command on the window menu c. position the mouse pointer over the cell d. click the edit comment command on the insert menu
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
B
We CANNOT use HLOOKUP to search for data in the UPPER row of the reference table. Select one: a. False b. True
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
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
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
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.
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.
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.
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
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
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
A
What happens when you press Ctrl + X after selecting some cells in Excel? Select one: A. The cells selected are marked for cutting B. The selected cells are deleted and cells are shifted up C. The selected cells are deleted and the cells are shifted left D. The cell content of selected cells disappear from cell and stored in clipboard
D
What is NOT a chart type in Excel? Select one: a. Line Chart b. Pie chart c. Column chart d. Graph Chart
A
What is entered by the function =today() A) The date value for the day according to system clock B) The time value according to system clock C) Today's date as Text format D) All of above
B
What is entered by the function =today() Select one: a. The time value according to system clock b. The date value for the day according to system clock c. All of above d. Today's date as Text format
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
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
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.
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
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.
A
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
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
D
What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells? a. F3 b. F5 c. F7 d. F11
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
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
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
What is the short cut key to replace a data with another in sheet? A) Ctrl + R B) Ctrl + Shift + R C) Ctrl + H D) Ctrl + F
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
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
D
When a range is selected, how can you activate the previous cell? A) Press the Alt key B) Press Tab C) Press Enter D) None of above
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
When you copy a formula Select one: a. Excel erases the original copy of the formula b. Excel doesn't adjust relative cell references c. Excel edits cell references in the newly copied formula d. Excel adjusts absolute cell references
C
When you enter Sunday and fill right, Excel fill in with Monday, Tuesday and so on. From where Excel knows what to fill in next? Select one: a. AutoComplete b. Calculation Automatic c. Custom List d. AutoFormat
D
When you group worksheets Select one: a. You can enter variable data on multiple worksheets at one time 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 d. b and c
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
When you insert an Excel file into a Word document, the data are Select one: a. Linked b. Embedded c. Hyperlinked d. Placed in a word table
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 link data maintained in Excel workbook to a Word document Select one: a. The Word document cannot be edited b. The word document must contain a hyperlink c. The Word document contains a reference to the original source application d. The word document contains a copy of the actual data
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
C
When you use the fill effects in the format data series dialog box, you can not Select one: a. select a pattern b. select a background color c. rotate text on the chart d. select a fore ground color
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
B
Where can you change automatic or manual calculation mode in Excel? A) Double CAL indicator on status bar B) Go to Tools >> Options >> Calculation and mark the corresponding radio button C) Both of above D) None of above
D
Where can you set the shedding color for a range of cells in Excel? A) Choose required color form Patterns tab of Format Cells dialog box B) Choose required color on Fill Color tool in Formatting toolbar C) Choose required color on Fill Color tool in Drawing toolbar D) All of above
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
B
Which command will you choose to convert a column of data into row? A) Cut and Paste B) Edit >> Paste Special >> Transpose C) Both of above D) None of above
A
Which function can return a serial number of the current date and time in Excel? a. Now () b. Time() c. Date() d. Today()
B
Which function will you use to enter current time in a woksheet cell? A) =today() B) =now() C) =time() D) =currentTime()
B
Which of the cell pointer indicates that you can fill series? A) Doctor's symbol (Big Plus) B) small thin plus icon C) Mouse Pointer with anchor at the tip D) None of above
A
Which of the cell pointer indicates you that you can make selection? A) Doctor's symbol (Big Plus) B) small thin plus icon C) Mouse Pointer with anchor at the tip D) None of above
A
Which of the following action removes a sheet from workbook? A) Select the sheet, then choose Edit >> Delete Sheet B) Select the sheet then choose Format >> Sheet >> Hide C) Both of above D) None of above
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
D
Which of the following is an absolute cell reference? A. #a#1 B. !A!1 C. A1 D. $A$1
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)
B
Which of the following is correct? Select one: A. =POWER(2#3) B. =POWER(2,3) C. =POWER(23) D. =POWER(2^3)
C
Which of the following is invalid regarding the Protection in Excel? A) Protect Sheet B) Protect Workbook C) Protect Workspace D) All of above are valid
D
Which of the following is invalid statement? A) Sheet tabs can be colored B) Some picture can be applied as a background of a sheet C) You can set the column width automatically fit the amount of text D) The width of a row and be specified manually or fit automatically
D
Which of the following is not a basic step in creating a worksheet? a. Save the workbook b. Modify the worksheet c. Enter text and data d. Copy the worksheet
D
Which of the following is not a valid Zoom percentage in Excel? A) 10 B) 100 C) 300 D) 500
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 valid data type in excel Select one: a. Number b. Label 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
A
Which of the following is not the correct method of editing the cell content? A) Press the Alt key B) Press the F2 key C) Click the formula bar D) Double click the cell
D
Which of the following is not true about Find and Replace in Excel A) You can search for bold and replace with italics B) You can decide whether to look for the whole word or not C) You can search in formula too D) You can search by rows or columns or sheets
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
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
D
Which of the following option is not available in Paste Special dialog box? A) Add B) Subtract C) Divide D) SQRT
C
Which of the following options is appropriate to show the numbers 9779851089510 in a cell? Select one: a. Enclose the number is brackets b. Place the character T before the number c. Apply the Text format in the cell and type the numbers d. Place the character TX before the number
D
Which of the following series type is not valid for Fill Series dialog box? A) Linear B) Growth C) Autofill D) Time
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
C
Which of the following setup options can not be set in the page setup dialog box? Select one: a. Row and column titles b. Orientation c. Printer selection d. Vertical or horizontal placement
A
Which of the following syntax is correct regarding to SUM function in Excel? Select one: a. All of the above b. =SUM (A1, B1) c. =SUM (A1:B9) d. =SUM (A1:A9, B1:B9)
D
Which of the following you can paste selectively using Paste Special command? A) Validation B) Formats C) Formulas D) All of above
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
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.
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
Which symbol must all formula begin with? A. @ B. = C. ( D. +
D
Which tool you will use to join some cells and place the content at the middle of joined cell? A) From Format Cells dialog box click on Merge Cells check box B) From Format Cells dialog box select the Centered alignment C) From Format Cells dialog box choose Merge and Center check box D) Click on Merge and Center tool on formatting toolbar
A
While Finding and Replacing some data in Excel, which of the following statement is valid? A) You can Find and Replace within the sheet or workbook B) Excel does not have option to match case for find C) Both are valid D) None are valid
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
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
D
Worksheet can be renamed by Select one: a. Worksheet cannot renamed b. Click on Worksheet tab by Holding CTRL Key and type new name c. Adding ? symbol at the end of filename while saving workbook d. Double Click on the Worksheet tab and type new name
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
D
You can auto fit the width of column by Select one: A. Double click on the cell pointer in worksheet D. Double clicking on the column left border of column header C. Double clicking on the column name on column header D. Double clicking on column right border on column header
C
You can automatically adjust the size of text in a cell if they do not fit in width by A) Double clicking on the right border of column header B) From Format choose Columns and then Autofit Selection C) From Format Cells dialog box mark Shrink to fit check box D) All of above
C
You can automatically adjust the size of text in a cell if they do not fit in width by Select one: a. All of above b. Double clicking on the right border of column header c. From Format Cells dialog box mark Shrink to fit check box d. From Format choose Columns and then Autofit Selection
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 edit a cell by Select one: a. Clicking the formula button b. None of above c. Double clicking the cell to edit it in-place d. Selecting Edit>Edit Cell from the menu
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
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
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
C
You can move a sheet from one workbook into new book by A) From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK B) From Edit menu choose Move of Copy then choose (Move to end) and click OK C) From Edit menu choose Move or Copy then select (new book) from To Book list and click OK D) None of above
D
You can move a sheet from one workbook into new book by Select one: a. None of above b. From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK c. From Edit menu choose Move of Copy then choose (Move to end) and click OK d. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
D
You can not link Excel worksheet data to a Word document Select one: a. With a hyperlink b. With the copy and paste special commands c. With the right drag method d. With the copy and paste buttons on the standard toolbar
D
You can print only an embedded chart by Select one: a. (2) Formatting the chart before you print b. (1) Moving the chart to a chart sheet before you print. c. (3) Selecting the chart before you print d. (1) and (3)
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 1
A
You can use the formula palette to Select one: a. Create and edit formulas containing functions b. Enter assumptions data c. Copy a range of cells d. Format cells containing numbers
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
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
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
_______ 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
B
(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
E
=AND(OR(2=2,3=3,5>6),FALSE) will result: A. TRUE B. #VALUE! C. A blank D. 5>6 E. FALSE
D
=AVERAGE("A", "B", "C","D") is A. 1 B. A C. 2 D. An error E. B
B
=COLUMN(B5) is Select one: a. 1 b. 2 c. Nothing
E
=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
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
C
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$
A
A formula is a function Select one: a. FALSE b. TRUE
B
A function inside another function is called a ..... function. A. Round B. Nested C. Text D. Sum
C
A function inside another function is called a ....... function. Select one: a. Text b. Range c. Nested d. ROUND e. SUM
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
B
A numeric value can be treated as a label value if it precedes with Select one: A. Ampersand (&) B. Apostrophe (') C. Hash (#) D. Exclamation (!)
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
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
A
A worksheet range is a Select one: a. A group of cells b. A range of values such as from 23 to 234 c. A group of worksheets d. A command used for data modeling
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
C
All worksheet formula Select one: a. Manipulate values b. Manipulate labels c. Return a formula result d. Use the addition operator
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
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
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
C
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
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.
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
A
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. A. 4/6/13 B. 4/6/2013 C. 6-Apr-13 D. 4-6-2013
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"
A
Excel probably considers the cell entry January 1, 2000 to be a A. Value B. Text string C. Label D. Formula
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
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
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
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
C
Getting data from a cell located in a different sheet is called ... Select one: a. Functioning b. Updating c. Referencing d. Accessing
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
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: A. Click on Remove Formatting tool on Standard Toolbar B. From Edit menu choose Delete C. From Edit menu choose Clear and then Formats D. Double click the Format Painter and then press Esc key in keyboard
D
If you press ...., the cell accepts your typing as its contents. Select one: a. Insert b. Ctrl + Enter c. TAB d. Enter
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
A
In =RANK() function, the same values will get the same rank. a. FALSE b. TRUE
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}
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
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: 2 In A2 input: 2 =AVERAGE(A1:A2,5) will be a. 4.5 b. 2 c. 3
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.
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
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
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 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
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 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
E
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
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
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()
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
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
It is acceptable to let long text flow into adjacent cells on a worksheet when A) data will be entered in the adjecent cells B) no data will be entered in the adjacent cells C) there is no suitable abbrevition for the text D) there is not time to format the text
B
It is acceptable to let long text flow into adjacent cells on a worksheet when Select one: A. there is not time to format the text B. no data will be entered in the adjacent cells C. data will be entered in the adjecent cells D. there is no suitable abbrevition for the text
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
Merge cells option can be applied from Select one: a. Both of above b. Formatting toolbar c. None of above d. Format Cells dialog box Alignment Tab
B
Status indicators are located on the Select one: A. Horizontal scroll bar B. Formula bar C. Vertical scroll bar D. Formatting toolbar
D
Status indicators are located on the Select one: a. Horizontal scroll bar b. Formatting toolbar c. Vertical scroll bar d. Formula bar
D
Selecting the Column G & H then choose Insert->Columns. What will happen? Select one: a. 2 Columns will be inserted after Column I b. 2 Columns will be inserted after Column H c. 2 Columns will be inserted after Column G d. 2 Columns will be inserted after Column F
B
Selecting the Rows 5 & 6 then choose Insert->Row. What will happen? Select one: a. 2 Rows will be inserted after Row 7 b. 2 Rows will be inserted after Row 4 c. 2 Rows will be inserted after Row 5 d. 2 Rows will be inserted after Row 6
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
B
The ......... chart type allows user to choose Percentage in data displaying. a. Line b. Pie c. Scatter d. Column
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
A
The Delete key of keyboard is assigned to which command in Excel? A) Edit >> Clear >> Contents B) Edit >> Clear >> All C) Edit >> Delete D) All of above
A
The HYPERLINK tool in Excel can actually help in making a web-interface spreadsheet A. TRUE B. FALSE
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
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 Name box on to the left of formula bar A) shows the name of workbook currently working on B) shows the name of worksheet currently working on C) shows the name of cell or range currently working on D) None of above
A
The Name box on to the left of formula bar Select one: A. shows the name of cell or range currently working on B. shows the name of workbook currently working on C. shows the name of worksheet currently working on D. None of above
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
D
The Paste Special command lets you copy and paste: Select one: a. Multiply the selection by a copied value b. Formatting options c. Cell comments d. The resulting values of a formula instead of the actual formula
A
The VLOOKUP and HLOOKUP function is born to reduce the number of nested If(s) using in equally comparing. A. TRUE B. FALSE
