Term
| How do you select an entire excel worksheet? |
|
Definition
| Go into space between a & I and click |
|
|
Term
| What is each tab at the bottom of a page? |
|
Definition
| Each tab is it's own sheet |
|
|
Term
| How do you copy in excel? |
|
Definition
Right click and then dow the moe or copy
Must check create a copy |
|
|
Term
| How do you rename a worksheet tab? |
|
Definition
| double click on the bottom of the tab. |
|
|
Term
| how do you change the color of a worksheet table tab? |
|
Definition
| select tab and click color |
|
|
Term
| Can you resize a scroll bar in excel? |
|
Definition
| Yesm you can make it smaller or bigger to see more or less of the tab |
|
|
Term
| How can you resize multiple columns? |
|
Definition
| If you highilight too plus columns then you can resize one and make them all the same size |
|
|
Term
|
Definition
| When you hae a list of dates/numbersOn bottom right corner, move curos to get X and then click on last one and pull down and it will automatically fill them based on the pattern |
|
|
Term
| Can fill handlers be done with numbers or dates? |
|
Definition
| to have them fill in in, you must set pattersn by doing 5 items and then it can fill out the rest of it by picking up the pattern |
|
|
Term
| How do you remove info from a cell? |
|
Definition
| Do not delete the cell, rather right click andclear the comments |
|
|
Term
| How do you add currency symbols? |
|
Definition
| Click on currency and then add $ £ €, etc. |
|
|
Term
|
Definition
| Tyep # and then insert the comma into the text using insert comma |
|
|
Term
| What to do if you can't fit all the text you type in one cell? |
|
Definition
| when ttype text but it all can't fit in one cell, you can go to format and then warp text to get it into one cell |
|
|
Term
|
Definition
| two get a colum wider select two columns next to each other and then doubl click |
|
|
Term
| Importing/Exporting txt files |
|
Definition
1) To export a file as a txt save a txt delminated file
2) to import text file, go to the data and selet coloum data and go to te convert to text and pick idnetifies.
Then to get rid of spaces go to find a replae and hit spce and replace with nothing, and then hit replace all. |
|
|
Term
| How do you get an excel spread sheet all on one page? |
|
Definition
| go to scale to fit and thn fore it to be all on one page |
|
|
Term
| How acan you figure out where the page will break? |
|
Definition
| Go to page break preview on page view |
|
|
Term
| How do you print aonly a certain area? |
|
Definition
go to page layout, printa are and then check set print area.
Always check the page break privew to see what's highlighted to pring. |
|
|
Term
| How do you get lines in excel without adding borders? |
|
Definition
| got to payge layout and selecte print gridelines |
|
|
Term
| how can you fit a large excel sheet on one page |
|
Definition
| go layout and then margins and click no margins and then landscape orientation. and then scale to fit. |
|
|
Term
|
Definition
| Click on the header footer portion of the change. When you do this |
|
|
Term
| How to get header/footer? |
|
Definition
go to page layout and add the sectino that you want. if you just insert header/footer, the look and feel of the page changes.
You can creates a macro by type the things in the headers footer and inserttingdesign elements misxed with your own text. |
|
|
Term
| How do you get something across multiple columns? |
|
Definition
|
|
Term
| When should you do merge and center |
|
Definition
| Do it last becuase w/it can creat a lof o difficulties |
|
|
Term
| What does filter let you do? |
|
Definition
| Filter lets you see all occurences of something or some info and it will only show these |
|
|
Term
|
Definition
| Use either =sum or auto sum |
|
|
Term
| How do you get the sum for only certain cells? |
|
Definition
| You cna also change the numbers by highlighting them and/or use the control key to select them certain rows and enter and get sum and just look at the right of the page |
|
|
Term
| How do you add a commenbt? |
|
Definition
| Right click on cil and go to comment and add |
|
|
Term
|
Definition
1) With scs can go into note page an see info
2) CVS stands for comma delinated files). It is a way to share data between software programs.
3) If you change commas to pipes, you sitll have values |
|
|
Term
|
Definition
| a demlinator is a character that separates data |
|
|
Term
| What happens if you don't want to use comas as your delineator? |
|
Definition
| CSV is only for commas, if you use something else as your deliminator, you will have to save as .txt |
|
|
Term
| How do you get the proper formatting for deliminated files? |
|
Definition
| Open txt file in excel and then use the wizard to format propertly |
|
|
