stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Google Sheets With LHSS Flashcards | StudBud
Explore
/
Google Sheets With LHSS
Google Sheets With LHSS
29 terms
·
StudBud Administration
·
6 plays
A #computers #googlesheets
Flashcards
29 cards
F
Practice quiz
P
Host live
L
Questions
29
Answers
1
A _______ is the intersection of a row and a column. (Hint: The box outlined in blue)
coordinate
form
box
cell
2
The fill ______ can be used to continue a
series
by guessing what should come next .
handle
drag and drop
3
To move a range of data from one column to another you might use.
drag and drop
handle
4
What is this cell called (its address)?
A1
1A
B2
A4
5
_______ allows you to customize the
look
of your spreadsheet, making it easier to understand.
Functions
Formatting
Text
Margins
6
How do you
Freeze
a row or column?
Insert-Row Above/Below
Data-Filter
Edit - Column Right/Left
View-Freeze
7
Is it important to follow the
order of operations
when creating a formula?
Yes, or Sheets will not calculate the results accurately.
No, Sheets will automatically put it in order.
Yes, or Docs will not calculate the results correctly.
IDK?????
8
In the picture shown, what do each of the different colored dotted lines represent?
vibes
math operations
functions
ranges
9
What menu item is highlighted?
merge
undo
copy
fill
10
What can be modified with this drop-down menu?
cell borders
cell color
font
text alignment
11
In a spreadsheet, letters stand for _____ while numbers stand for_____.
columns, rows
rows, columns
12
The name of a cell (for example, A1) is its cell ________.
heading
address
location
content
13
What can be modified with this drop-down menu?
text alignment
cell borders
cell color
font
14
Which function would you use to
add
the values of several cells?
AVERAGE
MAX
MIN
SUM
15
When you highlight multiple cells that is called a ______.
column
sort
group
range
16
Which of the following features allows you to narrow down the data in your worksheet?
data
filters
cells
functions
17
A function is like a math ______.
word problem
operation sign
equal sign
formula
18
Which of the following are recognized as mathematical operators within Google Sheets?
+
^
*
/
19
What is a function?
predefined formula that performs calculations.
Sorts info using specific values in a particular order.
20
Sorting a range will not affect other content on the worksheet.
False
True
21
The cursor will turn into a
double arrow
when you ....
modify the width of a column.
modify the height of a row.
add data (text) to a cell.
drag and drop a range from one column to the next.
22
If you have too much cell content to be displayed in a single cell, you may...
wrap text
unmerge cells
protect the cells
modify a cell's row height
23
What can be modified with this drop-down menu?
text alignment
cell borders
cell color
font
24
Can you filter for more than one thing?
Yes
No
25
By ____, you are able to scroll through a spreadsheet while continuing to see the header cells.
merging rows or columns
freezing rows or columns in place
26
Oops, need to add a row to the top of you sheet. What menu option should you use?
File-Save As
Insert - Row Below
Insert-Row Above
Edit-Delete Row
27
This picture shows...
how to rename a Google Sheet.
how to save a Google Sheet.
Did we learn this?????
how to start a new Spreadsheet (Google Sheet).
28
What does
sort
do?
Organizes all of the data from least to greatest.
Organizes the data by date it was typed.
Organizes the data in all columns into alphabetical order.
Organizes all of the data in your spreadsheet by one column.
29
What does the SUM function below do?
divides the numbers
Subtracts all the numbers
Takes the average of the numbers
Automatically adds all the numbers together
