Excel Tutorial 1
The cell currently sorted in the worksheet
Active cell
What are the column headings made from?
Alphabetical letters (A-z) in order.
How many characters can be typed in a cell before the text is truncated?
8-9
What contains charts or visual representations of spreadsheet data?
Chart sheets
What is the active cell outlined in?
Dark black box.
Completes energy and returns to ready mode
Enter
A program used to enter data, analyze data and present quantitative data.
Excel
How does excel stores spreadsheets?
In files called workbooks
What can a "what if" analysis do?
It can change one or more values in a spreadsheet. It also asses the effect those changes have on the calculated values.
What is a spreadsheet used to do?
Manage personal budget, track household assets and perform what if analysis
Expressed in points, default is 15 points high
Row Height
What are the numbers that appear along the left of the worksheet window?
Row headings
How many workbooks can be one at a time to display the contents of different workbooks?
More than 1
What provides information about the program, contains the view shortcuts and zoom controls and cantinas the mode indicator?
Status bar
What is used to select all cells?
Select all button (control + a)
Combination of letters, numbers and some symbols that form words and sentences, often refereed to as string because it contains a string of text characters.
Text data
What type of text can a cell contain?
Text, numbers, and formulas. Combinations of all three.
moves to identified sheet
Sheeet tabs
What scrolls the list of sheets in a workbook and is activated when there are multiple worksheets in the workbook?
Sheet tab scrolling buttons
What displays the names of the worksheets in the workbook?
Sheet tabs
What is each workbook made up of?
Sheets
Where are the contents of a workbook shown?
Workbook window.
What contain data laid out in columns and rows?
Worksheets
What is sed to magnify or shrink the content displayed in the active cell? Contains zoom out and in buttons. Also slider button
Zoom controls
moves left one window/ screen
alt + page up
moves right one window / screen
alt and page down
Label prefix
apostrophe '
moves one cell on the current sheet in the direction of the arrow
arrow keys
How can the Go To Command displayed?
used to Find and select button in the editing group on the Home tab of ribbon/ press F5 function key/ Control + G
Where does entered data appear?
within active cell and formula bar
deletes one character left of the insertion point
backspace
deletes text to the end of the line
control + delete
moves left or right by one word
control + left/ right arrow
commonly recognized formats for date and time values
date and time data
deletes one character to the right of the insertion point
delete
How can edit mode be activated?
double click cell, select cell and press {F2}, select cell and click anywhere in formula bar.
moves to the beginning of the entry
home
How are text data aligned?
left
moves the insertion point left or right by one character
left or right arrow
Will spell checker check the usage of words?
no
Any numerical value that can be used in a mathematical calculation.
number data
Moves up one cell / row
shift + enter
moves one cell/ column to the left
shift + tab
verifies the word in the active worksheet against the program's dictionary
spelling checker
moves one cell/ column to the right
tab
What are the three general categories of data?
text, number, date/ time data
Moves to cell A1
Control + Home
Moves to previous or next sheet in workbook
Control + PgUp; or Control + PgDown.
moves to edge of a group of cells containing data
Control + arrow keys
Moves to last cell on worksheet containing data
Control + end
Displays the label, value or formula entered in the active cell.
Formula bar
A collection of text and numbers laid out in a rectangular grid and is used in business for budgeting, inventory and decision making
Spreadsheet
How is numerical data aligned
By Default right aligned
Expressed based on the number of characters a column can contain.
Column Width
What are the letters that appear along the top of the worksheet window to identify the different columns in the worksheets?
Column headings
moves to the end of the entry`
end
moves down one cell
enter
What happens if the cell to the right of entry is blank for text longer than cell width.
it appears in blank cell on right
Moves down or up one window/ screen
page down / page up
What happens if numbers exceed its cell size?
####### is displayed for the truncated value
Hoe many actions can be redone or undon in excel?
100
By default, how many worksheets are in a worksheet?
3
How many columns are allowed in a worksheet in excel?
16,385
What is the standard size for column width
8.43 points
The intersection of a column and a row.
Cell
Limitations of AutoComplete
Doesn't work with dates Doesn't work with numbers Doesn't work with non- adjacent entries
moves to beginning of row (Column A)
Home
What is used to go left and right through a worksheet and doesn't move the insertion point or change the active cell?
Horizontal scroll bar
For separate lines of text in once cell. Press alt key while pressing Enter key.
Line Breaks
Displays the cell reference of the active cell
Name box
What provides access to workbook level features and program settings?
Office button
What is a collection of buttons that provide one click access to commonly used commands, such as save, undo and redo.
Quick access toolbar
What happens if the cell to right of entry has text; for text longer than cell width?
The text gets truncated.
What displays the name of the active workbook, the excel program name and the sizing buttons?
Title bar
What is used to go up and down a worksheet and doesn't move the insertion point or change the active cell?
Vertical scroll bar
What is used to change how the worksheet content is displayed: normal, page layout or page break preview view?
View buttons
What clearly identify overall goal/ present information in well organized format?
Well designed workbooks
What are effective workbooks?
Well planned and carefully designed,
Restores the previous cell contents and returns to Ready mode
escape