UpWork (oDesk) & Elance Knowledge of Google SketchUp Pro 7 Skills Test Question & Answers

UpWork (oDesk) & Elance Knowledge of Google SketchUp Pro 7 Skills Test Question & Answers

July 03, 2015 / No Comments

UpWork (oDesk) & Elance Knowledge of Google SketchUp Pro 7 Skills Test Question & Answers are really very important to pass UpWork & Elance test. You will get top score at this skill test exam. If you found any problem or wrong answer please inform me via contact or comments. We will try to solve it in short. This test is extremely valuable to acquire knowledge of Google SketchUp Pro 7 Skills. Lets Start test.

Ques : What happens when you click on the icon being pointed at, in the Google toolbar of SketchUp?
Ans  : A 3D image of the current view in Google SketchUp is placed in Google Earth.

Ques : What is the basic pre-requisite for the Flip Edge tool in Sandbox tools to operate?
Ans  : The surface needs to contain triangulations.

Ques : With the Ctrl key you can toggle between two modes of the Tape Measure tool. Which enhanced function does 'mode a' perform?
Ans  : Draws a dotted construction guide.

Ques : How can the transformation as shown in the given illustrations be brought about?
Ans  : View > Face Style > Wireframe

Ques : Which tool is being used in the illustration shown?
Ans  : Offset tool

Ques : What happens when you press the Alt key while using the Walk tool in Google SketchUp?
Ans  :  It enables you to walk through objects taller than 22 inches.

Ques : You can generate a report of a SketchUp model in an HTML file or a CSV file. The CSV file format is supported by:
Ans  : MS Excel

Ques : How can one use the pan tool navigation feature with the scroll button of the mouse in Google SketchUp?
Ans  : Shift key + Scroll button

Ques : Which single window, as shown in the figure, will enable you to access all the groups, components and layers used in your model?
Ans  : Outliner

Ques : Choose the right procedure to zoom in on a particular component of a SketchUp model?
Ans  : Go to Camera menu > Zoom Window > Click and drag to zoom in

Ques : Google Style Builder embedded with Google SketchUp Pro, helps in:
Ans  :  applying pre-existing or customized line strokes to models.

Ques : What happens when you click on the plus sign as shown in the figure?
Ans  : Additional options appear in an expanded drop down.

Ques : Which toolbar has been enabled in the given illustration?
Ans  : Sections

Ques : While using the Smoove tool from Sandbox, which of the following steps will work?
Ans  : Select a surface grid > Specify the radius or part you need to smoove > Select Smoove tool > Hover over the grid

Ques : How can the mirror image of an object be created in Google SketchUp?
Ans  : Select object > Create duplicate > Go to Scale tool > Pull in opposite direction

Ques : What happens when you click on the image at which the arrow points?
Ans  : It sets the material to paint with default.

Ques : What is the default number of segments of circle drawn in SketchUp?
Ans  : 24

Ques : What is the correct procedure to create a duplicate of a component in Google SketchUp 7?
Ans  :  Select component > Ctrl + Move tool > Click to drag the duplicate

Ques : Out of the tools used for navigation, what is the main difference between Orbit tool and Look Around tool in Google SketchUp?
Ans  : Look Around locks the view from one point.

Ques : Which of the following steps can help you exit from the Position Camera view?
Ans  : Hit the Esc key on the keyboard

Ques :The basic difference between the Push/Pull tool and the Sandbox Smoove tool is that the:
Ans  : Smoove tool works on surfaces with a grid.

Ques :  What operation does the given tool perform?
Ans  : It enables the user to interact with dynamic components.

Ques : When does Google SketchUp display a warning message to the user as shown in the figure?
Ans  : While using the Tape Measure tool to resize models with imported components.

Ques : In the Google Style Builder interface shown in the figure, what happens when you drag the highlighted Sample Stroke into box A?
Ans  : All segments which are 32 pixels in length attain the selected style.

Ques : When will you see three reference axes and the active area embedded in three concentric enclosures, as in Figure Z?
Ans  : When you Edit Component inside a component, which is inside a component.

Ques : Of the following, which tool is not found in the construction tools of Google SketchUp 7?
Ans  :  Renderer

Ques : Which of the following statements about 3D Warehouse is UNTRUE?
Ans  : My Models and My Collections links appear By Default in 3D Warehouse window.

Ques :  When do you see the given dialog box in Google SketchUp?
Ans  : When you right click on a component containing 3 dimensional planes and choose Soften/Smooth Edges.

Ques : Which settings window has been displayed in the given figure? Where can you access it from?
Ans  : Shadow Settings. It can be accessed under Windows > Shadows

Ques : In the given illustrations, what is the difference between the types of selection?
Ans  : A gives Entity Info of the selected face and B gives Entity Info of the segment.

Ques : How can you remove the unused components from the model so that they do not appear in the Components window?
Ans  : Click on details submenu on the Components window and choose Purge Unused

Ques : How can you perform the transformation as shown in the illustration, in Google SketchUp?
Ans  :  Draw a rectangle on the face > Select Move tool > Press Alt and click to pull up

Ques : If you press Ctrl and double click on the face of a model, which of the selections shown occurs?
Ans  : B

Ques : To prevent multiple copies of a component from being edited at the same time, you need to right click on the component and choose:
Ans  : Make Unique

Ques : What would be the correct order of steps to remove the wheel from the model displayed?
Ans  : Right click > Explode till the wheel can be selected as a component > Delete

Ques : In the Layers Palette shown in the given figure, what happens when you uncheck the box under Visible for Layer 1?
Ans  : SketchUp doesn't allow to hide active layers.

Ques :  Which of the following steps can help you convert two adjoining segments of a line into a single line segment?
Ans  : Draw another line segment from the common end point of two segments, then delete the new segment.

Ques : How can you enable single click access for Isometric view of a model?
Ans  : Go to View menu > Toolbars > Views

Ques : Which of the following statements is FALSE about the Dynamic Components in Google SketchUp 7?
Ans  :  Attributes of Dynamic Components are limited to 3 dimensional models which have spatial orientation.

Ques : Where in Google SketchUp 7 can you access the Sample Paint tool? The Sample Paint tool appears as shown above.
Ans  : Window menu > Materials window

Ques : Which of the following options would result in drawing of a triangle?
Ans  :  Select Circle tool > Draw circle > Type 3s in the Value Control Box

Ques : If the horizontal circle of Figure X is selected as path, and Follow Me tool is applied on the vertical triangular surface, which figure would be the outcome?
Ans  : B

Ques : Which of the following options will not help you import models from 3D Warehouse?
Ans  : Go to SketchUp Help and Downloads.

Ques : Using the Smoove tool from Sandbox menu over a grid, how can you move the vertical offset, as shown in the figure, accurately at 12 inches below the grid?
Ans  :  Type -12" and press Enter

Ques : Which of the following file types is NOT supported by the Google Style Builder while loading Styles from a template?
Ans  : .jpg

Ques : In Google Style Builder, what does the interface icon shown in the figure do to the model?
Ans  : It will enable or disable model shadows.

Ques : Which of the following statements is UNTRUE about the Google LayOut application?
Ans  : In LayOut, the model can be exploded into its components by a double click of the mouse.

Ques : What happens when you choose Send to LayOut in the File menu?
Ans  :  SketchUp model is exported to Google LayOut program.

Ques : In order to convert a single surface into a component, you may not get the option of Make Component in the context menu, as shown in the figure. What could be a possible workaround for this?
Ans  : Go to Edit menu and choose Make Component from the drop down.

Ques : The SimplifyContours.rb Ruby script file is available for free download from www.sketchup.com/downloads. What does this file do?
Ans  : It displays the model edges more accurately.

Ques : If you are unable to select an edge to use the dimension tool in SketchUp, what could the reason possibly be? Refer to the given figure.
Ans  : The Edges are hidden

Ques : Which of the following four methods would not work for the Follow Me tool?
Ans  : Select curved, folded and internal edged surfaces.

Ques : Where will you find the settings window as shown above? What do the brackets signify?
Ans  : Scenes window. The brackets mean the scene is excluded in animation.

Ques : Which of the following context menu sub-options will NOT work for the Intersect tool in SketchUp?
Ans  :  Intersect with Group.

