Module 2 Quiz 1
When you copy a document, the default name of the new document is:
Copy of + File Name
To access the color options for a tab, click on the down-pointing arrow in the tab, and then choose "Change color".
True
When you mouse over the square at the bottom of the data cell, the cursor turns into:
a crosshair
Copy = Ctrl+_____
c
When you see the hand cursor, clicking once will make the hand __________.
close
"Any data in your cell can be turned into an _____ link."
external
When you turn text into a link, it allows you to click on that text and be taken to a website.
true
When you upload a new file to Sheets, it will have the same name as the file on your computer has.
true
You can clear (remove all the data) a section of cells from across several columns.
true
Paste = Ctrl+_____
v
Cut = Ctrl+_____
x
Which symbol is used to multiply when writting a Google Sheets calculation?
*
The basic calculations in Google Sheets are:
-Addition -Subtraction -Multiplication -Division
Select all methods described for getting to Google Sheets:
-Do a Google search for "Google Sheets" -Enter the website URL
When text has been turned into a link, what happens to it? Select all that apply.
-It becomes blue -A URL appears when you hover over it -It becomes underlined
Why is it beneficial to use a Google Sheets template? Select all that apply.
-It can save you time -Most of the formatting is already done
Once you have selected cells that you want to delete, what are the different ways of deleting the content of those cells? Select all that apply.
-Press delete on your keyboard -Choose "delete values" from the edit menu
When creating a link, which two fields appear in the link dialogue box?
-Text -Link
The three main options in the "Spelling" dialogue box are:
-ignore -add to dictionary -change
The first character you should put in a calculation is:
=
Select the different options available for filtering items shown on the Google Sheets homescreen.
Owned by me, owned by anyone, not owned by me
Once you have found and replaced a number, what must you click in order to search for the next iteration of that number?
find
When you copy a doc, the three places you can save it to are: "My Drive", "_____ _____ _____" and "Starred"
shared with me
How many different options are there in the "Paste special" menu option?
8
Which calculation for dividing the values in cells A3 and B3 is correct?
=A3/B3
Select all of the following can be used to access Google Sheets?
A Gmail and Google account.
When re-sizing a column, what appears when you begin dragging the edge of the cell to the right or to the left?
A blue line that moves with the cursor
When you add a green color to a tab, _____________________________________.
A green line appears at the bottom of the tab
To get out of full screen mode, click ___________________.
Escape on your keyboard
Besides PDF, another option for printing a spreadsheet would be to open it in _________ and print from there.
Excel
Each tab at the bottom of a Google Spreadsheet shows a completely different document.
False
Rows are labelled with the letters A-Z.
False
The height of rows cannot be adjusted.
False
When a copy of a document is created, it opens up in the same tab as the original and replaces it.
False
If a caluculaton is applied to a particular cell it will appear written out in the _____ bar
Formula
Which of the following is not a file type that you can download a spreadsheet as?
Image files
If you have the word "January" in a cell, what happens when you drag down the square at the bottom of the cell WITHOUT holding Ctrl on the keyboard?
It creates a sequential list starting with February, March, etc.
How do you save changes you've made to a Google Sheets spreadsheet?
None of the above
The settings for a spreadsheet include all the following except:
None of the above
When a tab at the bottom of a page is active, it is slightly ___________.
None of the above
Which of the following is not an example of text formatting.
None of the above
Before a document can print, it must first be converted to a _____ file.
What is the default name of a new spreadsheet?
Untitled Spreadsheet
Under what menu is the "Freeze" option found?
View
When using the AutoFill feature, your cursor will turn into a __________ when hovering over the square at the bottom-right of the cell.
`crosshair
When you want to resize a column, hover the mouse over the edge of the column until you see the cursor turn into two _____ facing in opposite directions.
arrows
To create a new spreadsheet, click the icon labeled "_____".
blank
One of the primary functions of a spreadsheet is to do _____.
calculations
To re-order sheets, all you have to do is _____, hold and _____ over one of the tabs, and then move the mouse.
click; drag
If you wanted to remove the Title Bar from the top of the page in order to maximize space on the screen, you would select "_____ _____" from the View menu.
compact controls
You can upload a file that is saved on your _____ and save/open it in Sheets.
computer
A new sheet will add to the right of the _____ (active) sheet.
current
"Paste column widths only" will allow you to paste a _____ width of a column.
defined
To begin adding data to a cell, _____-click until a cursor appears.
double
If you want to edit a number in a cell, all you have to do is _____-_____ the cell, select the number that is already there, and then type in the new number.
double click
The Undo and Redo options are located in which menu?
edit
If you were to select "Open with Microsoft Excel", the file would automatically save.
false
In Google Sheets, the spell-check option is found in the "Edit" menu.
false
Once a column is hidden, it is removed from the spreadsheet and can no longer be retrieved.
false
The keyboard shortcut for "Find and Replace" is Ctrl+F. (Look carefully at the screen when the narrator opens up the Edit menu.)
false
The menu bar is located at the bottom of the page.
false
When using the AutoFill feature to complete a list of the days of the week, once you reach the last day, the list will stop.
false
When you copy and paste the formatting of a cell, you also copy and paste the data found inside the cell.
false
When you select "Full screen", all you can see are the sheet itself and the menu bars.
false
When you select a column and go to insert a new column beside it, there are three different choices for where the new column can go.
false
When you've chosen all your print settings, press "Print" and the spreadsheet will automatically begin printing.
false
You may only print the current (active) sheet of a Google Spreadsheet.
false
In order to drag and move a column, the cursor must appear as a _____.
hand
In order to replicate a calculation, you must "click and _____ on the square at the bottom of the cell, and _____ it down to the last row where there are numbers."
hold; drag
If you click, _____ and drag on your mouse and begin moving across a spreadsheet, you can select _____ cells.
hold;multiple
If you click "_____ _____" and you have the selected word misspelled multiple times throughout your sheet, it will leave every single iteration of the misspelling.
ignore all
The four "Find and Replace" search options you have (with check-boxes) are: "Match case", "_____ _____ _____ _____", "Search using regular expression.
match entire cell contents
Click "_____" to see all of the template options available for use.
more
If you had two rows frozen, and you wanted to unfreeze both of them, you'd go to the Freeze options and select "_____ _____".
no rows
Recalculations can be done: "On change", "On change and every minute" or "_____ _____ _____ _____ _____".
on change and every hour
In the "_____" window, the two options are: "Open with" and "Save file"
opening
A cell that has been copied is ________________.
outlined with a dotted line
If you are pasting only the formatting from a cell, you first copy the original cell, then select the new cell. Then you right-click, choose the "_________ ____________" option, and then select "Paste format only" from the list.
paste special
The icon used to add a sheet appears in the lower-left corner of your spreadhseet document and looks like which of the following?
plus sign
When you want to delete a file, click on the image of the three dots, then click on "_____" to send the file to the _____.
remove trash
To delete all the data in a column, select the column, then _____-_____ with your mouse and choose "Delete Column" from the list of choices.
right click
If you want to hide a column or row, the first thing you want to do is _____ the column or row that you want to hide.
select
"A lot of these changes for this spreadsheet deal with when you begin _____ this document with others or when you begin _____ your sheet from different devices."
sharing; accessing
Google Sheets is used to create __________.
spreadsheets
Once the uploading process is complete, the file will automatically open in Sheets in a new _____ within your browser.
tab
The AutoFill feature is a nice _____-_____ feature.
time saving
Columns run vertically.
true
Once you open a file in Excel, it is possible to save it at a later time.
true
There are 4 Freeze options for rows, and 4 Freeze options for columns.
true
To select a cell, you simply have to click on it.
true
When copying and pasting, the data that is copied remains in the original cell.
true
When moving a tab, the cursor changes from an arrow to a four-way arrow.
true
When you select "Paste formula only", the formula is placed into a cell but NOT a value.
true
