CSC 101 Intro to Computers

Mid-Term - Room 209

Dr. Diogo

Recapitulation

Questions	Multiple Choice	Completion	True / False
1
2
3
4
5
6
7
8
9
10

Multiple-Choice Questions

Study questions 1 through 10 and mark the correct answers in Blue.

1) The active cell can be identified in all of the following ways except __________.

a. a heavy border surrounding the cell

b. the active cell reference displayed in the Name box

c. the lit up column heading and row heading

d. a block plus sign displaying in the center of the cell

2) Excel positions text __________ the cell.

e. left-aligned, which means the text is positioned at the far left in

f. right-aligned, which means the text is positioned at the far right in

g. centered, which means the text is positioned in the middle of

h. justified, which means the text is spread across the width of

3) If a wrong letter is typed and the error is noticed before clicking the Enter box, use the __________ to erase all the characters back to and including the one that is wrong.

i. enter key

j. backspace key

k. esc key

l. delete key

4) A range can be entered by typing the beginning cell reference, a __________, and the ending cell reference.

m. colon (:)

n. hyphen (-)

o. slash (/)

p. tilde (~)

5) When a file is saved, Excel automatically appends the extension __________ to the entered file name, which stands for Excel workbook.

a) .exc

b) .wbk

c) .exw

d) .xls

6) An alternative method to using the mouse to select a cell is to use the __________ located just to the right of the typewriter keys on the keyboard.

a. alphabetic keys

b. function keys

c. arrow keys

d. special keys

7) Excel positions text __________ the cell.

a. left-aligned, which means the text is positioned at the far left in

b. right-aligned, which means the text is positioned at the far right in

c. centered, which means the text is positioned in the middle of

d. justified, which means the text is spread across the width of

8) The Microsoft Office 2000 Premium Edition includes all of the following except ____.

a. Microsoft Word 2000, Microsoft Excel 2000, and Microsoft Access 2000

b. Microsoft PowerPoint 2000, Microsoft Publisher 2000, and Internet Explorer

c. Microsoft FrontPage 2000, Microsoft PhotoDraw 2000, and Microsoft Outlook 2000

d. Microsoft WordPerfect 2000, Microsoft Paradox 2000, and Microsoft Quattro 200

9) The taskbar contains all of the following except

e. the Start button

f. the Quick Launch toolbar

g. the tray status area

h. the Close button

10) In the Windows Help window, the __________ lists a large number of entries, each of which references one or more Help screens.

i. Contents sheet

j. Index sheet

k. Search sheet

l. Options sheet

Completion

For each of the following, fill in the blank space words or phrases that best fit each sentence (Blue).

1) __________ is an application program included with Windows 2000 that allows the contents of the computer, the hierarchy of folders on the computer, and the files and folders in each folder to be viewed.

2) The left pane of the My Computer window, identified by the Folders title, displays in __________, or a ranked arrangement, the icons and folder names on the computer.

3) In the Folders pane of the My Computer window, folders called __________, are indented and aligned below a folder name.

4) In addition to folders and other files, the WINNT folder contains a series of predefined graphics, called __________, which can be used with application programs.

5) When you delete a file or folder on the hard drive using the __________ Windows 2000 temporarily stores the deleted file or folder here until you permanently discard the file or folder.

6) To the right of the sheet tabs at the bottom of the screen is the __________, which can be dragged to increase or decrease the view of the sheet tabs.

7) The menu bar that displays when Excel is started is the __________

8) When working with a chart sheet rather than a worksheet, the __________ displays with names that reflect charting commands.

9) When the mouse pointer is moved over a toolbar button or box, the name of the button or box displays below in a(n) __________.

10) The easiest way to __________ (make it active) is to use the mouse to move the block plus sign to the cell and then click.

True/False

Determine whether each statement is true or false. On the line following each question, write true (in blue) if it is true. If it is false, write false and rearrange the statement to make it true (in blue).

1) Microsoft Word makes it possible to access Web pages and search for information, design and publish Web pages on an intranet or the Internet, insert a hyperlink to a Web page in a word processing document, and retrieve pictures from other Web pages.

2) Databases provide scattered locations to store unrelated pieces of information.

3) The easiest method of navigating an intranet or the Internet is to use the Web toolbar.

4) Microsoft PhotoDraw 2000 is a business graphics software program that allows users to create eye-catching business graphics to be used in documents and presentations on the Web.

5) When Microsoft Outlook is started, the Personal Folders - Microsoft Outlook window displays with the current date, a list of scheduled events, a list of tasks to perform, and a summary of e-mail messages.

6) A new Excel workbook opens with three worksheets, but, if necessary, additional worksheets can be added to a maximum of 255.

7) A cell is referred to by its unique address, or cell reference, which is the coordinates of the intersection of a column and a row.

8) The menu bar, Standard toolbar, and Formatting toolbar display at the bottom of the screen just above the status bar.

9) When a menu name on the menu bar is clicked, a short menu displays listing the most recently used commands.

10) If the arrows at the bottom of a short menu are clicked, a full menu displays that lists all the commands associated with a menu.

Lab

The decision to purchase a personal computer in an important one-and finding and purchasing the right computer requires an investment of both time and money. In general, personal computers fall into three types: desktop computers, laptop computers, and handheld computers. Select one of these types of computers and shop for the best package deal. Many retailers offer software or additional hardware as a part of a package deal. Visit or call a computer store. Search the Web an online store. Look through the newspapers or magazines for retailers, and obtain prices for their latest computer package deals. Then, prepare a brief research paper (400-450 words) on the various computer deals and recommend the one you feel is the best buy for the price. Include at least two explanatory notes and three references, one of which must be a Web site on the Internet. Use the concepts and techniques presented in this project to format paper.

Mortimer’s Seaside Emporium

Monthly Accounts Receivable Balance Sheet

Problem: You were recently hired as a part-time assistant in the Accounting department of Mortimer’s Seaside Emporium, a popular Biloxi-based general merchandise company with several outlets along the Gulf coast. You have been asked to use Excel to generate a report that summarizes the monthly accounts balance. A graphic breakdown of the data also is desired. The customer accounts receivable data in the table below is available for test purposes.

Table 2-8 Accounts Receivable Data

CUSTOMER NUMBER	CUSTOMER NAME	BEGINNING BALANCE	PURCHASE	PAYMENTS	CREDITS	SERVICE CHARGE	NEW BALANCE
27839	Patel, Nipul	$2,356.15	4739.19	$175.00	$435.10
31982	Jaworski, Stanley	6,291.74	1,098.35	250.00	0.00
45012	Portugal, Juanita	4,103.75	620.75	4,000.00	25.00
56341	Country, James	5,691.45	4,352.12	250.00	35.25
76894	Santiago, Carlos	1,045.23	542.10	750.00	189.95

Use the following formulas to determine the monthly service charge in column G and the new balance in column H for customer 27839. Copy the two formulas down through the remaining customers.

a. Service Charge = 2.25% * (Beginning Balance- Payments-Credits)

b. New Balance = Beginning Balance + Purchases – Payments – Credits + Service Charge

Find the total, highest, and lowest for all six items.

Use the conditional formatting command on the format menu to bold the font and color the background orange of any cell in the range H4:H8 that contains a value greater than or equal to 3000.

When you are finished, save your work as “your First Name’s MidTerm Spg 03 and e-mail it as an attachment to:

cs4fmc@lycos.com