Getting Started with Excel Tutorial One
Pixel
A single point on a cell
Worksheet
A single spreadsheet made up of cells organized by rows and columns
ScreenTip
A box with descriptive text about a command that appears when you point to a button on the ribbon.
Point
Approximately 1/72 of an inch, used to measure height of a row
AutoFit
Changes the column width or row height to siplay the longest or tallest entry within the column or row
Name box
Displays the cell reference of the active cell
Formula bar
Displays the value or formula entered in the active cell
Range Reference
Identifes a range; includes the cell reference of the upper-left cell and the lower-right cell in a box
Sheet tab
Identifies a sheet by a name
Zoom controls
Increase or decrease the magnification of the worksheet content
Restore Down button
Restores a window to its previous size
Touch Mode
Mode in which the ribbon increases in height, the buttons are bigger, and more space appears around each button
Edit mode
Mode that allows you to replace only part of a cell's content
Groups
Organized group for buttons for related commands
Text string
String of text characters, another name for Text data
active sheet
Sheet currently displayed in the workbook window
Tabs
Has commands related to particular activities or tasks
Maximize button
Button that expands the window to fit the screen
Minimize button
Button that hides a window so that only its program button ins visible on the taskbar
Spreadsheet
A grouping of text and numbers in a rectangular grid or table.
Keybroard Shortcut
A key or combination of keys that you press to access a feature or perform a command
Shortcut Menu
A list of commands related to a selection that opens when you click the right mouse button.
Date and Time Data
Commonly recognized formats for date and time values
AutoComplete
Feature that makes entering repetitive text easier
template
A preformatted workbook with many design features and some content already filled in
Microsoft Excel 2013 (or Excel)
An application used to enter, analyze, and present quantitative data
Text data
Any combination of letters , numbers, and symbols
Numeric data
Any number that can be used in a mathematical calculation
nonadjacent range
Blocks that are not connected
Ribbon
Conatains buttons that you click to execute commands to work with Excel.
Chart Sheet
Contains a chart that provides a visual representation of worksheet data
Active cell
Currently selected cell
Cell
Each intersection of a row and a column
Cell range (range)
Group of cells in a rectangular box
Planning analysis sheet
Includes questions that help you think about the workbook's purpose and how to achieve desired results
Key Tips
Labels that appear over each tab and command on the ribbon.
Column headings
Letters along the top of the workbook window that identify the different columns in the worksheet
Sheets
Make up a workbook
Row headings
Numbers along the left side of the workbook window that identify the different rows of the worksheet
Backstage view
Provides access to various screens with commands that allow you to manage files and Excel options
Status bar
Provides information about the workbook
Cell reference
Something that identifies a cell by its column and row
Workbooks
Where excel stores spreadsheets