ODESK\ ELANCE MS EXCEL 2007 TEST
a. Right-click the picture, click Size and Properties.Click the Alt Text tab, and then in the Alternative text box, enter your text.
Q11: Case-sensitive sorting of text in Excel2007 can be performed.
Q:20 Deleting the PivotChart report automatically deletes the associated PivotTable report.
Q32: When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.
Q33: If a SmartArt graphic is converted to individual shapes, it is not possible to convert them back to the SmartArt graphic
Q34: Which of the following operators is not a type of calculation operator?
Q36: Which Consolidate option would you choose when you want to arrange data in all the worksheets in identical order and location?
Q38: Which option would you choose to display a list of formula used in the current PivotTable report?
Q40: When does the error, as shown in the picture, occur?
Q41: Refer to the given, What is the purpose of the cell denoted as 'A' in the worksheet?
a. It selects all the cells in the worksheet.
Q42. Refer to the given image, which formula should be written on the given table to display "Nancy Davolio"?
Q43: How would you assign a Macro to a graphic
c. On the 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.
Q44: No data is deleted when an outline is hidden or removed.
Q45: Refer to the given image, which of the following Fill options should be used to add color and transparency to a shape?
a. A (No fill)
Q46: Which among the following settings is the default macro setting?
c. Disable all macros with notification.
Q47: Which type of additional information is stored within the digital signature?
d. All of the above.
Q48: When 'a' or 'p' is not typed after the time in Worksheet cells, what does Excel enter the default time as?
d. It enters the time as AM.
Q46: Which of the following is not a valid file extension in which an Excel file can be saved?
Q47: When would the data validation command be unavailable on the data tab?
d. All of the above.