What Is MS Excel  Used For

Introduction To MS Excel:

• What Is MS Excel  Used For? MS Excel is a usually utilized Microsoft Office application. It is a calculation sheet program that is utilized to save and dissect mathematical information.

• In this article, we bring to you the significant highlights of MS Excel, alongside an outline of how to utilize the program, its advantages, and other significant components. A couple of test MS Excel questions and answers are likewise given further beneath in this article for the reference of Government test hopefuls.

• MS Excel used for 2013 is a popular spreadsheet program, where you design worksheets. It uses a workbook-style presentation which is made up of several worksheets, like a page in a notebook.

Elements Of Spreadsheet:

Excel Charts Graph

• Workbook:- A workbook is a collection of worksheets. In a single file, the user can store information in an organized manner. By default, a workbook contains three worksheets, and it has a maximum of 255 worksheets. The workbook is to sort or calculate the results. The workbook that is available to be viewed and edited by multiple users on a network is known as a shared workbook.  

• Worksheet:- A worksheet is a sheet made up of rows and columns. It begins with row number one and column A. Each cell can contain a number, text, or formula. It can also reference another cell in the same worksheet, the same workbook, or a different workbook. The worksheet is always stored in a workbook.

• Chartsheets:- Chartsheet is a separate sheet in a workbook that contains only graphs or charts. It is useful when you want to see a chart or tubular data separated from another type of data. 

• Row:- It is a horizontal block of cells that runs through the entire width of the worksheet. The row identifies the number that is on the left edge of the worksheet. The name of the first row is 1,2, and so on. Maximum row numbers range from 1,048,576 in an Excel 2013 worksheet.

• Column:- Columns in the Excel worksheet run vertically. It contains 16,384 (A to XFD ) columns. The columns are identified by letters A B and the final letter Z. After the letter Z, the next column is AA, AB, AC, . . . . AZ and then incrementing to BA, BB, and so on, to the last column XFD. 

• Cell:- Cell is the intersection between a row and a column is called a cell. It is identified by row number and column header so the cell is labeled as A1. For example, cell A9 is the intersection of column A and row 9. When you select a cell by clicking it with the mouse, it becomes the active cell. 

• Formula:- In Excel, formulas are used to calculate/ manipulate the numbers or text. It is a combination of values operators (+,-, / ,), and cell addresses ( for examples, A8, C2, and so on). While using formulas, it always beings with the (=) sign, you can refer to either cells or cell ranges or names or labels that represent those cells or cell ranges.

• Function:- Functions are pre-defined formulas or programs that perform calculations in Excel on specific values, called arguments. Each function takes specific types of arguments, such as numbers, references, text, or logical values.

How To Creating A Spreadsheet:

MS Excel 2013 needs Windows 8 and 10 operating systems to run on a PC. However, Excel 2013 can also run a Windows 7 operating system if service pack 3 is installed on Windows 7.

To start Excel 2013, perform the following steps:

1. Click the start button on the taskbar, highlight All Programs, and then click Microsoft Excel 2013.

Excel 2013 Interface:

Excel 2013 includes the MS Office fluent interface, which consists of a customizable visual system of tools and commands. Figure 1.1 shows the elements of the Excel 2013 application window.

Figure 1.1 - MS-Excel Interfaces

Title Bar:- At the top of an excel 2013 window, there is the Title Bar. The left edge of this bar has the office button next to which the name of the open document is displayed. On the right edge of the title bar, the minimize, Restore,/ maximize, and close buttons are placed, as seen in figure 1.1. 

• Application Window:- The window within which Excel 2013 runs.

• Quick Access Toolbar:- The Quick Access Toolbar lets you access common commands, no matter which tab is selected. You can customize the commands depending on your preference. This toolbar is located by default at the top of the Excel 2013 window. It provides tools that you use frequently, such as the save, undo and repeat buttons.

• Workbook window:- A window within the Excel 2013 application window in which a worksheet, chart, or dialog box is shown.

• File Tab:- The file tab is the colored tab which is located in the upper-left corner of Microsoft office 2016 programs and below the Quick Access Toolbar.

• Ribbon:- Ribbon is displayed just below the Title bar. In the ribbon, commands are organized in logical groups, which are collected together under tabs. You can hide the ribbon by double-clicking the active tab. Different types of tabs are described here, Which are available in the Ribbon of Excel 2013.

• Worksheets Tabs:- The tab is at the bottom of a workbook window that displays the name of a sheet. Click the sheet tab to move to the next sheet. To display the shortcut menu, right-click the sheet tab. To scroll through the sheet tabs, use the tab scrolling button.

• Name Box:- The name box is on the left side of the formula bar. It displays the location or name of a selected cell.

• Status Bar:- Status bar appears at the bottom of the Excel 2013 window. It displays information regarding a selected command or an operation in progress. Note that the right side of the status bar shows a zoom slider, and different views tools such as Normal, Page Layout, and page break view.

• Tell me:- The Tell me box works like a search bar to help you quickly find tools or commands you want to use.

• Cell:- An active cell in a rectangular box in a workbook is called a cell. A cell is an intersection of a row and a column. The border around the selected cell is called the cell pointer.

• Worksheet view options:- It offers three types of views in the status bar. Click to select the desired view to see it differently.

• Zoom Control:- You can drag the slider to use the zoom control and the number to the right side of the slider displays the zoom percentage.

• Vertical ad Horizontal Scroll bars:- Vertical scroll bars allows you to move up and down whereas horizontal scroll bars move up from left to right.

 Visit:-MS-Word, Introduction to computer, IOT Technology,