Question 1

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?

Accepted Answer

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 A

Question 2

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

Accepted Answer

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

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:

Accepted Answer

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

Question 4

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?

Accepted Answer

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 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

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 8

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?

Accepted Answer

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

Question 9

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?

Accepted Answer

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

Question 10

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.

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

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 13

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?

Accepted Answer

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.

Question 14

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)2 ÷ 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

Accepted Answer

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 15

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.

Accepted Answer

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 16

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:

Accepted Answer

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

Question 17

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

Accepted Answer

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 18

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?

Accepted Answer

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

Question 19

Dashboards would compare to which part on a car?

Accepted Answer

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

Question 20

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:

Accepted Answer

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

Exam 7: Mastering Spreadsheet Software