NEW
Font size
S
M
L
XL
WorksheetsTA1: Microsoft Excel/ Google Sheets/ Forms/ Sites
Total questions: 74
Worksheet time: 2hrs 34mins
Name
Class
Date
1.
B1 is a?
a)
row
b)
column
c)
cell
d)
sheet
2.
The correct formula to add cell B1 and B2 is
a)
AddB1+C1
b)
=sum(B1+C1)
c)
=B1+B2
d)
=sum(B1-B2)
3.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
4.
What value would you get if you put in the formula: =A1*B1
a)
2
b)
3
c)
4
d)
Error
5.
All formulas in Google Sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
6.
What value would you get if you put in the formula: =B1+C1
a)
2
b)
3
c)
4
d)
Error
7.
What number should be in E1 (based on the formula shown)?
a)
1
b)
3
c)
5
d)
9
8.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A1+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
9.
Select ______________ from the functions drop-down menu to add a set of numbers together.
a)
average
b)
count
c)
max
d)
sum
10.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
11.
Text wrapping in Sheets means the text will be on more than 1 line within the same cell.
a)
True
b)
False
12.
What is the name of a vertical section of a spreadsheet as selected in the image?
a)
row
b)
cell
c)
column
d)
format
13.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
14.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
15.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
16.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
17.
Select ______________ from the functions drop-down menu to add a set of numbers.
a)
average
b)
count
c)
max
d)
sum
18.
Why would you want to change the column width?
a)
to make sure the title is visible
b)
to make sure headings are always visible
c)
to make sure all of the numbers are visible
d)
All of the Above
19.
If I want to add a Chart, one way is to select the ____________ tab.
a)
Home
b)
Insert
c)
Page Layout
d)
Data
20.
If I want to make a cell a particular color, which button would I click on?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
21.
SUM, AVERAGE, MAX and MIN are preset formulas on the _______________ menu.
a)
filter
b)
functions
c)
border
d)
fill color
22.
Which function would you use to add the values of several cells?
a)
SUM
b)
AVERAGE
c)
MIN
d)
MAX
23.
When calculating information on a Sheet, you should use
a)
pencil and paper
b)
a calculator
c)
your head
d)
a formula
24.
When there is a formula that can be reused, what should you do?
a)
Ask your neighbor for help
b)
Retype the formula
c)
Use copy and paste to save time
d)
Figure it out on paper
25.
What type of question allows you to select more than one answer?
a)
Paragraph
b)
Checkboxes
c)
Multiple Choice
d)
List
26.
Where does Google Forms store the data it collects?
a)
Docs
b)
Slides
c)
Sheets
d)
Excel
27.
Which of the following CANNOT be added to a Google Form?
a)
Images
b)
You Tube Videos
c)
Word Documents
d)
Sections
28.
Allows you to create simple or in-depth online surveys, polls, or questionnaires.
a)
Google Forms
b)
Paragraph Text
c)
Preview
d)
Text
29.
Allows multiple lines of text input (more than 50 words).
a)
Paragraph Text
b)
Multiple Choice
c)
Responses
d)
Color Palette
30.
Allows you to select one answer from a list of options.
a)
Multiple Choice
b)
Questions
c)
Responses
d)
Preview
31.
Allows single line text input (up to 50 words).
a)
Text
b)
Checkbox
c)
Google Forms
d)
Multiple Choice
32.
A type of FORM VIEW that allows you to see the different responses from the users
a)
Responses
b)
Color Palette
c)
Preview
d)
Questions
33.
A type of FORM VIEW that displays of the fields in a record that makes it easy to enter new data or to edit existing data or to choose actions.
a)
Questions
b)
Responses
c)
Checkbox
d)
Text
34.
A type of FORM VIEW that allows you to change the design and appearance of the FORM.
a)
Color Palette
b)
Multiple Choice
c)
Paragraph Text
d)
Preview
35.
Allows you to view the form as it would look “live”.
a)
Preview
b)
Checkbox
c)
Paragraph Text
d)
Questions
36.
Determines the overall design of the form.
a)
Survey
b)
Theme
c)
Time Stamp
d)
Sheet
37.
When viewing response data in a Google spreadsheet, _____.
a)
The data can be sorted
b)
The data must stay in the original format
c)
Each form question displays in the last row of the spreadsheet
d)
A time stamp for each response is automatically entered into row 1
38.
What is this icon/button for?
a)
Additional Gear
b)
Gear Icon for Adjusting Account
c)
Adjust the Gears of the Sheet
d)
Adjust Settings for Form
39.
Can you make all the questions in a form required?
a)
Yes
b)
No
c)
Sometimes
d)
Only if it is a quiz
40.
What is the definition of poll?
a)
Poll is a metal frame that holds up a roof
b)
Poll is a thin piece of wood that has been trimmed
c)
Poll is a form given that is short, fast, and general
d)
I'm not sure
41.
What is a survey?
a)
Survey is a form that is given that is specific and has many questions
b)
Survey is a number of connected items or names written or printed consecutively, typically one below the other.
c)
Survey is when you make a list
d)
I don't know
42.
How do you create a new question?
a)
by clicking on add item
b)
by clicking on add title and description
c)
by clicking on add image
d)
by clicking on add section
43.
How do you create a survey?
a)
by going to google drive, clicking on new, click more, click on google drawings
b)
by going to google drive, clicking on new, click more, click on google forms
c)
by going to google drive, clicking on new, click more, click on google maps
d)
by going to google drive, clicking on new, click more, click on google slides
44.
Allows a user to rate an answer.
a)
Short Answer
b)
Multiple Choice
c)
Scale
d)
Checkboxes
45.
In Sites, the text in a text box can be changed to which type of style:
a)
Title
b)
Heading
c)
Subtitle
d)
All of These
46.
In Sites, the theme impacts the font style and color scheme of the site.
a)
True
b)
False
47.
In Sites, you cannot rename the pages in your site after they are created.
a)
True
b)
False
48.
You can preview your Google Site in which of the following views?
a)
Phone
b)
Tablet
c)
Large Screen
d)
All of These
49.
In Sites, if you double click on a blank area of your web page, you get a shortcut menu for adding content.
a)
True
b)
False
50.
In Sites, the purpose of this button is to:
a)
Publish Your Site
b)
Turn off Visibility
c)
Preview
d)
Print
51.
You can hyperlink to another website from your Google website.
a)
True
b)
False
52.
You can add a live Google Form to your site.
a)
True
b)
False
53.
Your site can be made private or public.
a)
True
b)
False
54.
Google Sites will autosave.
a)
True
b)
False
55.
You can embed into your site:
a)
YouTube Video
b)
Google Map
c)
Google Calendar
d)
All of These
56.
You can align text and images by dragging and dropping in Google Sites.
a)
True
b)
False
57.
It is possible to share a Google Site with editing rights to others.
a)
True
b)
False
58.
The order of the pages can be rearranged by dragging and dropping them in the Pages panel.
a)
True
b)
False
59.
In the Insert panel, you can choose to add Docs, Slides, Sheets, Forms and Charts from the Google Docs section.
a)
True
b)
False
60.
This button will let you:
a)
Delete your Site
b)
Share your Site
c)
Preview your Site
d)
Print your Site
61.
You must give your site an address before you can publish it.
a)
True
b)
False
62.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
63.
To create a formula, you first:
a)
Select the cell you want to place the formula into
b)
Type the equals sign (=) to tell Excel that you're about to enter a formula
c)
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
d)
Choose the new command from the file menu
64.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
65.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
66.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
67.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
68.
Which of the following formulas is not entered correctly?
a)
=10+50
b)
=B7+B8
c)
=B7+14
d)
10+50
69.
Which of the following formulas will Excel not be able to calculate?
a)
=SUM(Sales)-A3
b)
=SUM(A1:A5)*0.5
c)
=SUM(A1:A5)/(10-10)
d)
=SUM(A1:A5)-10
70.
Columns go...
a)
Across
b)
Down
71.
Rows go...
a)
Across
b)
Down
72.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
73.
Which of these symbols is used for divide on a computer?
a)
\
b)
*
c)
/
d)
|
74.
Which of these formulas is the easiest way to find the correct average of the cells?
a)
=AVERAGE(A1:A10)
b)
=MEAN(A1:A10)
c)
AVERAGE(A1:A10)
d)
=(A1+A2+A3+A4+A5+A6+A7+A8+A9+A10)/10
Reset
