Deck 3: Spreadsheet Software

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

Question 3

Every cell in a spreadsheet has a:

A)mouse pointer
B)cell address
C)cell indicator
D)range
E)formula

Answer 3

B

Question 4

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

A)Scenario planning
B)Option analysis
C)"What if" analysis
D)Relative cell referencing
E)Absolute cell referencing

Question 5

Calculations using the values in other cells are performed with:

A)graphs
B)text
C)labels
D)charts
E)formulas

Question 6

When using function commands, the beginning and ending cell addresses in a range are separated by a semicolon (;).

Question 7

When creating a spreadsheet, you should always make all of your columns 20 characters wide.

Question 8

What are headings and titles in a spreadsheet called?

A)Values
B)Text
C)Commands
D)Graphs
E)Formulas

Question 9

Arithmetic operators tell a spreadsheet how to compute values.

Question 10

What is numerical data in a spreadsheet called?

A)Values
B)Text
C)Labels
D)Cells
E)Formulas

Question 11

When inserting new rows into an existing spreadsheet, you can insert only one row at a time.

Question 12

Like a pie chart, a stacked column graph shows the relative contributions of various elements to a whole.

Question 13

Arithmetic operators can be used to add, subtract, multiply, and divide numbers.

Question 14

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

Question 15

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

Question 16

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.

Question 17

When creating a spreadsheet, it is recommended that you use complex headings and titles that only you and other members of your legal team would understand.

Question 18

Most spreadsheets do not offer a WYSIWYG screen.

Question 19

In a spreadsheet, rows proceed down the screen vertically.

Question 20

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

Question 21

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

A)complete
B)absolute
C)relative
D)optional
E)modified

Question 22

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

A)Bar graph
B)Line graph
C)Pie graph
D)Venn diagram
E)Box chart

Question 23

When you print in mode, you print down the length of the page.

A)column
B)portrait
C)row
D)landscape
E)macro

Question 24

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

A)bar chart
B)line graph
C)pie chart
D)Venn diagram
E)box chart

Question 25

When building a spreadsheet, you should always:

A)start in the uppermost left corner
B)make your cell widths as large as possible
C)enter your data first, then plan it out
D)audit your formulas
E)ignore the spreadsheet documentation

Question 26

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

A)cell height
B)cell width
C)column
D)row
E)formula

Question 27

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

A)The formula adds cells L50 through L60.
B)The formula adds cells L50 through L60 and multiplies by 2.
C)The formula adds cells L50 through L60 and divides by 2.
D)The formula adds cells L50 and L60 and divides by 2.
E)The formula divides cell L50 by cell L60 and multiplies the sum by 2.

Question 28

What statistical functions can a spreadsheet calculate?

A)Averages
B)Standard deviations
C)Square roots
D)All answers are correct.
E)No answer is correct.

Question 29

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

A)complete
B)absolute
C)relative
D)optional
E)modified

Question 30

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

A)+F20+F21+F22+F23
B)+F20+F21\2 * .10
C)=SUM(F20:F23)
D)+SUM(F20+F21−F23)
E)All answers are correct.