facebook twitter pinterest google plus Youtube
www.TestsTestsTests.com

www.TestsTestsTests.com

Window and Zoom Options in Excel 2016 Test
Excel 2016 Training - Getting Started in Excel 2016
Free Online Microsoft Excel Test

* Get a better look by zooming in and out of a worksheet
* View different parts of the same workbook at the same time
* How to find functions on the Ribbon
* Freeze rows or columns so that they remain visible when you scroll

10 Question Multiple Choice Quiz with Answers
and Answer Explanations

Window and Zoom Options in Excel 2016 Test


1) Which of the following zoom values can you NOT set in Microsoft Excel?
a) 75% magnification
b) 200% magnification
c) 300% magnification
d) -10% magnification

2) Which of the following is a quick and easy way to zoom in and out of a worksheet?
a) Hold down the Alt button on your keyboard and press the Up and Down arrows to zoom in and out of the worksheet.
b) Click on the Wrap Text button under the Home tab on the Ribbon and select Wrap Zoom In or Wrap Zoom Out.
c) Hold down the Ctrl key on your keyboard and use the mouse scrolling wheel to zoom in and out of the worksheet.
d) Hold down the Shift key on your keyboard and press the Up and Down arrows to zoom in and out.


3) Sally is working on two worksheets in the SAME workbook and must continuously move between the two worksheets by clicking on the individual worksheet tabs. Which of the following do you think will help Sally view and edit both worksheets at the same time WITHOUT saving two separate copies?
a) Sally can use the New Window function to open another instance of the same workbook, allowing her to view and edit both worksheets at the same time.
b) Sally can use the View Side by Side option to open another instance of the same workbook, allowing her view and edit both worksheets at the same time.
c) Sally can use the Duplicate Slide option to instantly make a copy of the worksheet, allowing her to view and edit both worksheets at the same time.
d) All the options listed above are correct.


4) The Excel function that allows you to keep rows or columns visible as you scroll through the worksheet is called:
a) Keep Rows and/or Columns With Next.
b) Save Selection, Save First Row, Save First Column.
c) Freeze Panes, Freeze First Row, Freeze First Column.
d) Keep Row Visible, Keep Column Visible, View Labels.


Question 5 - Window and Zoom Options in Excel 2016 Test
5) Study the screenshot above. Which rows and/or columns will remain in view when scrolling through the worksheet if the Freeze Panes option is activated with the cell outlined in orange (B2) selected?
a) Row 2 labels will remain visible when scrolling down through the worksheet.
b) Row 2 and Column B labels will remain visible when scrolling down and to the right in the worksheet.
c) Cell B2 will remain visible when scrolling down and to the right of the worksheet.
d) Row 1 and Column A labels will remain visible when scrolling down and to the right in the worksheet.


6) What does the New Window function do?

a) It opens another instance of the active workbook. It is a view only and does not represent two copies of the same workbook.
b) It opens a new Excel workbook.
c) It arranges two different Excel workbooks side by side.
d) It saves a new copy of the active workbook.


7) What does the Arrange All function do?

a) It rearranges all the rows and/or columns that have Freeze Pane applied to them.
b) It arranges all your open worksheets in alphabetical order.
c) It stacks all the open windows so that they are all visible on your screen.
d) None of the options listed above are correct.


Question 8 - Window and Zoom Options in Excel 2016 Test
8) Study the screenshot above. Do you recognize the button outlined in orange? Hint: it is visible when two workbooks are viewed side by side. What is it called?
a) It is the View Side by Side button which allows you to view two different workbooks side by side on your screen.
b) It is the Synchronous Scrolling button which allows you to scroll through two worksheets, line by line.
c) It is the Zoom function which allows you to zoom in and out of your active worksheet.
d) It is the Hide Window function which allows you to hide one of the open workbooks on your screen.


9) Where on the Excel Ribbon will you find the Freeze Panes option?
a) Under the View tab on the Ribbon in the Window group.
b) Under the Insert tab on the Ribbon in the Display group.
c) Under the Formulas tab on the Ribbon in the Function Library group.
d) None of the options listed above are correct.


10) Sally used the New Window option to open another instance of a workbook she is working on. If she makes changes to one window view of the workbook, how can she get these changes to reflect in the second window view of the same workbook?
a) She must amend both open instances of the workbook separately and then save them as copies of the original.
b) She must ensure she makes the same changes manually to both instances of the workbook by using copy and paste functions.
c) She can click Merge Workbooks to ensure the changes are carried to both instances of the workbook.
d) She doesn’t have to do anything. New Window opens another instance of the same workbook and any changes made in one window will reflect in the other window of the same workbook.