Deck 7: Mastering Spreadsheet Software

Question 1

A new nurse is learning how to use a spreadsheet and how it differs from word processing. Which action would the nurse most likely identify as specific to spreadsheets?

A) Features used in spreadsheets are different.
B) Programs are bundled with other office software.
C) Formula functions are built into the menu options.
D) Windows are used but icons are not.

Answer 1

Formula functions are built into the menu options.

Question 2

A nurse working on his personal computer is preparing a spreadsheet for his professional expenses. He plans to put data into the rectangles in the table. The nurse identifies these rectangles as:

A) Rows.
B) Columns.
C) Slots.
D) Cells.

Answer 2

Cells.

Question 3

A nurse has prepared a spreadsheet with times spent on various nursing activities. The data fill three columns and four rows. The nurse names a cell range that encompasses the first cell of the second column through the last cell of the third column. The nurse would express this cell range as:

A) 2.1 to 3.4.
B) B1/C4.
C) 2B:4C.
D) B1:C4.

Answer 3

B1:C4.

Question 4

A nurse is deciding about whether to create a spreadsheet or a table to present information. The nurse would most likely use a table for which information?

A) Listing benefits and limitations of breast-feeding
B) Monitoring for medication errors
C) Calculating length of stays of surgical clients
D) Documenting quality improvement of client care

Question 5

A nurse is reviewing a spreadsheet and identifies a cell containing an absolute formula. Which symbol would the nurse interpret as indicating this?

A) *
B) $
C) =
D) /

Question 6

When creating a spreadsheet that involves formulas, the user understands that the computer follows a specific order of operations. The following appears on the spreadsheet: 2 + 16 - 3(8 - 3)² ÷ 5. Place the operations listed below in the order that they would occur from first to last for this example.
A- Addition
B- Exponentiation
C- Parentheses
D- Division
E- Multiplication
F- Subtraction

A) A, F, E, D, C, B
B) C, D, F, E, A, B
C) B, D, F, A, C, E
D) C, B, E, D, A, F

Question 7

When creating a spreadsheet, a nurse locks the cells of a spreadsheet to prevent the nurse from changing the cell value. The nurse is engaged in:

A) Data protection.
B) Security.
C) Linking.
D) Freezing.

Question 8

To ensure that a spreadsheet effectively communicates what is intended, which action would be most important to include?

A) Entering two or three values into the cell if the data are to be sorted for analysis
B) Naming each spreadsheet to clearly identify its purpose or topic
C) Including a table of contents when designing a simple spreadsheet
D) Combining three or four tables in one worksheet for each workbook

Question 9

After entering information about groups of clients attending follow-up client education sessions into a spreadsheet, a nurse decides to create a chart to represent the information. Which type of chart would be most appropriate to use to depict the percentages of the groups of clients?

A) Pie chart
B) Column chart
C) Bar chart
D) Line charts

Question 10

When creating a chart from a spreadsheet using commercial software, which step would be done first?

A) Click on the chart tool menu
B) Select the type of chart for the data
C) Select the cells of data for the chart
D) Preview the chart on the screen

Question 11

Which actions demonstrate achievement of intermediate spreadsheet skills? Select all that apply.

A) Name a worksheet tab
B) Freeze rows
C) Import data in text format
D) Modify a pivot table
E) Create a dashboard

Question 12

A diabetic nurse educator is using a spreadsheet to perform an item analysis for a quiz given to several different groups of clients with diabetes over the past 6 months. The nurse educator has beginning-level spreadsheet skills. Which actions would the nurse educator most likely do? Select all that apply.

A) Use a separate worksheet for each of the tests in the workbook
B) Draft out the design using a pencil and paper first
C) Enter several values into each of the cells
D) Create a name for each spreadsheet developed
E) Customize the spreadsheet menu

Question 13

A nurse is enrolled in a class to learn how to use spreadsheet software. During one of the classes, the nurse asks, "What is the difference between a worksheet and a workbook?" Which response best answers this question?

A) "A workbook uses many more mathematical calculations than a worksheet."
B) "A worksheet is a spreadsheet but a workbook has one or more worksheets."
C) "The workbook is the starting point and the worksheet is the final result."
D) "The terms are used interchangeably in any spreadsheet program."

Question 14

A nurse manager has created a spreadsheet with data about the number of nurses enrolled in continuing education programs over the past 6 months. The nurse manager now wants to use this information to create a chart to compare the amounts over each quarter. Which type of chart would be most appropriate for the nurse manager to use?

A) Pie chart
B) Clustered bar chart
C) Stacked bar chart
D) Line chart

Question 15

A nurse is entering data into a spreadsheet and formats the cell as text. Which data would be appropriate for the nurse to enter into this type of cell? Select all that apply.

A) Medical record number
B) Zip code
C) Date
D) Time
E) Social security number

Question 16

A nurse working with a spreadsheet identifies that a logic error is occurring. The nurse understands that this type of error reflects:

A) Incorrect data entry.
B) Incorrect cell formula.
C) Bug in the program.
D) Omission of data.

Question 17

A nurse wants to reference a cell range in another workbook to the current spreadsheet. Which process would the nurse use?

A) Linking
B) Freezing
C) Data validation
D) Automatic data entry

Question 18

Dashboards would compare to which part on a car?

A) Engine
B) Tires
C) Instrument control panel
D) Steering wheel

Question 19

A nurse researcher is reviewing the line graph created from data on a spreadsheet. The researcher identifies the data point as:

A) Vertical axis of the chart
B) Label for the actual data value
C) Intersection of value on the x- and y-axes
D) The time values of the data

Question 20

A nurse is preparing to insert a date for the current year into a spreadsheet to be used for calculation. Which format would be most appropriate for the nurse to use?

A) April 3
B) 4:3
C) { 4-3}
D) 4/3