# Excel Test By T. Batool A.Rahim

25 Questions | Total Attempts: 84  Settings  During this quiz/test, each student will be able to: § Be introduced to Microsoft Excel § Be able to describe what a spreadsheet is § Describe a spreadsheet (cells, rows, and columns) § Describe types of data in spreadsheets (labels, constants, and formulas) § Creating and understanding formulas

• 1.
A ________________ consists of a grid made from columns and rows?
• A.

Cell

• B.

Labels

• C.

• D.

Formulas

• 2.
Which of the following data can be put inside a cell?
• A.

Row

• B.

Column

• C.

Constant

• 3.
In a spreadsheet, the ________ is defined as the horizontal space that is going across the window.
• 4.
In a spreadsheet, the __________ is defined as the vertical space that is going across the window.
• 5.
___________ are used to designate each row's location.
• 6.
In a spreadsheet, the ___________ is defined as the space where a specified row and column intersect.
• A.

Labels

• B.

Cell

• C.

Formulas

• D.

Numbers

• 7.
Name this cell:
• 8.
In the spreadsheet below, provide an example of a label?
• 9.
True or False: Labels do not have a value associated with them
• A.

True

• B.

False

• 10.
True or False: Constants are entires that do not have a specified value
• A.

True

• B.

False

• 11.
In the spreadsheet below, provide an example of a constant:
• 12.
All formulas must begin with what?
• 13.
____________  are entires that have equations that calculates the value to display. n
• A.

Labels

• B.

Constants

• C.

• D.

Formulas

• 14.
Provide the formula for the following spreadsheet: If you work for 23 hours and make \$5.36 an hour, how much do you make?
• 15.
The ___________ function takes all of the values in each of the specified cells and totals their values
• 16.
The _________ function adds all of the indicated cells together and divides by the total number of cells.
• 17.
What is the symbol for multiplication?
• 18.
What is the symbol for division?
• 19.
What is the symbol for addition?
• 20.
What is the symbol for subtraction?
• 21.
What is not a basic part of a spreadsheet?
• A.

Formula

• B.

Cell

• C.

Row

• D.

Column

• 22.
_____________ are used to designate each column's location.
• 23.
The two most widely used charts are the:
• 24.
Name the three basic parts of a spreadsheet?
• 25.
In a spreadsheet, each cell may have three types of data in them: Name all three
Related Topics Back to top