If you do not already have a Google account, you will need to create one before you can use Google Sheets. To do so, go to http://google.com and in the upper right corner, click:

Question 1 options:

	a) Start.
	b) Create Account.
	c) Sign In.
	d) New User.

Save

Question 2 (2.5 points)

You can insert ___________in an Excel worksheet to give a visual trend summary alongside your data.

Question 2 options:

	a) sparklines
	b) legends
	c) axes
	d) data points

Save

Question 3 (2.5 points)

_______________ is a charting command to swap the data over the axis-data being charted on the vertical axis will move to the horizontal axis and vice versa.

Question 3 options:

	a) Move data
	b) Realign Row/Column
	c) Switch Row/Column
	d) Reconfigure Row/Column

Save

Question 4 (2.5 points)

Small businesses often use Excel as a basic accounting program or:

Question 4 options:

	a) financial analysis tool.
	b) checkbook ledger.
	c) forecasting mechanism.
	d) for tracking sales volume.

Save

Question 5 (2.5 points)

_____________ is a command associated with the currently selected or active object; often activated by right-clicking a screen item.

Question 5 options:

	a) Show formulas
	b) Point and click
	c) Context sensitive
	d) Display value

Save

Question 6 (2.5 points)

The intersection of a row and a column is referred to as a(n):

Question 6 options:

	a) reference point
	b) entry point
	c) cell
	d) cell address

Save

Question 7 (2.5 points)

If the first character you type matches an existing entry, Excel attempts to fill in the remaining characters using:

Question 7 options:

	a) SharePoint.
	b) AutoFit.
	c) AutoFill.
	d) AutoComplete.

Save

Question 8 (2.5 points)

An Excel ________ contains one or more pages known as a worksheet or spreadsheet.

Question 8 options:

	a) workbook
	b) folder
	c) file
	d) document

Save

Question 9 (2.5 points)

With Excel Online you use ___________to create, view, and edit workbooks.

Question 9 options:

	a) Dropbox
	b) your web browser
	c) SharePoint
	d) OneDrive

Save

Question 10 (2.5 points)

A specific way in which Excel displays numbers in a cell is a(n. ___________ format.

Question 10 options:

	a) General
	b) Number
	c) Accounting Number
	d) Underlying

Save

Question 11 (2.5 points)

Tracking total business sales in dollars along with total advertising and marketing expenditures with Excel allows you to see your __________ for each campaign.

Question 11 options:

	a) Return on Equity
	b) Return on Investment
	c) Cost of Capital
	d) Sales volume

Save

Question 12 (2.5 points)

When others edit the worksheet, Excel Online shows their presence and the updates right away. This only works when:

Question 12 options:

	a) share folders have been set up.
	b) everyone is working in Excel Online.
	c) each Excel Online account is linked.
	d) workbooks are saved to Excel Online.

Save

Question 13 (2.5 points)

Excel 2016 is a tool to communicate ___________business information effectively.

Question 13 options:

	a) quantitative
	b) qualitative
	c) strategic
	d) managerial

Save

Question 14 (2.5 points)

Text values are also referred to as:

Question 14 options:

	a) formulas.
	b) labels.
	c) calculations.
	d) constants.

Save

Question 15 (2.5 points)

When using Google Sheets, you can download your Google file in several formats, including PDF or:

Question 15 options:

	a) Access.
	b) Excel.
	c) Word.
	d) PowerPoint.

Save

Question 16 (2.5 points)

Businesses create basic employee and resource __________with Excel that can be color-coded and designed to automatically update.

Question 16 options:

	a) task lists
	b) schedules
	c) contact lists
	d) productivity monitors

Save

Question 17 (2.5 points)

The Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers is a(n. ______________ format.

Question 17 options:

	a) General
	b) Number
	c) Accounting Number
	d) Underlying

Save

Question 18 (2.5 points)

The cell address displays in the:

Question 18 options:

	a) name box.
	b) formula bar.
	c) legend.
	d) split box.

Save

Question 19 (2.5 points)

An Excel ________ contains horizontal rows and vertical columns.

Question 19 options:

	a) workbook
	b) folder
	c) file
	d) spreadsheet

Save

