oDesk Microsoft Excel 2010 Skill Test Answers

oDesk Microsoft Excel 2010 Skill Test Answers

Question:- If you want to create a citation and fill in the source information later, you should:
Answer:- insert a caption.


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


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

Question:- Sarah receives a company turnover summary in the form of an embedded Excel chart (as shown in the above image) in a Microsoft Word 2010 document from her boss. Her boss wants the chart to be sent over to the Public Relations department with a line in the chart showing the variations in the company's turnover, as well as a prediction for the next 2 years. The turnover values for each year also need to be sent separately in an Excel file. What should Linda do to achieve this in the shortest possible time?
Answer:- Change chart type to a line chart and type all the values into an Excel file.

Question:- You want to add an image as the first character in your paragraph. Which type of text wrapping treats your graphic as if it were a character?
Answer:- Square

Question:- Roger was editing a Word document, when his mobile phone rang. By mistake, some button got clicked on the Word 2010 Ribbon area, so that the document's appearance changed from Image A to Image B. Which of the following options could be the cause?
Answer:- Tables with maximum number of rows and columns was added to the document.

Question:- A particular chart layout can be applied to a chart only if:
Answer:- it is a 2D chart.

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

Question:- Microsoft Word 2010 has enabled ligatures for which of the following fonts?
 Answer:- Open Type fonts

Question:- With which chart type(s) is the "Depth Gridlines" option available?
Answer:- Line chart

Question:- Which of the following is NOT an option under File > Print > Microsoft Document Image Writer?
Answer:- MDI

Question:- I want to use the AutoCaption feature for several elements in my document. What type of file format is NOT available in the AutoCaption dialog box?
Answer:- XLS

Question:- What view must be used when inserting a subdocument?
Answer:- Web Layout

Question:- Josh is creating a collage for his college project. He has an image - Image A - which he wants to show in different color themes so as to represent different moods in the collage (Images B, C and D). How can Josh achieve this in Microsoft Word 2010?
Answer:- By using the Recolor option under Format Picture.

Question:- Which of the following in NOT a type of Section Break?
Answer:- Continuous

Question:- Samantha is given an article to proofread. The article runs into hundreds of pages. She is asked to use hyphens to allow words in the article to break between two lines. There is an option in Microsoft Word 2010 which can be used to achieve this result with a single click. Please identify it.
Answer:- Orientation

Question:- Which of the following options allows you to arrange drawings in your document so they may be moved, kept together, aligned, or formatted more easily?
Answer:- Insert Flowchart

Question:- When you apply a theme to a Microsoft Word 2010 document, all the tables, charts, SmartArt graphics, shapes, and other objects are updated to complement one another.
Answer:- 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?
Answer:- "Allow row to break across pages" is unchecked.

oDesk Windows XP Test Answers 2017

oDesk Windows XP Test Answers 2017

Question:- There is a better method to enable or disable services on your computer than using msconfig and hardware profiles. When using msconfig, you might disable some services that are necessary to boot the system. Which of the following should be used to enable or disable services.
Answer:- Microsoft Management Console (MMC)  


Question:- What is the key combination to Quit a program through Task Manager that is not responding?
Answer:- hift + Alt + Del

Question:- Windows XP tracks whatever files that load during every boot and application launches, and the operating system uses that information to prefetch files into RAM. These prefetch data are parsed into a file named __________ located in the Windows\Prefetch folder on the boot drive. Every three days, a limited defragmentation operation automatically occurs in the background during idle for only those files in that file to further speed up the computer's file access.
Answer:- Defrag.ini

Question:- Accelerator (hot) keys: Several menu commands, such as File, Edit, Table, or Tools, have one underlined letter as shown. The command associated with the underlined character can be Quickly executed if that character is entered on the keyboard immediately after the _____ key is pressed.
Answer:- Alt

Question:- An icon with an arrow in its lower-left corner, which can be clicked for quick access to the object it represents, is a(n):
Answer:- Folder (directory) icon

Question:- A common name given to the bitmapped desktop image (usually a picture) that serves as a background for the entire desktop is:
Answer:- Wallpaper

Question:- Which of the following statements about Windows XP features is/are correct?
Answer:- Windows XP offline files allows you to synchronize your files with your file server.

Question:- Which of the following is/are valid Window's file names?
Answer:- expert-rating

Question:- Which statement(s) about the Recycle Bin is/are correct?
Answer:- The Recycle Bin stores files for one month before permanently deleting them.

Question:- Which of the following statements about the file security levels while browsing is/are correct?
Answer:- All of the above

Question:- Which of the following would be a System Restore feature in Windows XP?
Answer:- It allows you to restore your computer to a previous state in case of a system problem.

Question:- How can you customize Advanced Start menu options in windows XP operating system.
Answer:- Right click on the Taskbar, choose Properties, click on Start Menu, and click the Customize button.

Question:- You can create and edit files using the Windows Notepad. What are the extensions of a file that has been created using Notepad?
Answer:- text

Question:- What happens when you hold down the Windows button key and press the E key?
Answer:- It opens the Windows Explorer.

