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
Colours can be created with values between 1-255 for each of the primary colours: Red, Green, and Blue.
True False
FALSE
because its 0-255 not 1-255
List four ways that white space can be added to an HTML webpage. Provide two that are HTML and two that are CSS.
Note for the CSS properties: top, right, bottom, and left for a property will be counted as one way, not multiple.
-<p>
-<br></br>
-margin
-padding
-
Which of the following are functions of a client? (you may select more than one)
Display HTML files
Request files through HTTP
Respond to HTTPs requests
Interpret HTML files
Functions of aclient:
Display HTML Files
Requests files through HTTP
interpret HTML files
Query strings typically appear as pairs of values, with each pair separated by an ampersand (&) and then the two values within the pair separated by a tilde (~).
True False
False
& seperates the pairs
= sepeartes values within the pairs
Putting your browser in private/incognito mode will: (you may select more than one)
Prevent cookies from being permanently saved.
Hide your browsing activity from your Internet Service Provider.
Not create any browsing history.
Make it impossible to track any of your browsing activity.
Prevent cookies from being saved
-not create any browsing history
look over this
Match the following:
__2__
Most popular programming language used within HTML. The client interprets and executes the code.
__3__
To insert code within an HTML document, the code is put inside of this tag.
__5__
The page is modified by the web server.
__1__
This element is designed for adding graphics in HTML
__4__
The page is modified by the web browser.
<canvas>
2.
JavaScript
3.
<script> 4. Client-side dynamic page 5. Server-side dynamic pag </script></canvas>
Three types of client server communication
1) Cookies
2) Query Strings
3) BAckground Communicatino
Which method of encryption involves certificates used in the train of trust?
Caeser’s cipher
Asymmetric Keys
One-Way Wave
Key Exchange
Assymetric
_______ are included to ensure there have not been any further changes to a message.
Cookies
Chrome bits
Time stamps
Packets
Time Stamps
4 ways to manipulate search results
1) Hidden text
2) Aggregators
3) comment links on trusted websites
4) Link farms
5) Google bombs
Application Rquests made by the kernel (kenrle manages resources and makes application requests
In addition to accessing peripherals, application requests also include:
Requesting more primary memory
Accessing files in secondary storage
Accessing websites and other networking tasks
Communication with other applications (e.g., sending messages)
Whats the difference between a cable modem, a modern modem and a phone
-phone uses the phone to connect toi interent adn needs a modem
-modern modem is ADSL
-cable modem uses television frequencies instead of phone
