Computer Skills Quiz 7

In an equation, what symbol represents multiplication?

*

In an equation, what symbol represents division?

/

You know there is a note attached to a cell when you see _____________________.

A black triangle in the top-right corner

Which of the following is not an option for inserting an image in Google Sheets?

Adobe Photoshop

Which drop-down menu would allow you to switch from a column to line chart?

Chart Type

To remove all of the check-marks on the filter line, you need to click "____________".

Clear

When setting the permissions for a sheet, you can restrict who can edit the range. Which of the following are the options for restricting?

Custom... Only you Copy permissions from another range...

Under which tab of the Chart Editor would you find the option to change the chart title?

Customize

When validating data, which of the following are options in the Criteria drop-down menu?

Date Text List from a range Number List of items

Which of the following is a benefit of inserting a drawing rather than typing text onto a spreadsheet?

Drawings can be moved and resized freely

A chart legend is fixed in place and cannot be moved.

False

All chart types will work well with any set of data.

False

Cells with invalid data in them are marked with a small blue square in the corner.

False

If a cell already contains data, adding data validation will automatically change the existing data.

False

Once a chart is moved to a seperate sheet it can no longer be edited.

False

The first step when filtering data, is to select the "Filter data" button on the toolbar.

False

To add an image to a sheet, you'd go to the "Format" menu.

False

To remove a note from a cell, click "format" and then choose "note removal".

False

When creating your own equation (formula) in Google Sheets, you do not have to start off with the "=" symbol.

False

When you double-click on a cell with an equation in it, the solution to the equation shows up (rather than the equation itself).

False

When you use the "COUNT" function, it adds up the values of all of the selected cells.

False

You can use formulas from across different sheets, even if they are in different spreadsheets.

False

An image placed in a cell has more options for adjustment than an image placed over cells.

Fasle

The Data Validation tool is found in the "Format" menu.

Fasle

When creating a chart, the X (vertical) axis values are automatically chosen and cannot be manually changed.

Fasle

The icon for what tool is shown below? (filter)

Filter

When you select a row and filter it, what color appears in the selected rows?

Green

When adjusting any colors on a chart, which of the following are important to consider? Select all that apply.

How easily the colors can be seen That each series (line) can be easily distinguished from the others

To find the average value from a range of cells without using an automatic formula, you would need to know which of the following? Select all that apply.

How many values there are in the range The sum of all the values in the range

What are the two options for defining where an inserted image will end up?

In cell Over cells

To create a chart, you go to the ___ menu.

Insert

Which menu would you go to if you wanted to add a note to your sheet?

Insert

How is setting a point shape for each line in a chart series helpful?

It can help to more easily identify the value at a given location on the chart

Which of the following is not one of the default options found in the Function menu?

MODE

Just like images, charts that are being built can be... (Select all that apply)

Moved Resized

Which of the following chart types would work best for displaying percentages from a poll?

Pie Chart

The phrase to help you remember the order of operations is: " ___ ___ My ___ ___ Sally".

Please Excuse My Dear Aunt Sally

X-Axis=

Runs horizantally (left and right)

Y-Axis=

Runs vertically (up and down)

To remove data validation you must first...

Select an area of cells

To see a calculation displayed in the quick access formula bar you must first...

Select an area of data

To select multiple columns for sorting, click on one column header, then hold down the ___ key and click on the second column that you wish to sort.

Shift

In the Data Validation settings, the two options available when invalid data is entered are: " ___ ___" and "Reject input".

Show warning

Why should images always be resized using one of the blue boxes in the four corners?

So that the image does not squish or distort

A second method of sorting data involves going to the Data menu and choosing "___ ___ ..." from the list of options.

Sort range

The quick access formula bar includes which of the following calculations?

Sum Minimum (Min) Average (Avg) Maximum (Max)

Which of the following are reasons that charts and graphs are beneficial to use? Select all that apply.

They are more visually appealing They can be more easily understood/interpreted

Select all of the possible reasons why it would be beneficial to save a chart as an image.

To use on a website To use in a slideshow presentation

Google Sheets uses the standard order of mathematical operations.

True

If a spreadsheet is imported into a Google Doc validation rules will not be applied.

True

If you want to revert an image back to its original size once you've edited it, you can click on the 3 dots at the top of the image and choose "Reset size".

True

In order not to sort column headings like "First" or "Last" (as shown in the video), you need to make sure to check the box that says "Data has header row".

True

It is recommended that you select the cells that you would like to be included in the chart.

True

Once text inside a cell is wrapped, changing the cell width will also adjust the cell height.

True

The MIN function allows you to easily find the lowest value in a selected range.

True

When text in a cell is clipped, you can only see whatever fits in the pre-set width of the cell.

True

When using a value from another sheet, it lists the name of the sheet in single quotes.

True

Which of the following is not a formatting option available for a chart title?

Underline

To create an exponent, you must use the ___ symbol. (Please type the symbol and not the word(s))

^

When you go to move an image that you've put into a spreadsheet, the cursor looks like ___.

a hand

To add code that allows an image to perform a function as a clickable button you would click the 3 dots and choose ___ ___.

assign script

To find the average value from cells C3 to D9, you would type in the following: (Write out all words, symbols, numbers, and letters with no spaces)

average(C3:D9)

When you have filtered a certain column, the drop-down arrow for that column appears green. All other drop-down arrows in the other columns appear ___.

blue

To edit a chart or graph you can either click on particular parts of the chart or find all of the settings in the ___ ___ , located on the right.

chart editor

"A note is designed to give you a ___ or a heads-up about something within the ___ (such as the data or the headers)."

description sheet

Once you have selected a column for sorting, if you want to access the Sort Sheet function, you click on a little drop-down arrow that appears ___.

in the column letter heading

The ___ is like a key to the map (or chart) that helps you to read and interpret it.

legend

To find the maximum value from cells C3 to D9, you would type in the following: (Write out all words, symbols, numbers, and letters with no spaces)

max(C3:D9)

To move a chart to a new sheet the option to select from the drop-down menu reads " ___ ___ ___ ___ ".

move to own sheet

In order to get an image URL you would first ___ - ___ on the image and then choose Copy Image ___

right - click Address

When you choose Clip (instead of Wrap), the data is clipped based on the ___ of the cell.

width

When you choose to wrap text, it will stay at the set ___, but it will change the ___ of the cell in order to fit all of the text.

width height