PRE PART 5

B

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

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

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

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

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

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

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 two formulas: =INT(C1) and =ROUNDDOWN(C1,0) ALWAYS share the same result. A. TRUE B. FALSE

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

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

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

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.

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. A. 4/6/13 B. 04/06/2013 C. 6-Apr-13 D. 4-6-2013

D

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

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

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

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()

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,....

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

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

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

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

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

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 function can return a serial number of the current date and time in Excel? a. Now () b. Time() c. Date() d. Today()

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 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

C

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

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

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

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