WorksheetsSpreadsheet Vocabulary x2
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
How difficult was the Area Guide assignment this week?
(Easy = 1, Hard = 5)
(Easy = 1, Hard = 5)
a)
1
b)
2
c)
3
d)
4
e)
5
2.
The horizontal part of the worksheet identified by numbers is called a:
a)
row
b)
column
c)
cell
d)
range
3.
What does the word format mean?
a)
It is alphabetical or numeric text that will not be used in calculations.
b)
It means to change the shape, size, style, and general look of the text or doc.
c)
It stands for the numeric characters that can be calculated in a spreadsheet.
d)
It tells the software what to do with items in a formula.
4.
The vertical part of the worksheet identified by letters is called a:
a)
row
b)
column
c)
cell
d)
range
5.
The intersection where a row and a column meet is called a:
a)
cell
b)
sheet
c)
formula
d)
workbook
6.
One page in the spreadsheet is called a:
a)
cell
b)
worksheet
c)
formula
d)
workbook
7.
The computer will do the math for me, but I have to code the functions first in each cell.
a)
True
b)
False
8.
Spreadsheets are a good tool for organizing data.
a)
True
b)
False
9.
Spreadsheets are a good tool for word processing (typing paragraphs).
a)
True
b)
False
10.
What does data validation mean?
a)
allows you to create rules that limit what can be entered in a particular cell.
b)
a variety of color schemes that allows readers to easily see each row.
c)
changes how cells appear when values meet specific conditions.
11.
What does conditional formatting mean?
a)
allows you to create rules that limit what can be entered in a particular cell.
b)
a variety of color schemes that allows readers to easily see each row.
c)
changes how cells appear when values meet specific rules.
12.
Which element of the spreadsheet is most similar to a pixel in an image?
a)
row
b)
column
c)
cell
d)
formula
13.
Isaiah created a spreadsheet with the names of restaurants in his hometown. He is asking his friends to help him rate the restaurants. He wants to make sure that his friends can only enter "Great," "Average," or "Bad" as their rating. What should he do?
a)
Highlight the ratings column
b)
Freeze the header row
c)
Create a pivot table
d)
Use data validation
14.
Gabriel is creating a list of books on famous women tennis players. He included a summary of each book, but the summary text is long and runs off the page. Based on the image below, what should he do to make the summaries in column C readable in the spreadsheet below?
a)
Freeze the column
b)
Apply text wrapping to the column
c)
Insert a table
d)
Create a pivot table
15.
Susie is explaining to her classmate how to use the numbers in each cell to create a colorful image. What is the number or text in a cell called?
a)
value
b)
formula
c)
criteria
d)
format
16.
Which one of these is NOT a search engine?
a)
Bing
b)
Edge
c)
Yahoo
d)
Google
17.
Which one of these is NOT a web browser?
a)
Safari
b)
Yahoo
c)
Firefox
d)
Chrome
18.
What is a uniform resource locator?
a)
a URL
b)
a link
c)
the stuff in the address bar
d)
all of the above
19.
Geolocation is a process that enables apps and websites to record the EXACT location of a computer or mobile device.
a)
True
b)
False
20.
Search engines use text that is written and added to web pages, images, and files to find and show you results that match your search words. What is this text called?
a)
geolocation
b)
metalocation
c)
metadata
d)
geodata
100 %
