Exam 7: Mastering Spreadsheet Software

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 nurse is reviewing a spreadsheet and identifies a cell containing an absolute formula. Which symbol would the nurse interpret as indicating this?

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 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?

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

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

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

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 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 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 nurse wants to reference a cell range in another workbook to the current spreadsheet. Which process would the nurse use?

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

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?

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 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.

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:

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

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?

Dashboards would compare to which part on a car?

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: