MIS exam 3 review

Anything of value that is owned by an individual.

Asset

Focusing on the desired outcomes of your presentation forces you to make it more _____.

Audience oriented

When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference.

!

When you reference a cell or range in a different worksheet, the ___________ separates the sheet reference from the cell reference.

!

Net income is $4,000 a month. You should PYF 20% each month for savings. What is the amount?

$800

Careers

-Financial careers (accounting or finance) -Procurement (supply chain) -Chem HQ (supply chain) -ExxonMobil IT( EMIT)

Why exxon?

-Work and live programs -Health, savings, retirement -Base salary -Diverse workforce -Employee resource groups

The internet started in ________.

1969

What portion of the world's population uses the internet in 2019?

56%

The 7x7 rule refers to a presenter having no more than ________.

7 bullet points per slide, 7 words per bullet

Describe what is meant by database.

A persistent and organized store of data

To select adjacent sheets in a workbook, use:

SHIFT.

What language do database use to search (query)?

SQL

A _____ is an information system that enables users to retrieve data from the Web by using keywords related to their topic of interest.

Search engine

A query is when you:

Search the database

The worksheet range ____ references the worksheets, "Sheet1", "Sheet2", "Sheet3", and "Sheet4".

Sheet1:sheet4

To select adjacent cells or worksheets, can use the ________ key.

Shift

When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ___

Single quotation marks

Who invented the world wide web?

Sir Tim Berners-Lee

When you link an object, a direct connection is created between the __________ and the destination programs.

Source

SQL stands for?

Standard Query Language

The following are Excel-supported error alert types: _____.

Stop, Warning, and Information

Protecting the __________ of a workbook prohibits users from renaming, deleting, hiding, or inserting worksheets.

Structure

Adding a __________ sheet helps sum values up from multiple sheets of the same structure over time.

Summary

In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only text of a specified number of characters.

Text Length

If an Excel table is embedded into a Word document, what happens when the Excel table is updated?

The word document does not change

If an excel table is copy+pasted into a word document, what happens when the excel table is updated?

The word document does not change

________ invented the world wide web.

Tim Berners- Lee

Some websites use a 'cookie' to save data on your computer. Why might they want to do this?

To show you adverts, to track what you looked at, so you don't have to log in again.

By grouping 12 sheets of the same structure, you can run calculations once instead of 12 times.

True

Delete a value from ONE grouped sheet, cell contents will be deleted from ALL sheets.

True

If you delete a value from one cell in a worksheet group, the content is also deleted from the same cell in all the worksheets in the group.

True

If you delete a value from one cell, the content is also deleted from the same cell in all the worksheets in the group.

True

Once you group a collection of worksheets, any changes you make to one worksheet are applied to all sheets in the group.

True

The Stop alert prevents an entry from being stored in the cell.

True

The formula entered in the Paris sheet shown below will also appear in all sheets in the selection.

True

Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.

True

A(n) _____ identifies a Web page and is the address of a document or site on the Internet.

URL

A(n) ________ is the common name of the location of a document or site on the internet.

URL

A/an _______ is a common word you type into a web browser to find a website.

URL

To create a macro, you can enter a series of commands in the _____ programming language.

VBA

The Excel data _____ feature restricts data entry to follow a defined set of rules.

Validation

The excel data _______ feature restricts data entry to follow a defined set of rules.

Validation

A _________ expense and income that change over time.

Variable

To save a workbook with macros, the default Excel Workbook format needs to change to a macro-enabled workbook, which has the _____ file extension.

Xlsm

If you do not want your inserted content to update automatically when you edit the source, you should _______.

Copy/paste or embed.

Intranets are also called _____.

Corporate portals

Money granted as a loan that creates debt.

Credit

Press and hold down the ______ key, and click the worksheet tabs you want to select. (Highlight.png)

Ctrl

Relational database help to reduce:

Data redundancy

Text, Integer, Decimal, Boolean are all examples of which of these?

Data type

A collection of related tables is called a __________.

Database

What does DBMS stand for?

Database Management System

