Excel 2016: Advanced Formulas &
Functions
What's the command for doubling the column width of every cell with an equation?
correct answers Ctrl + ~ (tilda)
How does a user highlight all cells with formulas? correct answers Select a single cell /
Home / Find & Select / Formulas
How does a user highlight all cells with constant numbers? correct answers Select a
single cell / Home / Find & Select / Go To Special
How does a user reveal if/what other cells will be affected before altering the value in a
cell? correct answers Formulas / Trace Dependents or Trace Precedents (keep clicking
until
Select cell / Ctrl+Shift+Left-or-Right Bracket (dependents-or-precedents)
CTRL+ALT+V correct answers Paste Special enables a user can quickly add, subtract,
multiply, or divide a group of cells by a copied cell value without formulas.
What key allows a user to quickly calculate a specific, coherent part of an equation?
correct answers F9
Ctrl+. (i.e., control key + period key) correct answers Enables user to move from one
end of a highlighted range to another
Pressing F4 after referencing a cell for an equation will... correct answers ...deem that
cell as an "absolute address", which is equivalent to entering dollar signs before and
after that cell's respective ID.
A user can convert an entire column/row to their results by... correct answers ...Home /
Paste drop-down / Values (V)
...Data / Flash Fill (might not be as effective)
...right-click & hold an edge of the highlighted content, drag to intended location, let go
for pop-up menu, & choose Copy Here as Values Only
How does a user name a cell, or group of cells? How can this new range name be used
in an equation? correct answers Navigate to Name Box (left of Formula Bar) & enters
only letters (upper- & lowercase) & underscores; no spaces.
Functions
What's the command for doubling the column width of every cell with an equation?
correct answers Ctrl + ~ (tilda)
How does a user highlight all cells with formulas? correct answers Select a single cell /
Home / Find & Select / Formulas
How does a user highlight all cells with constant numbers? correct answers Select a
single cell / Home / Find & Select / Go To Special
How does a user reveal if/what other cells will be affected before altering the value in a
cell? correct answers Formulas / Trace Dependents or Trace Precedents (keep clicking
until
Select cell / Ctrl+Shift+Left-or-Right Bracket (dependents-or-precedents)
CTRL+ALT+V correct answers Paste Special enables a user can quickly add, subtract,
multiply, or divide a group of cells by a copied cell value without formulas.
What key allows a user to quickly calculate a specific, coherent part of an equation?
correct answers F9
Ctrl+. (i.e., control key + period key) correct answers Enables user to move from one
end of a highlighted range to another
Pressing F4 after referencing a cell for an equation will... correct answers ...deem that
cell as an "absolute address", which is equivalent to entering dollar signs before and
after that cell's respective ID.
A user can convert an entire column/row to their results by... correct answers ...Home /
Paste drop-down / Values (V)
...Data / Flash Fill (might not be as effective)
...right-click & hold an edge of the highlighted content, drag to intended location, let go
for pop-up menu, & choose Copy Here as Values Only
How does a user name a cell, or group of cells? How can this new range name be used
in an equation? correct answers Navigate to Name Box (left of Formula Bar) & enters
only letters (upper- & lowercase) & underscores; no spaces.
