Deck 108: Spreadsheets Part 1

Question 1

After you enter a function in a cell,pressing Enter ____.

A) opens Function options
B) runs the function and displays its result in the cell
C) opens a dialog box with charting options
D) formats the cell with absolute references

Answer 1

B

Question 2

In Google Spreadsheets,data can only be pasted into a cell when it is first placed in the Web clipboard.

Answer 2

True

Question 3

Using toolbar buttons in Google Spreadsheets,you can easily align data within a cell,merge adjacent cells into a single cell,and wrap text.

Answer 3

True

Question 4

You freeze the two leftmost columns in your Google spreadsheet.What happens when you scroll to the right to view column U? (You are doing your work on a laptop with a small screen.)

A) Columns A and B remain visible.
B) Columns A and B are no longer visible.
C) Column A is visible,but columns B and C are no longer visible.
D) Columns A,B,and C are now visible.

Question 5

When you type data in a Google spreadsheet cell,the entry is saved even if you did not yet save the file.

Question 6

Google Spreadsheets treats tabular data as lists.This means that each ____ represents a record in the list.

A) column
B) row
C) frozen section
D) table

Question 7

____ means you will not need to save changes made to a spreadsheet as you work on it.

A) Saving
B) Copying
C) Previewing
D) Autosaving

Question 8

In Google Spreadsheets,data entered into a cell can be moved in a way similar to how you move cell data in Excel.

Question 9

Inserting an image into a Google spreadsheet requires that the image be published on YouTube.

Question 10

AVERAGE is an example of a Google Spreadsheets built-in function.

Question 11

After inserting a chart in a spreadsheet,click the chart to reveal the chart menu with options specific to the chart.

Question 12

To edit a worksheet cell,you can click the Formula bar and type your text or formula.

Question 13

Google Spreadsheets offers the same number of formatting options as does Microsoft Excel.

Question 14

Anything copied to the Web clipboard will ____.

A) be saved there for 24 hours
B) be erased when you close your Web browser
C) remain on the clipboard for 30 days
D) either A or B

Question 15

A worksheet is made up of one or more individual workbooks.

Question 16

Google Spreadsheets is 100% free and in the cloud.

Question 17

The SUM function multiplies a range of cells against each other.

Question 18

The ____ is useful for creating a series within a range of cells.

A) Paste series option
B) scroll bar
C) fill handle
D) Create series button

Question 19

Google Spreadsheets supports the MAX function,but not the COUNT function.

Question 20

An Excel worksheet is typically stored in the cloud,whereas a Google spreadsheet is usually stored on a laptop computer.

Question 21

To enter a function or formula,first type a(n)____ in the cell.

A) equals sign
B) minus sign
C) colon
D) epsilon

Question 22

In Google Spreadsheets,____ is an example of an absolute reference.

A) V$456
B) $V$456
C) V456
D) $V*456

Question 23

When you paste an image URL into a spreadsheet cell,the image ____.

A) must already be online
B) can be uploaded from your computer
C) must originate from within the United States
D) none of the above; Google Spreadsheets does not support this functionality

Question 24

Printing a Google spreadsheet means that ____.

A) the file prints to your local printer
B) the file prints to a Web printer
C) an image is made of the file
D) a PDF file is created

Question 25

The cell entry ____ is an example of a reference to a cell in another worksheet in the workbook.

A) =SUM(B1:B25)
B) =Expense!B3
C) =Reference?Sheet4:CellA4
D) =Sheet6$Z$45

Question 26

You move an image in a spreadsheet by ____.

A) left-clicking the image and dragging it
B) clicking File-> Move image
C) pointing at the row holding the image and dragging the sizing handle that appears
D) dragging the image's top bar

Question 27

Wrapping text in a Google spreadsheet means that ____.

A) text in a cell may use more than one row to display its contents
B) cells will wrap together to properly display the cell contents
C) formulas will round results and display them as currency
D) either A or B

Question 28

To print a Google worksheet,click the Print command on the ____ menu.

A) Print
B) Format
C) File
D) Tools

Question 29

In Google Spreadsheets,____ is an example of a relative reference.

A) V$456
B) $V$456
C) V456
D) $V*456