 | |
MS Excel 2007 Odesk Test Answers PART 2 |
PART 2
Q:The
figure shows a view of the Standard Toolbar. What function is performed by the
button marked by the letter 'Y'?
Ans: It adds up the
values in the selected cells
Q:Which
of the following errors appears when an invalid argument is passed while converting
a number from one number system to another system?
Ans: #N/A
Q:Which
of the following function you will use to find the highest number in a series
of numbers?
Ans: MAX(B1:B3)
Q:You
have entered 4/6 as data in a cell without applying any formats to it. By
default, Excel will treat this data entry as a:
Ans: Date
Q:What
will be the output of the function IF(ISNA(MODE(B1:B4)),0,MODE(B1:B4)) when it
is applied to the data series given below?
Ans:#N/A
Q:AutoFilter
drop-downs are automatically added in the header row of a list when the list is
created.
Ans: TRUE
Q:What
does the NOW() function returns?
Ans: Returns the serial
number of the current date and time
Q:Which
toolbar is shown in the figure?
Ans: Forms toolbar
Q:When
you clear the contents from a cell, the formatting of the cell is also lost.
Ans: FALSE
Q:You
define a print area in your worksheet, but later you select a smaller range of
cells to print and then click Selection under the menu
File->Print->Selection. What will happen?
Ans: b
Q:
when a part of a formula is replaced with its calculated value, it cannot be
restored.
a. True.
Q:
When you sign the stamp signature line in an office document, you add both a
visible stamp and a document signature.
- True
Q:
Refer to the given image, what will be the result if the formula =B3&”, ”&A3 is applied to
the given table?
d. Both b and c
Q: How
will you reverse the direction of a Smart art graphics?
c. Under SmartArt tools,
on the Design tab, in the Create Graphic group, click on Right to Left
Q:
Which of the following chart have no
axes?
c. C-both a and b
Q:
Which of the following is not true regarding column width?
d. all of the above are
true
Q:
Which chart type is displayed in the given picture?
b.A surface chart
Q:What
does the red icon indicate as shown in the given picture?
b. it tells the
user that the document contains signatures
Q:
Which among the following is not true regarding a calculated column?
d. Additional formulae
cannot be entered in a calculated column as exceptions
Q:
What does the screen tip displaying “Showing all” mean?
a. It means that a filter
has been applied.
Q:
Which chart displays axes but can not display axis titles?
a. Radar chart
Q:
Which file format is typically used to remove printer corruption?
c. SYLK format
Q:
Which of the following methods would you follow to remove subtotals?
a. On the Data tab, in
the Outline group, click on Subtotal. The subtotal dialog box is displayed.
Click Remove all
Q:
When does triangle appear in the Top-left corner of the cell, as shown in the
picture?
c. When there is an error
in the formula
