Upgrade to remove ads
Only $2.99/month

HTML

Terms in this set (186)

<!DOCTYPE>
First line in an HTML5 document. Tells web browsers that this document is an HTML5 document.
src=
Attribute used to provide the file name of an image
Ex: <img src="folder/img1.jpg alt="Picture of pix" title="The Picture" />
<head>
This tag contains information about the document -
contains metadata, information, and instructions to the Web browsers & Search Engines
<h1>
c
<h6>
This tag defines the smallest heading
<a>
This tag is used to create links
Ex: <a href= http://www.sfasu.edu/> SFA</a>
<em>
This tag is used to create links
Ex: <a href= http://www.sfasu.edu/> SFA</a>
<li>
Each item in an ordered list or unordered list must use this tag
Ex: <ul>a list
<li> list item one </li>
<li> list item two </li>
</ul>
<br/>
This tag creates a line break
<hr/>
This tag creates a horizontal line across the page
style=
Attribute used to control the appearance of an element; specifies the inline style for an element
Ex: <h1 style="font-size: 350%"> Headline for the Page</h1>
<body>
All of the content to be displayed on the page is in this tag
<html>
This tag marks the start of a web page document
<img/>
This tag allows you to add a picture to your web page
Ex: <img src="folder/img1.jpg alt="Picture of pix" title="The Picture" />
<blockquote>
This tag creates an indented block
<q>
Quoted text
Ex: <q cite= "Hamlet">To be or not to be...</q>
href=
Attribute used provide the URL for a hyperlink
Ex: <a href= http://www.sfasu.edu/> SFA</a>
<ol>
This tag creates a list with numbers
Ex: <ol>a list
<li> list item one </li>
<li> list item two </li>
</ol>
<ul>
This tag creates a list with bullets
Ex: <ul>a list
<li> list item one </li>
<li> list item two </li>
</ul>
<p>
This tag creates paragraphs
Ex: <p> A statement to be displayed on the pages </p>
<!-- -->
Use this tag to add comments to your web page
Ex: <!-- last updated on 11/30/2011 -->
alt=
Attribute used provide text when an image cannot displayed & readers read this to the users who do not see the pages
Ex: <img src="folder/img1.jpg alt="Picture of pix" title="The Picture" />
<title>
Defines the title;shows on the tab - not on the web page
title=
An attribute that creates a tool tip - a text box that appears as the user's mouse hovers over it
Ex: Monet's <cite title= "Claude Monet"> Water Lilly</cite> is one of the most famous works of art.
<address>
Defines contact information in a document
Ex: <address> SFA, 1936 North Street, Nacogdoches TX 75964 </address>
<cite>
Defines a title to a work - a work of art, a book, an art piece, ...
<dd>
Defines a description of a term in a definition list
Ex: <dl>
<dt>Network</dt>
<dd>structure linking computers together for the purpose of sharing resources </dd>
</dl>
<strong>
Defines the text to be bolded
Ex: <strong>Study</strong> for the Final Exam!
<dl>
Defines a definition list
Ex: <dl>
<dt>Network</dt>
<dd>structure linking computers together for the purpose of sharing resources </dd>
</dl>
<dt>
Defines a term (an item) in a definition list
Ex: <dl>
<dt>Network</dt>
<dd>structure linking computers together for the purpose of sharing resources </dd>
</dl>
<meta/>
Defines metadata about an HTML document
Ex: <meta name= "author" content= "AME" />
<sub>
Defines subscripted text
Ex: In that equation, x<sub>1</sub> equals 10
<sup>
Defines superscripted text
Ex: 2<sup>2</sup> is 4
<table>
defines a table
Ex: <table>
<tr>
<td>Zoom-Zoom</td>
<td>Mazda's advertisement</td>
</tr>
</table>
<td>
Defines a cell in a table
<th>
Defines a head content in a table
<tr>
Defines a table row
id=
Specifies a unique id for an element
Ex: <h1 id= "top"> Headline</h1>
<abbr>
Describes and abbreviated phrase; informs search engines
Ex: The <abbr title= "United States">US</abbr> is in North America.
text-align
Horizontally aligns the contents of an element
Ex: <p style="text-align: center"> In the center. </p>
Color
Sets the text color of an element.
Ex: <p style="color: purple"> Purple colored letters!</p>
font-size
Sets the text size of an element.
Ex: <p style=" font-size:200%">Bigger than normal font!</p>
background-color
Sets the background color of an element.
Ex: <p style=" background-color: purple">Purple background.</p>
font-family
Sets the background color of an element.
Ex: <p style=" background-color: purple">Purple background.</p>
Which function calculates the payment of a loan based on constant payments and a constant rate?
pmt

=PMT(rate, nper, pv)

ex:=PMT(D32/12, D33*12, -D34)
Which function should you use to find the mean of a list of values?
average

=AVERAGE(range)

