Font size
WorksheetsSpreadsheet and Productivity Practice
Total questions: 61
Worksheet time: 30mins
A formula must always start with this. It tells Excel to perform a calculation.
plus sign
minus sign
equal sign
* sign
The numbers in a cell can be used in calculations.
value
cell
word book
cell address
Identified by letters at the top of the spreadsheet - vertical arrangement (up and down).
rows
columns
sides
back
This is the area (row and column intersection) of a spreadsheet that is currently active. Information will appear here when a key is typed.
spreadsheet
workbook
label
sign
Identified by numbers on the left side of the spreadsheet - horizontal arrangement (left to right).
column
bottom
row
side
A software application you can use to enter all sorts of data and perform mathematical calculations.
Microsoft Word
Android
Spreadsheet
Microsoft Excel
Locations on a spreadsheet, identified by the column letter and the row number - for example: A1.
Spreadsheet
Cell reference
Cell range
Active cell
The interception of a row and column.
Cell address
Cell
Cell reference
Column
A series of data put together to perform calculations.
subtracting
addition
calculations
formulas
adds all the numbers in a range to provide a total
Subtracting
Sum
/
*
In a calculation which symbol divides a number
/
+
*
#
In a calculation in which symbol multiples a number
/
-
*
+
A spreadsheet can have multiple pages called ______. The name of each page is found on a tab at the bottom of the screen.
Sheets
Tabs
Columns
Rows
This adds a dollar sign, a decimal, and two zeroes to the selected cells.
Currency button
Share button
Border button
Freeze button
alerts Google Sheets that you are entering a formula or function and not text
number button
equal sign
fill handle
share button
Allows users to insert charts into a spreadsheet and customize the charts.
insert link button
comment button
text color button
insert chart button
Used to merge two or more cells into one.
Bold button
Italics
Paint format button
Merge button
A group of adjacent cells you select to perform operations on all of the selected cells.
Cell range
Cell address
Fill handle
Merge
The column letter followed by the row number is used to reference a cell. Example B3
Cell range
Cell address
Header
Footer
A bar that you use to enter and edit formulas in a spreadsheet.
Cell range
Cell reference
Active cell
Formula
A productivity tool that helps you produce an effective slides on-screen
spreadsheet
document
presentation
database
A productivity tool that allows users to create, edit, and print documents.
spreadsheet
presentation
word processor
graphics software
A ___________ IS AN EQUATION TO SOLVE A MATHMATICAL PROBLEM.
FUNCTION
FORMULA
CELL
ROW
This language _______________was developed by ___________
Hyper Text Mark up Language, Laudon
Hyper Text Make up Language, Tim Berners Lee
Hyper Text Mark Up Language, Tim Berners Lee
All HTML Tags are enclosed in ____________
# and #
? and !
< and >
{ and }
This language _______________was developed by ___________
Hyper Text Mark up Language, Laudon
Hyper Text Make up Language, Tim Berners Lee
Hyper Text Mark Up Language, Tim Berners Lee
All HTML Tags are enclosed in ____________
# and #
? and !
< and >
{ and }
Which element should be at the start and the end of every .html file?
<html></html>
<body></body>
<head></head>
<title></title>
What does HTML stand for?
(a)
How many levels of headings are available to use in HTML?
6
1
2
10
Which element would I use to make a level 3 heading
<h1>
<h3>
<heading>
<heading3>
What would we use the <p> element for?
Paragraph
Picture
Passage
Which list would we use for a how to guide
Ordered List
Unordered list
Definition List
Which would be the correct code to implement an unordered list?
<ol>
<li>...</li>
<ol/>
<ul>
<li>...</li>
<ul/>
<uol>
<li>...</li>
<uol/>
<li>
<ul>...</ul>
<li/>
What does HTML stand for ?
Hyper Text Markup Language
Home Tool Markup Language
Hyperlinks and Text Markup Language
Choose the correct HTML element for the largest heading:
<head>
<heading>
<h6>
<h1>
How can you make a numbered list?
<ol>
<ul>
<dl>
<list>
Which HTML element defines the title of a document?
<head>
<title>
<meta>
sets the color of words in a paragraph
h1 {
color: pink;
}
img {
color: pink;
}
body {
color: pink;
}
p {
color: pink;
}
Select the rule set to make all the text in your web page blue and centered.
p {
color: blue;
}
body {
text-align: left;
color: blue;
}
p {
text-align: center;
color: blue;
}
body {
text-align: center;
color: blue;
}
Which rule set would change the font size to 24?
font-size: 24
size: 24;
font-size: 24;
font size: 24;
This is a picture of a ____.
CSS Rule
HTML Rule
Tags
Coding
The blue is called an _____________
Declaration
Selector
Property
Value
The blue is called an _____________
Declaration
Selector
Property
Value
The blue is called an _____________
Declaration
Selector
Property
Value
Which of the following is the last tag in an html document?
</end>
</body>
</footer>
</html>
Which of the following tags would create the largest heading?
h2
h3
h4
h6
HTML uses _____ to organize information.
Tabs
Tags
Labels
Quotes
This tag tells the computer this is a document written in HTML.
<p>
<!DOCTYPE html>
<h1>
<html>
This tag indicates the beginning of your code written in HTML.
<li>
<!DOCTYPE html>
<html>
</html>
This tag contains all the main contents of your webpage.
<body>
<head>
<contents>
<p>
These tags define the start & end of a paragraph. Paragraphs are blocks of text on your web page.
<p>
<P>
</p>
<h1>
This tag defines a heading at the smallest size.
<h6>
<h2>
<h7>
<h1>
This tag defines a heading at the largest size.
<h1>
<h20>
<h3>
<h2>
This file name is used for the main page of your website.
main.html
index.html
start.html
mysite.html
A software development technique in which two programmers work together at one workstation.
pair programming
partner programming
team programming
solo programming
