Excel Quiz

A features that displays only the data in column (s) according to specified criteria

• Formula

• Sorting

• Filtering

• Pivot Table

What type of chart is useful for comparing values over categories ?

• Pie Chart

• Column Chart

• Line Chart

• Dot Graph

What type of chart will you use to compare performance of two employees in the year 2016 ?

• Column Chart

• Pie Chart

• Dot Graph

• Line Chart

The ____ feature of MS Excel quickly completes a series of data

• Auto Fill

• Auto Complete

• Fill Handle

• Sorting

Which of the following is not a term pertaining to spreadsheets?

• Cell

• Character

• Formula

• Browse

Which of the following identifies a cell in Excel?

• Address

• Formula

• Name

• Label

This is not a function category in Excel.

• Logical

• Text

• Financial

• Data Series

Formulas in Excel are made up of ___

• Only arithmetic operators

• Only symbols

• Arithmetical operators and functions

• Symbols and functions

The ____ helps to identify various plotted data series.

• X- Axis

• Y-Axis

• Legend

• Gridlines

The worksheet names appear on tabs at the ____ of the workbook window.

• Bottom Right

• Top Left

• Bottom Left

• Top Right