Microsoft Excel 2019 Step by Step, First Edition

Index

Numbers

2D maps, 224, 227

3D maps, creating, 422–428, 430

Symbols

‘ (single quotes), using with workbook names, 179

- operator, 82

- operator, 82

/ operator, 82

+ operator, 82

#### error code, 95

% operator, 82

& operator, 82

* operator, 82

^ operator, 82

A

absolute references, 79, 83

actions, undoing and redoing, 59

active cell, 47. See also cells

addition operator, 82

AGGREGATE function, 144, 146–148

Alt key. See keyboard shortcuts

analyzing data. See also business intelligence analysis; data; Data Analysis; Quick Analysis Lens

data tables, 196–200

descriptive statistics, 208–209

Goal Seek, 200–202

Quick Analysis Lens, 190–191

Solver, 202–208

app window

arranging workbook windows, 26–27

customizing, 38

Quick Access toolbar, 28–30

ribbon, ...