# Information Technology Quiz: Spreadsheet Applications.

25 Questions | Attempts: 435
Share  Settings  .

• 1.
An intersection of a row and column is call a _______________.
• A.

Row

• B.

Column

• C.

Grid

• D.

Cell

• 2.
Letters are used to identify __________________.
• A.

Row

• B.

Column

• C.

Grid

• D.

Cell

• 3.
Numbers are used to identify ________________.
• A.

Row

• B.

Column

• C.

Grid

• D.

Cell

• 4.
• A.

Budgetting and Payroll

• B.

Science and Energy

• C.

Art and craft

• D.

Social Stuidies and Spanish

• 5.
Which one of the following represents a Relative Cell?
• A.

B7

• B.

\$B\$7

• C.

\$7\$B

• D.

7B

• 6.
Which of the following represents an Absolute Cell?
• A.

B7

• B.

\$B\$7

• C.

\$7\$B

• D.

7B

• 7.
A ____________________ is an equation that tells the spreadsheet what action to take.
• A.

Range

• B.

Cell

• C.

Grid

• D.

Formula

• 8.
Which one of the following is NOT a type of spreadsheet?
• A.

Word Prefect

• B.

Lotus

• C.

• D.

Excel

• 9.
A ________________________ is an application program that allows text, numbers and formulae to be entered into a grid of rectangle cells.
• 10.
To enter a formula in a cell, you must start with an _______________________.
• 11.
B6  specifies the cell in ___________________ B.
• 12.
B6  specifies the cell in __________________ 6.
• 13.
To add together the values in cells A1 and A2, you would type the formula ______________.
• 14.
A popular spreadsheet application is _____________________.
• 15.
If 25 was entered into cell B4 and 75 was entered into cell C4, write the formula that would be used to add cell B4 and C4:
• 16.
If 25 was entered into cell B4 and 75 was entered into cell C4, write the formulae that would be used to multiply cell B4 by 4:
• 17.
If 25 was entered into cell B4 and 75 was entered into cell C4, write the formula that would be used to divide Cell C4 by 3:
• 18.
If 25 was entered into cell B4 and 75 was entered into cell C4, write the formula that would be used to subtract cell B4 from cell C4:
• 19.
Which one of the following is NOT a valid cell addresses?
• A.

G3000

• B.

DH30

• C.

• D.

550

• 20.
A ________________ can be used as a title or heading to describe an aspect of a worksheet.
• 21.
A _______________ is a piece of data that can be used in a calculation.
• 22.
_____________ is automatic left align.
• 23.
_______________  are automatic right align.
• 24.
Which symbol is used for multiplication in a spreadsheet?
• 25.
Which symbol is used for division in a spreadsheet?

## Related Topics Back to top
×

Wait!
Here's an interesting quiz for you.