0
What else can I help you with?
How do you insert a picture in an Excel cell?
You cannot actually put a picture into a cell in Excel. Pictures and graphics sit on top of the worksheet but are not tied to any cell and so are not in a cell. So you can basically put a picture or graphic over a cell, but it is not actually in a cell, like you can put numbers or dates or text into a cell. They can be put into a worksheet by using the Insert Tab in newer versions of Excel, or the Insert menu in older versions. It can also be done through the Drawing toolbar.
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.
Where can you create a worksheet of scrambled words?
put a bunch of letter in the page
When entering numbers in a worksheet you must put if the number is to be used as currency true or false?
False
Why images are not bound to an Excel file cell?
Images cannot have any kind of formulas do things with them. They are not a data form for a spreadsheet, so they are not put in cells like dates, numbers, text etc. can be. Images float above the worksheet, not in actual cells. You can snap an image to gridlines, by pressing the Alt key when dragging and image, but the images are not put into a cell.
How can you scroll through a worksheet while still viewing the top five lines of that worksheet?
You can freeze the top 5 rows. Put the cursor in cell A6. The use the Freeze Panes option and all of the rows above the current cell will be frozen. As you then scroll down, those rows will stay on the screen.
What is the first action you would take to use the pointing technique to create a formula with a worksheet reference?
Type an equal sign (=) in the cell where you want to put the formula.
Do equals G15 do any assign in Excel?
Putting =G15 into any cell on a worksheet, will display the contents of cell G15. If you put it into G15 itself, then you will get what is known as a circular reference error, as the cell is referring back to itself which cannot be done.
What is a cell comment?
A notation added to a cell in a worksheet. This may give more information about what is in the cell. It is handy if you want to explain a formula or something about the value in a cell. You will know a cell has a comment in it by seeing a small red triangle in the top right corner. If you put the cursor over the cell, the comment will appear.
Can a chart be saved on the same worksheet as the data or on a separate worksheet?
A chart can be saved on the same worksheet or on a separate worksheet in Excel. The easiest way to put a chart on a separate worksheet is to create your chart on the same worksheet as your data. After you create your chart, just cut and past to the worksheet where you want it to show.
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.
How can you show only specific data on a worksheet in a workbook?
It depends on what you are trying to do. Here are some ways you can show specific data:Delete the data you do not want to show.Hide the row or column of data you do not want to show.Change the font color to the same color of the cell background (usually white).Put your calculations and data on one worksheet and display the results on another worksheet. You then can hide the worksheet you do not want anyone to see.
