Map Topology enables and disables topological editing for visible layers in the current map. Status reports editing permissions and source information for layers in your workspace. To learn more, see Automatic edit sessions. Saving or discarding your edits automatically stops the edit session. An edit session automatically starts when you modify existing data or create new data. There are no buttons to start or stop an edit session. In the Manage Edits group, you can toggle topological editing on or off, view editing permissions for layers in your workspace, and change project and application settings for editing. To learn more, see Copy and paste using the clipboard. In the Clipboard group, Cut, Copy, Paste, and Paste Special copy features to the clipboard and paste them to the same layer or a different layer. Ensure the filtered data output begins in the range A30:F30.You can right-click a button on the ribbon and add it to the Quick Access Toolbar. 2) Perform an Advanced Filter displaying only Sales Reps from the Mid-West region. Press ENTER (or CTRL+ENTER or TAB or click the Enter button to the left of the Formula Bar). In the cell (or in the Formula bar), t ype Sales Rep (or sales rep or Sales rep or SALES REP). Double-click (or press F2 or BACKSPACE) (optional). Use ARROW keys to select cell D26 (or c lick in the Name box, type d26 (or D26), and press ENTER), if necessary.

In the cell (or in the Formula bar), type Mid-West (or mid-west or MID-WEST or Mid-west). Use ARROW keys to select cell C26 (or click in the Name box, type c26 (or C26), and press ENTER). In cell D26, type Sales Rep, and then press ENTER. Excel Chapter 7: Simulation Exam Section: CGS1515_110_0570_Spring_2020_Ma Somaiya,Akhil Submitted: 8:21:08 PM Grade: 8.3% Questions Attempted: 2/12 Submission No: 1/1 Time Taken:00:08(hh:mm) 35 1) Enter Advanced Filter Criteria in cells C26 and D26 using the criteria Mid-West and Sales Rep.

Clipboard dialog box launcher.