Deck 11: Working With Spreadsheets

Question 1

Laptop computers present an ergonomic problem because the screen and keyboard are attached to each other.

Answer 1

True

Question 2

The arguments for a function are generally separated by commas and enclosed in parentheses.

Answer 2

True

Question 3

An LED produces on-screen images by manipulating light within a layer of liquid crystal cells.

Answer 3

False

Question 4

You place each number needed for a calculation in a block of the grid.

Question 5

You begin by entering a title and formulas that will identify your data.

Question 6

You can use spreadsheets for simple or complex calculations.

Question 7

A formula specifies how to add, subtract, multiply, or divide the numbers in worksheet cells.

Question 8

When you alter worksheet data, graphs related to that data do not automatically reflect the changes.

Question 9

A range is a series of cells.

Question 10

A spreadsheet is a tool for working with numbers.

Question 11

At lower screen resolutions, text and objects appear larger, but the apparent work area is smaller.

Question 12

The speed at which pixels change color is referred to as ghost time.

Question 13

Touch-sensitive screens can be classified as both input and output devices.

Question 14

Each dot of light on a computer screen is called a resolution.

Question 15

The person who creates a worksheet is responsible for its validity .

Question 16

A worksheet functions much like a visual computer.

Question 17

Most spreadsheet software includes sophisticated tools for testing worksheets.

Question 18

An argument is a label or cell reference that a function uses as the basis for a calculation.

Question 19

A formula begins with a(n) equal sign and contains cell references instead of raw numbers for a calculation.

Question 20

A cell reference is the column and row location of a cell.

Question 21

When creating a spreadsheet, you begin by entering a title and ____ that will identify your data.

A) cells
B) names
C) columns
D) labels

Question 22

The range for a graph is also referred to as a ____ or data series.

A) data set
B) formula
C) cell reference
D) data list

Question 23

When using the PMT function to calculate monthly car payments, the arguments include all but the following: ____.

A) date of purchase
B) interest rate
C) number of payments
D) cost of the car

Question 24

A(n) ____ is a predefined formula that performs simple or complex calculations.

A) function
B) argument
C) factor
D) calculator

Question 25

Arguments for a function are generally enclosed by ____.

A) commas
B) backslashes
C) parentheses
D) brackets

Question 26

Which of the following is not an additional formatting option helping to control the way your numbers are displayed?

A) dollar sign
B) decimal place
C) comma
D) semicolon

Question 27

A spreadsheet can examine several alternative ____scenarios.

A) average
B) what-if
C) test case
D) how-to

Question 28

Which of the following does not represent a range?

A) B1:B8
B) A2:G2
C) A2:H4
D) D2*D7

Question 29

Typically, a ____ begins with an equal sign (=) and contains cell references to the raw numbers for a calculation.

A) formula
B) calculation
C) cell reference
D) label

Question 30

Which of the following is NOT a typical worksheet error?

A) A formula contains a mixture of uppper and lower case characters.
B) A value entered in a cell is incorrect due to a typographical error.
C) A formula produces the wrong results because the order for the calculations is not correct.
D) The worksheet was created using a built-in function, but the wrong cells were selected as the arguments.

Question 31

A formula begins with ____.

A) #
B) *
C) =
D) &

Question 32

An electronic ____ is often referred to as a worksheet.

A) cell
B) spreadsheet
C) grid
D) formula

Question 33

A ____ is based on the data in a worksheet.

A) formula
B) function
C) graph
D) column

Question 34

Which of the following is NOT an example of spreadsheet software?

A) Google Sheets
B) Microsoft Excel
C) Microsoft Word
D) LibreOffice Calc

Question 35

A cell reference is the column and ____ location of a cell.

A) block
B) grid
C) row
D) line

Question 36

Your worksheet automatically calculates the ____ and displays the results.

A) equations
B) cells
C) scenarios
D) formulas

Question 37

Most spreadsheet software includes features that create ________ -- sometimes called charts.

A) formulas
B) functions
C) graphs
D) columns

Question 38

The ____ function calculates monthly payments.

A) ROUND
B) AVERAGE
C) STDEV
D) PMT

Question 39

Each number needed for a calculation is placed in a ____ of the grid.

A) box
B) frame
C) cell
D) label

Question 40

To create a formula, you should use ____ instead of the actual numbers.

A) equations
B) functions
C) cell references
D) scenarios

Question 41

Brighter monitors that offer more contrast give you more options for adjustments that can help you avoid ____.

A) back pain
B) neck pain
C) eye strain
D) stress injuries

Question 42

____ stores screen images as they are processed but before they are displayed.

A) A sound card
B) Video memory
C) A graphics card
D) A computer

Question 43

A ____ executes graphics commands, leaving the main processor free for other tasks.

A) graphics processing unit
B) video card
C) monitor
D) computer display device

Question 44

The speed at which pixels change color is referred to as ____ time.

A) resolution
B) display
C) response
D) ghost

Question 45

