Worksheets25/26 - Google Sheets Quiz
Total questions: 55
Worksheet time: 18mins
What is Google Sheets?
A) A web-based email application
B) A web-based spreadsheet application
C) A web-based presentation application
D) A web-based word processing application
How do you rename a Google Sheet?
Click on the 'Share' button and enter a new name.
Right-click on the sheet tab and select 'Rename'.
Locate and select "Untitled spreadsheet" at the top of the page, type a new name, and press Enter.
Go to File > Save As, and enter a new name.
Why is there no save button in Google Sheets?
Because you need to manually save your files periodically.
Because Google Sheets does not have the capability to save files.
Because Google Sheets uses autosave, which automatically saves your files as you edit them.
Because files are saved to the computer, not to Google Drive.
What is a cell in a spreadsheet?
A) A single data point
B) The intersection of a row and a column
C) A collection of worksheets
D) A type of formula
How are columns in a spreadsheet identified?
A) By numbers
B) By special characters
C) By letters
D) By colors
How are rows in a spreadsheet identified?
A) By letters
B) By numbers
C) By colors
D) By special characters
What is the cell address of the selected cell in the example?
A) A10
B) C10
C) B10
D) C9
What happens to a cell's column and row headings when the cell is selected?
A) They disappear.
B) They become italicized.
C) They become darker.
D) They change color to red.
What is a group of cells known as in a spreadsheet?
Cell block
Cell range
Cell group
Cell array
How do you refer to a cell range using the cell addresses?
By listing each cell address individually
By using a comma to separate the first and last cell addresses
By using a colon to separate the first and last cell addresses
By using a semicolon to separate the first and last cell addresses
If you select cells A1, A2, A3, A4, and A5, how would you write the cell range?
A1-A5
A1:A5
A1;A5
A1, A5
What is the difference between the cell ranges A2:A8 and A2:B8 as shown in the image?
A2:A8 includes only the dates, while A2:B8 includes both dates and sales
A2:A8 includes both dates and sales, while A2:B8 includes only the dates
A2:A8 includes only the sales, while A2:B8 includes both dates and sales
There is no difference; both ranges are the same
What is the name for the selected range in the spreadsheet?
A) A5:A6
B) B5:B6
C) A5:C5
D) A5:B5
What can the fill handle in a spreadsheet be used for?
To change the color of the cells
To continue a series in sequential order
To delete the content of a row or column
To merge multiple cells together
How can you modify the width of a column in a spreadsheet?
Right-click on the column header
Drag the line between the column headers
Double-click on the column header
Press the delete key
What is the method to autosize a column's width in a spreadsheet?
Right-click and select 'Autosize'
Drag the line between the column headers until it fits
Double-click the line between the column headers
Select the column and press 'Autosize' button
How can you modify the height of all rows in a spreadsheet?
Double-click on a row number
Click and drag a row boundary
Click to select all cells and then adjust one row
Right-click on a column letter and select "Modify row height"
What is the shortcut to select all cells in a spreadsheet?
Pressing Ctrl+A
Clicking on the corner button where row and column headers meet
Double-clicking on a cell
Right-clicking on a cell and choosing "Select all"
How do you insert a new column to the left of the current column in a spreadsheet?
Right-click on the column and select 'Insert 1 above'
Right-click on the column and select 'Insert 1 right'
Right-click on the column and select 'Insert 1 left'
Right-click on the column and select 'Delete column'
What is the correct way to insert a new row above the current row in a spreadsheet?
Right-click on the row and select 'Insert 1 left'
Right-click on the row and select 'Insert 1 right'
Right-click on the row and select 'Insert 1 above'
Right-click on the row and select 'Resize column...'
How do you delete a column in a spreadsheet?
Right-click on the column header and select 'Delete column'
Right-click on the column header and select 'Clear column'
Right-click on the column header and select 'Hide column'
Right-click on the column header and select 'Resize column...'
How do you insert a new row above the current row in a spreadsheet?
Right-click on the row number and select 'Insert 1 above'
Right-click on the row number and select 'Insert 1 below'
Right-click on the row number and select 'Delete row'
Right-click on the row number and select 'Clear row'
What do number formats in a spreadsheet indicate?
The font style and size
The background color of the cells
The type of data you're using, like percentages, currency, times, dates, etc.
The number of decimal places
What is the purpose of applying a number format in a spreadsheet?
To change the alignment of the text in a cell
To tell the spreadsheet exactly what types of values are stored in a cell
To merge multiple cells into one
To create a chart from the data
How do number formats affect the readability of a spreadsheet?
They make it more difficult to read
They have no impact on readability
They make it easier to read and use
They only change the color of the text
How do you apply number formats in a spreadsheet according to the learning material?
By selecting cells and choosing the desired formatting option.
By typing the format manually into each cell.
By using a special formula to set the format.
By changing the spreadsheet settings in the control panel.
What does applying the Currency format in a spreadsheet do to numerical values?
It converts numbers to text.
It adds currency symbols and displays two decimal places.
It changes the font color to red.
It multiplies the numbers by the current exchange rate.
The correct formula to add cell B1 and B2 is
AddB1+C1
=add(b1:b2)
=B1+B2
=total(B1-B2)
Which is the correct formula to add cells A1 thru A5?
=SUM(A1+A5)
=SUM(A1:A5)
=A1+A5
=SUM(A1:A4)
When you sort information, it can only be sorted by the first column of information.
True
False
The function formula to find the smallest value in a group is
max
min
sum
average
You can adjust the size of columns in Sheets.
True
False
Where would you click to select a column?
A
B
C
D
Which letter on the image is a column?
A
B
C
D
What symbol is used to designate an absolute cell reference?
!
%
@
$
Which of the following features allows you to narrow down the data in your worksheet?
Merge cells
Filters
Sorting
Relative cell references
What symbol is used to represent multiplication in a formula?
-
+
*
/
Which of the following symbols is not recognized as a mathematical operator within Google Sheets?
^
@
-
/
*
Which of the following is an absolute cell reference?
A2
A:2
$A$2
#A2
According to the order of operations, which calculation comes first in the following formula?
=3^2/5+(12-3)
12-3
3^2
2/5
5+12
What does the "Sort sheet by column" feature in Google Sheets allow you to do?
Sort data by row number
Sort data by row header
Sort data by column letter
Sort data by column header
Name for graphic representations used to compare and contrast worksheet data
What type of graph is this?
Bar graph
Line graph
Pie chart
Point graph
What type of graph is this?
Column graph
Line graph
Pie chart
Point graph
What type of graph is this?
Bar graph
Line graph
Pie chart
Row graph
Google Sheets is used to? (select all correct answers)
Add numbers.
Make charts (graphs).
Put information in columns and rows.
Collect Data
If I want to add a Chart, one way is to select the ____________ menu.
Home
Insert
Page
Data
Which is NOT a type of chart?
pie
column
bar
axis
What does autosum do?
subtracts totals
adds totals
multiplies totals
divides totals
Identify the icon?
Adding or taking away decimals
Adding 100ths to the file
Increase indent
None of the above
