Designing A Specific Task On Excel

1045 Words5 Pages
Here are the answers to some frequently asked questions about using Excel. They are here to provide you with some ideas as to the features contained but are in no way exhaustive. If you wish to find out how to perform a specific task on Excel then I recommend you visit the Microsoft Excel tutorials page at; https://support.office.com/en-us/article/Excel-2016-training-11af2a19-c46d-4b53-916d-f1597ba2b2ae You can also find many good video tutorials at YouTube.com. Excel is a widely used application and as such is well-documented online. What is the Ribbon in MS-Excel? Excel’s ribbon is at the top section of the application above the worksheet area. It is made up of a number of tabs divided into groups of buttons that will give you access…show more content…
Formulae are statements to be calculated written by the user. A formula can be made up from values, references, defined names and functions. An example of a formula is =IF( (A1<20*VAT), “Buy Cheese”, ”Buy Pickles” ) Functions are the codes that are built into Excel such as SUM, IF, COUNTA and MAX. They carry out operations of some kind and are used inside of formulae. How do I insert a row or column? First select one or more table rows above the position where you want to insert rows or to the left of the position where you wish to insert columns. Next, on the Home tab, in the Cells group, click the arrow next to Insert. A drop-down list will appear from which you can choose what you wish to insert. Is there a quick way to autofill a column? Yes. Click and drag the bottom right corner of the cell you wish to copy. Sometimes you can just double-click upon this corner and it will automatically fill in the column. How do I clear all formatting and cell contents from the cell in my spreadsheet? Pressing DELETE will delete the contents of a cell but to clear its formatting click on the arrow for Clear in the Editing Group on the Home tab and choose the option that best suits your needs. How do I show column titles on each page I print? To repeat a specific row at the top of each printed page click the Print Titles button in the Page Layout tab and a dialogue box will appear. Add an absolute reference to the row in the
Open Document