0
What else can I help you with?
What is one page on a worksheet?
There is no specific name for one page on a worksheet. A worksheet can be printed and will appear on many pages, depending on its size. Word processing documents have pages, whereas spreadsheet documents have worksheets. A worksheet is broken down into rows, columns and cells. They are not really though of in terms of pages, until printing happens.
Do headers and footers offer any advantages over adding the information within the worksheet cells?
Yes. You are guaranteed that the data will appear at the top and bottom of every page, which is what you want to do if you are using headers and footers. You can be assured of their positions on the printed page, which isn't always the case with worksheet cells. The size of the fonts may change or rows may be added or removed, which would change the position of the worksheet cells. If you wanted to put text onto every page, only using cells, you would have to put data in multiple times. With headers and footers, it only needs to be put in once to appear on every page. Headers and footers have special facilities such as being able to determine the number of the page or the name of the workbook or worksheet being printed, which can be added in so that they appear on every page.
When you remove the boundary between two cells in a table or worksheet you are BLANK the cells?
merging
What is it called to print a range of cells in the active worksheet click what in the settings area in the print gallery?
"Print Selection" will let you printed a selected range of cells.
What are the Importance of headers and footers in a worksheet?
For large worksheets that print on multiple pages, they will allow for a standard heading on them and the possibility of other details, such as page numbers on them. A printed header and footer does not actually appear on the worksheet itself. Any headings for that purpose must be put into cells on the worksheet.
To create a worksheet you enter information into cells?
Technically, a worksheet is a worksheet even if it is empty. To create a worksheet that will do calculations, then you would start to enter things into its cells.
Where does a formula appear on a worksheet?
It will appear in the cell as you type it in. When it has been put in, you will see it in the formula bar. If you set the spreadsheet to show formulas, you can see all the formulas in their cells.
What is the difference between sheet tabs and worksheets?
A worksheet contains columns, rows and cells and is where you do your work. Each worksheet has a name. You can have more than one worksheet in a workbook. Each worksheet has a tab at the bottom of the screen, with its name on it. This is a sheet tab. It allows you to identify the different worksheets and by clicking on a sheet tab, you can change from one worksheet to another.
A colon between two cell references indicates a range of cells that includes?
the entire worksheet
What cell does formulas and functions in Excel make use of?
Cells are the fundamental element of a worksheet. All formulas are put into them. Most functions and formulas will reference cells on the worksheet. So cells are extremely important in Excel. Without them, you do not have a worksheet.
When considering which cells another worksheet user should be able to manipulate leave the cells?
When considering which cells another worksheet user should be able to manipulate, leave the cells _____.
When building a worksheet for novice users you should the cells in the worksheet that you do not want changed?
protect