Ques : Where can you locate the geometric parameters/attributes of an imported component or a model in Google SketchUp?
Ans  : View menu > Toolbars > Dynamic Components

Ques :How can you access the following Animation settings in Google SketchUp 7?
Ans  :  View menu > Animation > Settings

Ques : What does the selection in the given figure depict?
Ans  : It depicts a section plane view

Thanks for watching this test Question & Answers. Please don't forget to leave a comment about this post. You can also find some more effective test question & answers, information, techniques, technology news, tutorials, online earning information, recent news, results, job news, job exam results, admission details & another related services on the following sites below. Happy Working!
News For Todays ARSBD oEtab ARSBD-JOBS DesignerTab

UpWork (oDesk) & Elance U.S. English Basic Skills Test Question & Answers

UpWork (oDesk) & Elance U.S. English Basic Skills Test Question & Answers

July 01, 2015 / 1 Comment

UpWork (oDesk) & Elance U.S. English Basic Skills Test Question & Answers are really very important to pass UpWork & Elance test. You will get top score at this skill test exam. If you found any problem or wrong answer please inform me via contact or comments. We will try to solve it in short. This test is extremely valuable to acquire knowledge of this skill. Lets Start test.

Ques: Change the following sentence from a quotation to indirect speech."I can meet with you at noon," said Peter.
Ans: Peter said he could meet with me at noon.

Ques: Change the following sentence from a quotation to indirect speech. "I will be moving soon," said Alma.
Ans: Alma said she would be moving soon.

Ques: Change the following sentence from a quotation to indirect speech.  "I'm not feeling well," Agatha said.
Ans: Agatha said she wasn't feeling well.

Ques: Change the following sentence from a quotation to indirect speech.  "It may snow tomorrow," he said.
Ans: He said it might snow the next day.

Ques: Change the following sentence from a quotation to indirect speech.  "Sharon must go to the bank today," said Albert.
Ans: Albert said Sharon had to go to the bank that day.

Ques: Change the following sentence from a quotation to indirect speech.  Carol has said, "I am responsible for this project."
Ans: Carol has said that she is responsible for this project.

Ques: Change the following sentence from a quotation to indirect speech.  Jerry said, "I saw my cousin at the fair."
Ans: Jerry said he had seen his cousin at the fair.

Ques: Change the following sentence from a quotation to indirect speech.  Rhonda says, "I get to work early every day."
Ans: Rhonda says she gets to work early every day.

Ques: Choose the option that correctly changes the original sentence from active voice to passive voice.  ORIGINAL SENTENCE: That tall man is carrying a lot of lumber.  REWRITTEN SENTENCES:
Ans: A lot of lumber is being carried by that tall man.

Ques: Choose the phrase that best completes the sentence below without creating a run-on sentence.  It's never too late to learn how to swim ________________ you may fall off a boat!
Ans: , you never know when

Ques: Choose the phrase that best completes the sentence below without creating a run-on sentence.  Mr. Peach has sent his four children to Ivy League colleges __________ he has sacrificed his health working day and night in that dusty factory.
Ans: , however

Ques: Choose the series of adjectives and adverbs that best completes the following sentence.  I think Pamela deserves to be punished for her __________ stupid and __________ behavior.
Ans: totally, irresponsible

Ques: Choose the series of adjectives and adverbs that best completes the following sentence.  Knowing that February was the _________ month of the year, Cheryl planned her vacation ___________.
Ans: shortest, accordingly

Ques: Choose the series of adjectives and adverbs that best completes the following sentence.  Of the two books, Sam's is definitely the __________ ; however, even though Sandra's didn't turn out as __________ as expected, she still did a __________ job of writing it.
Ans: better, well, good

Ques: Choose the series of adjectives and adverbs that best completes the following sentence.  The _______ , _______ odor was ________ coming from the chemistry lab up the street.
Ans: nasty, pungent, clearly

Ques: Choose the series of adjectives and adverbs that best completes the following sentence.  The archaeologists were ________ to discover such a __________ and __________ _________ artifact at that mostly uncovered site.
Ans: amazed, rare, incredibly, beautiful

Ques: Choose the series of adjectives and adverbs that best completes the following sentence.  The helium-__________ balloon rose __________ into the air; the villagers knew then that their __________ leader was off on another mission.
Ans: powered, powerfully, powerful

Ques: Choose the series of adjectives and adverbs that best completes the following sentence.  We were surprised when the ________ parade ________ turned into a ________ party!
Ans: dull, suddenly, wild

Ques: Choose the series of adjectives and adverbs that best completes the following sentence.  While __________ of our relatives live on the __________ hill in the county, __________ of our friends live in the __________ __________ areas of the valley.
Ans: many, windiest, most, more, protected

Ques: Choose the series of articles and conjunctions that best completes the following sentence.  _______ she was feeling ill, Teresa wanted to eat only _____ apple _____ some soup.
Ans: Because, an, or

Ques: Choose the series of articles and conjunctions that best completes the following sentence.  I think Fran could be ______ great public speaker, _______ she is still too shy to try it.
Ans: a, but

Ques: Choose the series of articles and conjunctions that best completes the following sentence.  Julia, who is studying to be _______foreign correspondent, is currently doing _______ internship in _______ Middle East _______  will return before the end of _______  year.
Ans: a, an, the, but, the

Ques: Choose the series of articles and conjunctions that best completes the following sentence.  Lilacs ______ violets are usually purple, ______ I have seen some ______ are white.
Ans: and, however, that

Ques: Choose the series of articles and conjunctions that best completes the following sentence.  Neither we ________ Sal, our neighbor, could understand ________ it had been our dog Rover or Sal's cat's kittens _________ had destroyed all the flower beds in the middle of _______ night.
Ans: nor, whether, that, the

Ques: Choose the series of prepositions that best completes the following passage.  Although Marvin said he had hidden the keys _______ the flower pot, we were unable to find them  _______ the dark. In the end, we waited for him at the coffee shop ___________ the corner.
Ans: under, in, around

Ques: Choose the series of prepositions that best completes the following sentence.  Although the issue was very serious, the committee disposed ______ it in a few minutes and moved _______ to other business.
Ans: of, away

Ques: Choose the series of prepositions that best completes the following sentence.  Charlotte knew ___________ the secret investigation _________ her past, but she closed her eyes to it and pretended it wasn't happening.
Ans: of, about

Ques: Choose the series of prepositions that best completes the following sentence.  I placed my notes _______ my desk and referred to them _______ the meeting.  
Ans: beside, during

Ques: Choose the series of prepositions that best completes the following sentence.  Jack, leaning casually ________ the tree, watched as Sally walked slowly ________ him.
Ans: against, toward

Ques: Choose the series of prepositions that best completes the following sentence.  Jeremy drove his motorcycle _______ the bridge, _______ the hill, and _______ the diner before finally parking it _______ two police cars.
Ans: across, down, past, between

Ques: Choose the series of prepositions that best completes the following sentence.  The deer ran quickly _______  the trees, its hooves pounding _______  the forest floor.
Ans: through, on

Ques: Choose the series of prepositions that best completes the following sentence.  Whiskey, my pet squirrel, jumped ________ my head and ________ the windowsill.
Ans: over, onto

Ques; Choose the series of pronouns that best completes the following sentence.  _______  is the name of the opera, and _______ role did you say Maria would play?
Ans: What, which

Ques; Choose the series of pronouns that best completes the following sentence.  After realizing that our hosts hadn't actually invited ______ to ______ party, ______  excused ______  from the table and slipped out the back door.
Ans: us, their, we, ourselves

Ques: Choose the series of pronouns that best completes the following sentence.  Don't ________ think Larry should call ________ wife if ________ is going to be late for dinner?
Ans: you, his, he

Ques: Choose the series of pronouns that best completes the following sentence.  That house used to be ______ , but ______ have given it to ______.
Ans: mine, I, her

Ques: Choose the series of pronouns that best completes the following sentence.  Victor, who stole _______ ideas and used them to make _______ a millionaire, never once offered _______ a word of thanks.
Ans: our, himself, us

Ques: Choose the series of verbs and phrases that best completes the following passage.  This dish _________ too spicy. Why __________ so much pepper?
Ans: is, did the chef use

