#QUICK SPREADSHEET SOFTWARE#

You can't delete a sheet if you only have one in your spreadsheet.ĭuplicate allows you to make a copy of a worksheet tab. This pulls up the following menu of options: Tab menu optionsįrom there, you can accomplish any of the following:ĭelete is available once you have several sheets. The four bars button allows you to quickly change tab. You can access a lot of extra editing features by clicking on the dropdown arrow next to Sheet 1 . Tab bar next to Sheet 1Ĭlicking on the + sign will create a new tab. 😀 Tab barįurther down the spreadsheet, you have the tab bar where you can edit the tab. If you make a mistake as you go through this course and something goes awry, the Undo button is always there to help you go back to the ways things were. Use whichever way comes easiest and is fastest for you! You can choose between the quick action button, or navigating to Edit and selecting Undo, which requires an extra click. It's featured first in the quick action button bar, even though it's also in the Edit button dropdown. It's so commonly used, it had to be a quick action button. Undo is a good example of a quick action button. and then access them via the dropdown options which appear.

Quick action buttons are handy because they allow you to use certain features directly, rather than having to click on Edit, Insert, etc. You also have some quick action buttons for common tasks such as:Ĭhanging the data type (i.e., adding currency) You can use the options from the menu to work in your spreadsheet. You can see a menu bar at the top of the screen with File, Edit, View, Insert, and other options. In Google Sheets, edit the title by clicking on it Navigate in the interface Menu Replace it with something meaningful so you can easily find it later on. You can edit the name of the spreadsheet in Google Sheets by clicking on it. Let's check out what the blank spreadsheet looks like. Once you click on either of these, a new blank spreadsheet will appear. Open up your first spreadsheetĪfter navigating to a program (such as Google Sheets, Excel, or Numbers), a new spreadsheet can be brought up by clicking New on the menu or clicking a + sign. The is fundamental vocabulary you need to master in order to follow the rest of this course. Check out what we mean by Column, Row and Cell in a spreadsheet.

We'll come back to this in Part 3 of the course.

#QUICK SPREADSHEET SOFTWARE#

The difference between a formula and function is that a formula is an equation which can be designed by a user, and a function is a predefined calculation in the spreadsheet, hard coded into the software in advance. You may need to include several in a workbook and relate the data to each other.Ī formula is an expression telling the program what operation to perform.įunctions are predefined common formulas. Here are some other common terms we’ll use throughout this course.Ī spreadsheet is made up of columns and rows to organize data.Ĭolumns are vertical and hold a data value, whereas rows are the horizontal data value holders.Ī cell is where the rows and columns intersect.Ī tab is a spreadsheet of data and looks like a page as you navigate through it.Ī workbook is a collection of spreadsheets in separate tabs. Let’s get to the know the basic vocabulary.

Quick spreadsheet