google search

Monday, February 25, 2019

Saving your Workbook

How to insert rows, columns, and cells

How to save the workbook

  • Click on the Microsoft Office button.
  • Select and click on Save or Save As.

  • Save As allows you to name the file and choose a location to save the spreadsheet. Choose Save As if you would like to save the file for the first time or if you would like to save the file as a different name.
  • Select Save if the file has already been named.






The two most common ways of saving a workbook are;

There are many ways of saving but the two common ones are saving with a 2007 file extension, or as an Excel 97-2003 Workbook, which saves the file in a compatible format so that people who have earlier versions of Excel can open the file. 

Compatibility mode

There may be need to work with workbooks that were created using earlier versions of Microsoft Excel sometimes, such as Excel 2003 or Excel 2000. 
When you open these kinds of workbooks, they will appear in Compatibility mode.
Compatibility mode disables certain features, so you will only be able to access commands found in the program that was used to create the workbook. 

For example, if you open a workbook created in Excel 2003, you can only use tabs and commands found in Excel 2003.
  • You will want to access all features of Excel 2007, you can save the workbook in the Excel 2007 file format.

How to exit Compatibility mode

  • Click the Microsoft Office button.
  • Select Save As Excel Workbook.

Cell Addresses

Cell addresses

Each cell has a name or a cell address based on the column and row it is located. For example, this cell in the picture below is C3 because it is where column C and row 3 meet. This means that the row is row3 while the column is column C. as shown in the picture below.
  • You can select multiple cells at the same time. 

  • A group of cells is known as a cell range, rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon.

  • For example, a cell range that included cells B1, B2, B3, B4, and B5 would be written as B1:B5.

  • There is need that you may want to change the default reference style for Excel in case the column in your spreadsheet are labeled with numbers instead of letters. Review our Extra on What are Reference Styles.

How to edit or delete text

  •  Select the cell.
  • Press the Backspace key on the keyboard to delete text and make a correction.
Or
  • Press the Delete key to delete the entire contents of a cell.
  • You can also make changes to and delete text from the formula bar. Just select the cell, then place your insertion point in the formula bar. 


How to move through a worksheet using the keyboard

  • Press the Tab key to move to the right of the selected cell.
  • Press the Shift key then the Tab key to move to the left of the selected cell.
  • Use the Page Up and Page Down keys to navigate the worksheet.
  • Use the arrow keys.

Microsoft Excel Office Button

The Office button

This button appears at the top of the Excel window, left-clicking the button, a menu appears.
  • You can select and create a new spreadsheet from this menu, open existing spreadsheet files, save spreadsheet files in a different way, (e.g. saving your workbook in the default file format, or saving the workbook in the XML-based and macro-enabled file format, or saving in a binary file format optimized for fast loading and saving, or saving in a compatible with excel 97-2003) and also print spreadsheet File.
  • It also allows you to add security features, publish your work, send files, and also close files.

You want to change the default Excel Options

  • Click the Excel Options button. (A dialog box will appear)
  • To access a variety of Excel options, Select a category on the left.
  • Modify any of the default settings and click on
  • OK.
As a beginner, it is best to leave the default settings. But there will be time when you may want to change some settings as you learn more about the program and become more proficient at it 

Want to learn how to Create a workbook?

Want to learn how to insert text and numbers into Excel workbooks to be able to use it to calculate, organize and analyze data.

In this article, you will learn how to create a new workbook, how to insert and delete text, how to navigate a worksheet, and also save an Excel workbook.






Creating a new blank workbook

  • Left click the Microsoft Office button.

  • Select and click New command, (the New Workbook dialog box appears, and Blank Workbook is highlighted by default.
  • Click Create. A new blank workbook appears in the window.
Opening Excel for the first time, the program opens to a new blank workbook.

How to Insert text in the New workbook created?

  • Left-click a cell to select it
Each rectangle in the worksheet is called a cell. As you select a cell, the cell address appears in the Name Box.
  • Enter text into the cell using your keyboard. Notice that the text appears in the cell and in the formula bar.

Want to Learn Excel Quickly?

How to modify/adjust columns, rows, and cells

 Saving your Work in Microsoft Excel 

 Learn to change page views in a worksheet


  •  Locate the Page View options in the bottom-right corner.
  • Notice that the Options there include the Normal view, Page Layout view, and Page Break view. Click any one of the option to select it.

     


Want to add commands to the Quick Access toolbar?

Follow this guide to add commands to the Quick Access toolbar

  • Click on the arrow to the right of the Quick Access Toolbar.
  • Select the command you wish to add from the drop-down list. It will appear in the Quick Access Toolbar.
For example, to add a New Command button to the Quick Access Tool bar, you have to see step above
  • Click on the arrow to the right of the Quick Access toolbar, A drop down list appear
  • Select the New Command button from the drop down list
  • Notice the New Command button added to the Quick Access Toolbar.

OR
  • Select More Commands from the menu, (a dialog box will appear)
  • Select the command you want to add.
  • Click the Add button.
  • Click OK.
The three commands, Undo, Redo and save commands appear by default in the Quick Access Toolbar. You may want to add other commands to use Excel features very convenient.

You probably Want to remove commands from the Quick Access toolbar?

·         Click on the arrow to the right of the Quick Access toolbar.
·         Select and click on the command that you wish to remove from the drop-down list. It will disappear automatically 

Want to minimize and maximize the Ribbon

  • Click the drop-down arrow next to the Quick Access Toolbar.
  • Select Minimize Ribbon from the list. The Ribbon disappears.
  • To maximize the Ribbon, click the arrow again, then select Minimize the Ribbon to toggle the feature off.
The new tabbed Ribbon system replaces menus in Excel 2007. 
It is created to be easy to use and responsive to your task, minimizing the Ribbon is a great ideal if you would prefer to use other menus or shortcuts keys.
  • By right-clicking anywhere in the main menu and selecting Minimize the Ribbon in the menu that appears means you are minimizing and maximizing the Ribbon.

Tuesday, February 19, 2019

Microsoft Windows Operating System




https://computersecrecy.blogspot.com/2019/01/definition-of-operating-system.htmlMicrosoft Windows operating system was created in the mid-1980s. there have been many different versions of Windows over the years, but the most recent ones are Windows Vista 2007, Windows 7 2009, Windows 8 2012, and Windows 10 which was released in 2015. Windows originates pre-loaded on most new personal computers these helps to make it the most popular operating system in the world.



Linux
https://computersecrecy.blogspot.com/2019/01/definition-of-operating-system.htmlLinux is a household of open-source operating systems, this means that they can be altered and spread by everybody around the sphere. This is different from branded software like Windows, which can only be adjusted by the company that owns it. The advantages of Linux are that it is free, and there are various different distributions or forms you can choose from. Linux users account for less than 2% of global operating systems. Though, most servers run Linux because it's relatively easy to modify.



 Mac OS X
https://computersecrecy.blogspot.com/2019/01/definition-of-operating-system.htmlMac OS is a track of operating systems created by Apple. It derives pre-loaded on all new Macintosh computers, or Macs. All of the recent versions are known as OS X pronounced O-S Ten, and the specific versions include Mountain Lion (2012), Yosemite (2014), El Capitan released in 2015, Mavericks (2013), and Lion (2011).According to Stat Counter Global Stats, Mac OS X users account for less than 10% of global operating systems much lower than the percentage of Windows users more than 80%. One reason for this is that Apple computers incline to be more expensive. However, People mostly prefer the look and feel of Mac OS X over the Windows.