Earn way & Many Free Software Here: Upwork MS Excel 2007 Test Answers 2015

Thursday 16 July 2015

Upwork MS Excel 2007 Test Answers 2015

Upwork MS Excel 2007 Test Answers 2015
1. Questions: This question is based upon the figure show below ?


Refer to the given image. What will be result if the formula =B3&’’, “&A3 I table ?
a.     It will display Nancy Davolio
b.     It will display fuller Andrew
c.      It will display fuller  Andrew (Answer)
d.     Both b and c.
2. Questions: Which chart displays axes but cannot display axis titles ?
a.     Radar chart
b.     Doughnut chart
c.      Pie chart
d.     all of the above (answer)
3. Questions: Which of the following options would you choose to clear a PivotChart report ?
a.     On the Analyze tab, in the Data group, click on clear and then click “clear All”. (answer)
b.     On the Analyze tab, in the Actions  group, click on clear and then click “clear All”
c.      Both a and b
d.     None of the above.
4. Questions: How can a chart be modified ?
a.     By modifying a legend
b.    By modifying the display of chart axes. (Answer)
c.      By modifying titles and data labels
d.     All of the above
5. Questions: which method will you use to update table data from a Sharepoint list?
a.     On the data tab, in the data tools group, click refresh
b.     On the view tab, in the show/hide group, click refresh
c.      On the design tab, in the External data group, click refresh. (answer)
d.     None of the above
6. Questions: which of the following is not true regarding naming a cell ?
a.     Names are case sensitive(answer)
b.     A name can contain up to 255 character
c.      Names can contains uppercase and lowercase letters
d.     Some keyboard characters can unexpected results if used in cell names
7. Questions: which among the following settings is the default macro setting ?
a.     Disable all micro without notification
b.     Disable all micro except digitally signed macros
c.      Disable all micro with notification (Answer)
d.     Enable all macros
8. Questions: How would you selected an entire PivotTable report ?
a.     On the home tab, in the Editing group, select the Entire PivotTable option
b.    On the options tab, in the actions group, click on select and then click Entire PivotTable (Answer)
c.      On the Analyze tab, in the data group, click on the select Entire PivotTable option
d.     None of the above
9. Questions: which keyboard shortcut should be used to enter the current time in a cell in an excel sheet using a QWERIY computer keyboard ?
a.     CTRL+SHIFT+"
b.    CTRL+SHIFT+ (Answer)
c.      CTRL+;
d.     None of the above
10. Questions: which of the following is not true about the Watch Window ?
a.      The Watch Window makes it convenient to inspect, audit, or confirm formula calculations
b.     When cells are not visible on the worksheet, those cells and their formulae can be seen in the Watch Window
c.      There can be two Watch Windows per cell (Answere)
11. Questions: when ‘a’or‘p’ is not typed after time in worksheet cells, what does Excel enter the default time as ?
a.     It displays the prompt box and asks the user to type ‘a’ or ‘p’
b.     It displays an error message
c.      It enters the time as PM
d.    It enters the times as AM (Answer)
e.      None of the above
This question is based upon the figure show below
 
12. Questions: What does the red icon indicate, as shown in the given picture ?
a.     It tells the user that macro is enabled
b.    It tells the user that the document contains Signatures (Answer)
c.      It tells the user that macro is disable
d.     None of the  above.
13. Questions: State whether true or false
A macro project can be digitally signed
a.     True (Answer)
b.     false
14. Questions: State whether true of false

When you freeze panes you select specific rows or column that remain visible when scrolling in the worksheet .
a.     True (Answer)
b.     False
15. Questions: This question is based upon the figure show below
 What is the significance of the red symbol at the top right corner of the cell, as shown in the picture ?
