Digital Information Technology: Semester Exam Study Guide

What is a resume?

A written compilation of your education, work experience, credentials, and accomplishments that is used to apply for jobs.

A brochure is

Casual reading material on a company or topic

In a table, this is the intersection of rows and columns.

Cells

What does the acronym CPU stand for?

Central Processing Unit

In a table, these are vertical...

Columns

What is the Internet?

It allows us to access information and communicate easily with people around the world through e-mail, forums, and organizations like Facebook, LinkedIn, and Twitter.

What are some examples of output devices?

monitor, printer

What is a cover letter?

A letter that introduces yourself, explains your purpose for writing, highlights a few of your experiences or skills, and requests an opportunity to meet personally with the potential employer; it accompanies your resume.

What are the various domain types and what do they represent?

Ends with an extension of 2 or 3 characters. These characters can signify the country the domain name is associated with or the type of organization. .edu = educational website .gov = government website .org = organizational website .com = commercial website

Spreadsheet application software

Excel

What is a memo?

A form of written communication most effectively used when sent to a small to moderate number of people to communicate company or job objectives.

What can you purchase for about $10-$20 that plugs into a USB port to save data on?

Flash drive

Mathematical equations in Excel are call what?

Formulas

Where are computer files stored on a typical computer?

Hard drive; usually a C:drive (at home)

Parts of a business letter include...

Heading, inside address, greeting, body, complementary close, signature

What is DSL?

High speed internet connection using a satellite/phone line

In MS Word, which TAB would you use to edit font style, size, and color

Home tab

What are the 4 main items included in the job exploration process?

Application, cover letter, resume, follow up or thank you letter

Letters at the top of an Excel spreadsheet are labels for what?

Columns

The tone of an email should be...

Courteous and professional

How is a cover letter supposed to be written?

In proper business letter format.

What is the purpose of the central processing unit (CPU) in a computer system?

It is the "brains" of the computer. It processes data and carries out instructions given to the computer. It's speed is measured in gigahertz. Pentium chip, and Athlon are examples of CPUs.

When entering data into a spreadsheet, the terminology for text data is what?

Label

What does the acronym RAM stand for?

Random Access Memory

In a table, these are horizontal...

Rows

Numbers on the left of an Excel spreadsheet are labels for what?

Rows

When typing a mathematical equation in Excel, what is used as the multiplication sign?

Star symbol (located above the 8 on the keyboard)

What are some examples of input devices?

mouse, keyboard, scanner

File extension for Word documents

.docx

File extension for Excel documents

.xlxs

What is a virus?

A piece of computer code that attaches itself to a program or file so it can spread by traveling from computer to computer. May damage computer software.

What is a network?

Allows computers to exchange data. Interconnected computing devices exchange data with each other using a data link through cable media or wireless media.

What is a search engine?

Allows you to look for websites and information (Yahoo, Google, Bing, AOL, Ask)

What is a web browser?

Allows you to visit websites (Google Chrome, IE, FireFox, Safari)

What is a workbook?

An Excel file

What are peripherals?

Any auxiliary device such as a computer mouse, keyboard, or printer that connects to and works with the computer in some way.

Word processing application software

Microsoft Word

In MS Word, which TAB would you use to adjust page orientation?

Page Layout tab

In MS Word, which GROUP on the ribbon can you find alignment buttons?

Paragraph group

What is the purpose of a follow-up or thank you letter after an interview?

To thank the employer for the interview opportunity, and remind them of the conversation they already had with you, and your interest in the position.

When entering data into a spreadsheet, the terminology for numerical data is what?

Values

What does the acronym WAN stand for?

Wide Area Networks

What is the latest Microsoft operating system called for personal computers?

Windows

An example of application software would be _______________________.

Word, Excel, PowerPoint, video games, iTunes, etc.

MS Excel files contain what?

Worksheets