Google Apps Final Exam

Which of the following functions returns the largest number from a range of cells?

MAX

Which of the following functions returns the smallest number from a range of cells?

MIN

Where on the Menu tab would you click to access the command to change the document's page orientation?

Edit

The soccer club is considering using a new field, but want to make sure it can offer enough seating. What application is the best for tracking game attendance? -Google Docs -Google Slides -Google Sheets

Google Sheets

Ashlee has a presentation to give for science class. She would like to show images of ocean life and some supporting text. What application should she use? -Google Slides -Google Sheets -Google Docs

Google Slides

What application is best used for creating a presentation? -Google Docs -Google Slides -Google Drive -Google Sheets

Google Slides

What does it mean to merge cells?

Combine cells into a single cell

What tool can be used to copy complex text formatting from one section of the document to another? -Paint format -Format paragraphs -Change font -Clear formatting

Paint Format

Every presentation should have a beginning, a middle and an end.

True

Google Drive can be used to open .jpg and .pdf files. -False -True

True

You recently finished an essay on the Milky Way Galaxy in Google Docs, but you can't locate the file anywhere on your Google Drive. What should you do? -Look though every folder on your Google Drive very carefully. -Use the search bar feature in Google Drive to search for "milky way." -Open Google Docs and search using the help tab. - Panic! Obviously you accidentally deleted it.

Use the search bar feature in Google Drive to search for "milky way."

Miguel received a Microsoft Word document in an email from his partner on a class project. Miguel is using a ----Chromebook, and doesn't have access to Microsoft Word. What would be the best thing for Miguel to do next? Reply to his partner and ask him to email the file as a Google Docs file type. Wait until he can use a school computer with Microsoft Office to open the file. View and convert the Microsoft Word document file using Google Drive. Ask his partner to paste the text into an email. Then copy and paste the text into Google Drive.

View and convert the Microsoft Word document file using Google Drive

Google Drive ________ be used to convert Microsoft Word files to Google Docs files. -can -cannot

can

Themes allow you to ________________. create a slide with predefined location of text boxes and images. change the colors and fonts for a whole presentation. populate your presentation with pre-defined slides related to a topic.

change the colors and fonts for a whole presentation.

Where would you click to rotate an image?

circle

Where would you click to change the cell format to a date?

format

Clicking the Present button plays the presentation _________________. in a separate window. from the first slide. in the current browser and opens speaker notes in a separate window. from the current slide

from the current slide

Where is the formula bar?

fx bar

What is a template? -A pre-designed document. -A customized document. -An empty document. -A document outline.

pre-designed document

Where would you click to hide a column?

pull down button

Where is the cell?

single block

Where on the Toolbar would you click to center text on the page?

-Center

Where would you click to resize the image?

-Corner square

Where on the Menu tab would you click to access the command to change the document's page orientation? -File -Edit -Insert -Format

-File

Where on the Toolbar would you click to change the font?

-Font

Where on the Menu tab would you click to access the command to change the paragraph line spacing? -Edit -Insert -Format -Tools -Table

-Format

Which of the following is found at the top of a document page? -Footer -Header

-Header

Where on the Menu tab would you click to access the command to add a drawing?

-Insert

Where on the Toolbar would you click to justify align the text in a paragraph?

-Justify

Where on the Toolbar would you click to display additional Toolbar commands?

-More

What tool is indicated in the paint brush image?

-Paint format

What paragraph alignment is shown in the image? fjjajjajajkjajkajaajakaaakk djfsjjsjskjfff ddjkjfjdjdjddd

-Right

Where on the Toolbar would you click to highlight text?

-Text color

Where would you click on the Toolbar to fill a shape with color?

Fill Color

Where would you click on the Toolbar to adjust the line spacing of text?

Line Spacing

What is the keyboard shortcut for paste? -Ctrl+P -Ctrl+V -Ctrl+C -Ctrl+Z

Ctrl+V

Which of these number formats would you want to apply to a cell showing the total sales in dollars? Currency Date Percentage

