Admin Table of Contents
Excel Module 3
| Question | Answer |
|---|---|
| Charts can either be embedded in a worksheet or placed in a separate ____. | chart sheet |
| Which of the following is the path to the Zoom button? | (VIEW tab l Zoom group) |
| When working with a large worksheet, you can split the window into ____ panes | two or four |
Which of the following is the path to the view side by side button?
To enable View Side by Side in Word, first click the “View” tab in the Ribbon. Then click the “View Side by Side” button in the “Window” button group. To disable View Side by Side in Word, click the “View Side by Side” button again. Word only lets you view two documents in side by side view.
Which of the following is the path to the Cell Styles button?
Excel Module 1 & 2
| Question | Answer |
|---|---|
| Which of the following is the Ribbon path to the cell Styles button? | (HOME tab/ Styles group) |
| You can use the ________ to check which cells are referenced in the formula assigned to the active cell. | Range Finder |
36 Cards in this Set
| A worksheet’s row-and-column structure can be used to organize and store a _____. | table |
|---|---|
| Which of the following is the path to the Sort & Filter button? | (Home tab | Editing group) |
| The process of a filtering activity based on one or more filter criteria is called a _____. | query |
Which of the following keys moves the insertion point?
Moving the Insertion Point
| Key | Moves the insertion point … |
|---|---|
| Home | To the start of the current line |
| End | To the end of the current line |
| Ctrl+Home | To the start of the document |
| Ctrl+End | To the end of the document |
How do I view side by side without synchronous scrolling?
On the View tab, in the Window group, click View Side by Side. in the Window group on the View tab. If you don’t see Synchronous Scrolling, click Window on the View tab, and then click Synchronous Scrolling. in the Window group on the View tab.
How do I turn on view side by side?
View two worksheets in the same workbook side by side
- On the View tab, in the Window group, click New Window.
- On the View tab, in the Window group, click View Side by Side .
- In each workbook window, click the sheet that you want to compare.
- To scroll both worksheets at the same time, click Synchronous Scrolling.
Which of the following is the path to the What If Analysis button?
Navigate to the following path to reach to this tool: Data tab > Forecast Tool > What-If Analysis button > Data Table.
What are the steps to sort and filter the data?
Select a cell in the column you want to sort (a column with numbers). Click the Sort & Filter command in the Editing group on the Home tab. Select From Smallest to Largest. Now the information is organized from the smallest to largest amount.
Which icon would you select to sort and filter records?
Filtering Data With filtered data, you can then copy, format, print, etc., your data, without having to sort or move it first. To use a filter, Go to the Home ribbon, click the arrow below the Sort & Filtering icon in the Editing group and choose Filter.