14.4: Quick Analysis Toolbar

Last updated
Save as PDF

Page ID: 13672

\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

Excel provides many tools to help the user complete their work quickly and efficiently. Another helpful tool is the Quick Analysis Toolbar. When highlighting multiple cells at once, depending on the type of information in the cell, a quick analysis toolbar may appear in the lower right-hand corner below the last cell highlighted. In addition, the status bar provides helpful calculations in reference to the information highlighted like Average, Count, and Sum.

Selecting the Quick Analysis button allows for multiple options to format your information, or to create Charts of the data, calculate the data, create tables, or visual sparklines. More information about these items will be explored in future chapters.

In addition, in the lower right-hand corner of the highlighted cell, there may be a “+” button. This is an autofill button that will be explained in further detail, but a quick summary of the autofill button is that it can allow the user to copy text from the above cell to other cells by clicking on the “+” sign, and dragging the mouse and highlight the other cells. The autofill button can also copy formulas and are other references.