Ques: Choose the series of verbs that best completes the following passage.  I find it very hard to remember _________ letters that are entrusted to me. In fact, I remember _________ to do so dozens of times!
Ans: mailing, forgetting

Ques: Choose the series of verbs that best completes the following sentence.  Alison regrets _________ you with her remarks; she never meant _________ so.
Ans: hurting, to do

Ques; Choose the series of verbs that best completes the following sentence.  Everyone __________  too busy cooking and __________ the campsite __________ the family of bears __________ from the woods.
Ans: was, setting up, to notice, watching

Ques: Choose the series of verbs that best completes the following sentence.  If Harry __________ to the party too early, don't let him in; he __________ outside like everyone else.
Ans: gets, will have to wait

Ques: Choose the verb that best completes the following sentence.  Do you know if Harlon ____________Japanese before moving to Japan?
Ans: has studied

Ques: Complete the following sentence by choosing the phrase with the best word order from the options given.  Only after they had completed an exhaustive study __________ how to adapt the technology to the needs of our company.
Ans: they did begin to understand

Ques: Complete the following sentence by choosing the phrase with the best word order from the options given.  The excited children, who had run toward the loud _____________ .
Ans: music, told the others about the ice cream truck outside

Ques; Complete the following sentence by choosing the phrase with the best word order from the options given.  Those who are not wise ____________  .
Ans: need not to be necessarily stupid

Ques: Read the following question and choose the response that uses the correct corresponding verb tense.  Did you see the show last night?
Ans; No, because by the time I got there all the tickets had already been sold.

Ques: Read the following question and choose the response that uses the correct corresponding verb tense.  Does Jack wear that furry hat often?
Ans: No, he only wears it when his ears are cold.

Ques: Read the following question and choose the response that uses the correct corresponding verb tense.  Will you be going to the company picnic this year?
Ans: Yes, and I plan on swimming, fishing, and eating all day!

Ques: Read the original sentence below and then choose the rewritten sentence that illustrates proper sentence structure.  ORIGINAL SENTENCE: It is easy to carry solid objects, but the same cannot be said of liquids.  REWRITTEN SENTENCES:
Ans: Unlike liquids; solid objects can easily be carried.

Ques: Rearrange the following words to create the most logical and grammatically correct sentence.  days . for last has good weather few The been the not
Ans: The weather has not been good for the last few days.

Ques: Rearrange the following words to create the most logical and grammatically correct sentence.  last what ! it's did you night, over After
Ans: After what you did last night, it's over!

Ques: Rearrange the following words to create the most logical and grammatically correct sentence.  sleeping likes the . midday Katie until on weekends
Ans; Katie likes sleeping until midday on the weekends.

Ques: Rearrange the following words to create the most logical and grammatically correct sentence.  with can't phone . on Whenever always to the time spend I speak I my friend , him
Ans: Whenever I can't spend time with my friend, I always speak to him on the phone.

Ques: Rearrange the following words to create the most logical and grammatically correct sentence.  work . is always to brother willing not My
Ans: My brother is not always willing to work.

Ques: Rearrange the following words to create the most logical and grammatically correct sentence.  would I have it anything if had . I you known said would not bother
Ans: I would not have said anything if I had known it would bother you.

Ques: Rearrange the following words to create the most logical and grammatically correct sentence.  your company name ? of What the is
Ans: What is the name of your company?

Ques: Which of the following sentences does NOT illustrate correct verb and verb tense usage?
Ans: Clarabelle's mother absolutely hated nicknames and always calls her daughter by her full name.

Ques: Which of the following sentences does NOT illustrate proper use of articles and conjunctions?
Ans: Bertha decided to change a locks of her house after burglars stole a computer or an oil painting.

Ques: Which of the following sentences illustrate(s) the proper use of commas?
Ans: Randy wanted to end the meeting, but Amy wanted to prolong it. &  After pouring herself a glass of water in silence, Nicky answered my question.

Ques: Which of the following sentences illustrates correct pronoun usage?
Ans: None of the above

Ques: Which of the following sentences illustrates correct usage of articles and conjunctions?
Ans: For my birthday, I would like a book, an hourglass, and the keys to a new boat.

Ques: Which of the following sentences illustrates correct usage of articles and conjunctions?
Ans: Celine lives on Arthur Street; however, she works on Beatrice Boulevard.

Ques: Which of the following sentences illustrates correct verb and verb tense usage?
Ans: Until the snow melts, the train will not be able to move.

Ques: Which of the following sentences illustrates correct verb and verb tense usage?
Ans: Did Annabel knowingly lie on the witness stand? & We think the judge will have noticed something strange in her behavior.

Ques: Which of the following sentences illustrates incorrect pronoun usage?
Ans: None of the above

Ques: Which of the following sentences illustrates proper sentence structure?
Ans: The queen had hardly finished her speech when the people began to disperse.

Ques: Which of the following sentences illustrates proper sentence structure?
Ans: The man in the black cape mounted his powerful stallion and rode away.

Ques: Which of the following sentences illustrates the proper use of apostrophes?
Ans: Helga borrowed her friend's skates for the day; however, she failed to return them.

Ques: Which of the following sentences illustrates the proper use of parallel construction?
Ans: Tatiana declared that the people in her office are smarter than the people who work in Tad's office.

Ques: Which of the following sentences is NOT punctuated correctly?
Ans: All of the apple's at the grocer's were rotten, so I bought oranges instead.

Ques: Which of the following sentences is NOT punctuated correctly?
Ans: I need you to pick up several boxes of paperclips, pens, and pencils; three pounds each of potatoes, carrots, and peas; and my dry cleaning.

Ques: Which of the following sentences is punctuated correctly?
Ans: "Come here," she said. "and let me get a good look at you."

Thanks for watching this test Question & Answers. Please don't forget to leave a comment about this post. You can also find some more effective test question & answers, information, techniques, technology news, tutorials, online earning information, recent news, results, job news, job exam results, admission details & another related services on the following sites below. Happy Working!
News For Todays ARSBD oEtab ARSBD-JOBS DesignerTab

UpWork (oDesk) & Elance Microsoft Word 2010 Test Question & Answers

UpWork (oDesk) & Elance Microsoft Word 2010 Test Question & Answers

/ No Comments

UpWork (oDesk) & Elance Microsoft Word 2010 Test Question & Answers are really very important to pass UpWork & Elance test. You will get top score at this skill test exam. If you found any problem or wrong answer please inform me via contact or comments. We will try to solve it in short. This test is extremely valuable to acquire knowledge of this skill. Lets Start test.

Ques: Which of the following is incorrect regarding "Hyphenation Zone?"

Ans: The hyphenation zone cannot be changed to make it narrower.

Ques: State whether true or false: The "Add Assistant" shape option in a SmartArt graphic is available only if an organization chart layout is chosen.
Ans: True

Ques: Which among the following is an invalid character to include in a file name?
Ans: All of the above

Ques: Which among the following is NOT true about content controls?
Ans: Customized content controls cannot be distributed.

Ques: 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.
Ans: True

Ques: Which keyboard shortcut is used to make the text size smaller?
Ans: CTRL+SHIFT+<

Ques: Which among the following charts do not have axes?
Ans: Doughnut charts

Ques: What is the significance of "Building Blocks?"
Ans: Building blocks are items within a document that can be saved to be reused in other documents.

Ques: Which among the following options should be used to number the cells in a table?
Ans: Select the table cells that need to be numbered. On the Home tab, in the Paragraph group, click on Numbering.

Ques: Why is the "Different First Page" option used in the Page Setup dialog box as shown in the given picture?
Ans: All of the above

Ques: Why is the "Different First Page" option used in the Page Setup dialog box as shown in the given picture?
Ans: All of the above

Ques: Edit tracking changes are typically formatted in the following manner: (1) deletions—red strikethroughs, (2) additions—green and underlined, and (3) formatting changes are made bold in almost any other desired color. Where in Word 2007 could you set your own custom formatting options for tracking changes?
Ans: Select the Review ribbon and then select the triangle by Track Changes. In the drop-down menu, select "Change Tracking Options" and then set your formatting options in the Track Changes Options dialog box.