ex:=AVERAGE(A1:A150)
Which function should you use to find the middle value in a list of values?
median

=MEDIAN(range)

ex:=MEDIAN(A1:A150)
Which function should you use to count the non-empty cells?
counta

=COUNTA(range)

ex:=COUNTA(A1:A150)
Which function should you use to find the most frequently occurring number in a list (or range) of numbers?
mode

=MODE(range)

ex:=MODE(A1:A150)
Which function should you use to change the contents of a cell based on a condition or criteria?
if

=IF(logical test, [true value], [false value])


ex:=IF(B3>100, "yes", "no")
Which function should you use to have information returned from a table?
vlookup

=VLOOKUP(lookup value, table array, col_index_number)

ex:=VLOOKUP(E6, $J$7:$K$12 ,2)
What feature should you use to change the appearance of a cell based on a criteria?
conditional formatting
Which function should you use to eliminate the decimal portion of a number?
trunc

=TRUNC(number)


=TRUNC(85.236515)
Which function should you use to display the date and time?
now

=NOW()

ex:=NOW()
Which function should you use to find the lowest number in a range?
min

=MIN(range)

ex:=MIN(A1:A150)
Which function should you use to find the highest number in a range?
max

=MAX(range)

ex:MAX(A1:A150)
Which function should you use to display the date?
today

=TODAY()

ex:=TODAY()
Which function should you use to count cells based on a criteria?
countif

=COUNTIF(range, criteria)

ex:=COUNTIF(A1:A150, criteria)
Which function should you use to return the sum of the products of corresponding ranges or arrays?
sumproduct

=SUMPRODUCT(range, range)

ex:=SUMPRODUCT(C1:C4, D1:D4)
Which function should you use to count the number of cells in a range that contain numbers?
count

=COUNT(range)

ex:=COUNT(A1:A150)
Which function should you use to format that number to a specified number of digits?
round

=ROUND(number, number)

=ROUND(56789.35684, 2)
What feature should you use to find the right input when you know the result you want?
goal seeking
Which function should you use to join several text strings into one text string?
concatenate

=CONCATENATE(text1, text2, [text3])


