Excel Concepts Quizs

Formula

• Expression which returns a value.

• A type of equation that is always true.

• A statement that can be proven false.

• A graphical representation of data.

Workbook

• File used to store worksheets

• A type of spreadsheet

• A document for writing notes

• A program for creating presentations

Number Data

• A numerical value which can be used in a mathematical calculation

• A type of data that represents categories

• A graphical representation of data

• A method of organizing data in a table

Data Source

• Range which contains the data selected to display in the chart.

• Type of chart used to represent data visually.

• Method of collecting data for analysis.

• Software used to create and edit charts.

Function

• A named operation which returns a value.

• A variable that stores data.

• A type of loop in programming.

• A method for inputting data.

Data Series

• A collection of unrelated data points.

• A range of values which is plotted as a single unit on the chart.

• A method of organizing data in a table.

• A type of data analysis technique.

Sorting

• Sort data by text, numbers, formatting and dates and times in one or more columns

• Organize data in a random order

• Remove duplicates from a dataset

• Group similar items together

Text Data

• Combination of letters, numbers, and some symbols which form words and sentences

• Only numerical values used for calculations

• Images and graphics used in digital media

• Audio recordings and sound files

Sparkline

• Tiny chart in the background of a cell

• Large graph displayed on a separate page

• Interactive dashboard for data visualization

• Static image of a data set

Page Break View

• Displays the location of different page breaks within a worksheet

• Shows the print layout of the worksheet

• Highlights cells with data validation

• Provides a summary of formulas used in the worksheet