odesk test answers 2014 for MS Excel 2007
Question: 01
How would you locate the last 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
d. None of the above
How will you display the Go To dialog box?
a. You will press F4
b. You will press F5
c. You will press F6
d. You will press F7
d. You will press F7
Question: 03
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
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
Question: 04
How will you find cells with data validation?
a. On the Home tab, in the Editing group, click the arrow next to Find & Select, then click Go To Special. Click on Data Validation, and then click All
b. On the View tab, in the Windows group, click Data Validation
c. Both a and b
d. None of the above
c. Both a and b
d. None of the above
Question: 05
How would you select 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’
c. On the Analyze tab, in the Data group, click on ‘Select Entire PivotTable’ option
d. None of the above
b. On the Options tab, in the Actions group, click on Select, and then click ‘Entire PivotTable’
c. On the Analyze tab, in the Data group, click on ‘Select Entire PivotTable’ option
d. None of the above
Question: 06
When ‘a’ or ‘p’ is not typed after the time in Worksheet cells, what does Excel enter the default time as?
a. it displays the prompt box an 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 time as AM.
e. None of the above.
b. it displays an error message.
c. It enters the time as PM.
d. It enters the time as AM.
e. None of the above.
Question: 07
Which keyboard shortcut re-calculates all formulas in all open workbooks, regardless of whether or not they have changed since the last time?
a. CTRL+ALT+F10
b. CTRL+SHIFT+ALT+F9
c. SHIFT+F9
d. None of the above
Right answer is CTRL+ALT+F9
b. CTRL+SHIFT+ALT+F9
c. SHIFT+F9
d. None of the above
Right answer is CTRL+ALT+F9
Question: 08
Which file format is typically used to remove printer corruption?
a. XLS format.
b. HTML format.
c. SYLK format (Symbolic Link format).
d. All of the above.
b. HTML format.
c. SYLK format (Symbolic Link format).
d. All of the above.
Question: 09
Which keyboard shortcut should be used to enter the current time?
a. CTRL+SHIFT+”
b. CTRL+SHIFT+:
c. CTRL+;
d. None of the above
b. CTRL+SHIFT+:
c. CTRL+;
d. None of the above
Question: 10
Which of the following wildcard characters can be used as comparison criteria for Text Filters?
a. ?
b. *
c. ~
d. All of the above
b. *
c. ~
d. All of the above
Question: 11
Which tab should be used to display or hide axes?
a. Data tab
b. Layout tab
b. Layout tab
c. Insert tab
d. View tab
Question:12
Which among the following settings is the default macro setting?
Question:12
Which among the following settings is the default macro setting?
a. Disable all macros without notification
b. Disable all macros except digitally signed macros
c. Disabled all macros with notification
d. Enable all macros
c. Disabled all macros with notification
d. Enable all macros
Question: 13
Which
scoping method should be used to conditionally format a set of fields in
the values area for all levels in the hierarchy of data?
a. Scoping by selection
b. Scoping by corresponding field
c. Scoping by value field
d. All of the above
d. All of the above
Question: 14
Which
Consolidate option would you choose when you want to arrange the data in
all the worksheets in identical order and location?
a. Consolidate by position
b. Consolidate by category
c. Consolidate by formula
d. None of the above
Question: 15
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
d. None of the above
d. None of the above
Question :16
Which of the given methods would you follow to add an alternative text to a picture?
a. Right-click on the picture, click on Size and Properties. Click on the Alt text tab, and then in the alternative text box, enter your text
b. Right-click on the picture, click on Format. Click on the Alt text tab, and then in the alternative text box, enter your text
c. Both a and b
d. None of the above
Question: 17
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 file is .CUE
c. It allows you to keep on working with the PivotTable and PivotChart reports when the server is unavailable
c. It allows you to keep on working with the PivotTable and PivotChart reports when the server is unavailable
Question: 18
Which among the following is not true regarding a calculated column?
a. It uses a single formula that adjusts for each row
b. It automatically expands to include additional rows
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
Question: 19
Which of the following is not true regarding column width?
a. If the column width is set to 0, the column is hidden
b. A column width between 0 to 255 can be specified
c. The default column width is 8.43 characters
d. All of the above are true
Question: 20
Which of the following is not true regarding naming a cell?
a. Names are case sensitive
b. A name can contain up to 255 characters
c. Names can contain uppercase and lowercase letters
d. Some keyboard characters can cause unexpected results if used in cell names
Question: 21
Which of the following methods would you follow to remove subtotals?
a. On the Data tab, in the Outline group, click on Subtotal. The Subtotal dialog box is displayed. Click Remove All
b. On the Data tab, in the Data Tools, select Remove Subtotals
c. Both a and b
d. None of the above
Question: 22
Question: 22
Deleting the PivotChart report automatically deletes the associated PivotTable report.
a. True
b. False
Question : 23
If a SmartArt graphic is converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.
a. True.
b. False .
Question: 24
No data is deleted when an outline is hidden or removed.
a. True
b. False
Question: 25
When you sign the stamp signature line in an Office document, you add both a visible stamp and a digital signature.
a. True
b. False
Question : 26
Question: 25
When you sign the stamp signature line in an Office document, you add both a visible stamp and a digital signature.
a. True
b. False
Question : 26
When a part of a formula is replaced with its calculated value, it cannot be restored.
a. True.
b. false.
Question: 27
a. True.
b. false.
Question: 27
When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.
a. True
b. False
Question: 28
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
d. None of the above
Question: 29
When does the error, as shown in the picture, occur?
a. It occurs when a column is not wide enough
b. It occurs when a negative date is used
c. It occurs when a negative time is used
d. All of the above
Question: 30
a. True
b. False
Question: 28
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
d. None of the above
Question: 29
When does the error, as shown in the picture, occur?
a. It occurs when a column is not wide enough
b. It occurs when a negative date is used
c. It occurs when a negative time is used
d. All of the above
Question: 30
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
c. C
d. D
Question: 31
Which part of the formula displays references in the given picture?
a. A
b. B
c. C
d. D
Question: 32
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)
d. None of the above
Question: 33
What would be the result, when =T(A4) is applied on the given table?
a. The text True is returned
b. The text Rainfall is returned
c. Empty text is returned
d. None of the above
Question:34
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
c. It signifies that the cell contains a macro
d. All of the above
Question: 35
What is the purpose of using the Keep text flat option, as shown in the picture?
a. It prevents the text inside the WordArt from rotating when rotate WordArt is rotated
b. It prevents the text from blurring
c. It moves the WordArt or text backward
d. Both b and c
Question: 36
Refer to the given image. Which line style option should be used to specify the style used for the end of the line?
a. A
b. B
c. C
d. D
Question: 37
Refer to the given image. What is the purpose of the cell denoted as ‘A’ in the worksheet?
a. It selects all the cells in the worksheet
b. It selects a large range of cells in the worksheet
c. It selects non-adjacent cells in the worksheet
d. It selects an entire row in the worksheet
Question: 38
Refer to the given picture. Which option causes the last row in the table to appear and displays the word Total in the leftmost cell?
a. A
b. B
c. C
d. D
Question: 39
Which among the following options displays Legend entries in the given picture?
a. A
b. B
c. C
d. None of the above
Question: 40
Which Chart type is displayed in the given picture?
a. A stock chart
b. A surface chart
c. An XY (Scatter) chart
d. None of the above
a. A
b. B
c. C
d. D
Question: 31
Which part of the formula displays references in the given picture?
a. A
b. B
c. C
d. D
Question: 32
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)
d. None of the above
Question: 33
What would be the result, when =T(A4) is applied on the given table?
a. The text True is returned
b. The text Rainfall is returned
c. Empty text is returned
d. None of the above
Question:34
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
c. It signifies that the cell contains a macro
d. All of the above
Question: 35
What is the purpose of using the Keep text flat option, as shown in the picture?
a. It prevents the text inside the WordArt from rotating when rotate WordArt is rotated
b. It prevents the text from blurring
c. It moves the WordArt or text backward
d. Both b and c
Question: 36
Refer to the given image. Which line style option should be used to specify the style used for the end of the line?
a. A
b. B
c. C
d. D
Question: 37
Refer to the given image. What is the purpose of the cell denoted as ‘A’ in the worksheet?
a. It selects all the cells in the worksheet
b. It selects a large range of cells in the worksheet
c. It selects non-adjacent cells in the worksheet
d. It selects an entire row in the worksheet
Question: 38
Refer to the given picture. Which option causes the last row in the table to appear and displays the word Total in the leftmost cell?
a. A
b. B
c. C
d. D
Question: 39
Which among the following options displays Legend entries in the given picture?
a. A
b. B
c. C
d. None of the above
Question: 40
Which Chart type is displayed in the given picture?
a. A stock chart
b. A surface chart
c. An XY (Scatter) chart
d. None of the above
1. Which among the
following methods would you select when you want to add protection to parts of
a template?
Ans: Go to the Developer tab, click on Properties in the
Controls group and then click any of the Locking options in the Content Control
Properties dialog box.
2. Which of the following is/are true
about phishing?
Ans: All if the above
3. This question is based upon the figure
shown below
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
4. Which among the following charts do not
have axes?
Ans: Doughnut charts
5. Microsoft named two styles that work in
Word 2007 as both character and paragraph types as being ______ styles:
Ans: Linked
6. This question is based upon the figure
shown below
Ans: It ensures that the
text is not obscured by binding.
7. With the help of which view will the
Watermark not be seen?
Ans: Web Layout view
8. This question is based upon the figure shown
below
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.
9. Which among the following is not a Bookmark
option to sort the list of bookmarks in the document?
Ans: Author
10. This question is based upon the
figure shown below
Why is the "Different First
Page" option used in the Page Setup dialog box as shown in the given
picture?
Ans: This option allows you to remove the Page Number from the
first page.
11. 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.
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
12. This question is based upon the
figure shown below
Which of the following types of charts are not
supported by either Lines or Bars, as shown in the picture?
Ans: Area charts
13. Which among the following features
could be used to create a connection to a Shared Network folder?
Ans: Map Network Drive
14. 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.
15. 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.
16. 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.
17. 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...
18. 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.
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
19. Which among the following options is
the reason of text deletion at the insertion point when you type a document?
Ans: The "overtype mode" is turned on in Word
options.
20. 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.
21. This question is based upon the
figure shown below
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: Restart Each Page
22. Which keyboard shortcut could be used
to switch to Draft View?
Ans: ALT+CTRL+N
23. State whether true or false:
The "Add Assistant" shape option in a SmartArt graphic is available only if an organization chart layout is chosen.
The "Add Assistant" shape option in a SmartArt graphic is available only if an organization chart layout is chosen.
Ans: True
24. Which view(s) could be used to view the
Equation placeholders in the Document Views group?
Ans: All of the above
25. 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.
Any changes that are saved to "Normal.dotm" will be applied to the documents that you create in the future.
Ans: True
26. 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.
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
27. 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.
28. Which of the following line-spacing
options sets fixed line spacing that Word does not adjust?
Ans: Doubled
29. How will you change the author name in an existing document?
Ans: All of the above
30. 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.
Microsoft Office programs store some additional information within the digital signature automatically that might not be visible in the current view document.
Ans: True
31. Which among the following options
could be used to turn off the Office Clipboard?
Ans: All of the above
32. 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.
33. Which among the following is an invalid
character to include in a file name?
Ans: All of the above
34. State whether true or false:
Gridlines do not print when a document is printed.
Gridlines do not print when a document is printed.
Ans: True
35. Which keyboard shortcut inserts a
hyperlink?
Ans: CTRL+K
36. Which among the following wildcards
should be used to select any single character?
Ans: ?
37. This question is based upon the
figure shown below
Refer to the given image. Which option
should be selected to convert a professionally formatted equation into an
equation on one line?
Ans: C
38. Which of the following is not a
Content Control?
Ans: Chart
39. This question is based upon the
figure shown below
Ans: Numbering
40. 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.
41. 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.
42.
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
43. State whether true or false:
ASCII-formatted text contains no formatting information such as bold, italic, or fonts.
ASCII-formatted text contains no formatting information such as bold, italic, or fonts.
Ans: True
44. State whether true or false:
New text animation effects can be applied in Microsoft Word 2007.
New text animation effects can be applied in Microsoft Word 2007.
Ans: False
45. 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.
46. Which of the following options repeats a
table heading on subsequent pages?
Ans: Repeat Header Rows
47. Which keyboard shortcut could be used
to check the spelling of a text file?
Ans: F7
48. Which among the following is not true
regarding the use of a pie chart?
Ans: A pie chart should be used when there are more than seven
categories.
49. This question is based upon the
figure shown below
Refer to
the given picture. Which of the following options turns off Enhanced ScreenTips
but keeps the ScreenTips still visible?
Ans: B
50. 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: False
51. This question is based upon the
figure shown below
What is the maximum number of columns that can
be created in the Columns dialog box as shown in the picture?
Ans: 13
52. This question is based upon the
figure shown below
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.
53. 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.
(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)
54. This question is based upon the
figure shown below
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.
55. 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
56. What steps should be followed to replace a
shape with other shape?
Ans: Select the shape to be changed. Select the Format tab; use
the "Change Shape" button in the Shape Styles group.
57. 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: False
58. This question is based upon the
figure shown below
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.
59. Which feature(s) should be selected
in order to find and remove hidden data and personal information in Office
documents?
Ans: Document Inspector
60. Which keyboard shortcut is used to make
the text size smaller?
Ans: CTRL+SHIFT+<
61. Which among the following options
will you use to add a command to the Quick Access Toolbar?
Ans: All of the above
62. Which option(s) should you select to
remove a chart or axis title from a chart?
Ans: To remove an axis title, select the Layout tab. In the
Labels group, click on Axis Titles, click the type of axis title, and then
click None.
63. Which among the following macro
settings is meant for developers only?
Ans: Trust access to the VBA project object model.
64. State whether true or false:
A building block can be added to as many
galleries as you want.
Ans: True
65. Which of the following is/are true
about phishing?
Ans: It is an online fraud technique used by criminals to lure
users into disclosing their personal in
How can a chart be modified?
-By modifying a legend
-By modifying the display of chart axes
-By modifying titles and data labels
-All of the above
This question is based upon the figure shown belowWhen does the triangle appear in the top-left corner of the cell, as shown in the picture?
-When the cell contains hidden information
-When the cell contains the Time function
-When there is an error in the formula
-None of the above
Which database function estimates variance based on a sample from selected database entries?
-DSTDEV
-DSUM
-DVAR
-DVARP
Which chart displays axes but cannot display axis titles?
-Radar chart
-Doughnut chart
-Pie chart
-All of the above
How will you reverse the direction of a SmartArt graphic?
-Right-click on the SmartArt graphic, select Reverse
-Under SmartArt Tools, on the Format tab, in the Arrange group, select Reverse
-Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left
-All of the above
Which database function estimates variance based on a sample from selected database entries?
-DSTDEV
-DSUM
-DVAR
-DVARP
jjjjj
How would you locate the last cell on a worksheet?
-Click anywhere in the worksheet, and then press CTRL+HOME
-Click anywhere in the worksheet, and then press CTRL+INSERT
-Click anywhere in the worksheet, and then press CTRL+END
-None of the above
Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
-Consolidate by position
-Consolidate by category
-Consolidate by formula
-None of the above
Which of the following options is not available on the Status bar?
-Cell mode
-Selection mode
-End mode
-Start mode
-By modifying a legend
-By modifying the display of chart axes
-By modifying titles and data labels
-All of the above
This question is based upon the figure shown belowWhen does the triangle appear in the top-left corner of the cell, as shown in the picture?
-When the cell contains hidden information
-When the cell contains the Time function
-When there is an error in the formula
-None of the above
Which database function estimates variance based on a sample from selected database entries?
-DSTDEV
-DSUM
-DVAR
-DVARP
Which chart displays axes but cannot display axis titles?
-Radar chart
-Doughnut chart
-Pie chart
-All of the above
How will you reverse the direction of a SmartArt graphic?
-Right-click on the SmartArt graphic, select Reverse
-Under SmartArt Tools, on the Format tab, in the Arrange group, select Reverse
-Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left
-All of the above
Which database function estimates variance based on a sample from selected database entries?
-DSTDEV
-DSUM
-DVAR
-DVARP
jjjjj
How would you locate the last cell on a worksheet?
-Click anywhere in the worksheet, and then press CTRL+HOME
-Click anywhere in the worksheet, and then press CTRL+INSERT
-Click anywhere in the worksheet, and then press CTRL+END
-None of the above
Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
-Consolidate by position
-Consolidate by category
-Consolidate by formula
-None of the above
Which of the following options is not available on the Status bar?
-Cell mode
-Selection mode
-End mode
-Start mode