BA230 Final Exam

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

Which of the following is code for the color white?

#FFFFFF

Case 1 Dr. Haynes, the dean of the College Prep Department at XYZ Community College, wants to expand the department's visibility. She believes using the web is a good way to help students learn about the services offered by the College Prep Department. Dr. Haynes creates an ID called tutorservices. She then creates an internal link to the ID by selecting the text Tutors on the home page, then types ____ in the Link text box in the Property inspector.

#tutorservices

Which character is used to indicate an end tag?

/

The point at which the net present value of an investment equals _______ is the internal rate of return.

0

With the PMT function, the type argument is _______ when the payments are made at the end of each period.

0

Item ____ in the figure above is the active panel

1

The hexadecimal number system is based on ____.

16

Given the flowchart in the accompanying figure, the Perf Rating of _____ yields a Bonus value of 2500.

2

In the figure above, the number ____ points to the property.

2

In the image above, which number points lets you know that Borders is set to All sides?

2

Item ____ in the figure above is the opening head tag

2

In the figure above, item ____ points to the Collapse to Icons button.

3

Item 4 and item ____ in the figure above are both meta tags.

5

Item ____ in the figure above is the Unordered list button.

6

Item ____ in the figure above is the Ordered list button

7

What is the correct HTML for creating a hyperlink?

<a href="http://www.erau.edu">ERAU</a>

How can you open a link in a new tab/browser window?

<a href="url" target="_new">

What is the correct HTML for adding a background color?

<body style="background-color:yellow;">

What is the correct HTML element for inserting a line break?

<br>

The HTML code for a Heading 4 tag is ____.

<h4>

How can you make a numbered list?

<ol>

How can you make a bulleted list?

<ul>

The DB function used to calculate the declining balance depreciation has the following syntax: _______.

=DB(cost, salvage, life, period [month])

The complete formula that corresponds to the flowchart in the accompanying figure is _____.

=IF([Perf Rating]=1,0,IF([Perf Rating]=2,2500,7500))

Which of the following statements about CSS is false?

A Cascading Style Sheet file is an example of an interpolated file.

You could test two or more conditions and determine whether all conditions are true using the _____ function.

AND

The _____ function calculates the average of values in a range that match criteria you specify.

AVERAGEIF

The _____ function calculates the number of cells in a range that match criteria you specify

COUNTIF

_______ analysis expresses the relationship between a company's expenses, its volume of business, and the resulting profit.

CVP

CSS stands for ____________________.

Cascading Style Sheets

____________________ CSS styles are styles whose code is located within the head section of the HTML code of a web page.

Embedded

If Solver is taking too long to find a solution, you can halt the program at any time by pressing the _______ key.

Esc

A(n) _______ is a limit that is placed on a Solver problem's solution.

constraint

To perform a what-if analysis with more than two input cells, you _______.

create scenarios

Once you enter an array formula, Excel will enclose the formula in a set of _______.

curly braces

In the figure above, the number 1 points to the ____.

Selector name

_______ is a program that searches for the optimal solution of a problem involving several variables.

Solver

_____ references make it easier to create formulas that use portions or all of an Excel table because the names of headers are usually simpler to identify than cell addresses.

Structured

Case 8-1 Evaluate the formula =AND(G2="FT",M2>=1) based upon the information provided. What value is returned assuming that G2 contains the value FT and M2 contains the value 2?

TRUE

Who is making the Web standards?

The World Wide Web Consortium

Embedded styles are handy when you want a particular page in your website to contain formatting that is different from the rules specified in an external style sheet.

True

External style sheets can be used to apply consistent formatting to the elements of a website.

True

If both an external style and embedded style are applied to a single element, the embedded style overrides the external style.

True

If you want to ensure consistent formatting across all elements of a website, it's a good idea to use external CSS style sheets instead of HTML styles or embedded styles

True

Inline elements are normally displayed without starting a new line

True

You can use a _____ function to return a value from a table that is based on an approximate match lookup.

VLOOKUP

Case 10-1 You are planning to open a new restaurant and need to determine how many dinners need to be sold to stay above the break-even point. You will investigate Cost Volume Profit (CVP), also known as break-even analysis. In building an Income statement worksheet, you will calculate variable and fixed expenses based on number of meals sold. To explore the impact of changing different values in the worksheet, you can use _______.

What-If analysis

{=SUM(B1:B10*C1:C10)} is an example of a(n) _______.

array formula

When using VLOOKUP, the _____argument is optional.

range_lookup

src="images/parade.jpg" The figure above is an example of a(n) ____ path.

relative

Cascading Style Sheets are made up of sets of formatting attributes called ____.

rules

