To
select vertical blocks of text, you would hold down which key while dragging
the mouse?
a. Alt
b.
Ctrl
c. Shift
Why
would you use content controls in a document?
a. To get
information from another source and have it appear at a specific place in a document.For
example, the customer data automatically appears when you create a new invoice.
b. To create a
document and restrict what people can do with it. For example, you create a
document that contains legal language, and you want to ensure people don't
accidentally change or delete any of its text.
c. To create
structured regions of a document that people fill out. For example, the cover
page of the proposal can't be changed except by filling out the title and
author.
d. All
of the above
e. None of the
above
Which
of the following is NOT an option when inserting a Cross-reference?
a. Numbered
item
b.
SmartArt
c. Heading
d. Equation
e. Table
If
you want to create a citation and fill in the source information later, you
should:
a. insert a
caption.
b. add a
placeholder.
c. add a new
source.
d. insert a
cross-reference.
You
are editing a shape using the Drawing Tools. Which among the following Shape Fill options in the Shape Styles group gives
you control over the transparency for a shape?
a. Fill color,
More Fill Colors
b. Background
Color
c. Texture
d. Pattern
Which
of the following protects a document from changes in Microsoft Word 2010?
a. Restrict
Editing
b.
Encrypt with Password
c. Add a
Digital Signature
d. Mark as
Final
e. All of the
above
Microsoft
Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type
fonts
b. True Type
fonts
With
which chart type(s) is the "Depth Gridlines" option available?
a. Bubble chart
b.
Line chart
c. True 3D
chart
d. All of the
above
On
creating her two page resume, Emma finds the paragraph heading for her
"Professional Achievements" paragraph is showing at the bottom of the
first page, while the details are on the next page. To keep the paragraph
heading as well as the paragraph text on the same page, and assuming there are
no empty paragraph markers in the document and the widow/orphan option is
turned on, Emma should click in the paragraph heading and select which option
from the Paragraph group:
a. Keep lines
together
b. Keep with
next
c. Widow/orphan
My
table heading row is not repeating on subsequent pages though I have properly
set the header row to repeat. What is one problem that might be causing this
behavior?
a.
"Allow row to break across pages" is unchecked.
b. My top and
bottom margins are too small.
c. There are
hard page breaks in my table.
Which
among the following chart types do not have axes?
a. Bar charts
b. XY (Scatter)
charts
c.
Doughnut charts
d. Area charts
To
insert a new citation to a specific book in a Microsoft Word 2010 document, you
should select:
a.
References" > "Style".
b.
References" >"Insert Citation" >"Add New Source.
c.
References" >"Insert Citation" >"Add New Placeholder.
d. None of the
above
You
need to email a picture to your co-workers, but the file is too large. Where on
the Picture Tools ribbon would you find the option to minimize the file size
for email sharing purposes:
a. Corrections
b. Change Picture
c. Compress
Picture
d. Picture
Layout
Using
the Draw Table option, it is possible to split an existing table cell into two
separate and distinct cells:
a. horizontally
b. vertically
c. diagonally
If
I do not want the contents of one of my fields to automatically update, I would
have to do which of the following?
a. Lock the
field.
b. Protect the
field.
c. Make the
field hidden.
d. Turn field
shading off.
Sarah
receives a company turnover summary in the form of an embedded Excel chart (as
shown in the above image) in a Microsoft Word 2010 document from her boss. Her
boss wants the chart to be sent over to the Public Relations department with a
line in the chart showing the variations in the company's turnover, as well as
a prediction for the next 2 years. The turnover values for each year also need
to be sent separately in an Excel file. What should Linda do to achieve this in
the shortest possible time?
a. Take a
screenshot of the chart and ask a designer to draw a line showing the trends.
She can then type the data manually into an excel sheet.
b. Import the
chart into an Excel sheet and change the formatting of the chart to a line
chart. She can then copy the corresponding fields into a separate Excel file
and send it over.
c. Change chart
type to a line chart and type all the values into an Excel file.
d. Use the
Trendline feature to create a line showing the trends and copy the data from
the Excel sheet field which opens up on clicking Edit Data.
If
your table of contents is not hyperlinking when you click on the page number,
what do you need to do?
a. Regenerate
the table of contents.
b. Add \H to
the table of contents field.
c. Add \L to
the table of contents field.
d.
Press Ctrl H.
If
a table cell is vertically split into two separate cells using the Draw Table
option, any existing text in the cell will be split up and text will appear in
both of the two newly created cells.
a. True
b. False
Which
among the following options represents Legend entries in the given picture?
a. A
b. B
c. C
d.
None of the above
In
Microsoft Word 2010, "Keep lines together" paragraph formatting:
a. works well
for paragraphs within a table if "Allow row to break across pages" is
also selected.
b. automatically
enables the text rows to break across pages.
c. does not
work for paragraphs within a table if "Allow row to break across
pages" is also selected.
d. always works
for paragraphs within a table.
Applying
a theme to your document affects all content except tables.
a.
True
b. False
Martha
is preparing a trigonometry worksheet for her students. She wants to include
the following example in the sheet. Which is the quickest way to achieve this?
a.
Click Formula on the Insert tab.
b. Click Symbol
on the Insert tab.
c. Click
WordArt on the Insert tab.
d. Click Equation
on the Insert tab.
What
view must be used when inserting a subdocument?
a.
Print Layout
b. Web Layout
c. Outline
d. Full Screen
Reading
Which
of the following is NOT a type of Section Break?
a. Next Page
b. Linked
c. EvenPage
d. Continuous
What
is the function of Widow/Orphan control in Microsoft Word 2010?
a. It is a
feature that prevents single lines of paragraphs from appearing on a separate
page from the rest of the paragraph.
b.
It is a feature which indents only the first line of a paragraph.
c. It is a
feature used to change the layout or formatting of a page or pages.
d. It is
feature which is used to insert ghosted text behind the content of the page.
Consider
the following scenario:
A table cell contains text. You place your cursor in that cell and split it into two columns. The resultant text will:
A table cell contains text. You place your cursor in that cell and split it into two columns. The resultant text will:
a. be spread
across both cells.
b. be deleted.
c.
remain intact in the first cell and the second cell will be empty.
You
want to add an image as the first character in your paragraph. Which type of
text wrapping treats your graphic as if it were a character?
a. Through
b. Square
c. In Front of
Text
d. In Line with
Text
Microsoft
Word 2010 enables you to wrap text easily around pictures, shapes and tables
with any position or style that you want. When should a "Text wrapping
break" be used?
a. While
applying a wrapping style to an image.
b. While
applying a wrapping style to a table.
c.
When you want to separate text around objects on web pages.
d. When you
want to see the hidden formatting marks used in the page.
Below
are two statements regarding Breaks in Microsoft Word 2010.
Statement X: Text Wrapping Page Break separates text around objects on web pages, such as caption text from body text.
Statement Y: Continuous Section Break inserts a section break and starts the new section on the next page.
Which of the following options is correct?
Statement X: Text Wrapping Page Break separates text around objects on web pages, such as caption text from body text.
Statement Y: Continuous Section Break inserts a section break and starts the new section on the next page.
Which of the following options is correct?
a. Statement X
is correct. Statement Y is incorrect.
b. Statement X
is incorrect. Statement Y is correct.
c.
Both Statements X and Y are correct.
d. Both
Statements X and Y are incorrect.
Roger
was editing a Word document, when his mobile phone rang. By mistake, some
button got clicked on the Word 2010 Ribbon area, so that the document's
appearance changed from Image A to Image B. Which of the following options
could be the cause?
a. Margins were
activated on the document.
b. Tables with
maximum number of rows and columns was added to the document.
c. Gridlines
were enabled from the View Tab.
d. A preset
Watermark was inserted.
Anna
selects a paragraph in a Microsoft Word 2010 file. On the horizontal ruler, she
drags the Hanging Indent marker to the left. What will happen?
a. The whole
paragraph will get indented to the left.
b. The first
line will get indented to the left.
c. All but the
first line will get indented to the left.
When
you apply a theme to a Microsoft Word 2010 document, all the tables, charts,
SmartArt graphics, shapes, and other objects are updated to complement one
another.
a.
True
b. False
Dave
receives a file named Theme1.thmx from his boss. Opening the file opens a blank
PowerPoint document. On clarifying from his boss, he learns that the .thmx file
contains a particular theme which needs to be applied to the annual report on
which Dave is working. How can Dave achieve this?
a. By pasting
all the text of the report in the PowerPoint file which opens on double
clicking the .thmx file and then saving it as a Word document.
b. By opening
the .thmx file with Microsoft Word 2010 and pasting the complete report text
into it.
c. Dave's Boss
is wrong. No such arrangement is possible in Microsoft Word 2010.
d.
By opening the Word file containing the report, and importing the theme from
the .thmx file by using the "Browse for themes" option on the Page
Layout tab.
Josh
is to create a technical write-up comprising short paragraphs with double line
spacing. Each paragraph is to be separated from the other by a single line
space. He writes a paragraph, selects the text, points to Line Spacing on the
paragraph toolbar and sets it to 2.0. He gets the paragraph double spaced. The
moment he clicks enter to start a new paragraph, it automatically gets double
spaced. How can Josh achieve paragraphs separated by single line spaces from
each other within the document?
a. He sets the
Line Spacing on the formatting toolbar to 1.0.
b. He selects
the double-spaced paragraphs and clicks on Paragraph.Then under Indents and
Spacing, he sets the Spacing "Before" and "After" options
to zero.
c. He uses the
Shift and Enter keys at the same time to create a new paragraph.
d.
He selects the double-spaced paragraphs and clicks on Paragraph. Then under
Indents and Spacing, he sets the Spacing "Before" and
"After" options to Auto.
You
need to insert an image of only part of a web page that is currently open in
your browser. You would use:
a. Insert,
Screenshot
b. Insert,
Screen Clipping
c. Print Screen
d. Insert,
Image
When
using the booklet-printing feature, the term "gutter" refers to the
space between page content and the fold in the middle of the paper where you
would normally bind pages together.
a.
True
b. False
A
particular chart layout can be applied to a chart only if:
a. it has been
saved as a template in the Charts Template folder.
b.
it has been set as the default chart.
c. it is a 2D
chart.
d. it is a 3D
chart.
Josh
is creating a collage for his college project. He has an image - Image A -
which he wants to show in different color themes so as to represent different
moods in the collage (Images B, C and D). How can Josh achieve this in
Microsoft Word 2010?
a. By using
Format Painter.
b. By altering
the Line Color.
c. By using the
Recolor option under Format Picture.
d. This can't
be achieved in Microsoft Word 2010.
While
working on a project report, Anna inserts various citations in the MLA style by
using the Insert Citation option on the References tab. On completing the
report, she realizes that she was required to use the Chicago style. To correct
this, Anna should:
a. change all
the citations individually to the desired style.
b. remove all
the citations and then enter them afresh in the new style.
c. Select
Chicago from the Style dropdown list on the References tab.
If
you were writing a book and wanted each chapter to start on the right page, which Section Break would you use to begin each
chapter?
a. Even Page
b. Odd Page
c.
Continuous
a. Picture
Effects
b.
Insert Shapes
c. Picture
Layout
d. Crop to
Shape
Choose
the INCORRECT statement:
a. Only
high-risk documents from an uncertain location are opened in Read-Only view.
b. All
documents that contain macros open in Read-Only view.
To
insert a new citation to a specific book in a Microsoft Word 2010 document, you
should select:
a.
References" > "Style".
b.
References" >"Insert Citation" >"Add New Source.
c.
References" >"Insert Citation" >"Add New Placeholder.
d. None of the
above
You
want to select all instances of a specific style used in your document.
However, the Select All command in the Styles pane is not available (grayed
out). You must enable:
a.
Formatting marks
b. Keep track
of formatting
c. Linked
styles
Samantha
is given an article to proofread. The article runs into hundreds of pages. She
is asked to use hyphens to allow words in the article to break between two
lines. There is an option in Microsoft Word 2010 which can be used to achieve
this result with a single click. Please identify it.
a. Breaks
b. Indentation
c. Orientation
d. Hyphenation
Which
of the following options allows you to arrange drawings in your document so
they may be moved, kept together, aligned, or formatted more easily?
a. Insert Clip
Art
b. Insert
Flowchart
c. Insert
SmartArt
d. Insert Quick
Parts
e.
Insert Drawing Canvas
How
many items can be maintained on the clipboard at one time?
a. One
b.
Up to 24
c. Unlimited
d. Up to 100
Which
of the following statements is not true regarding offline cube files in Microsoft
Excel 2010?
a.
An offline cube file stores data in the form of an OLAP cube.
b. If you
delete the offline cube file for a report, still you can create a new offline
cube file for the report.
c. An offline
cube file allows you to work with PivotTable and PivotChart reports even when
the server is unavailable.
You
are creating a new formatting rule which will be used to format a PivotTable
report. Which of the following formatting styles is NOT available while
formatting all cells of PivotTable report based on their values in an MS Excel
2010 worksheet?
a. 2-Color
Scale
b. 3-Color
Scale
c.
4-Color Scale
d. Data Bar
You
are a financial consultant to multiple clients and you made an investment model
for them. Now you want to find out how investment rates change under different
market conditions. Which of the following Microsoft Excel 2010 What-if analysis tools will you use to study
such conditions?
a.
Scenarios
b. Data tables
c. Goal Seek
Which
of the following axis settings are available for the appearance of data bars
for negative values in Microsoft Excel 2010?
a. Cell
midpoint
b.
Cell left
c. Cell right
This
question is based upon the figure shown below
With reference
to the screenshot given, which of the following formulae CANNOT be used to
calculate the average of the column 'Marks' in the cell 'E17'?
a.
=AVERAGE(E6,E7,E8,E9,E10,E11,E12,E13,E14,E15)
b.
=AVERAGE(E6:E15)
c.
=(SUM(E6:E15)/COUNT(E6:E15))
d. =AVERAGE(E6 to E15)
Suppose
you create a workbook in Microsoft Excel 2010 and run the 'Check Accessibility'
option. This option is used to check the workbook for __________.
a. Content that
people with disabilities might find difficult to read.
b. Checking features not supported by earlier versions of
Excel.
c. Both a and b
Suppose
you have created a report in Excel named 'report.xlsx'. Now you want that your
team members should be able to see the report remotely on a web browser, and
edit the report, as desired. Also it is required that the previous versions of
the report are maintained to protect against any loss of data. Which of the
following options is the most suitable one to deploy this report?
a. Share 'report.xlsx'
by saving it to SkyDrive.
b. Share 'report.xlsx' by saving it to a SharePoint site.
c. Share
'report.xlsx' by sending it through email.
Which
of the following statements is NOT true regarding import of data into
PowerPivot?
a. Data can be imported into PowerPivot by either selecting
list of tables or by writing SQL query.
b. The data
being imported into PowerPivot can be filtered before the import.
c. The
PowerPivot Import Wizard provides you with an SQL Query builder.
Which
of the following axis settings are available for the appearance of bars for
negative values in Microsoft Excel 2010?
a. Automatic
b. Cell right
c. Cell left
a. One
limitation of PowerPivot is that it does not allow access to Slicers when
working on data in PowerPivot.
b. A connection
to a server running SQL Server Analysis Services is required to answer
PivotTable queries by the PowerPivot engine.
c. Version control and tracking is supported by PowerPivot.
Microsoft
Excel Services is a component of:
a. Microsoft SharePoint Technology
b. Microsoft
Server Technology
c. Microsoft
Virtualization Technology
Which
of the following is available as fill options while formatting cells of an
Excel worksheet using the format style as Data Bar?
a. Gradient Fill
b. Crystal Fill
c. Texture Fill
Which
of the following areas in the Microsoft Excel 2010 PivotTable Field List,
calculates the aggregates of columns?
a. Report
Filter
b. Row Labels
c. Values
What
is the purpose of time stamping a digital signature in Microsoft Excel 2010?
a. It helps you
mitigate integrity threats.
b. It ensures that digital signatures remain valid and
legally defensible even if the certificate that is used to sign the document
expires.
c. It enables
you to specify cryptographic settings for encrypting documents.
d. None of the
above
This
question is based upon the figure shown below
In the given
screenshot, there are red triangles in the upper-right corner of each cell
under the column titled 'Registrations'. What do these signify?
a. The red triangles represent the comment associated.
b. The red
triangles signify an associated data validation control.
c. The red
triangles represent the tracking of the cell.
d. The red
triangles signify that the cell is a hidden cell.
This
question is based upon the figure shown below
Which of the
following tools is used to format Excel worksheet data, as shown in the figure
above?
a. Slicer
b. SmartArt
c. Macros
Which
of the following sorting options is NOT available under the Sort On option
while sorting the data of a table in an Microsoft Excel 2010 worksheet?
a. Cell Color
b. Font Color
c. Font Style
Excel
keeps the changed history of a workbook for ________ days by default.
a. 10 days
b. 20 days
c. 25 days
d. 30 days
Analyze
the syntax of LOOKUP function when used in vector form?
LOOKUP(lookup_value, lookup_vector, result_vector)
Which of the following arguments of the LOOKUP function is optional?
LOOKUP(lookup_value, lookup_vector, result_vector)
Which of the following arguments of the LOOKUP function is optional?
a. lookup_value
b.
lookup_vector
c. result_vector
This
question is based upon the figure shown below
In the given
screenshot, the letter X is pointing to an area between the first Row header,
and the first Column header. What will happen when this particular area is
selected?
a. It will select the whole sheet, having the same effect as
that of Ctrl+A.
b. It will
close and save this particular worksheet of the workbook.
c. Nothing will
happen.
d. It will hide
this particular worksheet.
This
question is based upon the figure shown below
When you
double-click on a pivot report value of a PivotTable in Microsoft Excel 2010,
Excel creates new ________ with data corresponding to the pivot report value.
a. Table
b. Worksheet
c. Workbook
This
question is based upon the figure shown below
In the above
given screenshot of a Microsoft Excel 2010 Worksheet, there are two columns B
and D containing some integer data.
Considering that cell D9 is assigned the formula: =SUM(D3:D7), which of the following statements is true?
Considering that cell D9 is assigned the formula: =SUM(D3:D7), which of the following statements is true?
a. The value of
cell D9 will be 24
b. The value of cell D9 will be 42
c. The value of
cell D9 will be #VALUE!
State
whether following statement regarding images in Microsoft Excel 2010 is true or
false:
Microsoft Excel 2010 supports 3D rotation of images.
Microsoft Excel 2010 supports 3D rotation of images.
a. True
b. False
This
question is based upon the figure shown below
In the given
screenshot, the contents of the 'Name of User' column have been oriented at an
angle. How is this done?
a. By using the 'Orientation' button in the alignment group
of the 'Home' tab.
b. By using the
'Orientation' button on the 'Page Layout' tab.
c. By using the
'WordArt' button on the 'Insert' tab.
Which
of the following statements are true regarding PowerPivot in Microsoft Excel
2010?
a. PowerPivot streamlines the process of integrating data
from multiple sources like databases, spreadsheets, reports and text files.
b. PowerPivot
does not allow access to slicers when working on data in PowerPivot.
c. Version
control and tracking are NOT supported by PowerPivot.
Which
of the following statements is true regarding MS Excel Web Access on a
SharePoint Foundation 2010 Server?
a. The
worksheet grid in Excel Web Access on SharePoint Foundation 2010 Server is
limited to 20 columns and 75 rows.
b. It is
possible to select contiguous and noncontiguous cells on a worksheet using
mouse and keyboard.
c. It is not possible to use the CTRL+Enter keyboard
combination on formulas entered in multiple cells in a worksheet.
This
question is based upon the figure shown below
Analyze the
image shown. What would be the output when you use the following formula in an
MS Excel 2010 worksheet?
=SUM(A2:CHOOSE(2,A3,A4,A5))
a. 67
b. 80
c. 90
d. 60
How
would you assign a macro to a graphic?
a. On the
Developer tab, in the Code group, click on Macros.
b. On the View
tab, click on Macros and then click on 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 on
Assign Macro on the shortcut menu. In the Macro name box, click on the macro
that you want to assign.
This
question is based upon the figure shown below
Suppose you
clone the slicer shown in the image above into another worksheet in Microsoft
Excel 2010. Considering that you make changes to the tile selected, in one of
the slicers, which of the following statements shall be true?
a. All cloned copies of that slicer are also updated
instantly.
b. Only the original
slicer reflects the changes being made.
c. An error is
displayed because no updations are allowed in slicers having cloned copies.
d. None of the
above.
State
whether the following statement regarding cell references in Microsoft Excel
2010 is true or false:
An Absolute cell reference consists of the column letter and row number.
An Absolute cell reference consists of the column letter and row number.
a. True
b. False
Analyze
the syntax of LOOKUP function when used in vector form?
LOOKUP(lookup_value, lookup_vector, result_vector)
The values in the lookup_vector must be placed in ________ order.
LOOKUP(lookup_value, lookup_vector, result_vector)
The values in the lookup_vector must be placed in ________ order.
a. Ascending
b. Descending
c. Either
ascending or descending
State
whether following statement regarding cell references in Microsoft Excel 2010
is true or false:
A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).
A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).
a. True
b. False
State
whether the following is true or false:
Excel Web App supports Undo/Redo but it is disabled when multiple users are collaborating on the same workbook
Excel Web App supports Undo/Redo but it is disabled when multiple users are collaborating on the same workbook
a. True
b. False
This
question is based upon the figure shown below
What does the
icon marked with a red square in the figure above signify?
a. It signifies
that a macro is enabled.
b. It signifies that the document contains digital
signatures.
c. It signifies
that a macro is disabled.
d. It signifies
that a webcam has been detected.
What
are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
a. Digital
signatures help authenticate the source of the messages.
b. Both the
sender and the receiver of a message can verify that the message has not been
altered during transmission, if the message is digitally signed.
c. Digitally
signed e-mails meet legal requirements for admissibility and authenticity.
d. All of the above.
What
is the filename extension of Excel workbooks which are saved as 'Excel
Templates'?
a. .xlsx
b. .xslt
c. .xltx
d. .slk
Slicers
are filtering components which are used to filter the data in a PivotTable
report or CUBE functions. Which of the following data sources is/are supported
by Slicers in Microsoft Excel 2010?
b. Online
Analytical Processing (OLAP) Queries
c. Online Analytical Processing (OLAP) Cube Files
d. All of the
above
This
question is based upon the figure shown below
In the
screenshot above, some product sales data is given followed by a pivot table
derived from that data. Which of the following options is correct regarding the
PivotTable?
a. The data can
only be sorted according to the 'Total for three months' field.
b. The data can only be sorted according to the 'Product'
field.
c. The data can
be sorted according to the 'Total for three months' field, along with
filtration using the 'Product' field.
d. None of the
above
Deleting
a PivotChart report automatically deletes the associated PivotTable report.
a. True
b. False
Which
of the following components of Excel Services enables the user to edit a
published workbook inside a web browser?
a. Excel
Calculation Services (ECS)
b. Excel Web Access (EWA)
c. Excel Web
Services (EWS)
Which
among the following settings is the default macro security setting?
a. Disable all
macros except digitally signed macros.
b. Disable all macros with notification.
c. Enable all
macros.
Which
of the following statements is not true regarding offline cube files in
Microsoft Excel 2010?
a. An offline
cube file stores data in the form of an OLAP cube.
b. If you
delete the offline cube file for the report, still you can create a new offline
cube file for the report.
c. An offline cube file allows you to work with PivotTable
and PivotChart reports even when the server is unavailable.
Question:If you want to create a citation and fill
in the source information later, you should:
a. insert a caption.
b. add a placeholder.
c. add a new source.
d. insert a cross-reference.
Question:To select vertical blocks of text, you would hold down which key while dragging the mouse?
a. Alt
b. Ctrl
c. Shift
Question:If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
a. Lock the field.
b. Protect the field.
c. Make the field hidden.
d. Turn field shading off.
Question:Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
a. Take a screenshot of the chart and ask a designer to draw a line showing the trends. She can then type the data manually into an excel sheet.
b. Import the chart into an Excel sheet and change the formatting of the chart to a line chart. She can then copy the corresponding fields into a separate Excel file and send it over.
c. Change chart type to a line chart and type all the values into an Excel file.
d. Use the Trendline feature to create a line showing the trends and copy the data from the Excel sheet field which opens up on clicking Edit Data.
Question:You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
a. Through
b. Square
c. In Font of Text
d. In Line with Text
Question: Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document's appearance changed from Image A to Image B. Which of the following options could be the cause?
a. Margins were activated on the document.
b. Tables with maximum number of rows and columns was added to the document.
c. Gridlines were enabled from the Page Layout Tab.
d. A preset Watermark was inserted.
Question:A particular chart layout can be applied to a chart only if:
a. it has been saved as a template in the Charts Template folder.
b. it has been set as the default chart.
c. it is a 2D chart.
d. it is a 3D chart.
Question:Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.
b. All documents that contain macros open in Read-Only view.
Question:Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts
b. True Type fonts
Question:With which chart type(s) is the "Depth Gridlines" option available?
a. Bubble chart
b. Line chart
c. True 3D chart
d. All of the above
Question:Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
a. PDF
b. TIFF
c. MDI
Question:I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
a. BMP
b. PDF
c. XLS
d. JPG
Question:What view must be used when inserting a subdocument?
a. Print Layout
b. Web Layout
c. Outline
d. Full Screen Reading
Question:Josh is creating a collage for his college project. He has an image - Image A - which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?
a. By using Format Painter.
b. By altering the Line Color.
c. By using the Recolor option under Format Picture.
d. This can't be achieved in Microsoft Word 2010.
Question: Which of the following in NOT a type of Section Break?
a. Next Page
b. Linked
c. EvenPage
d. Continuous
Question: Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010 which can be used to achieve this result with a single click. Please identify it.
a. Breaks
b. Indentation
c. Orientation
d. Hyphenation
Question: Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?
a. Insert Clip Art
b. Insert Flowchart
c. Insert SmartArt
d. Insert Quick Parts
e. Insert Drawing Canvas
Question:When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.
a. True
b. False
Question: My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat. What is one problem that might be causing this behavior?
a. "Allow row to break across pages" is unchecked.
b. My top and bottom margins are too small.
c. There are hard page breaks in my table
a. insert a caption.
b. add a placeholder.
c. add a new source.
d. insert a cross-reference.
Question:To select vertical blocks of text, you would hold down which key while dragging the mouse?
a. Alt
b. Ctrl
c. Shift
Question:If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
a. Lock the field.
b. Protect the field.
c. Make the field hidden.
d. Turn field shading off.
Question:Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
a. Take a screenshot of the chart and ask a designer to draw a line showing the trends. She can then type the data manually into an excel sheet.
b. Import the chart into an Excel sheet and change the formatting of the chart to a line chart. She can then copy the corresponding fields into a separate Excel file and send it over.
c. Change chart type to a line chart and type all the values into an Excel file.
d. Use the Trendline feature to create a line showing the trends and copy the data from the Excel sheet field which opens up on clicking Edit Data.
Question:You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
a. Through
b. Square
c. In Font of Text
d. In Line with Text
Question: Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document's appearance changed from Image A to Image B. Which of the following options could be the cause?
a. Margins were activated on the document.
b. Tables with maximum number of rows and columns was added to the document.
c. Gridlines were enabled from the Page Layout Tab.
d. A preset Watermark was inserted.
Question:A particular chart layout can be applied to a chart only if:
a. it has been saved as a template in the Charts Template folder.
b. it has been set as the default chart.
c. it is a 2D chart.
d. it is a 3D chart.
Question:Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.
b. All documents that contain macros open in Read-Only view.
Question:Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts
b. True Type fonts
Question:With which chart type(s) is the "Depth Gridlines" option available?
a. Bubble chart
b. Line chart
c. True 3D chart
d. All of the above
Question:Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
a. PDF
b. TIFF
c. MDI
Question:I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
a. BMP
b. PDF
c. XLS
d. JPG
Question:What view must be used when inserting a subdocument?
a. Print Layout
b. Web Layout
c. Outline
d. Full Screen Reading
Question:Josh is creating a collage for his college project. He has an image - Image A - which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?
a. By using Format Painter.
b. By altering the Line Color.
c. By using the Recolor option under Format Picture.
d. This can't be achieved in Microsoft Word 2010.
Question: Which of the following in NOT a type of Section Break?
a. Next Page
b. Linked
c. EvenPage
d. Continuous
Question: Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010 which can be used to achieve this result with a single click. Please identify it.
a. Breaks
b. Indentation
c. Orientation
d. Hyphenation
Question: Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?
a. Insert Clip Art
b. Insert Flowchart
c. Insert SmartArt
d. Insert Quick Parts
e. Insert Drawing Canvas
Question:When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.
a. True
b. False
Question: My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat. What is one problem that might be causing this behavior?
a. "Allow row to break across pages" is unchecked.
b. My top and bottom margins are too small.
c. There are hard page breaks in my table
Odesk Microsoft Excel 2010 Test
Question:If you want to create a
citation and fill in the source information later, you should:
a. insert a caption.
a. insert a caption.
Question:To select vertical blocks of text, you would hold down which key while dragging the mouse?
b. Ctrl
Question:If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
c. Make the field hidden.
Question:Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
c. Change chart type to a line chart and type all the values into an Excel file.
Question:You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
b. Square
Question: Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document's appearance changed from Image A to Image B. Which of the following options could be the cause?
b. Tables with maximum number of rows and columns was added to the document.
Question:A particular chart layout can be applied to a chart only if:
c. it is a 2D chart.
Question:Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.
Question:Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts
Question:With which chart type(s) is the "Depth Gridlines" option available?
b. Line chart
Question:Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
c. MDI
Question:I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
d. XLS
Question:What view must be used when inserting a subdocument?
b. Web Layout
Question:Josh is creating a collage for his college project. He has an image - Image A - which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?
c. By using the Recolor option under Format Picture.
Question: Which of the following in NOT a type of Section Break?
d. Continuous
Question: Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010 which can be used to achieve this result with a single click. Please identify it.
c. Orientation
Question: Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?
b. Insert Flowchart
Question:When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.
c. False
Question: My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat. What is one problem that might be causing this behavior?
a. "Allow row to break across pages" is unchecked.
Q1: figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Z'?
Ans:It copies the formatting properties from one cell to another
Q2:The figure shows the AutoFit Selection menu option. What function does it perform?
Ans:It automatically resizes the column height and width to the minimum necessary to fit the contents of the selected cell
Q:How does the AutoComplete feature in Excel help you save time?
Ans:It automatically completes abbreviated words
Q:The figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'A'?
Ans:It is used to add a hyperlink
Q:Which of the following options would be used if you need to insert a 77889867810070809 number in a cell?
Ans:Apply the Text Format to empty cells, and then type the numbers
Q:Suppose the value in cell A1 is John and B1 is Smith then which of the following function you will use to get the John_Smith in C1 cell?
Ans:A_B
Q:How can you select all the blank cells in your worksheet?
Ans:This must be done manually as it is not automated through any built-in feature
Q:What is the quickest way to select all the columns on a worksheet?
Ans:Click on the gray rectangle on the upper left corner of the worksheet where the column headings and row headings meet
Q:The figure shows an Excel worksheet. If you want to freeze the row showing the months (row 1) and the column showing the products (column A), what should you do?
Ans:Select the cell A1 and click on Freeze Panes under the menu Window->Freeze Panes
Q:Which of the following functions would return a value of 8?
Ans:b and c
Q:You select the row headings 10, 11 and 12 and then choose the menu option Insert->Rows. What will happen?
Ans:3 new rows will be inserted after row 9
Q:The figure shows a view of the Drawing Toolbar. What function is performed by the button marked by the letter 'X' ?
Ans:It inserts a Diagram or Organization Chart in the worksheet
Q:When using Document Workspaces, you cannot work directly on the Document Workspace copy, but you can work on your own copy which you can update periodically with changes that have been saved to the copy on the Document Workspace site.
Ans:TRUE
Q:You have created a worksheet which consists of confidential data. You want that these values, although present in the worksheet, should remain hidden and as a result the cells containing this data should appear blank in the worksheet. Which method will help you do this?
Ans:Select the cells, open the Window menu and click on Hide
Q:Which of the following Date and Time function you will use to return the serial number of the last day of the month before or after a specified number of months?
Ans:DATEVALUE
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?
Ansna
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: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: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: na
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:You start Microsoft Excel and you do not want it to automatically run a macro upon starting. What will you do?
Ans:Hold down the CTRL key during startup
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
odesk Microsoft Excel 2010 Test
answers.
odesk Microsoft Excel 2010 Test answers.
Question: If you want to create a citation and fill in the
source information later, you should:
a.
insert a caption.
b. add a placeholder.
c. add a new source.
d. insert a cross-reference.
b. add a placeholder.
c. add a new source.
d. insert a cross-reference.
Ans:
a
Question: To select vertical blocks of text, you would hold down which key while dragging the mouse?
a. Alt
b. Ctrl
c. Shift
Ans: b
Question: If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
a. Lock the field.
b. Protect the field.
c. Make the field hidden.
d. Turn field shading off.
Ans: c
Question: Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
a. Take a screenshot of the chart and ask a designer to draw a line showing the trends. She can then type the data manually into an excel sheet.
b. Import the chart into an Excel sheet and change the formatting of the chart to a line chart. She can then copy the corresponding fields into a separate Excel file and send it over.
c. Change chart type to a line chart and type all the values into an Excel file.
d. Use the Trendline feature to create a line showing the trends and copy the data from the Excel sheet field which opens up on clicking Edit Data.
Ans: c
Question: You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
a. Through
b. Square
c. In Font of Text
d. In Line with Text
Ans: b
Question: Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document's appearance changed from Image A to Image B. Which of the following options could be the cause?
a. Margins were activated on the document.
b. Tables with maximum number of rows and columns was added to the document.
c. Gridlines were enabled from the Page Layout Tab.
d. A preset Watermark was inserted.
Ans: b
Question: A particular chart layout can be applied to a chart only if:
a. it has been saved as a template in the Charts Template folder.
b. it has been set as the default chart.
c. it is a 2D chart.
d. it is a 3D chart.
Ans: c
Question: Choose the INCORRECT statement:
a. Only high-risk documents from an uncertain location are opened in Read-Only view.
b. All documents that contain macros open in Read-Only view.
Ans: a
Question: Microsoft Word 2010 has enabled ligatures for which of the following fonts?
a. Open Type fonts
b. True Type fonts
Ans: a
Question: With which chart type(s) is the "Depth Gridlines" option available?
a. Bubble chart
b. Line chart
c. True 3D chart
d. All of the above
Ans:
b
Question: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
a. PDF
b. TIFF
c. MDI
Ans: c
Question: I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
a. BMP
b. PDF
c. XLS
d. JPG
Ans: c
Question: What view must be used when inserting a subdocument?
a. Print Layout
b. Web Layout
c. Outline
d. Full Screen Reading
Ans: b
Question: Josh is creating a collage for his college project. He has an image - Image A - which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?
a. By using Format Painter.
b. By altering the Line Color.
c. By using the Recolor option under Format Picture.
d. This can't be achieved in Microsoft Word 2010.
Ans:
c
Question: Which of the following in NOT a type of Section Break?
a. Next Page
b. Linked
c. EvenPage
d. Continuous
Ans:
d
Question: Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010 which can be used to achieve this result with a single click. Please identify it.
a. Breaks
b. Indentation
c. Orientation
d. Hyphenation
Ans: c
Question: Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?
a. Insert Clip Art
b. Insert Flowchart
c. Insert SmartArt
d. Insert Quick Parts
e. Insert Drawing Canvas
Ans: b
Question:When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.
a. True
b. False
Ans:
b
Question: My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat. What is one problem that might be causing this behavior?
a. "Allow row to break across pages" is unchecked.
b. My top and bottom margins are too small.
c. There are hard page breaks in my table
Ans: a
Microsoft Excel 2010 Test Answer
Syllabus of the Test
- Managing Worksheets
- Microsoft Excel 2010 Advanced
Features
- Analyzing Data- PivotCharts and
PivotTables
- Web based Co-authoring and
Streamlined Communications
- Document Customizing-Working
with Themes, Language, Images, Ribbon
- Microsoft Excel 2010 Documents
Security, Privacy and Recovery
01. Question: Question:If you want to create a citation and fill in the source information later, you should:
Answer: a. insert a caption.
02. Question: To select vertical blocks of text, you would hold down which key while dragging the mouse?
Answer: b. Ctrl
03. Question:If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
Answer: c. Make the field hidden.
04. Question: Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
Answer: c. Change chart type to a line chart and type all the values into an Excel file.
05. Question: You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
Answer: b. Square
06. Question: Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document's appearance changed from Image A to Image B. Which of the following options could be the cause?
Answer: b. Tables with maximum number of rows and columns was added to the document.
07. Question: A particular chart layout can be applied to a chart only if:
Answer: c. it is a 2D chart.
08. Question: Choose the INCORRECT statement:
Answer: a. Only high-risk documents from an uncertain location are opened in Read-Only view.
09. Question: With which chart type(s) is the "Depth Gridlines" option available?
Answer: b. Line chart
10. Question: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
Answer: c. MDI
11. Question: I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
Answer: c. XLS
12. Question: What view must be used when inserting a subdocument?
Answer: b. Web Layout
13. Question: Josh is creating a collage for his college project. He has an image - Image A - which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?
Answer: c. By using the Recolor option under Format Picture.
14. Question: Which of the following in NOT a type of Section Break?
Answer: d. Continuous
15. Question: Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010 which can be used to achieve this result with a single click. Please identify it.
Answer: c. Orientation
16. Question: Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?
Answer: b. Insert Flowchart
17. Question: When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.
Answer: b. False
18. Question: My table heading row is not repeating on subsequent pages though I have properly set the header row to repeat. What is one problem that might be causing this behavior?
Answer: a. "Allow row to break across pages" is unchecked.
19. Question: Microsoft Word 2010 has enabled ligatures for which of the following fonts?
Answer: a. Open Type fonts
Question:If you would like to form a citation and fill
within the supply data later, you should:
a. insert a caption.
Question:To choose vertical blocks of text, you'd hold down that key whereas dragging the mouse?
b. Ctrl
Question:If I don't need the contents of 1 of my fields to automatically update, i might need to do that of the following?
c. build the sector hidden.
Question:Sarah receives an organization turnover outline within the type of an embedded Excel chart (as shown within the on top of image) in an exceedingly Microsoft Word 2010 document from her boss. Her boss needs the chart to be sent over to the general public Relations department with a line within the chart showing the variations within the company's turnover, likewise as a prediction for future two years. The turnover values for every year conjointly got to be sent separately in an Excel file. What ought to Linda do to realize this within the shortest attainable time?
c. modification chart kind to a line chart and sort all the values into an Excel file.
Question:You need to feature a picture because the initial character in your paragraph. which sort of text wrapping treats your graphic as if it were a character?
b. Square
Question: Roger was editing a Word document, when his mobile rang. By mistakes,some button got click on the Word 2010 Ribbon space, in order that the document's look modified from Image A to Image B. that of the subsequent choices may be the cause?
b. Tables with most range of rows and columns was added to the document.
Question:A explicit chart layout are often applied to a chart solely if:
c. it's a 2nd chart.
Question:Choose the inaccurate statement:
a. solely high-risk documents from an unsure location are opened in Read-Only read.
Question:MS Word 2010 has enabled ligatures that of the subsequent fonts?
a. Open kind fonts
Question:With that chart type is that the full q"Depth Gridlines" possibility available?
b. Line chart
Question:Which of the subsequent isn't an possibility below File > Print > Microsoft Document Image Writer?
c. MDI
Question:I need to use the AutoCaption feature for many components in my documents.What sort of file format isn offered within the AutoCaption dialog box?
d. XLS
Question:What read should be used when inserting a subdocument?
b. Web Layout
Question:Josh is making a collage for his school projecting.He has a picture Image A that he needs to indicate totally different|in several|in numerous} color themes therefore on represent different moods within the collage (Images B, C and D). How will Josh achieve this in Microsoft Word 2010?
c. By using the Recolor possibility below Format image.
Question: that of the subsequent in NOT a kind of Section Break?
d. Continuous
Question: Samantha is given a piece of writing to proofread. The article runs into many pages. She is asked to use hyphens to permit words within the article to interrupt between 2 lines. there's an possibility in Microsoft Word 2010 which might be used to realize this result withing one click.Please determine it.
c. Orientation
Question: that of the subsequent choices permits you to rearrange drawings in your document in order that they could also be moved, kept along, aligned, or formatted a lot of easily?
b. Insert Flowchart
Question:When you apply a subject to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and alternative objects are updated to enrich each other.
c. False
Question: My table heading row isn't repeating on subsequent pages though I actually have properly set the header row to repeat. what's one drawback that may be inflicting this behavior?
a. "Allow row to interrupt across pages" is unchecked.
a. insert a caption.
Question:To choose vertical blocks of text, you'd hold down that key whereas dragging the mouse?
b. Ctrl
Question:If I don't need the contents of 1 of my fields to automatically update, i might need to do that of the following?
c. build the sector hidden.
Question:Sarah receives an organization turnover outline within the type of an embedded Excel chart (as shown within the on top of image) in an exceedingly Microsoft Word 2010 document from her boss. Her boss needs the chart to be sent over to the general public Relations department with a line within the chart showing the variations within the company's turnover, likewise as a prediction for future two years. The turnover values for every year conjointly got to be sent separately in an Excel file. What ought to Linda do to realize this within the shortest attainable time?
c. modification chart kind to a line chart and sort all the values into an Excel file.
Question:You need to feature a picture because the initial character in your paragraph. which sort of text wrapping treats your graphic as if it were a character?
b. Square
Question: Roger was editing a Word document, when his mobile rang. By mistakes,some button got click on the Word 2010 Ribbon space, in order that the document's look modified from Image A to Image B. that of the subsequent choices may be the cause?
b. Tables with most range of rows and columns was added to the document.
Question:A explicit chart layout are often applied to a chart solely if:
c. it's a 2nd chart.
Question:Choose the inaccurate statement:
a. solely high-risk documents from an unsure location are opened in Read-Only read.
Question:MS Word 2010 has enabled ligatures that of the subsequent fonts?
a. Open kind fonts
Question:With that chart type is that the full q"Depth Gridlines" possibility available?
b. Line chart
Question:Which of the subsequent isn't an possibility below File > Print > Microsoft Document Image Writer?
c. MDI
Question:I need to use the AutoCaption feature for many components in my documents.What sort of file format isn offered within the AutoCaption dialog box?
d. XLS
Question:What read should be used when inserting a subdocument?
b. Web Layout
Question:Josh is making a collage for his school projecting.He has a picture Image A that he needs to indicate totally different|in several|in numerous} color themes therefore on represent different moods within the collage (Images B, C and D). How will Josh achieve this in Microsoft Word 2010?
c. By using the Recolor possibility below Format image.
Question: that of the subsequent in NOT a kind of Section Break?
d. Continuous
Question: Samantha is given a piece of writing to proofread. The article runs into many pages. She is asked to use hyphens to permit words within the article to interrupt between 2 lines. there's an possibility in Microsoft Word 2010 which might be used to realize this result withing one click.Please determine it.
c. Orientation
Question: that of the subsequent choices permits you to rearrange drawings in your document in order that they could also be moved, kept along, aligned, or formatted a lot of easily?
b. Insert Flowchart
Question:When you apply a subject to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and alternative objects are updated to enrich each other.
c. False
Question: My table heading row isn't repeating on subsequent pages though I actually have properly set the header row to repeat. what's one drawback that may be inflicting this behavior?
a. "Allow row to interrupt across pages" is unchecked.
Comments
Post a Comment