Currency

In a spreadsheet all formulas must begin with what symbol? ! # $ =

=

Which of the following functions adds a range of cells and then divides by the number of cell entries?

AVERAGE

Which item can be used as a hyperlink?

All of the above

You want to copy a formula across a row. What method would be best for the job? Copy and Paste Cut and Paste Autofill Find and Replace

Autofill

What formula would you enter into B7 to calculate the total budget?

B3+B4+B5+B6

Which of the following font styles or effects is good for making text stand out? -Subscript -Strikethrough -Bold

Bold

Where would you click on the Tool bar to add a border around a cell?

Borders

Which type of list is best suited for items that DO NOT go in any specific order? -Connected -Bulleted -Numbered

Bulleted

Which of the following is NOT a good use of Google Sheets? -Sorting and filtering data. -Graphing and Charting data. -Creating invitations. -Performing mathematical calculations.

Creating invitations

Where would you click on the Toolbar to crop an image using a mask?

Crop Image

Which tool can most easily be used to find synonyms for words in your document? -Lookup -Define -Research -Spelling

Define

It's always better to add more images to a slide.

False

The "Title" paragraph style is a good choice for a paragraph of text in your report.

False

You should put as much information into each slide, to limit the number of slides in a presentation.

False

Which of the following is found at the bottom of a document page? -Footer -Header

Footer

Joelle needs to write a research paper. What is the best application to use? -Google Sheets -Google Docs -Google Slides

Google Docs

Montel is looking for a job, and is ready to begin work on his resume. What application should he use? -Google Slides -Google Docs -Google Sheets

Google Docs

What application is used for word processing? -Google Drive -Google Docs -Google Sheets -Google Slides

Google Docs

Which of the following is an example of an application: -iPhone -Chromebook -Microsoft Windows -Google Docs

Google Docs

Which of the following is found at the top of a document page?

Header

Where would you click on the Toolbar to add an image to a slide?

Image

Where would you click on the Menu bar to find the Word Art command?

Insert

What would you use to select pre-defined locations of text boxes on a new slide? Templates Themes Layouts

Layout

What is the name of the Google Drive location where you store the files you create or upload? -BC21 Work -BC21 Folder -Your Drive -My Drive

My Drive

Where would you click on the Toolbar to add a new slide to a presentation?

New Slide

Which type of list is best suited for items that DO go in a specific order? -Virtual -Bulleted -Numbered -Connected

Numbered

What do the tabs contain? -Un-related commands. -The most frequently used commands. -Commands that are obscure. -Related commands.

Related commands

Where would you click on the Toolbar to reset edits made to an image?

Reset Image

Which of the following functions adds together the values in a range of cells?

SUM

Where would you click on the Toolbar to add a shape to the slide?

Shape

Where on the Toolbar would you click to change a paragraph style? -Styles -Font -Font size -Add Comment -More

Styles

Where on the Toolbar would you click to change the text color?

Text color

What happens when you hide a column? The column doesn't appear, but the data is still there. The data in the column is deleted. Formulas referencing cells in the column stop working.

The column doesn't appear, but the data is still there.

What would you use to change the colors and fonts used by a presentation at one time? Templates Layouts Themes

Themes

You are writing a report about a trip you made to several cities last month. Which of the following paragraph styles would be the best choice for the report's name? -Heading3 -Title -Normal text

Title

Can the same header and footer appear on multiple pages? -Yes -No

Yes

Can you open a web site from within a Google Sheets presentation? Yes, your best option would be to use a text box. Yes, your best option would be to use a hyperlink. Maybe, it depends on the web site address No, there is no feature in that allows this.

Yes, your best option would be to use a hyperlink.

You would use conditional formatting on a cell when you want to ____________. highlight negative numbers by using red text hide the contents of a column add an image to the spreadsheet use a function to sum the values in a column

highlight negative numbers by using red text

Where is the row?

horizontal line

Where would you click to select a column?

letters

Where would you click to select a row?

list of numbers

Where is the column?

vertical line