Question 20 (2.5 points)

__________is a feature in Excel that works with alphabetic values.

Question 20 options:

	a) AutoComplete
	b) SharePoint
	c) AutoFit
	d) AutoFill

Save

Question 21 (2.5 points)

Both values and formulas can be copied using the fill handle. When a formula is copied, Excel copies the formula but adjusts the ____________ relative to the row number.

Question 21 options:

	a) length
	b) functions
	c) values
	d) cell references

Save

Question 22 (2.5 points)

The type of cell reference that refers to cells by their fixed position in a worksheet is:

Question 22 options:

	a) absolute.
	b) relative.
	c) exponentiation.
	d) central.

Save

Question 23 (2.5 points)

An element in the Excel window that displays the value or formula contained in the active cell is the:

Question 23 options:

	a) name box.
	b) status bar.
	c) formula bar.
	d) value box.

Save

Question 24 (2.5 points)

When a value is typed into a cell it also displays on the:

Question 24 options:

	a) fill handle.
	b) formula bar.
	c) function bar.
	d) value box.

Save

Question 25 (2.5 points)

__________ displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas.

Question 25 options:

	a) Insert Options button
	b) AutoComplete
	c) Quick Analysis Tool
	d) Data Analysis Tool

Save

Question 26 (2.5 points)

The default format that Excel applies to numbers is the ____________ format.

Question 26 options:

	a) comma
	b) calculating
	c) accounting
	d) general

Save

Question 27 (2.5 points)

On startup, Excel displays a new blank:

Question 27 options:

	a) document.
	b) workbook.
	c) worksheet.
	d) grid.

Save

Question 28 (2.5 points)

A __________ is two or more cells that are adjacent (next to each other) or non-adjacent (not next to each other).

Question 28 options:

	a) column
	b) width
	c) range
	d) cell cluster

Save

Question 29 (2.5 points)

__________ is an equation that performs mathematical calculations on values in a worksheet.

Question 29 options:

	a) Formula
	b) AutoSum
	c) Operator
	d) AutoFill

Save

Question 30 (2.5 points)

The data that displays in the Formula Bar is referred to as the:

Question 30 options:

	a) constant value.
	b) underlying value.
	c) formula.
	d) calculated value.

Save

Question 31 (2.5 points)

Dragging a column to the right increases the:

Question 31 options:

	a) length.
	b) width.
	c) number of rows.
	d) cell size.

Save

Question 32 (2.5 points)

The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:

Question 32 options:

	a) pixels.
	b) operators.
	c) data points.
	d) option tags.

Save

Question 33 (2.5 points)

__________ is a specific way in which Excel displays number in a cell.

Question 33 options:

	a) Number values
	b) Number format
	c) Label
	d) Numerical theme

Save

Question 34 (2.5 points)

__________ is an element of the Excel window that displays the name of the selected cell, table, chart, or object.

Question 34 options:

	a) Cell content
	b) Graphic content
	c) Formula Bar
	d) Name Box

Save

Question 35 (2.5 points)

Values can be copied to adjacent cells, based on the first cell, by using the:

Question 35 options:

	a) fill handle.
	b) formula bar.
	c) function bar.
	d) value box.

Save

Question 36 (2.5 points)

A formula can be created by inserting a ____________ (a prewritten formula).

Question 36 options:

	a) formula template
	b) function
	c) row calculation
	d) cell configuration

Save

Question 37 (2.5 points)

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:

Question 37 options:

	a) name box.
	b) select all box.
	c) split box.
	d) copy box.

Save

Question 38 (2.5 points)

__________ is a defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

Question 38 options:

	a) Cell address
	b) Cell style
	c) Cell reference
	d) Cell content

Save

Question 39 (2.5 points)

__________ that refers to cells by their fixed position in a worksheet.

Question 39 options:

	a) Relative cell reference
	b) Dynamic cell reference
	c) Cell address
	d) Absolute cell reference

Save

Question 40 (2.5 points)

The chart __________ is a combination of chart elements that can be displayed in a chart such as a title, legend, labels for the columns, and the table of charted cells.

Question 40 options:

	a) type
	b) layout
	c) filters
	d) theme