WorksheetsGoogle Apps Quiz 121624
Total questions: 82
Worksheet time: 1hrs 2mins
During a math class, Daniel was asked to identify the icon used for adjusting decimal places in a document. What does this icon represent?
Adding or taking away decimals
Adding 100ths to the file
Increase indent
None of the above
Zoe is organizing her digital files and comes across this icon. What is this icon?
slides
chrome
drive
classroom
Anika is organizing her digital files and comes across this icon. What application does it represent?
sheets
docs
classroom
youtube
Aria is organizing a presentation for her class project. She needs to use a specific tool to create slides. What is this icon?
drive
slides
sheets
classroom
Maya is organizing her data for a school project. She needs to use a tool that helps her create spreadsheets. What is this icon?
sheets
slides
docs
classroom
Emma is working on a school project and wants to duplicate a paragraph from a document to use in her presentation. What keyboard shortcut should she use?
Copies text or images
Cuts text or images
Pastes text or images
Deletes text or images
Priya is working on a school project and needs to move some text from one document to another. What does ctrl+v do?
Copies text or images
Pastes text or images
Cuts text or images
Deletes text or images.
Which icon lets you add a link to your text?
Which icon lets you change the color of the text?
Which icon lets you undo?
Emma is starting a new project in Google Docs. What is this used for?
Blank Document
Exit Google Docs
Save Google Docs
Blue Screen
Ava is using a word processor and sees this icon. What does it do?
Underline
Italics
Font color
Bold
Sophia is editing a document and wants to emphasize a word by slanting it to the right. What formatting option should she use?
Underline
Italics
Font color
Boldface
Mia is creating a new document on her computer. What should she type in the title box?
The name of your document
Your email address
The teacher's name
Your dog's name
Ava is working on a document and sees this icon in her toolbar. What function does this icon represent?
Font color
Font name
Increase font
Bold
Which of these is used to change the font size?
Which icon lets you change the type of font?
Rohan is using Google Docs to make his project stand out. This picture is an example of:
coloring a text
highlighting a text
coloring the page
None
Priya is writing a report and wants to emphasize a section of text. She decides to use Ctrl+B. What does this shortcut do?
It's for Bold
It's for Italic
It's formatting
Google Drive
Maya is typing a document and wants to make a word italic. Which keyboard shortcut should she use?
Bold
Underline
Italic
All of them
Scarlett is typing a document and wants to underline a word quickly. Which keyboard shortcut should she use?
Ctrl+U
Bold
Italic
All of them.
Scarlett is organizing a spreadsheet for her class project. The spreadsheet is made up of all of the following EXCEPT
Columns
Cells
Rows
Pictures
In Lily's spreadsheet for organizing a field trip, a ____________ is where a row and column meet.
formula
cell
sheet
blank
Priya is organizing a spreadsheet for a school project. Which of the following is a correctly named cell?
B8
8B
8-B
B-8
In Avery's spreadsheet, the rows run ____________.
horizontally
vertically
none of the above
vertically
In Harper's spreadsheet for organizing a field trip, rows are labeled by __________.
numbers
symbols
letters
colors
In Liam's math class, the teacher asked which symbol is used to start writing an equation or formula on the computer?
$
+
=
-
Mia is working on a spreadsheet and wants to "auto fit" the content in a column. Which cursor should she use?
vertical line with arrows pointing left and right
plus sign
hand
white arrow
Olivia is organizing a spreadsheet for her class project. In the spreadsheet, columns are labeled by ______________.
numbers
symbols
letters
colors
In Emma's spreadsheet, the columns run _______________.
vertically
horizontally
diagonally
none of the above
horizontally and diagonally
Which icon will let you highlight text?
Elijah is using a word processor and wants to center the text in his document. Which one of the icons will help him do that?
The first one
The second one
The third one
The fourth one
Rohan is working on a spreadsheet to calculate his monthly expenses. Which of the following formulas is in the correct format?
SUM(A1:A10)
=B1+B2+B3+B4+B5
D7*C7
All are correct
Avery is working on a spreadsheet and wants to create one long cell from several smaller cells to organize the data better. Which of the following options should Avery choose?
Cell width
Merge cells
Combine cells
Add cells
Ava accidentally deleted a paragraph in her document. What keyboard shortcut should she use to undo the deletion?
Ctrl+C
Ctrl+Z
Ctrl+V
Ctrl+P
Which icon lets you insert an image?
Which one of the icons will create a bulleted list?
Grace is working on a document and needs to move a paragraph to a different section. Under which menu can she find cut and paste?
Edit Tab
File Tab
Tools Tab
View Tab
Michael is designing a poster and needs to set the margins. How many margins should he consider on the page?
Two (header and footer)
Two (landscape and portrait)
Four (top, bottom, right, left)
Two (top and bottom)
Ava is working on a document and wants to change the fonts and their sizes. Which of these menus should she use?
Format
Add-Ons
Tools
None of these
Grace is working on a document and wants to add a table. Under which menu would she find the option to insert a table?
Insert
View
Edit
Tools
In order to crop an image, which icon should I click?
Evelyn is working on a project in Google Sheets and wants to change the font style and size of her text. How can she do this?
Use the 'Insert' menu and select 'Font'
Use the 'Format' menu and select 'Text'
Click on the 'File' tab and choose 'Style'
Access the 'View' menu and click on 'Appearance'
Anika is working on a project in Google Sheets and needs to combine several cells to create a header for her data table. Explain the process she should follow to merge these cells.
Use the 'Merge' function in the 'Insert' tab
To merge cells in Google Sheets, select the cells you want to merge, then click on the 'Merge' button in the toolbar or go to Format > Merge cells in the menu.
Type 'Merge' in the formula bar
Right-click on the cells and select 'Merge'
Aria is working on a sales report in Google Sheets and wants to easily identify which sales figures exceed a certain target. What feature should she use?
To highlight or format cells based on certain conditions or criteria.
To calculate formulas in cells
To insert images into the spreadsheet
To change the font style of the entire sheet
Mia is working on a project in Google Sheets and needs to add more data. How can she insert a new row or column?
Use the 'Cut' function
Press the delete key
Double-click on the row number or column letter
Right-click on the row number or column letter and select 'Insert 1 above' or 'Insert 1 left'.
Olivia is working on a budget spreadsheet in Google Sheets. She wants to know the difference between a formula and a function. What should she understand?
A formula performs calculations on values in a range of cells, while a function is a predefined formula that performs specific calculations.
A formula and a function are the same thing
A formula can only be used for text manipulation, while a function is used for calculations
A formula is used for adding numbers, while a function is used for subtracting numbers
Hannah is managing the budget for a school event and needs to calculate the total expenses. Explain the use of the SUM function in Google Sheets with an example.
The SUM function in Google Sheets is used to sort a range of cells.
The SUM function in Google Sheets is used to add up a range of cells. It is commonly used to calculate the total of a series of numbers.
The SUM function in Google Sheets is used to find the average of a range of cells.
The SUM function in Google Sheets is used to multiply a range of cells.
Luna is working on a spreadsheet. What is the name of the selected cell?
B10
5B
B5
you cannot know the name from this picture
Aria wants to calculate the total of her scores in cell B1 and B2. What is the correct formula she should use?
AddB1+C1
=add(b1:b2)
=B1+B2
=total(B1-B2)
Evelyn is calculating the total cost of items in her shopping cart. If she uses the formula: =A1*B1, what value would she get?
2
3
4
Error
Nora is using a spreadsheet to calculate her expenses. If she inputs the formula =B1+C1, what value will she get?
2
3
4
Error
Mia is using a spreadsheet to calculate the total number of apples, bananas, and oranges she has. She enters the numbers in cells A1, B1, and C1 respectively. If the formula in cell E1 is =sum(A1:C1), what number should be in E1?
1
3
5
9
Emma is calculating the total sales from Monday to Friday. Which is the correct formula to add the sales figures from cells A1 thru A5?
=SUM(A1+A5)
=SUM(A1:A5)
=A1+A5
=SUM(A1:A4)
Mason is analyzing the monthly expenses of his household. He wants to find the smallest expense in the list. Which function formula should he use?
max
min
sum
average
Zoe is working on a spreadsheet for her class project. She selects a vertical section to organize her data. What is the name of this vertical section?
row
cell
column
format
Grace is starting a small aquarium business. Using cell references, select the correct formula for calculating the initial cost of goldfish.
=b9*c9
b9*c9
.25*6
=.25*6
Mia is working on a spreadsheet and wants to ensure that all the text in a cell fits without spilling into the next column. Which of the following options should she use?
Overflow
Text wrapping
Clip
Liam is calculating his monthly expenses. The correct formula to add his grocery expenses in cell B1 and utility bills in cell B2 is
AddB1+C1
=add(b1:b2)
=B1+B2
=total(B1-B2)
Where would you click to select a column?
A
B
C
D
Which method is best for selecting the cells highlighted in red?
Press the Ctrl key and click on the cells.
Click and drag the mouse to select the cells
Press the Shift key and click on the cells.
Press the Alt key and click on the cells.
What symbol is used to designate an absolute cell reference?
!
%
@
$
What function should be entered into B7 to calculate the total budget?
=SUM(B3:B6)
=CALCULATE(B3:B6
=SUM(B3-B6)
=AVERAGE(B3:B6)
Identify the icon?
Adding or taking away decimals
Adding 100ths to the file
Increase indent
None of the above
Double-clicking between two columns will ____________ the column.
Delete
Copy
Resize
Fill
What is the name of the yellow highlighted area?
Task bar
Formula bar
Tool bar
Functions
Where would you click to select a column?
A
B
C
D
What is the purpose of the 'AVERAGE' function in Google Sheets?
It finds the median of a set of numbers.
It finds the mean of a set of numbers.
It finds the mode of a set of numbers.
It finds the range of a set of numbers.
What is the formula here?
=45+14+65
=A2+B2+C2
=a1+b1+c1
none
How can you restrict data entry to a specific range of values in a cell in Google Sheets?
Conditional formatting
Data validation
Using functions
Collaboration settings
What function would you use to count the number of cells in a range that contain numbers?
`COUNT()`
`COUNTA()`
`COUNTIF()`
`SUM()`
How can you apply a rule in Google Sheets that highlights cells in a column that are greater than 100?
Data validation
Conditional formatting with a custom formula
Using the `SUM()` function
Collaboration settings
What is the result of the function `=IF(A1>B1, "Yes", "No")` if A1 contains the value 10 and B1 contains the value 20?
Yes
No
True
False
What does this button do?
Border the cells
Merge the cells
Change the alignment in the cells
Change the color in the cells
What formula would be good for adding up the values in cells?
=sum(A5:A16)
=add(A5:A16)
=total(A5:A16)
=(A5:A16)
What symbol is used to multiply values in cells in Google Sheets formulas?
x
*
#
/
