How to
PakEvents4u
AIOU past papers,Odesk test answers, VU Papers, Papers, BISE news and many more.
Wednesday, April 1, 2015
Tuesday, March 31, 2015
oDesk MS Word 2007 Test Solution
2015
MS Excel 2007
oDesk MS Excel 2007 Test Answer
All data entry workers
must be needed to pass MS Excel 2007 Test exam at oDesk of any above windows MS
Excel versions. By following this answers shit you will pass with a very good
result.
Written and Solutions By: Muhammad Altaf
MS Excel 2007 Test
www.pakevents4u.blogspot.com
Time- 40 Minutes ID- …….. Mark-
5.00
1.
This question is based upon the figure shown below
Which
of the following options should be used to create a connection to a shared
network folder, as shown in the picture?
a.
A
b.
B
c.
C
d.
D
2. Which
of the following wildcard characters can be used as comparison criteria for
Text Filters?
a.
?
b.
*
c.
~
d.
All of the above
a.
Doughnut
charts
b.
Pie
charts
c.
Both a and b
d.
None of the above
4. What is the
option on the Document Inspector that finds the content type information?
a.
Comments
and Annotations
b.
Headers
and Footers
c.
Document Properties and Personal
Information
d.
Hidden Rows and Columns
5. Which
of the following is not a valid file extension in which an Excel file can be
saved?
a. .XLSB b. .XLSM c. .XLSX
d.
All of the above are valid
6. How would you
select an entire PivotTable report?
a.
On
the Home tab, in the Editing group, select the 'Entire PivotTable' option
b.
On the Options tab, in
the Actions group, click on Select, and then click 'Entire PivotTable'"
c.
On the Analyze tab, in the Data group,
click on 'Select Entire PivotTable' option
d.
None
of the above
7. Which of the
following is not true regarding naming a cell?
a.
Names are case sensitive
b.
A name can contain up to 255 characters
c.
Names
can contain uppercase and lowercase letters
d.
Some
keyboard characters can cause unexpected results if used in cell names
8. Which type of
additional information is stored within the digital signature?
a.
Date
information
b.
Time
information
c.
The
Office version number of the program in which the file was created
d.
All of the above
© oDeskGuideBlog.wordpress.com
9. How will you
find cells with data validation?
a.
On the Home tab, in the
Editing group, click the arrow next to Find & Select,, then click Go To
Special. Click on Data Validation, and then click All
b.
On the View tab, in the Windows group,
click Data Validation
c.
Both
a and b
d.
None
of the above
10. How should blank
cells be inserted on a Worksheet?
a.
Select the cell or the range of cells.
Then on the Home tab, in the Cells group, click 'Insert Cells'
b.
Select the cell or the range of cells.
Then right-click on the selected cells and click on Insert in the shortcut menu
c.
Both a and b
d.
None of the above
11. Which
scoping method should be used to conditionally format a set of fields in the
values area for all levels in the hierarchy of data?
a.
Scoping
by selection
b.
Scoping
by corresponding field
c.
Scoping by value field
d.
All of the above
12. Which keyboard
shortcut should be used to minimize or restore the ribbon?
a.
CTRL+F3
b.
CTRL+F2
c.
CTRL+F1
d.
None of the above
13. State whether
true or false:
When
you freeze panes, you select specific rows or columns that remain visible when
scrolling in the worksheet.
- True
- False
14. This
question is based upon the figure shown below
Refer to the given image. Which of the following
Fill options should be used to add color and transparency to a shape?
a.
A
b.
B
c.
C
d.
D
15. State
whether true or false:
When a part of a
formula is replaced with its calculated value, it cannot be restored.
a.
True
b.
False
16. When
'a' or 'p' is not typed after the time in Worksheet cells, what does Excel
enter the default time as?
a.
It
displays the prompt box and asks the user to type 'a' or 'p'
b.
It
displays an error message
c.
It enters the time as PM
d.
It enters the time as AM
Written and
Solutions By: Muhammad Altaf
e. None of the above
17. This question is
based upon the figure shown below
Refer
to the given picture. Which option causes the last row in the table to appear and
displays the word Total in the leftmost cell?
a.
A
b.
B
c.
C
d.
D
18. Which among the
following settings is the default macro setting?
a.
Disable
all macros without notification
b.
Disable
all macros except digitally signed macros
c.
Disabled all macros with notification
d.
Enable all macros
19. How will you
reverse the direction of a SmartArt graphic?
a.
Right-click
on the SmartArt graphic, select Reverse
b.
Under
SmartArt Tools, on the Format tab, in the Arrange group, select Reverse
c.
Under SmartArt Tools, on
the Design tab, in the Create Graphic group, click on Right to Left
d.
All of the above
20. This question is
based upon the figure shown below
When does the
triangle appear in the top-left corner of the cell, as shown in the picture?
a. When the cell contains hidden information
b.
When
the cell contains the Time function
c.
When there is an error in the formula
d.
None of the above
21. Which of the
given methods would you follow to add an alternative text to a picture?
a.
Right-click on the
picture, click on Size and Properties. Click on the Alt text tab, and then in
the alternative text box, enter your text
b.
Right-click on the picture, click on
Format. Click on the Alt text tab, and then in the alternative text box, enter
your text
c.
Both
a and b
d.
None
of the above
22. State
whether true or false:
When
you sign the stamp signature line in an Office document, you add both a visible
stamp and a digital signature.
a.
True
b.
False
23. This question is
based upon the figure shown below
What
is the significance of the red symbol at the top right corner of the cell, as
shown in the picture?
a.
It
signifies that the cell contains a formula
b.
It signifies that the cell contains a
comment
c.
It signifies that the cell contains a
macro
d.
All
of the above
24. This question is
based upon the figure shown below
Refer to the given image. Which line style option should be used to specify the style used for the end of the line?
a.
A
b.
B
c.
C
d.
D
25. Which file
format is typically used to remove printer corruption?
a.
XLS
format
b.
HTML
format
c.
SYLK format
d.
All of the above
26. This question is
based upon the figure shown below
Which Chart type
is displayed in the given picture?
a.
A
stock chart
b.
A surface chart
c.
An XY (Scatter) chart
d.
None
of the above
27. Which of the
following is not true regarding column width?
a.
If
the column width is set to 0, the column is hidden
b.
A
column width between 0 to 255 can be specified
c.
The
default column width is 8.43 characters
d.
All of the above are true
28. This
question is based upon the figure shown below
What is the
purpose of using the Keep text flat option, as shown in the picture?
a.
It prevents the text
inside the WordArt from rotating when rotate WordArt is rotated
b.
It prevents the text from blurring
c.
It
moves the WordArt or text backward
d.
Both
b and c
29. This question is
based upon the figure shown below
Refer
to the given image. Which formula should be written on the given table to
display "Nancy Davolio"?
- =UPPER(A2)
- =LOWER(A2)
- =PROPER(A2)
- None
of the above
30. State
whether true or false:
If
a SmartArt graphic was converted to individual shapes, it is not possible to
convert them back to the SmartArt graphic.
a. True
b.
False
31. Which
Lookup function should be used when the comparison values are located in a
column to the left of the data that is to be found?
a.
HLOOKUP
b.
VLOOKUP
c.
TRANSPOSE
d.
None
of the above
32. Which of the
following options would you choose to clear a PivotChart report?
a.
On the Analyze tab, in the
Data group, click on Clear, and then click 'Clear All'
b.
On the Options tab, in the Actions
group, click on Clear, and then click 'Clear All'
c.
Both
a and b
d.
None
of the above
33. How would you
locate the last filled cell on a worksheet?
a.
Click
anywhere in the worksheet, and then press CTRL+HOME
b.
Click
anywhere in the worksheet, and then press CTRL+INSERT
c.
Click anywhere in the worksheet, and
then press CTRL+END
d.
None of the above
34. This question is
based upon the figure shown below
Refer
to the given image. What will be the result if the formula =B3&",
"&A3 is applied on the given table?
- It
will display Nancy Davolio
- It
will display Fuller Andrew
- It will display Fuller, Andrew
- Both
b and c
35. State
whether true or false:
Case-sensitive
sorting of text in Excel2007 can be performed.
a.
True
b.
False
36. State whether
true or false:
Deleting the
PivotChart report automatically deletes the associated PivotTable report.
a. True
b.
False
ODesk Ms Word 2007 Test Solution
37. Which
database function estimates variance based on a sample from selected database
entries?
a.
DSTDEV
b.
DSUM
c.
DVAR
d.
DVARP
38. State whether
true or false:
For
XY (Scatter) and bubble charts; error bars for the x values, the y values, or
both, can be displayed.
a. True
b.
False
39. Where can the
'Show All Comments' command be found?
a.
On
the Page Layout tab
b.
On
the View tab
c.
On
the Review tab
d. All of the above
40. Which tab should
be used to display or hide axes?
a.
Data
tab
b.
Layout tab
c.
Insert tab
d.
View
tab
Subscribe to:
Posts (Atom)