Computer Science Exam Review - Excel
Session 1.1 The Excel Window
Workbook Where Excel stores its spreadsheets in files
Name Box Displays the cell reference of the active cell
Select All button Used to select all of the cells in the active worksheet
Row Headings The numbers along the left side of the worksheet window that identify the
different rows in the worksheet. You click a row heading to select the entire
Sheet tab scrolling buttons Scroll the list of sheet tabs in the worksheet
Active Sheet the sheet currently displayed in the workbook window and its tab is white
Formula bar displays the value or formula entered in the active cell
Sheets Excel is made up of individual sheets. Each sheet is identified by a name, which
appears in the sheet tab
Cell The intersection of a row and a column
Active Cell The cell currently selected in the active worksheet is the active cell. The active
cell is outlined with a thick border and the corresponding row and column
headings are highlighted.
Column Headings The letters along the top of the worksheet window that identify the
different columns in the worksheet. You click a letter to select the entire
Worksheet displays the contents of the spreadsheet laid out in a grid of rows and columns
Spreadsheet A collection of text and numbers laid out in a rectangular grid.
Cell Reference Indicates a cells column and row location
Text Data Any combination of letters, numbers, and symbols that form words and
Number Data Any numerical value that can be used in a mathematical calculation
Truncated when text is hidden because it is too large to fit in the cell to be displayed
AutoComplete When Excel tries to complete what youre typing by displaying possible
words/numbers from previously recorded entries
Pixel A single point on a computer monitor or printout. A column width of 8.43 characters
equals 64 pixels.
Point Is approximately 1/72 of an inch. The default row height is 15 points or 20 pixels.
Autofitting Eliminates empty space by matching the row height or column width to its
tallest or longest cell entry.
Clearing Clearing data from a worksheet removes the data, leaving blank cells where the
data had been.
Deleting Deleting data from the worksheet removes both the data and the cells.
Navigation Between Worksheets
- A workbook can have two kids of sheets: o Worksheets contains a grid of rows and columns into which the user enters
data values and formulas
o Chart sheets contains Excel chart that provides visual representation of
o Charts can also be embedded within worksheets, displaying both the data
and charts in one sheet
Navigating Within a Worksheet
- Each cell within a worksheet is identified by a cell reference
Entering Text, Numbers, and Dates
- Text data is often referred to a text string, because it contains a string of text
- Date and time data are commonly recognized format for date and time values.
- By default, text is left-aligned in cells and numbers, dates, and times are right-
- If the adjacent cells contain text or data, only the text that fits into the cell is
displayed. The rest of the text entry is hidden, or truncated, from the view.
- Excel tries to anticipate the remaining characters by displaying text that begins with
the same letters as a previous entry in the same column. This feature, known as
AutoComplete, helps make entering repetitive text easier. To accept the suggested
text, press the Tab or Enter key. To override the suggested text, continue to type the
text you want to enter in the cell.
International Date Formats
- Many international businesses adopt ISO (International Organization for
Standardization) dates in the format yyyy-mm-dd
Deleting and Clearing a Row or Column
- When a cell is deleted, the remaining cells in the worksheet shift into the deleted
- Note: pressing the Delete key does not DELETE the selected row or column; instead,
it CLEARS the contents, leaving the row or column in place Session 1.2 Worksheet Data
Spelling checker verifies the words in the active worksheet against the programs
Cell Range/Range a group of cells
Formula an expression that returns a value
Nonadjacent range is two or more distinct adjacent ranges
Adjacent range is a group of cells in a single rectangular block of cells
View buttons change how the worksheet content is displayed
Sum button (also referred to as the AutoSum feature) inserts Excel functions to sum,
average, or count all the values in a column or row, as well as display the minimum
or maximum value in a column or row.
Range reference Indicates the location and size of a cell range
Function A named operation that returns a value. Functions are used to simplify formulas,
reducing what might be a long formula into a compact statement.
Normal View Shows the contents of the worksheet
Page Layout View Shows how the worksheet will appear when printed
Page Break Preview Displays the location of the different breaks within the worksheet
Portrait Orientation The page is TALLER than it is WIDER
Landscape Orientation The page is WIDER than it is TALLER
Formula View a view of the worksheet contents that displays formulas instead of the
Scaling A printout reduces the width and the height of the printout to fit the number of
pages you specify by shrinking the text size as needed.
Moving and Copying Range
- One way to move a cell or range is to select it, position the pointer over the bottom
border of the selection, and then drag the selection to a new location. This technique
is called drag and drop because you are dragging the range and dropping it in a new
- If too complex, its often more efficient to cut and past the cell contents. Cutting
places the cell contents into computer memory or on the Clipboard. The contents
can then be pasted from the Clipboard into a new location in the worksheet.
Entering a Formula
- Every Excel formula begins with an equal sign (=) followed by an expression
describing the operation that returns the value.
- Note: if you dot begin the formula with the equal sign, Excel assumes that you are
entering text and will not treat the cell contents as a formula.
- A formula is written using operators that combine different values, resulting in a
single value that is then displayed within the cell.
- The most commonly used operators are arithmetic operators that perform
addition, subtraction, multiplication, division and exponentiation. - The order of precedence is a set of predefined rules used to determine the
sequence in which operators are applies in a calculation. Remember, BEDMAS?
Copying and Pasting Formulas
- With formulas, Excel adjusts the formulas cell references to reflect the new location
of the formula in the worksheet.
Entering Functions with the AutoSum Feature
- The AutoSum feature includes buttons to quickly insert the SUM, AVERAGE, COUNT,
MIN and MAX functions to generate the following:
o Sum of the values in the column or row
o Average value in column or row
o Total count of numeric values in the column or row
o Min value in the column or row
o Max value in the column or row
Editing Worksheet Content
- Sometimes you need to edit only a portion of an entry rather than change the entire
content of a cell, especially if the cell contains a large block of text or a complex
formula. To edit the cell contents, you can work in Edit mode.
Using Find and Replace
- You can use the Find command to locate a string of characters known as a search
string and replace the text with a replacement string of new text characters.