Exam 3: Spreadsheet Software

Most spreadsheets do not offer a WYSIWYG screen.

Which of these terms refers to the ability to build a spreadsheet and then to change it to reflect alternative planning assumptions or scenarios?

When you have completed your spreadsheet, you should rigorously test it to make sure it is functioning as intended.

Which type of chart consists of a sequence of columns that illustrate numerical values?

What is numerical data in a spreadsheet called?

Calculations using the values in other cells are performed with:

The AutoFill command can be used to copy information from one cell to another as long as the cells are not adjacent to one another.

When building a spreadsheet, you should always:

You should always password-protect any spreadsheet that is going outside of the firm.

Which description of the following formula is accurate? =SUM(L50:L60)\2

A(n) cell reference, when copied, does NOT change to reflect its new location.

When you use the Protect Cells feature in a spreadsheet, you lock the spreadsheet so that no unauthorized party can view its contents.

A(n) cell reference, when copied, automatically changes to reflect its new location.

A graph that plots data or trends over time is called a:

Which answer below shows an example of a formula using a function command?

If you have a value or label that is too large for the cell, you need to change the:

You should save your work often when using a spreadsheet program to prevent the accidental loss of data.

Every cell in a spreadsheet has a:

Cell width refers to the number of characters that can be placed in any one cell.

What are headings and titles in a spreadsheet called?