Ques: Which view(s) could be used to view the Equation placeholders in the Document Views group?
Ans: All of the above

Ques: Which among the following is a keyboard shortcut to cut a table?
Ans: CTRL+X

Ques: State whether true or false: When you save a document as a Web page, the textures and gradients are saved as JPEG files and the patterns are saved as GIF files.
Ans: True

Ques: State whether true or false: Changing the Author property in the Document Information Panel of an existing document has no effect on the User name setting in the Word Options dialog box.
Ans: True

Ques: Which keyboard shortcut inserts a hyperlink?
Ans: CTRL+K

Ques: State whether true or false: Microsoft Office programs store some additional information within the digital signature automatically that might not be visible in the current view document.
Ans: True

Ques: What does the icon marked with 'A' on the status bar on the bottom of the page indicate in the given picture?
Ans: It indicates that the document contains a signature.

Ques: Refer to the given image. How could the Quick Access Toolbar be moved?
Ans: Click on "Customize Quick Access Toolbar." In the list, click on "Show Below the Ribbon."

Ques: State whether true or false: Gridlines do not print when a document is printed.
Ans: True

Ques: How would you divide your Word 2007 document into three columns?
Ans: Position your cursor where you would like to insert the columns. Open the Page Layout ribbon. In the Page Setup section, click Columns. Select Three.

Ques: What is meant by Enhanced ScreenTips?
Ans: Enhanced ScreenTips are larger windows that display more descriptive text than a ScreenTip and can have a link to a Help topic.

Ques: Which among the following options is not true regarding a macro?
Ans: To work with macros in Word 2007, the Review tab needs to be opened.

Ques: State whether true or false: A building block can be added to as many galleries as you want.
Ans: True

Ques: What steps should be followed to replace a shape with another shape?
Ans: Select the shape to be changed. Select the Format tab; use the "Change Shape" button in the Shape Styles group.

Ques: State whether true or false: In Microsoft Word 2007, a diagram can be converted to individual shapes.
Ans: False

Ques: How does the "Gutter margin" help while using Page Setup, as shown in the picture?
Ans: It ensures that the text is not obscured by binding.

Ques: The Draft view was called the Normal view in versions of Word prior to Word 2007. The Draft view can help with setting the page and section breaks for the document. Which of the following could be used to select the Draft view for a document?
Ans: Select the Office button and then select Word Options. In the Word Options dialog box, select Display and check the Draft check box under Page display options.

Ques: In Picture1, the check box has a gray background. Which among the following Legacy Tools (select the Developer tab and then the Controls group) will be used to remove the gray shading in Picture2?
Ans: C

Ques: Refer to the picture given above. Which of the following options should be selected to scroll both documents together?
Ans: B

Ques: Which of the following line-spacing options sets fixed line spacing that Word does not adjust?
Ans: Multiple

Ques: With the help of which view will the Watermark not be seen?
Ans: Web Layout view

Ques: State whether true or false: An existing table cannot be copied and pasted into another table.
Ans: True

Ques: State whether true or false: New text animation effects can be applied in Microsoft Word 2007.
Ans: False

Ques: Which option(s) should you select to remove a chart or axis title from a chart?
Ans: All of the above

Ques: What is the purpose of the "Demote" button as shown in the diagram?
Ans: It increases the level of a selected bullet or a shape.

Ques: Which of the following is not true about "Format Painter?"
Ans: Format Painter is used to apply text formatting and some basic graphics formatting, such as borders and fills.

Ques: State whether true or false: Placeholder citations appear in the bibliography.
Ans: True

Ques: Which among the following is not true regarding the use of a pie chart?
Ans: A pie chart could be used when there is only one data series to be plotted.

Ques: In the given picture, the "Washout" option has been selected. What purpose does it serve?
Ans: It lightens the picture so that it does not interfere with the text.

Ques: What is the maximum number of columns that can be created in the Columns dialog box as shown in the picture?
Ans: 13

Ques: Which feature has been used from the Picture Pane on Picture1 to achieve the same result as Picture2?
Ans: Recolor

Ques: Which command-line switch and parameter starts Word 2007 without displaying the Word splash screen?
Ans: /q

Ques: What does the command "Winword.exe /f MyDocument.docx" mean?
Ans: This command instructs Word to start and immediately open a file named MyDocument.docx.

Ques: How will you set the default font so that every time you open Microsoft Word it will use the settings that you had selected?
Ans: Select the Home tab, and then click the Font Dialog Box Launcher. Select the font style and size. Click on Default... and then click Yes.

Ques: In some cases, when lists are combined into one "List," the formatting is not updated. Refer to the picture given above. Which among the following options should be used to update this formatting?
Ans: D

Ques: Refer to the given image. In Picture1, axes appear on the left side. Which setting should you use to make them appear on the right side, as shown in Picture2?
Ans: Select the Axis Options tab in the Format Axis dialog box. Set the Axis labels: field to High.

Ques: In the given picture, the "Keep Text Flat" option has been selected. What is the use of this feature?
Ans: It prevents text inside the shape from rotating when the shape is rotated.

Ques: State whether true or false: Changes that are made on the Worksheet are automatically updated in the chart.
Ans: False

Ques: Refer to the given picture. Which of the following Line Numbers should be used when each page has to begin with the number 1?
Ans: B

Ques: Suppose you want to insert a cross reference at the current cursor position in the document to a heading (located elsewhere in the document). Which of the following methods would do this in Word 2007?
Ans: Select the Insert tab. In the Links section, click Cross-reference. Select Headings under Reference type. Select the appropriate heading from those displayed in the bottom pane. After you have made your selection, click Insert. Close the dialog box.

Ques: For what purpose is the SmartArt graphic control used, as shown in the picture?
Ans: It shows the Text Pane on clicking the control.

Ques: Which among the following is not a Bookmark option to sort the list of bookmarks in the document?
Ans: Author

Ques: The default installation of Word 2007 includes several built-in character styles. Which of the following is NOT one of the default, built-in character styles:
Ans: Special Emphasis

Ques: How will the Message Bar alerts be enabled as shown in the given picture?
Ans: Select Word Options from the Microsoft Office Button. Click on Trust Center, then click Trust Center Settings, and then click Message Bar.

Ques: Which of the following is not a type of "Section Breaks?"
Ans: First Page

Ques: Which chart type does the given picture represent?
Ans: Area charts

Ques: Which of the following charts display "Error bars" for x values, y values, or both?
Ans: XY (Scatter) charts & Bubble charts

Ques: Microsoft named two styles that work in Word 2007 as both character and paragraph types as being ______ styles:
Ans: linked

Ques: To enter a symbol or special character into your document (to where the cursor is located), which of the following methods could you employ in Word 2007?
Ans: Open the Insert ribbon. Click Symbol in the Symbols group. A menu will appear with a small selection of symbols. If you don't see the symbol or character you'd like to insert, click More Symbols. Choose the special character (or symbol) that you want and then click Insert and click Close.

Ques: The given picture shows the list items being at different levels rather than at one level. What is this list known as?
Ans: Multilevel

Ques: Which among the following file types of templates allows macros to be enabled in the file?
Ans: .dotm

Ques: Refer to the given picture. Which of the following buttons is used to show paragraph marks and other hidden formatting symbols?
Ans: D

Ques: Which of the following is/are true about phishing?
Ans: All of the above

Ques: Which of the following options repeats a table heading on subsequent pages?
Ans: None of the above

Ques: Which among the following options represents Legend entries in the given picture?
Ans: C

Ques: Which among the following features could be used to create a connection to a Shared Network folder?
Ans: Map Network Drive

Ques: Which among the following is a correct way to make your file "Read-only?"
Ans: Click "Save As" from the Microsoft Office Button. Click on Tools and then click General Options. Select the Read-only recommended check box. Click OK. Click on Save.

Ques: You are editing a figure using the Drawing Tools > Format options. Which among the following Shape Fill options in the Shape Styles group adds a solid color and transparency to a shape?
Ans: More Fill Colors...

Ques: State whether true or false: Any changes that are saved to "Normal.dotm" will be applied to the documents that you create in the future.
Ans: True

Ques: Refer to the given image. Which option should be selected to convert a professionally formatted equation into an equation on one line?
Ans: C