____ is the study of safe and efficient environments, particularly work environments.

A) Agriculture
B) Ergonomics
C) Economics
D) Environmentalism

Question 46

Which of the following is NOT an advantage of LCD technology?

A) high-radiation emissions
B) lightweight
C) compact in size
D) energy efficient

Question 47

In the figure above, what is the function of the button to which item 1 is referring?

A) It inserts a function into the selected cell.
B) It deletes the contents of the selected cell.
C) It opens a dialog box that gives you options for creating formulas.
D) It calculates the result of a function.

Question 48

Most displays have a recommended ____ at which images are clearest and text is crispest.

A) resolution
B) picture element
C) response time
D) viewing angle

Question 49

The ____ tab menu provides options to change the appearance of the chart labels, data markers, and dimensions.

A) CHARD TOOLS
B) GRAPH TOOLS
C) IMAGE TOOLS
D) GRAPHIC TOOLS

Question 50

In the figure above, the function indicated by item 1 calculates ____.

A) standard deviation
B) monthly payments
C) the average of a set of numbers
D) the sum of a set of numbers

Question 51

Integrated graphics ____ are built into a computer's system board.

A) networks
B) electronics
C) circuitry
D) displays

Question 52

Which of the following is a valid formula?

A) =A1+A2
B) =sum(A:B)
C) A1:A8
D) A1/B4

Question 53

In the figure above, item 2 is pointing to the ____.

A) data set for the PMT function
B) cell references used as a function
C) arguments that the PMT function uses as a basis for its calculation
D) function that calculates monthly payments

Question 54

____ computers present an ergonomic problem because the screen and keyboard are typically attached to each other.

A) Desktop
B) Graphic
C) Laptop
D) iPad

Question 55

Which of the following is NOT a type of graph?

A) bar
B) doughnut
C) high-low-close
D) average

Question 56

In the figure above, item 3 displays the result of a ____ function.

A) PMT
B) SUM
C) ROUND
D) AVERAGE

Question 57

The number of horizontal and vertical pixels that a device displays on screen is referred to as ____.

A) screen resolution
B) graphic resolution
C) display
D) output

Question 58

To use a function, simply select it from the function list, then follow the on-screen instructions to select the ____ that contain arguments for the calculation.

A) columns
B) rows
C) cells
D) references

Question 59

In the figure above, item 2 ____.

A) shows the different functions available
B) adds a function when you click it
C) displays the function and its arguments
D) creates an argument for a function

Question 60

To create a formula that adds cells H1 and H4, you would enter: ____.

A) H1+H4
B) H1-H2
C) =H1+H4
D) =H1:H4

Question 61

____________________ devices are a key computer system component.

Question 62

Handy spreadsheet software ____________________ include AVERAGE, SUM, PMT, STDEV and ROUND.

Question 63

What are the steps for creating a graph?

Question 64

____________________ graphics are built into a computer's system board.

Question 65

An electronic spreadsheet is often referred to as a(n) ____________________.

Question 66

Case-Based Critical Thinking Questions Case 11-1 Hal is starting a new job that requires him to work with spreadsheet software. He has never used spreadsheet software before. Hal needs to create a formula that multiplies the contents of cell B7 by the contents of cell C1. The correct way for Hal to enter this formula is ____.

A) B*/C1
B) B7/C1
C) =B7*C1
D) =B7/C1

Question 67

Case-Based Critical Thinking Questions Case 11-1 Hal is starting a new job that requires him to work with spreadsheet software. He has never used spreadsheet software before. Hal is having trouble getting a formula to calculate the correct results. His formula reads =2+10*5. The answer he should be getting is 60 but this formula results in an answer of 52. The correct way to write the formula Hal is looking for is ____.

A) =2+(10*5)
B) =(2+10*5)
C) =(2)+10*5
D) =(2+10)*5

Question 68

Describe three factors that may result in worksheet errors.

Question 69

The number of horizontal and vertical pixels that a device displays on screen is referred to as ____________________ resolution.

Question 70

____________________ is the science of configuring jobs, equipment, and workplaces with regard to worker health and safety.

Question 71

A formula specifies how to add, subtract, multiply, or divide the numbers in worksheet ____________________.

Question 72

The ____________________ for a graph is also referred to as a data set or data series.

Question 73

You can use a spreadsheet to examine several alternative "what-if" ____________________.

Question 74

Spreadsheet software first performs any operations in ____________________, then performs multiplication and division, and finally performs addition and subtraction.

Question 75

Case-Based Critical Thinking Questions Case 11-1 Hal is starting a new job that requires him to work with spreadsheet software. He has never used spreadsheet software before. Hal has noticed that his back hurts while working at his computer. In order to remedy this situation, Hal should ____.

A) get a different job that doesn't require him to sit at a computer all the time
B) get a chair that allows him to lean back slightly with his back supported from his pelvis to his shoulder blades
C) get a chair that is tilted slightly forward
D) lower his chair so he has to look up at his computer monitor