Tuesday 6 March 2012

MS WORD 2010 MCQs 2

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.
To select vertical blocks of text, you would hold down which key while dragging the mouse?


            a.         Alt
            b.         Ctrl
            c.         Shift
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.

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

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

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
Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?


            a.         PDF
            b.         TIFF
            c.         MDI
c

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.
Which of the following in NOT a type of Section Break?


            a.         Next Page
            b.         Linked
            c.         EvenPage
            d.         Continuous
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
Under Insert > Date & Time, you can create custom formats for date and time, and set them as default.


            a.         True
            b.         False
Question:
Martha is writing an article on time management. After typing some text, as shown in Image A, she goes to the other room to make a phone call. On returning, she finds that her 8-year-old son changed some settings in the document, saved and closed the file, so that on re-opening it looks as shown in Image B. What should Martha change to make the document look the same as before?


            a.         Select the paragraph and remove the numbering.
            b.         Set the "Line Numbers" to None under the Page Layout controls.
            c.         Select the paragraph and re-apply numbering.
            d.         Copy the complete text to notepad and then paste it back
c
Which among the following chart types do not have axes?


            a.         Bar charts
            b.         XY (Scatter) charts
            c.         Doughnut charts
            d.         Area charts
Question:
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.         be spread across both cells.
            b.         be deleted.
            c.         remain intact in the first cell and the second cell will be empty
Question:
How many items can be maintained on the clipboard at one time?


            a.         One
            b.         Up to 24
            c.         Unlimited
            d.         Up to 100
Question:
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
To convert an existing picture to the shape of a star, which of the options will be useful?


            a.         Picture Effects
            b.         Insert Shapes
            c.         Picture Layout
            d.         Crop to Shape
Question:
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
Question:
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.
Question:
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
Question:
Which among the following is not true regarding the use of a pie chart?


            a.         A pie chart could be used when there is only one data series to be plotted.
            b.         A pie chart could be used when the data points in a pie chart are displayed as a percentage of the whole pie.
            c.         A pie chart could be used when none of the values that need to be plotted on the chart is negative.
            d.         A pie chart should be used when there are more than seven categories.
Question:
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
Question:
Which among the following options represents Legend entries in the given picture?


            a.         A
            b.         B
            c.         C
            d.         None of the above
a
Question:
The Insert Picture option allows you to insert:


            a.         Insert "Link to File"
            b.         Insert "File"
            c.         "Insert and Link" to a File
b
Question:
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
b
Applying a theme to your document affects all content except tables.


            a.         True
            b.         False
a
Question:
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.
Question:
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
Question:
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
Question:
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
Question:
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

Microsoft Excel 2000 Solution

Microsoft Excel 2000 Odesk Test


Q1: figure shows a view of the Standard Toolbar. What function is performed by the button marked by the letter 'Z'?

Ans:It copies formatting properties from the one cell to the another


Q2:The figure shows the AutoFit Selection menu option. What function does it perform?

Ans:It will automatically resize the column height and the width to minimum necessary to fit the contents of the selected cell

Q:How does the AutoComplete feature in Excel help you save time?

Ans:It will automatically complete abbreviated words in excel 

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


Q:Which of the following options would be used if you need to insert a 66879897810079809 number in a cell?

Ans: you should Apply Text Format to the empty cells, then have to 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: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?

NA 

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:

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?

Selection will be printed 



Q:AutoFilter drop-downs are automatically added in the header row of a list when the list is created.

Truse

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
 

Ms Excel 2000/2003 Questions and Answers


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: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 'Z'? 


Ans: It copies the formatting properties from one cell to another


Q: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: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: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: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: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? 


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

Readiness Test for Independent Contractors and Staffing Managers


Q: Can I start my own company on Upwork ?

A: Yes! Upwork allows you to build and manage a team of workers, colleagues and collaborators. You can even subcontract other workers on Upwork to other customers Upwork (and take a cut).






Q: Which of the following actions are NOT allowed when applying to job openings?



A: All of the above






Q: ‘How does feedback work on Upwork ?’



A: All of the above






Q: Which of the following is true of your Upwork  timelog?



A: All of the above






Q: Which of the following break the Upwork  user agreement?



A: All of the above






Q: Which of the following statements about the Upwork  Team application are true?



A: All of the above






Q: What do you need to do to ensure guaranteed payment on hourly jobs?



A: All of the above






Q: If you have not done so please download and install the Upwork  Team application. With the client running right click on the Upwork  Team icon in the system tray (or doc for Mac users). Which of the following options is listed first? Note that you do NOT have to log into any actual Team Room to answer this question.



A: TeamRoom..






Q: Which of the following statements are correct about Upwork  fees?



A: All of the above






Q: Buyers set weekly limits on hourly assignments, how do these work?



A: All of the above






Q: How does Upwork ’s dispute resolution policy for work?



A: All of the above