Ques: In the given picture, the "Match case" check box has been selected. Which among the following is true for this selection made for the "Match case" check box?
Ans: It searches for only entire words that match the case of the word or phrase that is typed in the "Find what" box.

Ques: State whether true or false: ASCII-formatted text contains no formatting information such as bold, italic, or fonts.
Ans: True

Ques: Which method determines the position of the "Envelope" while printing, in the Envelope options dialog box?
Ans: Feed method

Ques: Which among the following is an "Orientation" type of Page Layout?
Ans: Portrait

Ques: Which among the following is a keyboard shortcut to underline blank spaces for a form?
Ans: Shift + Hyphen(-)

Ques: Which among the following options is the reason for text getting deleted at the insertion point when you type a document?
Ans: The "overtype mode" is turned on in Word options.

Ques: State whether true or false: Cover pages are always inserted at the beginning of a document, no matter where the cursor appears in the document.
Ans: True

Ques: State whether true or false: Switches and parameters are not case-sensitive.
Ans: True

Ques: Just as in Word 2003 or prior Word versions, the default standard view for Word 2007 is the Draft view (and is still also called the Normal view in Word 2007):
Ans: True

Ques: How will you insert text boxes for a printed form?
Ans: Select the Insert tab, in the Text group, click on Text Box and then select Draw Text Box.

Ques: Which of the following two paragraphs is/are true for Word 2007?
(1)To show or hide formatting marks in your editing markup — on the Home ribbon, in the Paragraph group, click the Show/Hide button.
(2) The Show/Hide button will not hide all the formatting marks in the document if you selected those marks that are to be displayed at all times (such as paragraph marks, tab characters, hidden text, optional hyphens, object anchors, or spaces). To turn off any or all of these selected formatting marks, follow this procedure: Click the Microsoft Office Button and then click Word Options. Then Click Display. Under "Always show these formatting marks on the screen," clear the check boxes for any formatting marks that you do not want to show at all times in your documents.
Ans: Both (1) and (2)

Ques: How will you change the author name in an existing document?
Ans: Click on the Microsoft Office Button, select Prepare, and then click Properties. Type the author name in the Author box.

Ques: Which among the following is the correct order to convert a table to text?
Ans: Select the table. Under Table Tools, on the Layout tab, in the Data group, click on "Convert to Text."

Ques: Which of the following is true about the term "Mark as Final," as shown in the picture?
Ans: It helps to communicate that a completed version of a document is being shared.

Ques: Which keyboard shortcut could be used to switch to Draft View?
Ans: ALT+CTRL+N

Ques: Which of the following is shown in the picture, denoted by A?
Ans: Rotation Handle

Ques: Refer to the given picture. Which of the following options turns off Enhanced ScreenTips but keeps the ScreenTips still visible?
Ans: B

Ques: With which chart type(s) is/are the "Depth Gridlines" option available?
Ans: True 3-D chart

Ques: Which of the following can be the reason for the appearance of the red X, as shown in the picture?
Ans: All of the above

Ques: State whether true or false: Once a bullet is removed from the "Bullet Library" and it is no longer available in the "Document Bullets" area, the bullet cannot be added back to the Bullet Library.
Ans: False

Ques: Which keyboard shortcut could be used to check the spelling of a text file?
Ans: F7

Ques: Which keyboard shortcut could be used to check the spelling of a text file?
Ans: F7

Ques: Which among the following options should be used to start a bulleted list automatically?
Ans: Type * (asterisk) and then press spacebar or the Tab key.

Ques: Which among the following options would you choose to automatically enter the current date?


Ans: Select the Insert tab and then select Date & Time in the Text group. Choose one of the available formats in the Date and Time dialog box.

Thanks for watching this test Question & Answers. Please don't forget to leave a comment about this post. You can also find some more effective test question & answers, information, techniques, technology news, tutorials, online earning information, recent news, results, job news, job exam results, admission details & another related services on the following sites below. Happy Working!
News For Todays ARSBD oEtab ARSBD-JOBS DesignerTab

UpWork (oDesk) & Elance Microsoft Excel 2010 Test Question & Answers

UpWork (oDesk) & Elance Microsoft Excel 2010 Test Question & Answers

/ No Comments

UpWork (oDesk) & Elance Microsoft Excel 2010 Test Question & Answers are really very important to pass UpWork & Elance test. You will get top score at this skill test exam. If you found any problem or wrong answer please inform me via contact or comments. We will try to solve it in short. This test is extremely valuable to acquire knowledge of this skill. Lets Start test.

Ques: 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?
Ans: All cloned copies of that slicer are also updated instantly.

Ques: How would you assign a macro to a graphic?
Ans: 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.

Ques: 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 ($).
Ans: False

Ques: 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?
Ans: Online Analytical Processing (OLAP) Cube Files

Ques: Which of the following tools is used to format Excel worksheet data, as shown in the figure above?
Ans: SmartArt

Ques: 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?
Ans: It will select the whole sheet.

Ques: Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser?
Ans: Excel Web Access (EWA)

Ques: What is the filename extension of Excel workbooks which are saved as 'Excel Templates'?
Ans: .xltx

Ques: State whether following statement regarding images in Microsoft Excel 2010 is true or false: Microsoft Excel 2010 supports 3D rotation of images.
Ans: False

Ques: 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?
Ans: The value of cell D9 will be 42

Ques: Which of the following statements are true regarding PowerPivot in Microsoft Excel 2010?
Ans: PowerPivot streamlines the process of integrating data from multiple sources like databases, spreadsheets, reports and text files.

Ques: 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'?
Ans: =AVERAGE(E6 to E15)

Ques: Which of the following statements is true regarding MS Excel Web Access on a SharePoint Foundation 2010 Server?
Ans: It is not possible to use the CTRL+Enter keyboard combination on formulas entered in multiple cells in a worksheet.

Ques: 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
Ans: False

Ques: What does the icon marked with a red square in the figure above signify?
Ans: It signifies that the document contains digital signatures.

Ques: Excel keeps the changed history of a workbook for ________ days by default.
Ans: 30 days

Ques: Which of the following is available as fill options while formatting cells of an Excel worksheet using the format style as Data Bar?
Ans: Gradient Fill

Ques: Suppose you create a workbook in Microsoft Excel 2010 and run the 'Check Accessibility' option. This option is used to check the workbook for ____________.
Ans: Both a and b

Ques: Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?
Ans: Cell left

Ques: What is the purpose of time stamping a digital signature in Microsoft Excel 2010?
Ans: It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.

Ques: Microsoft Excel Services is a component of:
Ans: Microsoft SharePoint Technology

Ques: Which of the following statements is NOT true regarding import of data into PowerPivot?
Ans: Data can be imported into PowerPivot by either selecting list of tables or by writing SQL query.

Ques: Which among the following settings is the default macro security setting?
Ans: Disable all macros with notification.

Ques: 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?
Ans: Font Style

Ques: 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.
Ans: True

Ques: In the given screenshot, the contents of the 'Name of User' column have been oriented at an angle. How is this done?
Ans: By using the 'Orientation' button in the alignment group of the 'Home' tab.

Ques: Which of the following statements is not true regarding offline cube files in Microsoft Excel 2010?
Ans: An offline cube file allows you to work with PivotTable and PivotChart reports even when the server is unavailable.

Ques: 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?
Ans: The red triangles represent the comment associated.

Ques: 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.
Ans: Worksheet

Ques: What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
Ans: All of the above.

Ques: Deleting a PivotChart report automatically deletes the associated PivotTable report.
Ans: False

Ques: 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?
Ans: Scenarios

Ques: Which of the following axis settings are available for the appearance of data bars for negative values in Microsoft Excel 2010?
Ans: Cell left

Ques: Which of the following areas in the Microsoft Excel 2010 PivotTable Field List, calculates the aggregates of columns?
Ans: Values

Ques: 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.
Ans: Ascending

Ques: 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?
Ans: 4-Color Scale

Ques: 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))
Ans: 80

Ques: 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?
Ans: result_vector

Ques: Which of the following statements is true regarding PowerPivot in Microsoft Excel 2010?
Ans: Version control and tracking is supported by PowerPivot.