a.     It signifies that the cell contains a formula
b.    It signifies that the cell contains a comment (Answer)
c.      It signifies that the cell contains a macro
d.     All of the above
16. Questions: Which among the following is not true regarding a calculated column
a.     It user a single formula that adjusts for each row
b.    It automatically ally expends to include additional rows (Answer)
c.      A formula is required to be entered only once in a calculated column
d.     Additional formulae cannot be entered in  a calculated column as exceptions
17. Questions: Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area ?
a.     By selection
b.     By corresponding field
e.      By value field (Answer)
c.      By number field
18. Questions: Which lookup function should be used when the comparison values are located in a column to the left of the data that is to be found ?
a.     HLOOKUP
b.     VLOOKUP (Answer)
c.      TRANSPOSE
d.     NONE OF THE ABOVE
19. Questions: How would you locate the last filled cell on a worksheet ?
a.     Click anywhere in the worksheet, and then press CTRL+HOME
b.     Click anywhere in the worksheet, and then press CTRL+INSERT
c.      Click anywhere in the worksheet, and then press CTRL+END (Answer)
d.     None Of The Above
20. Questions: This question is based upon the figure show below ?
Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.
a.     A
b.     B (Answer)
c.      C
d.     D
21.Questions: Which of the following is incorrect regarding “Hyphenation Zone ?”
a.     The hyphenation zone is the maximum amount of space that Word 2007 allows between a word and the right margin without hyphenating the word.
b.    The hyphenation zone cannot be changed to make it narrower. (Answer)
c.      The number of hyphens can be reduced by making the hyphenation zone wider.
d.     None of the above
22. Questions: State whether true or false
The “Add Assistant” shape option in a SmartArt graphic is available only if an organization chart layout is chosen.
a.     True (Answer)
b.     False
23. Questions: Which among the following is NOT true about content controls
a.     They are individual controls that can be used in templates, forms, and documents.
b.     They can be reused.
c.      Customized content controls cannot be distributed. (Answer)
24. Questions: Unlike the other types of styles (paragraph, character, linked, and table), predefined list styles are available when you first create a document in Word 2007 .
a.     True (Answer)
b.     False
25. Questions: Why is the “Different first Page” option used in the Page setup dialog box as show in the given picture ?
a.     This option allows you to remove the Page Breaks from the first page.
b.     This option allows you to remove the Page Number from the first page.
c.      This option allows you to remove the Section Breaks from the first page.
d.     All of the above
26. Questions: When does the triangle appear in the top-left corner of the cell, as shown in the picture ?
a.     When the cell contains hidden information
b.     When the cell contains the time function
c.      When there is an error in the formula (answer)
d.     None of the above 
27. Questions: which view(s) could  used to view the Equation placeholders in the document Views group ?
a.     Print Layout view
b.     Web Layout view
c.      Draft view
d.    All of the above (answer)
28. Questions: which among the following is a keyboard shortcut to cut a table ?
a.     CTRL+
b.     CTRL+V
c.      CTRL+C
d.    CTRL+Z (Answer)
29. Questions: This question is based upon the figure show below ?
As show in the image, the checkbook ‘Create links to source data’ has been selected. Which of the following statements is correct regarding this ?

a.     This option does not let you change the consolidation
b.     This option does not let you create the consolidation
c.      Both a and b
d.    None of the above (Answer)
30. Questions: State whether true or false
When the table headers are turned off ,the table header Autofilters and all other applied filters are removed from the table.
a.     True (Answer)
b.     false
31. Questions: how would you assign a Macro to a graphic ?
a.     On the Developer tab, in the Controls group, select Macro name
b.     On the View tab, click on Macros and then click 'Assign Macro' on the shortcut menu. In the Macro name box, click on the macro that you want to assign
c.      On a worksheet, right-click on the graphic, then click 'Assign Macro'" on the shortcut menu. In the Macro name box, click on the macro that you want to assign
d.    All of the above (Answer)
32. Questions: This question is based upon the figure show below ?
Which chart type is displayed in the given picture.
a.      A stock chart
b.    A surface chart (Answer)
c.      An XY (Scatter) chart
d.     None of the above
33. Questions: Which of the following is not true about an offline cube file ?
a.     It stores data in the form of an OLAP cube
b.    The file format for an offline cube files is CUE (Answer)
c.       It allows you to keep on working with the PivotTable and PivotChart reports when the server is unavailable
34. Questions: This question is based upon the figure show below ?
 Refer to the given image. Which formula should be written on the given table to display “Nancy Davolio” ?
a.      =UPPER(A2)
b.     =LOWER(A2)
c.      =PROPER(A2) (Answer)
d.     None of the above
35. Questions: which of the following is not a valid file extension in which an Excel file can be saved ?
a.     XLSB
b.      XLSM
c.      PXL
d.    All of the above are valid (Answer)
36. Questions: This question is based upon the figure show below
Which of the following options should be used to create a connection to a shared network folder, as shown in the picture ?
a.     A (answer)
b.     B
c.      C
d.     D
37. Questions:How should black cells be inserted on a worksheet ?
a.      Select the cell or the range of cells. Then on the Home tab, in the Cells group, click 'Insert Cells'
b.     Select the cell or the range of cells. Then right-click on the selected cells and click on Insert in the shortcut menu
c.      Both a and b ((answer)
d.     None of the above
38. Questions:Which of the following methods would you follow to remove subtotals ?
a.     On the data tab, in the outline click on subtotal dialog box is displayed click remove all. (Answer)
b.     On the data tab, in the data tools. Select removes subtotals
c.      Both a and b
d.     None of the above
39. Questions: Which type of additional information is stored within the digital signature ?
a.     Data information
b.     Time information
c.      The office version number of the program in which the files was created
d.     All of the above (Answer)
40. Questions: Which of the following wildcard characters can be used as comparisons criteria for Text Filters ?
a.     A.?
b.     B.*
c.      C.-
d.     All of the above (Answer)

1 comment:

  1. Need SEO, Online Money Making & Technological Forum.
    Visit http://linkkl.com.
    http://LinkkL.CoM is free a SEO, Online Money Making & Technological Forum. Asked your question, get answer & share your idea.

    ReplyDelete