The item marked 2 in the accompanying figure is the _______ value.

salvage

When you extrapolate a series, the _______ value represents the amount that each value is increased or multiplied as the series is extended.

step

A scenario summary report's _______ layout makes it simpler to compare the results of each scenario, and the automatic formatting makes it useful for reports and meetings.

tabular

Using the VLOOKUP function, an exact match lookup occurs when the value entered must match one of the values in _____ of the lookup table.

the first column

In the function =CUMIPMT(rate, nper, pv, start, end, type), it is _______ that defines whether the payments are made at the beginning or end of each period.

type

In two-variable tables, you must always place a reference to the result cell in the _______ corner of the table at the intersection of the row values and the column values.

upper-left

In Solver, changing cells are sometimes referred to as _______ cells.

variable

A ____ is a particular way of displaying page content.

view

A ____ is a group of related web pages that are linked together and share a common interface and design.

website

Case 8-1 Evaluate the formula =AND(G2="FT",M2>=1) based upon the information provided. What value is returned assuming that G2 contains the value PT and M2 contains the value 2?

FALSE

If any logical condition listed in the function is true, the AND function returns a TRUE value.

FALSE

You can calculate the number of cells in a range that match criteria you specify using the SUMIF function

FALSE

The hexadecimal value of white is ____.

FFFFFF

____ is the protocol used for uploading and downloading files to and from a remote site.

FTP

An absolute path is a type of path used to reference web pages and image files within the same website

False

If you don't include a pv value, Excel assumes a future value of 1.

False

The advantage of using CSS is that all of your formatting rules are kept in each web page together with the HTML code.

False

When using CSS styles, the advantage of external styles is that you can use them to override an embedded style.

False

You cannot create a CSS style that redefines the body HTML tag.

False

Which property is used to force other page elements to display to the left or right of another page element/

Float

Options in the Property inspector change depending on whether the ____________________ or CSS button is selected.

HTML

The figure above shows the ____.

HTML Property inspector

What does HTML stand for?

Hyper Text Markup Language

The _______ function returns the amount of a particular payment that is used to pay the interest on the loan.

IPMT

To calculate the number of montly payments required to pay off a loan or meet an investment goal, use the _______ function.

NPER

All of the following are default predesigned Fluid Grid layouts except:

Notebook

The _____ function is a logical function that returns a TRUE value if any of the logical conditions are true and a FALSE value if all the logical conditions are FALSE

OR

The _______ function calculates the amount paid into an investment or loan during each payment period.

PMT

As shown in the accompanying figure, later payment periods apply more of the payment toward the _______.

Principal

____ a website means that you transfer all the files for the site to a web server.

Publishing

When an HTML file is linked to other files necessary to display page content, what do we call the files it links to?

Related files

The _______ function takes only these arguments: cost, salvage, and life.

SLN

The _____ function adds the values in a range that match criteria you specify.

SUMIF

When using CSS, what is the name of the tag to which the style declarations have been assigned?

Selector

The NPV function is used in calculating the net present value of a transaction, which is the _______ value of all the cash inflows and outflows in the investment adjusted by the time value of money.

current

An ____ CSS style is part of the individual page code and is written in the head section.

embedded

In the figure above, the three links in the Assets panel are ____ links.

external

To calculate a series of values from a starting point without a defined ending point, you have to _______ the values.

extrapolate

src="images/parade.jpg" In the figure above, item 1 refers to the _____________ .

folder name

The item marked 2 in the accompanying figure represents the _______ trend.

growth

An example of the code for an external link would be as follows: <a ____="http://www.adobe.com"Adobe website</a>

href

The item marked 1 in the accompanying figure is the _______ value.

initial asset

The items marked 1 in the accompanying figure are _______ cells.

input

To _______ a series, the cells between the first and last cells in the series must be blank

interpolate

As shown in the accompanying figure, a(n) _______ trend appears as a straight line.

linear

Before using Scenario Manager, you should assign _______ to all the input and result cells you intend to use in your scenarios.

names

The major difference between HLOOKUP and VLOOKUP functions is the way the lookup tables are _____.

organized

A(n) ________ is a tabbed window that displays information on a particular topic or contains related commands.

panel


Ensembles d'études connexes

The gettysburg address and definition

View Set

Chapter 1: Body Planes And Sections

View Set

Chapter 7 Section 1: Equal Justice under the Law

View Set

Evolve Wong's 11th ed - Chapter 03: Developmental and Genetic Influences on Child Health Promotion

View Set

Texas Real Estate Finance Part 2

View Set

Accounting Chapter 4: Cash and Internal Controls

View Set

Chapter 23 - Transferability and holder in due course

View Set