49 terms

# Excel 2013 Review Quiz

###### PLAY
Active cell
Location in the worksheet that will displays typed data that will be affected by a command
Fill handle
The small black square in the bottom right corner of as cell that allows you to fill adjacent cells with a repeated formula
content appearing at the top of each printed page
Footer
content appearing at the bottom of each printed page
Row
The horizontal reference in a spreadsheet
Column
The vertical reference in a spreadsheet
An electronic file used to organize data and perform calculations
Workbook
Cell
The intersection of a row and a column
The name of a cell; contains both the column and row reference
Formula
A mathematical function that contains cell addresses and mathematical operators
Autosum
A function to add a set of values in a column or a row
Average
A function that identifies the numeric average of a set of values in a column or a row
Ascending order
To sort data in A>Z order
Descending order
To sort data in Z>A order
Name Box
The box that contains the cell address
Formula Bar
Displays the contents stored in the active cell
Column Chart
An image used to compare different groups of data to each other through the use of vertical columns of different lengths
Autofit
To make a column or row as it needs to be to fit the data contained in the cell, Determines the best width for a column or the best height for a row, based on its contents.
Numbers
Used to identify rows in a spreadsheet
Letters
Used to identify columns in a spreadsheet
Pie Chart
A chart used to visually display the parts of a whole as percentages, a circular chart divided into triangular areas proportional to the percentages of the whole
Ctrl
The key presses to select non adjacent cells of data to create a chart
Equal Sign
Used to indicate the start a formula
Merge and Center
To make one cell out of several highlighted cells and then center the content of that cell
Legend
Labels that identify the different data series in a chart.
x-axis
The horizontal line on a graph
y-axis
The vertical line on a graph
Chart Title
The title or name of chart usually identifying what data depicts, most often found at center top of chart area
Data label
Value or name assigned to individual data points.
Data
Text or numbers in a cell
A toolbar located in the upper-left corner of the program window, which displays the Save, Undo, and Repeat buttons by default but can be customized to include any command.
Ribbon
An area at the top of the Excel 2010 window where almost all the capabilities of Word are available to help you use the program efficiently.
Scrollbar
A feature that allows you to scroll up and down or left and right in order to view portions of your work area
File Tab
The File Tab explains the access to the Excel Options dialog box and provides control to create new documents, save and print documents, as well as several other features.
Zoom Slider
A bar in the lower-right corner of an Office program window that you can use to increase or decrease the size of the document on screen.
Sheets Tab
Tabs that appear at the bottom of the workbook window,which displays the name of each worksheet
Sort
To arrange a list of words or numbers in ascending or descending order
Ctrl+c
Keyboard shortcut for copy
Ctrl+v
Keyboard shortcut for paste
Portrait
The orientation of a document where the page is taller than it is wide.
Landscape
The orientation of a document where the width is greater than the height.
xlsx
file extension used for Microsoft Excel 2013 documents-identifying the type of program used to create it
Insert Tab
Allows you to add various items into a document; such as pages, tables, charts, illustrations, links to Internet sites or other documents, headers, footers,text and symbols
Custom margins
Used to center the spreadsheet both horizontally and vertically on a printed page.
Chart Sheet
A separate sheet in a workbook that stores a chart.
Rename sheet
To rename a sheet in a workbook. Right click the sheet tab ,click rename.
Border
A line or box that frames a cell.
* (Shift 8)
Multiplication symbol used in an Excel formula