COMPSCI 1BA3 Chapter Notes -Lookup Table, Dialog Box, Pivot Table
Document Summary
Session 1. 1: two types of sheets used in a workbook- chart sheets and worksheets. Page layout view shows the layout of the worksheet as it appears on a page. Break preview shows the page breaks within the worksheet. Session 5. 1: what"s the purpose of the freeze pane panel- to keep, or freeze, rows and columns so that they don"t scroll out of view as you move around the worksheet. If we order data from most recent purchase to oldest, what order did we sort in- descending (newest to oldest) Total row: how do you only display a list of marketing majors with a gpa of 3. 0 or up- click the. Major filter arrow, and then check only the marketing check box. Click the gpa filter arrow, point to number filters, click greater than or equal to, and then enter the value.