Review Questions from quizzes Flashcards
What would you use to solve for x in the equation xe-2x +4=9?
SUMPRODUCT
Scatter Plot
Numerical Filter
Goal Seek
Goalseek
What feature(s) are available for Pivot Charts and not Line Charts? (You can choose more than one answer)
Pivot charts automatically create a pivot table when added to a workbook.
Pivot charts allow you to plot several different series of data.
Filters can be easily applied to pivot charts.
1 and 3
Match each data type to the corresponding graph that is best used to display the data.
1) Column
2) Line
3) PIe
4) Scatter
Pressure at various ocean depths.
The price comparison of a new or used car by brand.
The amount of snowfall measured per month for a year.
The percent of pet owners that have a cat.
The number of vehicles on the road per year since 1970.
The percent of a monthly budget spent on different things.
Incorrect Response
The unemployment rates of men and women in various countrie
Match each data type to the corresponding graph that is best used to display the data.
__4__
Pressure at various ocean depths.
__1__
The price comparison of a new or used car by brand.
__2__
The amount of snowfall measured per month for a year.
__3__
The percent of pet owners that have a cat.
__2__
The number of vehicles on the road per year since 1970.
__3__
The percent of a monthly budget spent on different things.
Incorrect Response __4__ (1)
The unemployment rates of men and women in various countries.
Two advantages of pivot charts over regular
1) Pivot charts change right away as the pivot table changes, this mean that if dealing with a large amoutn of dynamic data, the achart will stay up to date
2) pivot charts allow modifications to be made easily, can apply filter,s change if something is a row or column very easy etc,
What are the three parameters of goal seek
1) Set cell (the cell u want to manipulate)
2) To value (the value u desire in the set cell)
3)By changing cell (the value that will change in order to get the set cell to be the desired value)
If you wanted your HTML page to display the ampersand symbol (&), which of the following would you code into your page?
&
&ersand;
&
∧
&
What is the primary purpose of the <!DOCTYPE html> at the top of an HTML file?
To communicate to the text editor that the file is an HTML file.
To tell the text editor to add the correct extension for an HTML file.
To tell the reader that they are looking at an HTML file.
To communicate to the web browser that the file is an HTML file.
To communicate to the web browser that this is a html file
How to link to another section within the same doc
use id, its an attribute
<body>
...
<h2>Introduction</h2>`
...
<a>return to the introduction</a>
</body>
The following will display Example Title in the title of your web browser:
<title><b><i> Example Title </i></b></title>
Hint: try it out in your own HTML file
True False
False
-it interprets it as plain text
How can you add whitespace to an HTML document?
<p>
<br></br>
All of the above
</p>
All
How to specify if i wante to use i in my list
<ol>
</ol>
how to link to a css file
<link></link>
Which of the following is the correct syntax to use a style attribute within a tag?
style=”font-size: 30px;”
style: font-size= 30px;
<font-size= 30px;>
style=”font size= 30px;”, “font style= italics”
style=”font-size: 30px”
What is the cascading behaviour rules
A style attribute has the highest precedence (or is the most specific).
An #id is considered the next most specific
A .class is the next most specific, and
A <tag> is the least specific</tag>
Given the following CSS:
p { color: green; }
.Raptors { color: red; }
#Toronto { color: yellow; }
and the HTML:
<p> What colour am I?
What will be the colour of the text?
Green
Red
Yellow
Blue
</p>
Yellow
bc the style attribute is talkingabout background colour not font
