Upwork
MS Excel 2007 Test Answers 2015
1.
Questions: This question is based upon the figure show below ?
Refer
to the given image. What will be result if the formula =B3&’’, “&A3 I
table ?
a. It will display Nancy
Davolio
b. It will display fuller
Andrew
c. It will display
fuller Andrew (Answer)
2.
Questions: Which chart displays axes but cannot display axis titles ?
a. Radar chart
b. Doughnut chart
c. Pie chart
d. all of the above (answer)
3.
Questions: 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”. (answer)
b. On the Analyze tab, in
the Actions group, click on clear and then click “clear All”
c. Both a and b
d. None of the above.
4.
Questions: How can a chart be modified ?
a. By modifying a legend
b.
By modifying the display
of chart axes. (Answer)
c. By modifying titles and
data labels
d. All of the above
5.
Questions: which method will you use to update table data from a Sharepoint
list?
a.
On
the data tab, in the data tools group, click refresh
b.
On
the view tab, in the show/hide group, click refresh
c. On the design tab, in the External data group, click refresh. (answer)
d.
None
of the above
6.
Questions: which of the following is not true regarding naming a cell ?
a. Names are case sensitive(answer)
b.
A
name can contain up to 255 character
c.
Names
can contains uppercase and lowercase letters
d.
Some
keyboard characters can unexpected results if used in cell names
7.
Questions: which among the following settings is the default macro setting ?
a.
Disable
all micro without notification
b.
Disable
all micro except digitally signed macros
c. Disable all micro with notification (Answer)
d.
Enable
all macros
8.
Questions: How would you selected 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 (Answer)
c. On the Analyze tab, in the data
group, click on the select Entire PivotTable option
d. None of the above
9.
Questions: which keyboard shortcut should be used to enter the current time in
a cell in an excel sheet using a QWERIY computer keyboard ?
a.
CTRL+SHIFT+"
b.
CTRL+SHIFT+
(Answer)
c.
CTRL+;
d.
None of the above
10.
Questions: which of the following is not true about the Watch Window ?
a.
The Watch
Window makes it convenient to inspect, audit, or confirm formula calculations
b.
When cells are not visible on the worksheet, those cells and their
formulae can be seen in the Watch Window
c.
There can be
two Watch Windows per cell (Answere)
11. Questions: when ‘a’or‘p’ is not typed after 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 times as AM (Answer)
e.
None
of the above
This
question is based upon the figure show below
12. Questions: What does the red icon indicate, as shown in the
given picture ?
a. It tells the user that macro is
enabled
b.
It tells the user that the document
contains Signatures (Answer)
c. It tells the user that macro is
disable
d. None of the above.
13. Questions: State whether true or false
A macro project can be digitally signed
a. True (Answer)
b.
false
14. Questions: State whether true of false
When
you freeze panes you select specific rows or column that remain visible when
scrolling in the worksheet .
a.
True (Answer)
b. False
15. Questions: This question is based upon the figure show 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 (Answer)
c. It signifies that the cell contains
a macro
d. All of the above
16. Questions: Which among the following is not true regarding
a calculated column
a.
It
user a single formula that adjusts for each row
b. It automatically ally expends to include additional rows
(Answer)
c.
A
formula is required to be entered only once in a calculated column
d.
Additional
formulae cannot be entered in a
calculated column as exceptions
17. Questions: Which of the following is a default method of a
PivotTable report for scoping the conditional format of fields in the values
area ?
a.
By
selection
b.
By
corresponding field
e. By value field (Answer)
c.
By
number field
18. Questions: 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 (Answer)
c.
TRANSPOSE
d.
NONE
OF THE ABOVE
19. Questions: 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 (Answer)
d.
None
Of The Above
20.
Questions: This question is based upon the figure show below ?
Referring to the given image, point out which option should be
selected to automatically save a backup copy of a workbook.
a.
A
b.
B (Answer)
c.
C
d.
D
21.Questions:
Which
of the following is incorrect regarding “Hyphenation Zone ?”
a.
The hyphenation zone is the maximum amount of space that Word 2007
allows between a word and the right margin without hyphenating the word.
b.
The
hyphenation zone cannot be changed to make it narrower. (Answer)
c.
The number of hyphens can be reduced by making the hyphenation
zone wider.
d.
None of the above
22.
Questions: State whether true or false
The “Add Assistant” shape option in a SmartArt graphic is
available only if an organization chart layout is chosen.
a.
True (Answer)
b.
False
23.
Questions: Which among the following is NOT true about content controls
a.
They are individual controls that can be used in templates, forms,
and documents.
b.
They can be reused.
c.
Customized
content controls cannot be distributed. (Answer)
24.
Questions: Unlike the other types of styles (paragraph, character, linked, and
table), predefined list styles are available when you first create a document
in Word 2007 .
a.
True (Answer)
b.
False
25. Questions: Why is the “Different first Page”
option used in the Page setup dialog box as show in the given picture ?
a.
This option allows you to remove the Page Breaks from the first
page.
b.
This option allows you to remove the Page Number from the first
page.
c.
This option allows you to remove the Section Breaks from the first
page.
d.
All of the above
26. Questions: 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 (answer)
d.
None
of the above
27. Questions: which view(s) could used to view the Equation placeholders in the
document Views group ?
a.
Print Layout view
b.
Web Layout view
c.
Draft view
d.
All of the
above (answer)
28. Questions: which among the following is a
keyboard shortcut to cut a table ?
a.
CTRL+
b.
CTRL+V
c.
CTRL+C
d.
CTRL+Z
(Answer)
29. Questions:
This question is based upon the figure
show below ?
As show in the image,
the checkbook ‘Create links to source data’ has been selected. Which of the following
statements is correct regarding this ?
a.
This option does not let you change the consolidation
b.
This option does not let you create the consolidation
c.
Both a and b
d.
None of the
above (Answer)
30. Questions: State whether true or false
When the table headers are turned off ,the table
header Autofilters and all other applied filters are removed from the table.
a.
True (Answer)
b.
false
31. Questions: how would you assign a Macro to a
graphic ?
a.
On the Developer tab, in the Controls group, select Macro name
b.
On the View tab, click on Macros and then click 'Assign Macro' on
the shortcut menu. In the Macro name box, click on the macro that you want to
assign
c.
On a worksheet, right-click on the graphic, then click 'Assign
Macro'" on the shortcut menu. In the Macro name box, click on the macro
that you want to assign
d.
All of the
above (Answer)
32. Questions: This question is based upon the figure
show below ?
Which chart type is displayed in the given
picture.
a.
A stock chart
b.
A surface
chart (Answer)
c.
An XY (Scatter) chart
d.
None of the above
33. Questions: Which
of the following is not true about an offline cube file ?
a.
It stores data in the form of an OLAP cube
b.
The file
format for an offline cube files is CUE (Answer)
c.
It allows you to keep on
working with the PivotTable and PivotChart reports when the server is
unavailable
34. Questions: This question is based upon the figure
show below ?
Refer to the
given image. Which formula should be written on the given table to display
“Nancy Davolio” ?
a.
=UPPER(A2)
b.
=LOWER(A2)
c.
=PROPER(A2)
(Answer)
d.
None of the above
35. Questions: which of the following is not a valid
file extension in which an Excel file can be saved ?
a.
XLSB
b.
XLSM
c.
PXL
d.
All of the
above are valid (Answer)
36. Questions: This question is based upon the figure
show 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 (answer)
b.
B
c.
C
d.
D
37. Questions:How
should black 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 ((answer)
d. None of the above
38. Questions:Which
of the following methods would you follow to remove subtotals ?
a.
On
the data tab, in the outline click on subtotal dialog box is displayed click
remove all. (Answer)
b.
On
the data tab, in the data tools. Select removes subtotals
c.
Both
a and b
d.
None
of the above
39. Questions: Which
type of additional information is stored within the digital signature ?
a.
Data
information
b.
Time
information
c.
The
office version number of the program in which the files was created
d.
All
of the above (Answer)
40. Questions: Which
of the following wildcard characters can be used as comparisons criteria for
Text Filters ?
a.
A.?
b.
B.*
c.
C.-
d.
All
of the above (Answer)
Need SEO, Online Money Making & Technological Forum.
ReplyDeleteVisit http://linkkl.com.
http://LinkkL.CoM is free a SEO, Online Money Making & Technological Forum. Asked your question, get answer & share your idea.