Midterm and Introduction to Excel Information
You will be having your Midterm next week: Period 2 on Wednesday, January 23 from 11:15 am - 12:25 pm; Period 5 on Thursday, January 24 from 8:45 - 9:55 am; and Period 9 on Thursday, January 24 from 11:15 am - 12:25 pm. The test will take place in the Windows Lab.
Please review the following information (you can copy and paste this information in a Word Document and print it for yourselves):
Microsoft Excel is a spreadsheet application which allows one to enter numerical values or data into rows and columns of a spreadsheet, and to use these entries for calculations, graphs, and statistical analysis. There are many uses for a spreadsheet application including payroll, inventory, data collection, personal budgets, and cost calculations.
A document created in Excel is referred to as a "workbook." An Excel workbook consists of individual worksheets (or sheets). You can add more worksheets, delete them and rename them. Columns are labeled with letters and rows are labeled with numbers in Excel. You can add more columns and more rows in a spreadsheet.You can also change the width of columns and rows.
The cell address or cell reference is the address of a cell in Excel (the Column Letter and the Row Number): i.e. D3 - Column D, Row 3. This cell address appears in the Name Box. You use cell addresses when creating formulas in Excel. When you enter data in cells you can also see it in the Formula Bar.
The worksheet area is the area containing the gridlines in the Excel window. These gridlines are the gray vertical and horizontal lines that define the cells in the worksheet area. A cell in Excel is the intersection between a row and a column. An active cell is the cell surrounded by a black border with the AutoFill Handle (see below). When the cell is active you are ready to enter information, text or other data (numbers, dates, formulas, etc.).
When text doesn't fit into a cell, it overlaps to the next cell. When a number is too long to fit a cell, Excel changes the display into number symbols (###) to warn the user.
The cell pointer is the white cross (mouse pointer). Excel offers several automatic features: AutoComplete, AutoCorrect, AutoFill, AutoSum and AutoCalculate.
The AutoComplete Feature automatically inserts data in a cell that begins the same as a previous entry. It's very useful when entering repetitive data entries.
The AutoCorrect Feature automatically corrects many common typographical (typing) errors, like in Microsoft Word.
The AutoFill Feature is used to quickly fill a range of cells with the same data or with consecutive data; you can also quickly enter months of the year or a list of numbers. To use this feature you use the AutoFill fill handle (or AutoFill handle), which is the black square at the bottom right of the border that surrounds an active cell.
The Auto Sum Feature allows you to add and calculate the sum of a list of numbers in your worksheet. Go to the Home Tab and click the AutoSum symbol - the Greek letter Sigma (like an E) after highlighting a group of cells with numbers.
The AutoCalculate Feature is a shortcut that allows you to view a calculation for a selected range of cells without placing a function in a cell. You can highlight a group of cells, and "AutoCalculate" will calculate the sum, average, or count (on the bottom right side of the Status Bar).
If you have any questions, please feel free to see Mrs. Feld.
Please review the following information (you can copy and paste this information in a Word Document and print it for yourselves):
- Computer concepts: What is a computer? What is hardware? Examples. What is software? Examples. Check your notes and review your tests and quizzes. Input devices, output devices, processing devices, CPU, storage devices (examples of all), two kinds of software and examples. What is computer memory? What is digital? What are bits, bytes, kilobytes, megabytes, gigabytes, terabytes? What is a network? Which is the most popular network?
- What are copyrights?
- Ergonomics: what is it? How do you call the persons that study and design safe and comfortable environments and furniture for humans? Why is good posture important?
- Home Row Keys. What is touch typing? Which is the first goal of a beginner typist? Name of the Keyboard. Who invented the typewriter?
- What is Excel? What is a cell? What is an active cell? What is a cell address or cell reference? How do you call a document in Excel? When do you use Excel? How are columns labeled? How are rows labeled?
- There will be two Timings: a 2 minute and a 3 minute timed writing.
Microsoft Excel is a spreadsheet application which allows one to enter numerical values or data into rows and columns of a spreadsheet, and to use these entries for calculations, graphs, and statistical analysis. There are many uses for a spreadsheet application including payroll, inventory, data collection, personal budgets, and cost calculations.
A document created in Excel is referred to as a "workbook." An Excel workbook consists of individual worksheets (or sheets). You can add more worksheets, delete them and rename them. Columns are labeled with letters and rows are labeled with numbers in Excel. You can add more columns and more rows in a spreadsheet.You can also change the width of columns and rows.
The cell address or cell reference is the address of a cell in Excel (the Column Letter and the Row Number): i.e. D3 - Column D, Row 3. This cell address appears in the Name Box. You use cell addresses when creating formulas in Excel. When you enter data in cells you can also see it in the Formula Bar.
The worksheet area is the area containing the gridlines in the Excel window. These gridlines are the gray vertical and horizontal lines that define the cells in the worksheet area. A cell in Excel is the intersection between a row and a column. An active cell is the cell surrounded by a black border with the AutoFill Handle (see below). When the cell is active you are ready to enter information, text or other data (numbers, dates, formulas, etc.).
When text doesn't fit into a cell, it overlaps to the next cell. When a number is too long to fit a cell, Excel changes the display into number symbols (###) to warn the user.
The cell pointer is the white cross (mouse pointer). Excel offers several automatic features: AutoComplete, AutoCorrect, AutoFill, AutoSum and AutoCalculate.
The AutoComplete Feature automatically inserts data in a cell that begins the same as a previous entry. It's very useful when entering repetitive data entries.
The AutoCorrect Feature automatically corrects many common typographical (typing) errors, like in Microsoft Word.
The AutoFill Feature is used to quickly fill a range of cells with the same data or with consecutive data; you can also quickly enter months of the year or a list of numbers. To use this feature you use the AutoFill fill handle (or AutoFill handle), which is the black square at the bottom right of the border that surrounds an active cell.
The Auto Sum Feature allows you to add and calculate the sum of a list of numbers in your worksheet. Go to the Home Tab and click the AutoSum symbol - the Greek letter Sigma (like an E) after highlighting a group of cells with numbers.
The AutoCalculate Feature is a shortcut that allows you to view a calculation for a selected range of cells without placing a function in a cell. You can highlight a group of cells, and "AutoCalculate" will calculate the sum, average, or count (on the bottom right side of the Status Bar).
If you have any questions, please feel free to see Mrs. Feld.
posted by Karol B. Feld at
5:55 AM
0 Comments:
Post a Comment
<< Home