Study Guides (238,517)
Canada (115,191)
Dr.Hurst (16)

EXCEL Exam Review.docx

16 Pages
Unlock Document

McMaster University
Computer Science

Computer Science Exam Review - Excel Session 1.1 The Excel Window Terms: 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 worksheet row. 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 column. 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 sentences. 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 properly 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. Content: 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 worksheet data. 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 characters. - 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- aligned - 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 location. - 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 Terms: Spelling checker verifies the words in the active worksheet against the programs dictionary 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 resulting values 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. Content: 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 location. - 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.
More Less

Related notes for COMPSCI 1BA3

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.