Chapter 1

Question 1

Which of the following is FALSE pertaining to Excel number formats?

Answer 1

The default number format is Comma

Question 2

In business terms, selling price refers to the original price of a product/service.
-true or false

Answer 2

False

Question 3

A seller asks more than the original price of a product/service when retail price is greater than selling price.
-true or false

Answer 3

False

Question 4

The fill handle:

Answer 4

is a small green square at the bottom-right corner of a cell.

Question 5

A range:

Answer 5

refers to a group of adjacent or contiguous cells.

Question 6

Excel displays data in gridlines of columns and rows. Those grid lines always appear on the printed document

Answer 6

False; a spreadsheet contains a grid of columns and rows to organize related data and it is not seen on a printed document

Question 7

An output area is defined as:

Answer 7

a region of a worksheet with formulas dependent on values from an input area.

Question 8

A cell address:

Answer 8

identifies a cell by a column letter and a row number.

Question 9

You should use cell references in formulas instead of constant values so that:

Answer 9

you can change the input values without changing the formulas

Question 10

Column width:

Answer 10

is adjustable so you can display more or less characters in a column