An obligation to repay borrowed money.

Debt

Which US organization designed ARPAnet - the precursor to the internet?

Dep. of defense

To customize theme colors, click the ________ tab.

Design

You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the _____ tab.

Developer

_____ are unique identifiers of computer or network addresses on the Internet.

Domain names

How do you ensure data stolen by hackers can't be read easily?

Encrypt it

The net and the web are the same thing.

False

A column heading in the database table is called a _________.

Field

A ________ expense and income that do not change over time.

Fixed

A worksheet _________ is a collection of two or more selected worksheets.

Group

_________ multiple sheets allows you to quickly process data based on the same structure.

Grouping

When you import a formatted Word outline, each heading formatted with the ________ style in word becomes a slide title.

Heading 1

To create a link, on the ribbon, click the _________ tab, and then in the Links group, click the Hyperlink button.

INSERT

The internet is a collection of:

Millions of computers

The _____ dialog box displays all of the names in the workbook.

Name Manager

Total value of a person's assets minus their liabilities.

Net worth

When you _____ a workbook, you control the ability users have to make changes to the file.

Protect

Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets.

Ranges

Two or more tables linked together by common attributes is called a:

Relational Database

Text size can indicate ___________.

Relative importance

They said that ______________ is key to success because they prepare you very well.

Rockwell career center

Why do you need a Primary Key in a database?

Because you must have a unique identifier

Personal finance is about 80%__________?

Behavior

A monthly plan for how you are going to save and spend income.

Budget

One way to make sure you have enough money to cover your needs and wants is to create a __________.

Budget

To select nonadjacent cells worksheets, you use the __________ key.

CTRL

To select non-adjacent sheets in a workbook, use:

CTRL.

Presentations created and presented by a team of people are referred to as _________ presentations.

Collaborative

The cost of goods and services.

Expenses

A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks.

External

The Federal Express Tracking System allows customers to enter a package's tracking number and locate any package still in the system as well as prepare and print shipping forms, get tracking numbers, and schedule pickups. Federal Express is an example of a(n) ____.

Extranet

A(n)__________is a secure network that uses the Internet and Web technologies to connect intranets of business partners so that communication between organizations is possible.

Extranets

James gets a job at a multinational corporation. On his first day at work, he finds out that the numerical code assigned by the Internet Corporation for Assigned Names and Numbers (ICANN) to his computer system is 115.248.178.233. This numerical code is referred to as a(n) _____.

IP address

The numerical location of a website is:

IP address

Which of the following is/are not mentioned the Bad Email Reply - What not to say to your professor..."video?

Inappropriate Photos

When you build a worksheet for other users, you may decide to add a(n) _____ message to a cell even if you do not validate the data in that cell.

Input

When you build a worksheet for other users, you may decide to add a(n) _________ message to a cell even if you do not validate the data in that cell.

Input

Companies like Verizon, Comcast, and AT&T are called:

Internet service providers(ISP)

Which of these is not a real web browser?

Internetium

Money put into an account intended for growth over time.

Investments

Once you have determined your focus, the next step is to identify the ___________ of your presentation.

Key points

Which of the following are used as common fields across tables so that fields can be accessed, organized, and manipulated in access?

Keys

Anything you owe; a debt.

Liability

A/an _______ automates data processing.

Macro

The best way to automate the creation of donor letters with different names and addresses is through:

Mail merge

Web pages are constructed using a language called HTML. What could you use the <b> "tag" for?

Making some text bold

You want to budget your monies coming in and monies going out. The best software to use is ___________.

Microsoft Excel

Meta-Four Houston's performance illustrates the impact of:

Our phones and the internet on our critical thinking capabilities

Nima wants to create a hyperlink to a location in her current workbook. She clicks the Hyperlink button in the Links group on the Insert tab. What option should she select from the Link to list?

Place in this document

There are three stages to developing a presentation: planning, creating, and _________.

Preparing your delivery

What is a foreign key?

Primary Key in another table

The "Lightbeam for Firefox" video reminds us to be mindful of our ______ as we interact with websites.

Privacy