Question

1. Excel 2010 allows you to choose an image as your worksheet background

a. True

b. False

2. When do you delete a cell or a range of cells, wich of the following is not an option in the delete dialog box?

a. Enrtire row

b. Entire column

c. Shift cells up

d. Shift cells down

e. Shift cells left

3. PivotTablbe automatically refreshes its contents when the source data changes

a. True

b. False

4. Normal Excel 2010 workbooks (* .xlsx) cannot contain macros

a. True

b, False

5. Which of the following components appears in Full Screen view?

a. Ribbon Tabs

b. Ribbon groups

c. sheets bars

d. Status bar

e. Help bar

6. In an Excel workbook with a hyperlink in cell B4 that points an external document, you want to selecet the cell and make its font larger by 2 points without actually opening the external document. How can you do this without using the keyboard or selecting multiple cells?

a. Click on cell B4 while holding down the shift key.

b. Click on cell B4 while holding down the ctrl key

c. Click on cell B4 while holding down the alt key

d. Right click on cell B4, then left click on the same cell

e. none of the above

7. If you save a file from Microsoft Excel 2010 in the OpenDocument Spreadsheet format (.ods), none of the 3D picture options in use will be saved correctly.

a. True

b. False

8. How does Excel 2010 behave by defeaut when String type data in cell grows larger than the cell width?

a. A new text automatically wraps to next line

b. Excel doesn't allown any more typing in that cell

c. The text that doesn't fit within the cell width is always hidden.

d. The text that doesn't fit within in the cell width is hidden if the cell to right contains data. Otherwise, it displays all of the text, as long as the cells to the right are empty.

e. The text doesn't fit within the cell width is hidden and ellipsis ( three dots) is shown at the end of the text in that cell, to indicate that there's more text than is currently visible.

Answer 1

1. True - we can choose an image as your worksheet background in Microsoft 2010
2. Option D - Shift cells down - There is no such option for cell deletion
3. False - Since its created by using Pivot Cache it does not update automatically when source data changes
4. True - Workbook containing macros should be saved with '.xlsm' extension.
5. Ribbon Tabs
6. Click on cell B4 while holding down the ctrl key - While using this key we will give the popover, where we can select format cells and increase font size
7. True - This is due to different features and formatting options
8. Answer is Option D: The text that doesn't fit within in the cell width is hidden if the cell to right contains data. Otherwise, it displays all of the text, as long as the cells to the right are empty.