Ques: Suppose you have created a report in Excel named 'report.xlsx'. Now you want your team members to 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?
Ans: Share 'report.xlsx' by saving it to a SharePoint site.

Ques: State whether the 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 ($).
Ans: False

Ques: What view must be used when inserting a subdocument?
Ans: Web Layout

Ques: Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
Ans: MDI

Ques: Which of the following in NOT a type of Section Break?
Ans: Continuous

Ques: 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?
Ans: Insert Flowchart

Ques: Which among the following chart types do not have axes?
Ans: Doughnut charts

Ques: 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.
Ans: Worksheet

Ques: When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, Smart Art graphics, shapes, and other objects are updated to complement one another.
Ans: False

Ques: 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?
Ans: It will select the whole sheet, having the same effect as that of Ctrl+A.

Ques: 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.
Ans: Worksheet

Ques: 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.
Ans: The value of cell D9 will be 42

Ques: 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?
Ans: By using the 'Orientation' button in the alignment group of the 'Home' tab.

Ques: 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))
Ans: 80

Ques: 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?
Ans: All cloned copies of that slicer are also updated instantly.

Ques: 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?
Ans: The data can only be sorted according to the 'Product' field.

Ques: This question is based upon the figure shown below
Ans: It signifies that the document contains digital signatures.

Ques: Deleting a PivotChart report automatically deletes the associated PivotTable report.
Ans: False

Ques: 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.
Ans: Ascending

Ques: Which of the following arguments of the LOOKUP function is optional?
Ans: result_vector

Ques: Excel keeps the changed history of a workbook for ________ days by default.
Ans: 30 days

Ques: Microsoft Excel Services is a component of:
Ans: Microsoft SharePoint Technology

Ques: If you want to create a citation and fill in the source information later, you should:
Ans: insert a caption

Ques: If I do not want the contents of one of my fields to automatically update, I would have to do which of the following?
Ans: Make the field hidden.

Ques: To select vertical blocks of text, you would hold down which key while dragging the mouse?
Ans: Ctrl

Ques: 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?
Ans: Tables with maximum number of rows and columns was added to the document.

Ques: A particular chart layout can be applied to a chart only if:
Ans: it is a 2D chart.

Ques: Choose the INCORRECT statement:
Ans: Only high-risk documents from an uncertain location are opened in Read-Only view.

Ques: Microsoft Word 2010 has enabled ligatures for which of the following fonts?
Ans: Open Type fonts

Ques: With which chart type(s) is the “Depth Gridlines” option available?
Ans: Line chart

Ques: 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?
Ans: XLS

Ques: 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?
Ans: By using the Recolor option under Format Picture.

Ques: 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?
Ans: “Allow row to break across pages” is unchecked.

Ques: 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

Ques: 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?
Ans: Share 'report.xlsx' by saving it to a SharePoint site.

Ques: 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?
Ans: Change chart type to a line chart and type all the values into an Excel file.

Ques: 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.
Ans: Orientation

Ques: 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?
Ans: Scenarios

Ques: 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?
Ans: 4-Color Scale

Ques: 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?
Ans: Square

Ques: 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(ans)

Thanks for watching this test Question & Answers. Please don't forget to leave a comment about this post. You can also find some more effective test question & answers, information, techniques, technology news, tutorials, online earning information, recent news, results, job news, job exam results, admission details & another related services on the following sites below. Happy Working!
News For Todays ARSBD oEtab ARSBD-JOBS DesignerTab

UpWork (oDesk) & Elance Search Engine Optimization-SEO Test Question & Answers

UpWork (oDesk) & Elance Search Engine Optimization-SEO Test Question & Answers

/ No Comments

UpWork (oDesk) & Elance Search Engine Optimization-SEO Test Question & Answers are really very important to pass UpWork & Elance test. You will get top score at this skill test exam. If you found any problem or wrong answer please inform me via contact or comments. We will try to solve it in short. This test is extremely valuable to acquire knowledge of this skill. Lets Start test.

Ques: Google can index the information inside of an iFrame
Ans: False, Google does not recognize the information inside of iFrames.

Ques: SEO skills are only used for Google.
Ans: False. SEO skills are used for all dominant search engines worldwide.

Ques: Google AdWords:
Ans: All of these

Ques: Which site should you connect your website with to improve your SEO?
Ans: All of these

Ques: What will cause a 404 page to display?
Ans: All of these

Ques: SEO is best used for?
Ans: Driving web traffic to your website

Ques: Google's Panda, Penguin and Hummingbird search algorithm updates are a move by Google to
Ans: show sites with relevant, original, high-quality content in search results.

Ques: When permanently moving content from one webpage to another, you should...
Ans: use a 301 redirect.

Ques: SERP stands for
Ans: Search Engine Results Pages

Ques: Is SEO a one-time event?
Ans: No, SEO requires a long-term commitment.

Ques: On Google, what is PageRank?
Ans: An evaluation of the importance of a page on a site based on the number of genuine links from other sites to it.

Ques: Which program lets Google know if you are using an XML Site Map?
Ans: Google Webmaster Tools

Ques: How can you communicate additional information about an image to a bot?
Ans: Use the ALT attribute in the IMG tag.

Ques: What does Google use in a listing to describe your web site?
Ans: All of these

Ques: What does EMD mean?
Ans: Exact Match Domain

Ques: What does Google use to "name" your web page in its search listing?
Ans: The information in the TITLE tag of the page.

Ques: Which activity is NOT considered to be a page optimization method?
Ans: Directory submission

Ques: Which form of redirect/meta tag will transfer the most authority to the directed page?
Ans: 301

Ques: SEO techniques offer a guaranteed method of appearing as the first listing on an unpaid search engine listing
Ans: False

Ques: What was the main difference between the Panda and Penguin Google algo changes?
Ans: Panda was aimed at poor quality content and user experience. Penguin was aimed at a range of black-hat techniques.

Ques: Google search results will display up to how many characters of a page's meta description?
Ans: 156

Ques: Which statement about 404 pages is true?
Ans: A custom 404 page that kindly gives users back to a working page on your site can greatly improve a user's experience.

Ques: What would happen if you searched Google for site:example.com “some text here”
Ans: It would list only web pages on example.com that contained the exact words "some text here"

Ques: Which of these meta-data types is the LEAST important to Google for ranking, indexing or display purposes?
Ans: meta name="keywords"

Ques: Of the following options which is the LEAST important area to include your target keywords?
Ans: Meta Keywords

Ques: What does LSI stand for?
Ans: Latent Semantic Indexing

Ques: How do you control where robots go and what they do in your web site?
Ans: Use all of these

Ques: Which of these is NOT something that you can use to improve your SEO?
Ans: None of these

Ques: Search engines do not index some common words (such as “or”, “and”, “when”, and “in”) within the webpage. What are these common words called?
Ans: Stop words

