Vocabulary Test 1

1.

5 points

Double-click a cell or press F2 to go into worksheet...

AutoComplete

Template

Edit mode

Formula bar

2.

5 points

A _______________ is a feature that automatically adds the selected numbers in a column.

Cell address

Tool bar

AutoSum

AutoProduct

3.

5 points

What is an active cell?

The row and column location of the active cell, which appears in the name box.

A subdivision of a drive that you can create to hold files that are related to each other.

The cell in use or the cell that is ready to receive text or a formula.

A software application that is used for analysis and charting of numerical data.

4.

5 points

The location in a document where one page ends and another begins.

Range

Cell address

Task pane

Page break

5.

5 points

Formulas is a(n)

The area in an application window which displays information about the current status of the document.

feature that automatically adds the selected numbers in a column.

default location for saving and opening files

instruction to the computer to calculate data in a certain way

6.

5 points

What is located under the menu bar that displays icons which represent various commands?

Title bar

Autocomplete

Tool bar

Formulas

7.

5 points

Who is Steve Jobs?

An American entrepreneur, marketer, and inventor, who was the co-founder, chairman, and CEO of Apple Inc.

a former chief executive and chairman of Microsoft.

The inventor of Facebook.

principle of MacArthur High School

8.

5 points

A row is a horizontal area for data that is identified by a number along the side of a spreadsheet grid.

True

False

9.

5 points

AutoFill is an excel feature that allows you to drag, copy and fill data.

True

False

10.

5 points

A _______________ is a subdivision of a drive that you can create to hold files that are related to each other.

11.

5 points

One or more contiguous cells in spreadsheet application is...

Range

Template

Status bar

12.

5 points

A column is a vertical area for data that is identified by letter across a spreadsheet grid.

True

False

13.

5 points

To find the mean you would use what formula?

=sum(A2:A3)

=A2-A3

=average(A2:A3)

=A2/A3

14.

5 points

In spreadsheet, a label is a numeric entry that is able to be calculated.

True

False

15.

5 points

Drag and drop is...

The area in an application window which displays information about the current status of the document.

a designed and formatted document on which mew documents are based.

A method of moving text using the mouse. Text is “dragged” from its original location and dropped into its new location

The location of a cell as identified by the column letter and row number.

16.

5 points

_______________ is the name of Ms. Conwell's dog.

17.

5 points

Ms. Conwell allows you to bring food, drinks, and candy into the lab.

True

False

18.

5 points

The _______________ appears on the right side of the document/data/slide window on the startuup, and shows options pertinent to the task at hand.

19.

5 points

________________is a software application that is used for analysis and charting of numerical data.

Spreadsheet

Worksheet or Spreadsheet

Worksheet

None of the above

20.

5 points

Function arguments is...

In spreadsheet application, one or more contiguous cells.

The cell addresses that make up the data for the function formula.

In spreadsheets, a built-in formula that performs special calculation automatically.

Appears on the right side of the document/data/slide window on startup, and shows options pertinent to the task at hand.

21.

5 points

A text entry in spreadsheets is known as...

Title Bar

Row

Value

Label

22.

5 points

The Task pane appears on the right side of the document/data/slide window on start up?

True

False

23.

5 points

Ms. Conwell requires you to have a flash drive in this class, and if you do not have one you receive a zero.

True

False

24.

5 points

What is the definition of Autofit?

The excel feature that allows you to drag, copy, and fill data.

A feature that automatically adds the selected numbers in a column.

Feature to widen columns to fit the longest data in that column.

row and column location of the active cell, which appears in the name box.

25.

5 points

What is under the tool bars and shows the entry of data, and provides formula assistance?

Tool bar

Channing Tatum

Active cell reference

Formula bar