=CONCATENATE(S24, ", ", S23)
A cell's unique address is its ________.
cell reference
The default view
normal view
Text is ____ aligned.
left
Numbers are _____ aligned.
right
Which feature would you use to join several selected cells into one cell?
merge
A prewritten formula that is built into Excel is a _______.
function
Which feature would you use to check which cells are references in the formula assigned to the active cell?
range finder
______ allows you to select cells for use in a formula by using a mouse.
point mode
Which format would you use to have a fixed dollar sign?
accounting
Which format would you use to have a floating dollar sign?
currency
Which view allows you to create or modify a worksheet while viewing how it will look in printed format?
page layout view
How do you display the formulas version?
[ctrl]+[accent mark]
The data is cleared and the format is reset to the default when you _______ a cell.
move
The data and format remain intact when you _____ a cell.
copy
A row is inserted ______.
above
A column is inserted _________.
to the left
Which feature would you use to keep the titles on the screen no matter how far you scroll down or to the right?
freeze titles
freeze panes
A date is just a _____ since 1/1/1900
number
Which addressing mode would you use to keep the column and row the same as you copy the formula?
absolute
Which address mode would you use to keep the column the same as you copy the formula?
mixed
Which addressing mode would you use to adjust the column and row as you copy the formula?
relative
Which feature would you use to scrutinize the impact of changing values in cells that are referenced by a formula in another cell?
what if analysis
What is the small black square located in the lower-right corner of an active cell?
fill handle
Headline
the first line of a flyer/document that conveys the idea of the document
Zoom slider
visually increases or decreases the document's size; no effect on the printed document
Insertion Point
the blinking vertical bar that indicates where text, graphics, and other items will be inserted
Print Layout View
default view in Word
Formatting Mark
a nonprinting character, a character that shows spaces, returns, tabs, ...
Wordwrap
allows you to type words in a paragraph continually without pressing the Enter key at the end of the line
End
to the end of the line
Home
to the beginning of the line
Ctrl+Home
to the beginning of the document
Ctrl+End
to the end of the document
Font
the typeface; the defined appearance and shape of letters, numbers, and appearance
Point
how font size is measured
Theme
a set of unified formats for fonts, colors, and graphics
Shift+*
select adjacent items
Ctrl+*
selects nonadjacent/noncontiguous items
mini toolbar
a transparent menu that appears when you select a word or group of words to format
select a line
point to the margin left of the line
select a paragraph
triple click in the paragraph
select a sentence
Ctrl+click
select a word
double click
Word Help
Where to find answers to questions and displays information about various topics
document properties
metatdata, information about the document's author, title, subject, and keywords
found on the File tab's Info tab also
Normal Style
the default style of the Word document
Line Spacing
the amount of vertical space between lines of text in a paragraph
Paragraph Spacing
the amount of space above and below a paragraph
Header
is text and graphics that print at the top of each page in a document
Footer
is text and graphics that print at the bottom of each page in a document
Click and Type
Word's feature to format and enter text, graphics, and other items; use by double clicking in a black area of the document
Shortcut Keys
keyboard key combinations for convenience while typing
Autocorrect
Word feature that automatically corrects typing, spelling, capitalization, or grammar errors
Footnote
Explanatory note at the bottom of the page
Endnote
Explanatory note at the end of the document
Works cited
a list of sources that are referenced directly in a research paper
soft page break
automatic page break
hard page break
a manually entered page break
Hanging Indent
a paragraph style where the first line begins at the left margin and subsequent lines are indented one-half inch from the left margin
copy
placing items on the clipboard
paste
copying an item from the Clipboard into the document at the location of the insertation point
Navigation Pane
a window that enables you to search for text in a document, browse through pages in the document or browse through headings in a document
Thesaurus
book of synonyms
clear formatting
returning the formatting to the Normal style
AutoFormat
Word feature that automatically formats text for you as you type it
Template
a document that includes prewritten text and/or formatting common to documents of the specified type
Quick Styles
Word's built-in, or pre-defined styles to format text
Data Code
checking the Update Automatically box so that everytime the document opens, it reflects the current date
Building Block
frequently used text or graphics stored as a block entry for easy insertion into the document
Building Block vs AutoCorrect
user instructs when to insert a Building Block, AutoCorrect automatically replaces it
nonbreaking space
a special character that prevents 2 or more words from splitting at the space
nonbreaking hyphen
a special character that prevents 2 or more words from splitting at the hyphen
Table
a collection of rows and columns
cell
the intersection of a row and column
dimension
the total number of rows and columns of a table
merge cells
a single cell that spans rows and/or columns
split cells
a single cell that is made into multiple cells
small caps
letters that look like capital letters but are not as tall as a typical capital letter
multilevel list
a list that contains several levels of list items, with each lower level displaying a different numeric, alphabetic, or bullet character
gridlines
show cell outlines on the screen, they do not print
Watermark
faint text and/or graphics that display behind all the text and graphics in a document
resume
a document that contains personal information, educational background and job experiences
content control
an object that contains instructions for filling in text and graphics; your typing replaces the instructions in the control
placeholder text
indicates where text can be typed
AutoComplete
Word's feature to predict the word or phrase you are typing and display its prediction in a ScreenTip
line break
advances the insertion point to the beginning of the next physical line, ignoring any paragraph formatting
PDF
Portable Document Format; to view the document requires a program called Adobe Reader
XPS
XML Paper Specification; an electronic image of the document; viewed on XPS Viewer
Mail Merge
blending the main document with the data source to generate a series of individual letters
Mail Merge Task Pane
a wizard that guides you step-by-step through the merging process
data source
a file that contains data
record or data record
a row in a data file/source
header record
identifies the name of each column
data field
each column in the data file/source
field name
the unique identification of a column in the data file/source
merge fields
field names linked to the data source
merge field characters
the chevrons that mark the beginning and end of a merge field
AddressBlock merge field
several fields that relate to an address
GreetingLine merge field
fields that relate to a salution
If...Then
if a condition is true, then perform the action
iF...Then...Else
if a condition is true, then perform the action, else perform a different action
Condition
consists of an expression, followed by a comparison operator, followed by a final expression
expression
the if... then(... else) condition to evaluate
comparison operator
the mathematical operator to compare: =, <>, <, <=, >, >=
Directory
a single document that displays all the data records of the data source
convert text to table
converts the selected text into a table, splitting the text into columns at each comma, period, or other specified character
home tab
the primary tab that contains the most frequently used commands
shortcut menu
appears when the user right-clicks an object
serif
a Font family that incorporates semi-structuctural details on the ends of some of the characters that make up its letters and symbols
sans-serif
a Font family that does not incorporate serifs on its characters
gallery
set of choices, often graphical, arranged in a grid or list
quick access toolbar
located above the Robbin by default, provides easy access to frequently used commnds that the user can customize
status bar
presents information about the document, the progress of current tasks, and the status of certain commands; located at the bottom of the document window
dialog box launcher
the small arrow in tehh lower right corner of some groups
task pane
a window that can remain open and visible while you work in the document
format painter
Home tab àClipboard; quickly applies the format where the insertion point is to the selected text
comments
Review tab àComments; allows you to add a note about the selected text
contextual spelling errors
indicated by a blue wavy line
words not in the dictionary or misspelled words
indicated by a red wavy line
grammar error
indicated by a green wavy line
overtype mode
replaces text with newly typed text
insert mode
inserts text to the left of the insertion point; text to the right moves to the right and downwards to fit the new text in
toggle key
allows the user to switch, or toggle, between two different modes
THIS SET IS OFTEN IN FOLDERS WITH...