Case 2-2
Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status.
-When Antoinette shares her worksheet with other colleagues, she wants to ensure that everyone knows why certain cells are highlighted. To accomplish this, she will create a _____.
A) journal
B) documentation sheet
C) legend
D) formula sheet

Question

Case 2-2
Antoinette is part of a college department creating a number of student files with Microsoft Excel. She  is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status.
-When Antoinette shares her worksheet with other colleagues, she wants to ensure that everyone knows why certain cells are highlighted. To accomplish this, she will create a _____.
A) journal
B) documentation sheet
C) legend
D) formula sheet

Quizplus · Accepted Answer

A legend is used to explain the meaning of colors or symbols used in a worksheet. It helps to clarify the purpose of any highlighted cells or columns. A documentation sheet is used to explain the purpose, layout, and calculations used in a spreadsheet, but it is not specific to highlighting. A journal is a record of events or transactions, and a formula sheet is a separate document that shows the formulas used in a spreadsheet.

Case 2-2 Antoinette Is Part of a College Department Creating a Number