facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Working with Multiple Worksheets Excel Test

Excel 2010 - Worksheets
Free Online Microsoft Excel Test

* Create and Delete Worksheets
* Copy and Move Worksheets
* Format Multiple Worksheets Simultaneously
* Calculate Formulas Across Worksheets

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Working with Multiple Worksheets Excel Test

Question 1 - Excel Test - Working with Multiple Worksheets

1) Study the screenshot above.  How would you go about renaming the third worksheet tab currently labelled Sheet3 (circled in yellow)?

a) Left-click the tab and type the new name directly on the worksheet tab.
b) Right-click the tab and type the new name directly on the worksheet tab.
c) Right-click the tab and select Rename from the menu list.  Type the new name on the worksheet tab.
d) All of the above options are methods for renaming a worksheet tab.


2) How do you go about inserting additional worksheets into a workbook?
a) Click on the Insert Worksheet tab located to the right of the last worksheet tab in a workbook.
b) Press Shift+F11 on your keyboard to insert a new worksheet.
c) Under the Home tab in the Cells group, click on Insert and select Insert Sheet from the list.
d) All of the methods listed above are ways of inserting new sheets into a workbook.

Question 3 - Excel Test - Working with Multiple Worksheets
3) Study the screenshot above.  How would you go about deleting the worksheet above named Address?
a) Right-click the worksheet tab named Address and select Delete from the menu list.
b) Left-click the worksheet tab named Address and press Delete on your keyboard.
c) Left-click and drag the worksheet tab named Address out of the Excel window to delete it.
d) All of the options listed above are valid methods for deleting a worksheet in Excel.

4) How do you change the color of worksheet tabs?
a) It is not possible to change the color of worksheet tabs.
b) Select the worksheet tab by left-clicking it and then select a border shading color from the Font group under the Home tab.
c) Right-click the worksheet tab, go to Tab Color on the menu list and select a color.
d) Use the Format Painter in the Clipboard group under the Home tab to apply color to worksheet tabs.


5) Study the screenshot below.  Which of the formulas listed below do you think will accurately SUM the totals from the January, February, March worksheets above for each employee when inserted into the selected cell in the Salary Totals worksheet?

a) The formula: =SUM(January!C10,February!C10,March!C10) will calculate across all three worksheets.
b) The formula:  =SUM(January:C10,February:C10,March:C10) will calculate across all three worksheets.
c) The formula:  =SUM(C10,C10,C10) will calculate across all three worksheets.
d) The formula:  =SUM(January,February,March) will calculate across all three worksheets.
Question 5 - Excel Test - Working with Multiple Worksheets

6) James wishes to reformat 12 worksheets he has created for the months of the year by changing the font size for the top row labels of all the worksheets.  Which of the following is the quickest way for him to do this?
a) Apply the required formatting to the first sheet then use the Format Painter to replicate the formatting onto the other sheets.
b) Copy the row that has been reformatted on the first sheet over the same row on the other worksheets.
c) Select all the worksheets and then make the changes to one of the worksheets to have it change on all of them.
d) All of the above options are equally quick.

7) What happens when you hold down the Ctrl key and then click and drag a selected worksheet to a different position in the Worksheet tab area?
a) Doing the above will move the worksheet to a different location.
b) Doing the above will have no effect whatsoever.
c) Doing the above will allow you to rename the selected tab.
d) Doing the above will create a copy of the selected worksheet.


8) What will happen if you have two workbooks open simultaneously and you click and drag a worksheet tab from one workbook to another workbook?
a) Nothing will happen, this is not possible.
b) You will get an error message stating this is an illegal procedure.
c) The worksheet will be copied to the other workbook.
d) The worksheet will be moved to the other workbook.


Question 9 - Excel Test - Working with Multiple Worksheets
9) Study the screenshot above.  The February worksheet is the selected sheet.  What will happen if the OK button is pushed?
a) The February worksheet will be inserted ahead of the April worksheet.
b) The February worksheet will replace the April worksheet.
c) The February worksheet will be inserted directly after the April worksheet.
d) A copy of the April worksheet will be created.

10) What is the purpose of the Consolidate function in Excel?
a) It allows you to apply formatting consistently across multiple worksheets.
b) It allows you to perform calculations across multiple worksheets.
c) It allows you to check the formulas entered across multiple worksheets and list any formula errors.
d) None of the above options are correct.