Ques: What do you enter in the rule portion of a robots.txt file single entry to block .gif images from indexing?
Ans: Disallow: /*.gif$

Ques: Which of these types of page content can Google NOT index?
Ans: Javascript

Ques: What do you enter in the robots.txt file to remove all images on your site from Google Images?
Ans: User-Agent: Googlebot-Image Disallow: /

Ques: Google did the "caffeine" roll-out to:
Ans: crawl websites 50% faster

Ques: What do you enter in the robots.txt file to block indexing of all PDF files on your web site?
Ans: Disallow: /*.pdf$

Ques:  Which of these meta-data types is the LEAST important to Google for ranking, indexing or display purposes?
Ans: meta name="keywords"

Ques: Which is a best practice for creating URL names?
Ans: Use real words in the URL name.

Ques:  Why are meta tags important in relation to SEO?
Ans: Because a search engine may use them as snippets for your pages.

Ques: Google's Panda, Penguin and Hummingbird search algorithm updates are a move by Google to
Ans: show sites with relevant, original, high-quality content in search results.

Ques: What type of redirect gives you the most credit in terms of SEO?
Ans:  301 ('Moved Permanently')

Ques: What does Google use in a listing to describe your web site?
Ans: All of these

Ques: Which statement about 404 pages is true?
Ans: A custom 404 page that kindly gives users back to a working page on your site can greatly improve a user's experience.

Ques: What would happen if you searched Google for site:example.com “some text here”
Ans: It would list only web pages on example.com that contained the exact words "some text here"

Ques: Paid search result of Google helps to improve overall website usability.
Ans: False: Paid search result has nothing to do with website usability

Ques: Google did the "caffeine" roll-out to:
Ans: crawl websites 50% faster

Ques: For maximum potential visitor traffic, if you could choose just ONE search engine to     optimize your Web site for, which should it be?
Ans: Google

Ques: What is the meaning of the term "H1" tag?
Ans: It stands for Heading Level 1.

Ques: Which of the following URLs would be the best choice of structure for both the search engines and humans?
Ans: http://www.company.com/seo/sitearchitecture

Ques: What is sitemap.xml?
Ans: Sitemap helps in easy crawling of all the pages of a website.

Ques: What is a 404 page?
Ans: A page that shows up when the selected page is not available.

Ques: Which of the following is a SEO best practice?
Ans: Choose a title that effectively communicates the topic of the page's content

Ques: Which of the following is beneficial to the search engine optimization of a specific web page?
Ans: placing content you want indexed in search engines within a

Thanks for watching this test Question & Answers. Please don't forget to leave a comment about this post. You can also find some more effective test question & answers, information, techniques, technology news, tutorials, online earning information, recent news, results, job news, job exam results, admission details & another related services on the following sites below. Happy Working!

News For Todays ARSBD oEtab ARSBD-JOBS DesignerTab

UpWork (oDesk) & Elance Microsoft OutLook 2007 Test Question & Answers

UpWork (oDesk) & Elance Microsoft OutLook 2007 Test Question & Answers

June 30, 2015 / No Comments

UpWork (oDesk) & Elance Microsoft OutLook 2007 Test Question & Answers are really very important to pass UpWork & Elance test. You will get top score at this skill test exam. If you found any problem or wrong answer please inform me via contact or comments. We will try to solve it in short. This test is extremely valuable to acquire knowledge of this skill. Lets Start test.

 

Ques: For which of the given features does Outlook contain a logging option?
Ans: All of the above

Ques: Which of the following items cannot be archived?
Ans: Tasks

Ques: Refer to the given image.
When does this Warning message appear?
Ans: Both a and b

Ques: Which option will you choose to send an e-mail message with a report as an Excel attachment?
Ans: On the Reports toolbar, click the Send E-mail with report as Excel Attachment button

Ques: State whether True or False.

Certificate files have either a.p7c or.cer file extension.
Ans:  True

Ques: Refer to the given image.
Which option will you select to turn on Inline comments and create identifying text?
Ans: D

Ques: Refer to the given image.
Which option displays a command in the given picture?
Ans: B

Ques: Refer to the picture.
What is not true about an additional time zone?
Ans: All of the above

Ques: Which option is used to refresh a report?
Ans: On the Tools menu, Click Options and then select Refresh Report

Ques: Which of the following types of internet calendars are not updated automatically in the Outlook?
Ans: None of the above

Ques: Refer to the given image.
Which tab contains the ''Always show full menus'' check box?
Ans: C

Ques: Refer to the given image.
Which of the following rules work only for Exchange accounts?
Ans: B

Ques: Which of the following types of address books require you to use an Exchange account?
Ans: Outlook Address Book

Ques: Which type of communication history items cannot be linked to Account, Business contact, Opportunity and Business project?
Ans: Opportunity

Ques: Which option will you select to get information about your online or offline status?
Ans: Connection Status??

Ques: Refer to the given image and state whether True or False.
The Reconnect at login check box automatically connects to this network drive each time you start Microsoft Windows.
Ans: True

Ques: State whether True or False.

Attachments, such as files or e-mail messages cannot be added to project tasks, but they can be added to the linked Business Project.
Ans: False

Ques: Which of the following is the way to receive notifications about updates to a SharePoint site in Outlook 2007?
Ans: RSS

Ques: Which standard form is used for logging information about an item or event?
Ans: Post

Ques: Which type of attachment files does Outlook not block?
Ans: .Xls

Ques: With which types of e-mail accounts can the Junk E-mail filter be used
Ans: All of the above

Ques: Which type of communication history item is not saved in the Business Contact Manager for Outlook?
Ans: Business project

Ques: Which option will you select to change the size of an individual note?
Ans: All of the above

Ques: Which of the following parts does the To-Do Bar consist of?
Ans: All of the above

Ques: Which option will you choose to Mark a task complete?
Ans: Open an e-mail message marked with the task flag

Ques: Which option will you choose to add a RSS Feed in Outlook?
Ans: On the Tools menu, click account settings. Select RSS feeds tab

Ques: In which folder is the distribution list saved?
Ans: Contacts

Ques: Which option will you choose to see the completion status of all the project tasks linked to this Business Project record?
Ans: Project tasks

Ques: Refer to the given image.
Which of the following options will you select when you want to include a signature in all your multimedia messages?
Ans: None of the above

Ques: Which option will you select to insert a hyperlink in Microsoft Outlook?
Ans:  All of the above

Ques: Refer to the given image.
Which search option is not selected by default?
Ans: D

Ques: State whether True or False.

Meeting requests do not work in a SharePoint calendar.
Ans: True

Ques: Which option will you select to reduce the size of a Personal folders file?
Ans: Both a and b

Ques: Refer to the given image
Which option will you select to create a connection to a Shared Network folder?
Ans: A

Ques: State whether True or False.

The Outlook.ost files are used only when you have an Exchange Server account and choose to work offline or use the Cached Exchange Mode
Ans: False

Ques: Which option will you choose to turn on the Reading pane?
Ans: Both a and b

Ques: Which option will you select to digitally sign a macro project?
Ans: All of the above

Ques: Which option will you choose to turn off the Duplicate Detection Feature?
Ans: Both a and b

Ques: Which option allows you to preview the first three lines in unread messages?
Ans: Multiline layout

Ques: State whether True or False.

In the Reading Pane, you can read the content of an item, open attachments, follow a hyperlink and use voting buttons.
Ans: True

Ques: Refer to the given image.
Which tab will you choose to make Outlook the default program for E-mail, Contacts, and Calendar?
Ans:  D

Ques: In which type of files does the Inbox Repair tool(Scanpst.exe) scan or repair errors?
Ans: Both a and b

Ques: Refer to the given image.
When does an attachment appear in the body of the message?
Ans:  When the message format is rich text

Ques: Which of the following options do not add received flagged e-mail messages automatically?
Ans: To-Do Bar

Ques: State whether True or False.

The color of overdue items in Calendar in the Daily Task List cannot be changed as shown in the given picture.
Ans: False

Ques: Which option will you select to turn off the Favorite folders?
Ans: Both a and b

Ques: Refer to the given image.
When do we use 'then by 'option in the list?
Ans: When we need to sort the record on time basis

Ques: Refer to the given image.
Which of the following options display events and appointments in the month?
Ans: B

Ques: Refer to the given image.
Which icon displays that the message is of high importance?
Ans: B

Ques: Refer to the given image.
Which among the following calendar symbols display data conflict in Outlook?
Ans:  B

Ques: State whether True or False.

Standard Outlook forms' customizations can be programmed by using Microsoft Visual Basic Scripting Edition.
Ans: True

Ques: Which of the following options display the RSS Feeds icon in the given image?
Ans: B

Ques: With which extension is a file saved when you export 'Rules'?
Ans: .VCS

Thanks for watching this test Question & Answers. Please don't forget to leave a comment about this post. You can also find some more effective test question & answers, information, techniques, technology news, tutorials, online earning information, recent news, results, job news, job exam results, admission details & another related services on the following sites below. Happy Working!

News For Todays ARSBD oEtab ARSBD-JOBS DesignerTab

UpWork (oDesk) & Elance MS-Access Test Question & Answers

UpWork (oDesk) & Elance MS-Access Test Question & Answers

June 28, 2015 / No Comments

UpWork (oDesk) & Elance MS-Access Test Question & Answers are really very important to pass UpWork & Elance test. You will get top score at this skill test exam. If you found any problem or wrong answer please inform me via contact or comments. We will try to solve it in short. This test is extremely valuable to acquire knowledge of this skill. Lets Start test.

Ques: To ensure a value no greater than 30 is entered into a field you would use:

Ans: A validation rule

Ques: The action of typing a record into a database is:
Ans: Data entry

Ques: Why use a database instead of a spreadsheet?
Ans:  Multiple data from various tables are needed.

Ques:  What is a form?
Ans: An Access object where you can enter, edit or display data from a table or query

Ques: Which query can you delete records?
Ans:  Delete Query

Ques: Can a primary key be used as a non-primary key in another table?
Ans:  Yes

Ques: Microsoft Access does not offer parameterized queries.
Ans: False

Ques: Before you split a database, you should:
Ans: Back up the database file

Ques: True or False: You can import an Excel spreadsheet to an Access table.
Ans:  True

Ques: What would Format("210.6", "#,##0.00") return?
Ans:  210.60

Ques: How to you ensure that a field is filled out properly?
Ans: Use a validation rule.

Ques: What is a data type?
Ans: It determines the kind of values users can store in a field

Ques: What happens when you freeze a column?
Ans: It prevents the column from moving positions

Ques: What is a purpose of a report?
Ans: To represent data in a more aesthetic, professional manner

Ques: What would Format("1267.5", "Currency") return?
Ans: $1,267.50

Ques: True or False: You use an AutoNumber data type when you want unique numeric values to be created automatically by Access when you create a record.
Ans: True

Ques:  Which one of these is not a valid database relationship?
Ans: many-to-pair

Ques: What is a drop down list?
Ans:  A way to have a user select from list of values in a table or form.

Ques:  An Access file can import:
Ans: All of these

Ques: Of these, which can comparison operator symbols be applied to?
Ans:  All of these

Ques:   Of these, what could be the purpose for splitting a database?
Ans:  All of these

Ques: How do you sort data in order?
Ans:  All of these

Ques: What kind of relationships can you do in a database?
Ans:  All of these

Ques: How do you save a file?
Ans:  All of these

Ques: When you press the Tab key, which way does the insertion point go?
Ans:   The adjacent field

Ques:  What is a primary key?
Ans: It uniquely identifies each record in a table.

Ques: True or False: You cannot assign a Macro to a Command Button.
Ans:  False

Ques: What is a caption?
Ans: The label for a field when used on a form.

Ques: On the ribbon with the Window tools, how can you view opened queries, tables, and reports?
Ans: All of these

Ques: Can relationships be between primary keys and non-primary keys?
Ans: Yes

Ques:  Where in an Access window can you search for a specific record?

Ans: 2 of these are correct

Ques: Which of these would be a proper way to type a parameter?
Ans: [Where was this shipped to?]

Ques: Why should you enter sample data in tables after creating them?
Ans: To check for potential data maintenance problems

Ques: Name the object that is linked to a table that is used to enter data?
Ans: Form

Ques: What language is used to extend and automate MS Access?
Ans: Visual Basic for Applications

Ques: Which two objects can a report object be based on?
Ans: Table and Query

Ques:When you use the Max function, you are searching for...
Ans: The largest value in a field

Ques: The Input Mask Wizard is used to....
Ans:  Format data being entered into a table

Ques: What type of query is used to show data but that does not alter data on the table?
Ans: Select

Ques: Where can you find the # of results in a Query?
Ans:  Lower left of the screen

Ques: What are relationships for?
Ans: To ensure referential integrity

Ques: What are the 3 buttons for sorting data?
Ans: Ascending, descending, clear all sorts

Ques: How does changing the appearance of a datasheet affect the underlying table structure?
Ans:  It does not change the structure

Ques: Before deleting a query object in your database you need to check whether any report objects are based on it. How do you do this?
Ans:  Use the Object Dependencies Task Pane

Ques: Choose the correct criteria to enter when prompting a user for the Customer Name in a
Ans: [Enter the Customer Name]
Ques: An Input Mask is:
Ans:

A data pattern which dictates how users can enter data into a field
Ques: Which of these is not a valid aggregate function for a query search?
Ans: Quo

Ques: When you run a query to find records in related tables, Access, by default, uses... an Inner Join
Ans: an Inner Join

Ques:  Can you modify information while viewing a report?
Ans :  No, you can only view information with a report

Ques: The Following statements are all true except:
Ans: You can only have one criterion per line in the design grid

Ques: What does DAO stand for?
Ans: Data Access Object

Ques: What does DAO stand for?
Ans: Data Access Objects

Ques: How do you move to the last record in a table?
Ans: All are correct

Ques: What is an example of a comparison operator symbol?
Ans:  All of these

Ques: You wish to filter data on a report before printing without changing the design of the report. How do you do this?
Ans: In Layout view, select the Home Tab and click Filter, uncheck the Select All check box, and check the values you want to filter on

Ques: What does a group header or group footer do?
Ans:  Displays the field label of grouped data on the top or bottom of a report

Ques: Datasheet views are different from continuous forms in very subtle ways. Which of the following statement is false?
Ans: Datasheet Views cannot have code modules associated with them.

Ques: To adjust the length of fields in a report while displaying data you would use:
Ans:  Layout View

Ques: Which of these can you apply conditional formating to?
Ans: Form

Ques:  To query two tables that are unrelated you:
Ans: Create a junction table which contains fields common to both tables

Ques: You are creating a Macro and you require the SetValue Action, but it does not exist.  What do you do?
Ans: Click the Macro Tools Design Tab and choose "Show all Actions" from the Ribbon

Ques: What is typically displayed on a Relationship Report?
Ans: The current date and database name

Ques: What would StrConv("Tech on the Net", 3) return?
Ans: Tech On The Net

Ques: You need to create a lookup field where more than one option can be chosen.  Where would you do this?
Ans: In the Lookup Wizard check "Allow Multiple Values"

Ques:  In the design view of a make table query the destination table name is displayed:
Ans: In the propery sheet with selection type query properties.

Ques: When you open an Access Form, what is the second event that fires?
Ans: On Load

Ques: Field selectors are located..
Ans: at the top of a table

Ques: Access 2007/2010 theoretically allows how many concurrent users accessing the same .accdb database file?
Ans:  255

Ques: The report header displays on:
Ans:  The first page only

Ques:  Which of the following is not included in the Access Built-In Functions for SQL Aggregate
Ans: Median(«expression»)

Ques: What is the "iif" function named?
Ans: Immediate If

Ques: What does ADO stand for?
Ans: ActiveX Data Objects

Ques: Which of the following Access 2010 macro actions does not require you to select "Show All Actions" in order to use it in Macro Design?
Ans:  RunCode

Ques:  A calculated control is one form that uses an expression to generate the data value for the master key of a table
Ans:  False

Ques: "Yes/No" answers in Access are commonly stored as:
Ans:  0 or -1

Ques: When you move between records on an Access Form, which one of the following events fires?
Ans: On Current

Ques: Which of the following is NOT a type of query in Access?
Ans: CrossSelect

Ques:  What is the maximum size of Microsoft Access 2010 database file?
Ans:  2 GB, minus the space needed for system objects

Ques: When do you use the Lookup Wizard?
Ans:  You want to lookup the value of a field from another table or create a list of values to choose from

Ques: Which of the following helps to study the information in a table and then make changes to streamline the data?
Ans: Table Analyzer Wizard

Ques: In a loop that begins with "Do Until rs.EOF = True", what problem occurs if you omit "rs.movenext"?
Ans:  The code continues executing but Access appears to hang.

Ques:  You require a form control that provides a text box to which a drop-down list is attached.  Users can either type a value directly into the text box or select from the list of choices available. Which control will you choose?
Ans: Combo Box contro

Ques: What would Mid("Alphabet", 3, 10) return?
Ans:  phabet

Ques: Each sales person has many customers.  Each customer can have many orders.  In building a query for how much in sales a salesperson is generating, what kind of relationship will exist between customer and orders?
Ans: One-to-many

Ques:  What would Replace("alphabet", "bet", "hydro") return?
Ans:  alphahydro

Thanks for watching this test Question & Answers. Please don't forget to leave a comment about this post. You can also find some more effective test question & answers, information, techniques, technology news, tutorials, online earning information, recent news, results, job news, job exam results, admission details & another related services on the following sites below. Happy Working!
News For Todays ARSBD oEtab ARSBD-JOBS DesignerTab