Computer Applications Final Exam Study Guide Spring 2006

Computer Applications Final Exam Study Guide Spring, 2006 Directions: Click the mouse or press enter to move through the slide presentation.

What is a computer? n An electronic machine that can make calculations and logical decisions.

Identify the parts of the Windows desktop. icon Start button Minimized program button Task Bar

What is a computer program? n A list of instructions written in a language the computer can understand.

What is an applications program? n A program that allows the user to perform a specific task.

What is a system program (operating system) n A program that allows the user to communicate with the computer and the applications program.

What type of program is… n Word? n An applications program, word processor n Windows XP n An operating system n Excel n An applications program, spreadsheet n Access n An applications program, database n Power. Point n An applications program, presentation

What is the difference between a computer and a calculator? n A computer can make logical decisions; a calculator cannot.

What is the clipboard? n A temporary part of memory used for cut, copy, and paste commands.

What is RAM? n Random Access Memory n Temporary memory in the computer

What is ROM? n Read Only Memory n Memory that is built into the hardware; memory that cannot be changed

What is the ALU? n The arithmetic logic unit n The part of the CPU that handles arithmetic computations and logical decision making

What is the Control Unit? n The part of the CPU that controls the flow of data through the computer.

What is the CPU? n The central processing unit n The “brain” of the computer

What is meant by the term “peripherals” when used with a computer? n All of the hardware devices attached to the CPU. n Examples: keyboard, mouse, disk drives

Identify the parts of a computer system. monitor Floppy disk drive CD/DVD keyboard mouse

Identify the parts of the Word Title window. bar Menu bar cursor Status bar Scroll box

Identify the parts of the Excel window. Formula bar cell Row column

What is the purpose of the office assistant? n To give help with functions of Office

What is meant by the margin? n The white space on the paper between the edge of the text and the edge of the page.

What are the dimensions of a letter-sized sheet of paper? n 8. 5” X 11”

What is the default setting? n The original setting on the computer before it is changed by the user.

What is a dialog box? A special window that asks the user for more information so that the computer can execute a command.

Can a Word document be arranged into columns? n Yes

What are the steps necessary to copy a block of text to a new location? 1. 2. Select the block of text Execute the copy command 1. 2. 3. 4. Copy button CTRL-C Right click, copy Edit, copy Move the cursor to the new location Execute the paste command 1. 2. 3. 4. Paste button CTRL-V Right click, paste Edit, paste

What is the meaning of a wavy red line under a word? n It is not in the dictionary and is probably misspelled. n What should you do about it? Right click n What will the computer do? n Suggest changes n

Selecting Text n How do you select a single word? n Drag or double click n How do you select a paragraph? n Drag or triple click n How do you select a single sentence? n Drag or Ctrl+click n How do you select the entire document? n Ctrl+A

What is the meaning of a green wavy line? n There is probably a grammatical error in your sentence. n What should you do? n Right click n What will the computer do? n Suggest a correction n Do you have to accept the computer’s suggestion? n No

What is the purpose of a header or a footer in an Office document? n To place the same information on the top or bottom of every page. n Does this information have to be the author’s name? n No

What is font? n The shape of a set of characters.

How is font measured? n Points n 1 point = 1/72 inch

What is the difference between serif and sans serif fonts? n Serif fonts have serifs n Example: Times New Roman n Sans serif fonts do not n Example: Arial

What is alignment? n The arrangement of text on a page.

Left Aligned n Even left edge, ragged right edge. n Now is the time for all good men to come to the aid of their country. Now is the time for all good men to come…

Right Aligned n Even right edge, ragged left edge. n Now is the time for all good men to come to the aid of their country. Now is the time for all good men to come…

Centered n All lines are equally distant from the left and right margin n Now is the time for all good men to come to the aid of their country. Now is the time for all good men to come…

Justified n Even left and right margins Now is the time for all good men to come to the aid of their country.

Personal Business Letter n Identify the parts of the personal business letter.

What is the purpose of parenthetical documentation? n To document sources of research and thereby avoid plagiarism.

What special formatting is used for the Works Cited page of an MLA style report? n Hanging Indentation. Herrnstein, Richard J. , and Charles Murray. The Bell Curve: Intelligence and Class Structure in American Life. New York: Free, 1994.

What is data? n An android on Star Trek? n Information

What is a spreadsheet? n An applications program that is used to store and calculate numbers.

Define n Cell n The intersection of a row and column in a spreadsheet n Value n Numbers that can be used in calculations n Label n Characters that are not used in calculations

What is a formula? n A mathematical statement used for calculations.

What is a function? n A built-in formula.

What are cell references? n The column letter and row number of a cell in a spreadsheet. n Ex: C 3

What is the difference between an absolute cell reference and a relative cell reference? n An absolute cell reference does not change when the formula it is in changes to a new location. n $A$3 n A relative cell reference changes relative to the location of the new cell that the formula is copied into. n A 3 n A mixed cell reference locks either the column or row but allows the other to change. n $A 3 or A$3

How does the computer distinguish between an absolute and a relative cell reference? n An absolute cell reference has a $ before the column letter and row number to anchor the cell. n Example: $A$3

What is an argument? n Information contained in parenthesis that is needed for a function. n Ex: =Average(B 3: B 56) n Ex: =IF(B 3>10, 5, 12)

What is the order of operations? n The order in which mathematical operations must be performed. Parenthesis n Exponents n Multiplication n Division n Addition n Subtraction n

What are the mathematical operators? n * multiplication 2*3 = 6 n/ division 16/4 = 4 n ^ raise to an exponent 3^2 = 9 n + addition 2+2 = 4 n - subtraction 6 -5 = 1

What is the purpose of… n The SUM function n To add a range of numbers n The AVERAGE function n To calculate the average of a range of numbers n The MAX function n To find the largest value in a range of cells n The MIN function n To find the smallest value in a range of cells

What must be entered into a cell before any formula or function? n An equal sign =

What is the term for adjacent cells in a row or column? n A range of cells

What are gridlines? n Dark lines outlining the rows and columns in a spreadsheet

What is the name given an entire Excel document? n A workbook

By default, how many spreadsheets are in a new workbook? n three

How can you tell if a workbook has more than one spreadsheet or charts on separate sheets? n Look at the tabs on the bottom of the sheet.

What type of information would be on a… n Pie chart – parts of a whole, percentages n Bar chart – comparison of values n Line graph – change over time

Can data be copied or moved between sheets in a workbook? n yes

What are the relational operators? = equal to > greater than < less than >= greater than or equal to <= less than or equal to <> not equal to

What is the form of an If statement n =If(<comparison>, <true value>, <false value>)

What type of chart is this?

Identify the parts of the chart. Y-axis labels title X-axis labels legend

What is a database? n A system of storing large amounts of information.

Give an example of a manual database. n The telephone book

Give an example of an electronic database. n Microsoft Access

What type of applications program allows the user to show slides and give a speech? n A presentation program

Give an example of a presentation program. n Power. Point

Good luck on your test and have a happy and safe holiday!