Question:- You are logged in as an administrator to the computers on your small local network and you want to change the names of those computers and the workgroup so that their names are more informative. One way to change the names would be to:
Answer:- Open the Performance and Maintenance control panel. Select the Computer Name tab and then click Change. Enter the desired name for the computer and click OK.

Question:- The _____________ is a large hidden file where Windows XP finds information about all of the hardware, software, and various settings and user options.
Answer:- Preferences

Question:- Which of the following activities can you accomplish with the Remote Desktop feature in Windows XP?
Answer:- You can view files and documents on your computer's desktop from a coworker's computer.

Question:- The hard-drive utility tool in Windows XP for automatically fixing file system errors or for searching for and attempted recovery of bad sectors is:
Answer:- CheckDisk (CHKDSK)

Question:- By hovering the mouse pointer over the clock, what happens?
Answer:- It will speak out the time through the speaker connected to the computer.

Question:- The left side of the Start menu contains two parts, separated by a thin horizontal line. The Windows XP term for manually inserting a shortcut to one of your chosen applications into the top part of the left side (by using the right-context menu of the application in Windows Explorer) is called:
Answer:- Porting an application to the Start menu.

Question:- Which of the following statements about Windows XP Internet Connection Sharing (ICS) is/are true?
Answer:- Using ICS, a single computer can connect to more than one dial-up connection.

Question:- The older version of the Windows XP Desktop is called the "Windows Classic" look. One way to get the Windows Classic Desktop from the new default Windows XP Desktop is to:
Answer:- In the System control panel, select Properties from the View menu. Select the Desktop tab and click on the Desktop pull-down list and select Windows Classic. Click OK.

Question:- Starting with Windows 95, the File Manager tool for organizing and controlling the files and folders of the computer's storage systems, such as the hard drive(s) and disk drive(s) has been called:
Answer:- Windows Explorer

Question:- Windows XP includes a new type of view for folders that contain graphics files. This folder view is called _________ and displays small images of all the graphics in the folder in the bottom right-hand pane of Windows Explorer and a large image of a selected picture in the top right-hand pane.
Answer:- Filmstrip

Question:- What happens when you choose ClearType for your screen fonts in Windows XP?
Answer:- Only the text in primary colors will be visible.

Question:- Which of the following statements regarding Windows XP user access is/are correct?
Answer:- None of the above

Question:- With Windows XP, the default display resolution is 800x600 in 32-bit true color. With some computers 32-bit video tends to slow down screen redraws. How could you drop the screen depth to 16 bits instead of 32 bits in order to speed up the display in older PCs, especially laptops?
Answer:- In the Display Properties dialog box, on the Settings page, set the Color quality option to Medium (16 bits).

Question:- A new function of Windows XP that allows two or more users in a local network to use only one Internet connection by routing all the Internet traffic through one computer is called __________________.
Answer:- Windows Internet Sharing (WIS)

Question:- Which of the following statements is/are correct regarding the grouping of Windows tabs?
Answer:- There is no option to group tabs in Windows XP.

Question:- Microsoft makes available a tool called the _____________________ for checking computers with a Windows operating system. This tool helps remove infections left by third-party software installed on the computer and displays a report describing the outcome in a log file named mrt.log in the %WINDIR%\debug folder.
Answer:- a.     Microsoft Reliability Tool
c.     Microsoft Windows Antivirus Tool
    d.     Microsoft Recovery Tool


Question:- Windows XP usually retains copies of old drivers when newer versions of them are installed or upated. If the new drivers have problems, the user can return to the previous version. Does this new Windows XP feature work with printer drivers?
Answer:- Yes

Question:- Windows XP has a new user system. Its new user system:
Answer:- a.     Was inherited from Windows 98.
    c.     Was inherited from Windows NT/2000.
    d.     Was not inherited from any prior Windows O/S.


Question:- A new feature introduced in Windows XP that allows another user to log in and use the system without having to log out the previous user and Quit any running applications is known in Windows XP as:
Answer:- Fast user switching

Question:- The Windows XP installs its search function that, by default, has an animated dog character, Rover. Which of the following is/are true?
Answer:- Rover cannot be replaced by another character. It is a permanent feature.

Question:- What does the Desktop Cleanup Wizard do?
Answer:- It removes the desktop wallpaper.

Question:- Windows XP has several command-line utility tools for troubleshooting the computer. Suppose that your computer seems to have a problem with connecting to the Internet. Before reporting your connectivity problems to your ISP, which tool could you use to display the current TCP/IP network configuration values and to refresh the Dynamic Host Configuration Protocol (DHCP) and Domain Name System (DNS) settings?
Answer:- Ipconfig

Question:- Which key combination would you use to flip between open windows?
Answer:- Alt + Shift

Question:- What type of icons are displayed in the system tray?
Answer:- Icons of programs developed by Microsoft.

Question:- Which of the following statements about icons on the desktop is correct?
Answer:- You can rename an icon by right-clicking the mouse button and selecting Rename.

Question:- State whether the following statement is true or false.

With Windows XP, you cannot specify that files with certain file name extensions should always open in the same program.
Answer:- True