Skip to main content
Workforce LibreTexts

14.4: Quick Analysis Toolbar

  • 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}}\)

    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 clipboard_e985f98d49a187c448e84b747417f6545.png 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.

    clipboard_e5bb58b5d90bbc26cae6d2ea12a1e4ce5.png

    Selecting the Quick Analysis button clipboard_e985f98d49a187c448e84b747417f6545.png 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.

    clipboard_e285bd2e009558e82c7f348ab138ae4dd.png

    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.


    14.4: Quick Analysis Toolbar is shared under a CC BY license and was authored, remixed, and/or curated by Nick Heisserer.

    • Was this article helpful?