Excel
Fill Handle
A fill handle mouse pointer is used to copy cell content
Thick Cross
A thick cross pointer will enable you to select a cell or range of cells .
Worksheet
A worksheet consists of cell that are organized into columns and rows . A worksheet is stored in a workbook .
Active Cell
An active cell has a black border indicating that a data is ready for entry . You can use the mouse or the keyboard arrow keys to change the location of the active cell .
Arrow-
An arrow mouse pointer will allow you to select commands in the Ribbon
Cell
An individual cell lies at the intersection between a row and a column The combinations of both a column letter and row number is also known as cell reference or cell address . A rectangular highlight specifies the on screen location of an active . This is also referred to as the active cell indicator
Shift or F8
Click the first cell and then press Shift or F8 while pressing the arrow keys to extend your selection , Pressing F8 will stop extending the selection
Date and Time Entries
Dates and times are numbers . MS Excel treats dates and times as numbers . The way that a time or date is displayed on a worksheet depends on the number format applied to the cell . When you type a date or time that Excel recognizes , the cell's format changes from the General format to a built in date or time format . By default , dates and times are right - aligned in a cell . The most convenient way to enter a date is to follow the pattern MM / DD / YYYY To enter a date : Type the date and press Enter or Tab Press Ctrl + ; ( semicolon ) Use the date and time functions in Excel . -today ( ) / now ( ) The most convenient way to enter time is to follow the pattern HOUR : MINUTE : SECOND To type a time based on the 12 - hour clock , type a space followed by AM or PM ( or A or P ) after of
cell reference
Each unique cell name is sometimes called the
Galleries
Galleries help you change the look of your spreadsheet by offering an array of different visual styles .
Number Entries
In Microsoft Excel , a number can contain only the following characters 0123456789 + - ( ) ./$% Excel ignores leading plus signs ( + ) and treats a single period as a decimal . All other combinations of numbers and nonnumeric characters are treated as text . Entering fractions . To avoid entering a fraction as a date , precede fractions with a 0
Entering Data
In excel , any set of characters containing a letter , hyphen , or space is considered text Text is place titles , such as worksheet titles , column titles , and row titles , on the worksheet . There are several ways to encode data in Excel : in an active cell or in the formula bar . To enter data in an active cell , first select the cell and then begin typing your data . As your encode characters from the keyboard , an insertion point will appear in the cell . The characters . will simultaneously appear in the cell and in the formula bar at the same time . To encode data into the formula bar , position the mouse pointer and click on the cell where you type the data . Move your cursor to the formula bar . Type in your data . Note : a cell may display ######## when it contains data that has a value or decimal numbers which are wider than the present column width . To see the whole value , simply increase the width of the column by double clicking on the line in between the column border
Tabs-
It contain features organized around the tasks that you do most in each program . The most frequently used features or commands are found in the Home tab . There are seven of them across the top . Each tab represents a collection of tasks you can do in Excel . Tabs and tasks are categorized as follows : a. Home - Clipboard , Fonts , Alignment , Number , Styles , Cells , Editing b . Insert Tables , Illustrations , Add - ins , Charts , Sparklines , Filters , Links Text , Symbols c . Page Layouts --- Themes , Page Setup , Scale to Fit , Sheet Options , Arrange d . Formulas --- function Library , Defined Names , Formula Auditing , Calculation e. Data - Get External Data , Connections , Sort & Filter , Data Tools , Outline f . Review Proofing , Language , Comments , Changes g . View-- Workbook Views , Show / Hide , Zoom , Window , Macros
Groups
It contains more detailed tools that are organized according to their functions . Example . Font group provides the tools for text .
The File tab is new to Excel 2016 Quick Access Toolbar
It is a customizable toolbar that allows you to access frequently used commands such as Save , Undo , Redo , etc. You can place the Quick Access toolbar above or below the ribbon
The File tab is new to Excel 2016
It is a replacement for the Office Button in Excel 2007 which was a replacement for the file menu in earlier versions of Excel . Like the old file menu , the File tab options are mostly related to file management such as opening new or existing worksheet files saving , printing , and a new feature - saving and sending Excel files in PDF format
Dialog Box Launcher
It is located at the bottom right corner of a group which displays a dialog box containing additional options and settings for each command
source area or copy area
The cell being copied is called the
Double Headed Arrow
The double headed arrow allows you to adjust the column's width and row heights You can do this by clicking and dragging the line between column headings from left to right and for rows , clicking and dragging the line between row headings up and down .
Scroll bars
The horizontal and vertical scroll bars allow the user to scroll through other parts of the sheet . To scroll horizontally in a worksheet , you can locate the horizontal scroll bar in the bottom - right corner or you can click the bar and move it from left to right .
destination area or paste area
The range of cells receiving the copy is called
Ribbon
The ribbon is a panel located at the top portion of the document . It consists of a series of tabs that provides you with quicker access to commands for completing a particular task . Each tab is divided into groups which are logical collections of related features designed to perform functions for developing , editing , and formatting your Excel spreadsheet
Status Bar
The status bar display if options such as signatures , permissions , track changes , and macro are turned on or off . It also displays if the cell is ready for data entry .
Zoom Control
The zoom control is located t the bottom right corner of the window that is used to increase or decrease the viewing size of the work area . The plus ( + ) sign indicates to increase the size of the text while the minus ( - ) sign is to decrease the text on the screen .
Rows
These are horizontal blocks of cell running across the entire width of the spreadsheet . Rows are sequentially numbered from the top . There are 1,048,576 rows which you can use in Excel 2007 .
Sheet Tabs
These are tabs that allow you to view a specific sheet . By default , there are three worksheet tabs which appear each time you create a new workbook .
Contextual Tabs--
These are the additional tabs to the normal sets of tabs that appear when certain object is selected . These tabs give you other commands that can be applied to the object you have selected
Commands
These are the buttons which will either display a dialog box where you can enter information or open a menu for more related options .
Columns
These are vertical blocks of cells which can be identified by alphabetical letters There are 16 , 384 columns which are indicated by column heading XFD . Columns are represented by letters .
Mini Toolbar
This feature is Excel is visible when you select or highlight text . It is a floating toolbar that contains specific commands and paragraph formatting features such as Bold , Italic , font , font Size and Font color . This toolbar remains translucent until the mouse pointer is positioned over the mini toolbar
Restore Button
This will bring back the original size of the worksheet
Minimize Button
This will expand the application to fill the entire screen .
Selecting Non - Adjacent Cells
To select cells that are apart from each other , follow the steps below : 1. Select the first cell or range of cells 2 . Hold down the Ctrl key while selecting non - adjacent cells . Release the Ctrl key when done with your selections .
Text Entries
a . In Microsoft Excel , text is any combination of numbers , spaces , and non numeric characters --- For example MS Excel treats the following entries as text : 10AA109 , 127AXY , 12-976 , 20846 b . All text is left aligned in a cell . To change the alignment , click the desired alignment tool in the Format Cells dialog box under Alignment Group c . A long text entry spills to the next cell . However , if the next cell to the right has an entry , the long text entry is truncated . To fully display the entry within the cell , adjust the column width . d . To display all the text on multiple lines in the cell , select the Wrap text check box as Text Control on the Format cells , Alignment Group dialog box . e . To enter a " hard " carriage return in a cell , press ALT - ENTER
Views--
a new feature in MS Excel 2007 is the Views toolbar which allows you to switch between available views of your workbook . It is located on the right side of the status bar .
active cell
always highlighted with a dark border
Spreadsheet-
another name for a worksheet and often used another name for workbook
Values
are numeric data used in calculations including dates . Data is considered a value if it belongs to any type of numerical data such as numbers , dates , times , fractions , percentages , currencies
Labels
are text entries which do not have a value associated with them . Labels are used to identify data in your spreadsheet . A label can also consist of numerical data which is not used in any calculations and can also be a combination of alphanumeric characters . It can also be a date or a serial number ..
Worksheet subtitle
could include a more detailed description of the content of the worksheet . E.g December 2010 Payroll , Year 2011 Projected Budget
Worksheet title
could include the name of the organization , department , or a description of the content of the worksheet
I Beam
enable An I - beam mouse pointer will allow you to select text within a formula bar .
Name Box
indicates the location of the active cell , which is the selected cell . It also show the name assigned to a cell or range of cells . It can be used to navigate to different cells in your worksheet
The preset font for the entire workbook
is Calibri , with a font size , font style , and font color of 11 point regular black .
A theme
is a collection of cell styles and other styles that have common characteristics , such as a color scheme and font . The default theme for an Excel workbook the Office Theme .
The fill handle
is the small black square located the lower - right corner of the heavy border around the active cell
cell
name ; The intersection of a row and column
Worksheet
numerical information presented in a tabular row and column format with text that labels the data / A collection of rows and columns that hold text and numbers
Workbook
office documents that contain one or more worksheets
range
refers to a selected rectangular block of cells . It can be as small as a single cell or as large as the entire worksheet To select a range of cells , do either of the following : Click the first cell and then drag to the last cell . Click the first cell and then hold down the Shift key while pressing the arrow keys to extend your selection .
Formula Bar
the formula bar is located just below the ribbon . It displays the data or formula as you type in the cell . You can use the formula bar to enter and edit a formula , function or data in the cell .
Cell reference-
the name of a cell composed of its column and row intersection such as G14 . This is sometimes called the cell address or cell name .
Esc key
the user can cancel a command
Minimize Button
this will reduce the size of the entire screen and place it on the taskbar
Press Alt or F10
to display the keys for each tab in the ribbon
Rows
typically contain information that is similar to items in a list Example of row titles : Product and Total
