4. Cells must be __________ and the sheet protected to prevent edits being made to the data.
locked
secured
formatted
values
5. To print column and row headings on all pages, set the options in the __________ command in the Page Setup group.
Highlight
Set Print Area
Print All
Print Titles
6. __________ names in tables should be unique and meaningful for clarity purposes.
Row
Worksheet
Field
Workbook
7. To organize the records in
down arrow.
filter command.
sort command.
Format Painter.
8. To sort information in a table that has common information in a key field, you may want to perform a
__________ sort.
Secondary
Primary
Multiple Level
Single
You need to let us know what YOU THINK the answers to these questions are. Then someone here will be happy to help you.
To print column and row headings on all pages, set the options in the __________ command in the Page Setup group.
4. To answer this question, you need to know that cells can be locked in Excel to prevent edits being made to the data. To lock cells, you need to select the cells you want to lock, right-click, and choose "Format Cells." In the Format Cells dialog box, go to the Protection tab and check the "Locked" box. Next, you need to protect the sheet to actually enforce the cell locking. To protect the sheet, go to the Review tab, click on "Protect Sheet" and set a password if desired. This will prevent edits being made to the locked cells.
Therefore, the answer is "locked."
5. To print column and row headings on all pages in Excel, you need to use the "Print Titles" command in the Page Setup group. To access this command, go to the Page Layout tab and click on "Print Titles." In the Page Setup dialog box, go to the Sheet tab and under the "Print titles" section, specify the rows and/or columns to repeat on each printed page.
Therefore, the answer is "Print Titles."
6. When working with tables in Excel, it is important to assign unique and meaningful names to the fields within the table for clarity purposes. To give a field a name, select the range of cells that make up the field, go to the Formulas tab, and click on "Define Name" in the Defined Names group. In the New Name dialog box, enter a unique and meaningful name for the field.
Therefore, the answer is "Field."
7. To organize the records in Excel, you can use the sort command. To access the sort command, select the range of cells you want to sort, go to the Data tab, and click on the "Sort" button in the Sort & Filter group. In the Sort dialog box, choose the column you want to sort by and select either ascending or descending order. Click OK to apply the sort.
Therefore, the answer is "sort command."
8. To perform a sort in Excel on a table that has common information in a key field, you may want to do a primary sort. A primary sort will sort the data based on one key field. To perform a primary sort, select the range of cells you want to sort, go to the Data tab, and click on the "Sort" button in the Sort & Filter group. In the Sort dialog box, choose the column you want to sort by and select either ascending or descending order. Click OK to apply the sort.
Therefore, the answer is "Primary sort."