BA230 Final Exam
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
