Microsoft Excel

Question 1

It is a SPREADSHEET program developed by Microsoft for windows, macOS, Android, and iOS.
It features calculations, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA).
It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets.
Excel forms part of the Microsoft Office suit of software.

Answer 1

Microsoft Excel

Question 2

Microsoft originally marketed a spreadsheet program called _______in _____.

Answer 2

Multiplan and 1982

Question 3

Microsoft Excel features:

Answer 3

calculations, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA)

Question 4

Microsoft released the first version of Excel for the Macintosh on SEPTEMBER 30, 1985 and the first WINDOWS version was 2.05 (to synchronize with the Macintosh version 2.2) in NOVEMBER 1987.

Answer 4

read remember

Question 5

Microsoft maintained its advantage with regular new releases, every _____years or so.

Answer 5

2

Question 6

In 1995, Microsoft changed Excel’s naming system to emphasize the primary year of the product’s release. Excel 95 was designed for the latest 32-bit computers that used the Intel Corporation’s 386 microprocessor.
New editions appeared in 1997 (Excel 97) and 1999 (Excel 2000).
In 2003, Excel 2002 was released as part of the Office XP suite and included a significant new feature that allowed users to recover Excel data in the event of a computer crash.
Excel 2007 featured a redesigned interface, sharing features with the Microsoft products Word and Powerpoint and allowing users to move smoothly between these applications. In addition, chart making, data sharing, security, formula writing, sorting, and filtering were improved.

Answer 6

read and remember

Question 7

1. ANALYZING AND STORING DATA
2. Excel tools make your work easier
3. Data recovery and spreadsheets
4. Mathematical formulas of MS Excel make things easier
5. Security
6. Add sophistication to data presentation
7. Online access
8. Keeps data combine at one location
9. Helps businessmen in developing future strategy
10. Manage expenses

Answer 7

USES OF MICROSOFT EXCEL

Question 8

One of the best uses of MS Excel is that you can ____larger amounts of data to discover trends. With the help of graphs and charts, you can summarize the data and store it in an organized way so that whenever you want to see that data then you can easily see it. It becomes easier for you to store data and it will definitely save a lot of time for you. Once the data is stored in a systematic way, it can be used easily for multiple purposes.

Answer 8

ANALYZING AND STORING DATA

Question 9

There are so many tools of MS Excel that make your work extremely easy and save your time as well. There are many wonderful tools for sorting, filtering and searching which all more make your work easy. If you will combine these tools with tables, pivot tables etc. then you will be able to finish your work in much less time. Multiple elements can be searched easily from large amounts of data to help solve a lot of problems and questions.

Answer 9

Excel tools make your work easier

Question 10

Another best use of MS Excel is that if your data gets lost then you can recover it without much inconvenience.
Suppose, there is a businessman who has stored his important data in MS Excel and somehow it gets lost or the file gets damaged then he must not worry as with the new MS Excel XML format can restore the lost or damaged file data.

Answer 10

Data recovery and spreadsheets

Question 11

Next best use of MS Excel is that it makes easy for you to solve complex mathematical problems in a much simpler way without much manual effort. There are so many formulas in MS Excel and by using these formulas you can implement lots of operations like finding the sum, average, etc. on a large amount of data all at once. Therefore, people use MS Excel whenever they have to solve complex mathematical problems or they need to apply simple mathematical functions on tables containing larger data.

Answer 11

Mathematical formulas of MS Excel make things easier

Question 12

The chief use of MS Excel is that it provides security for excel files so people can keep their files safe. All the files of MS Excel can be kept password-protected through visual basic programming or directly within the excel file.

Answer 12

Security

Question 13

Another use of MS Excel is that it can be accessed online form anywhere and everywhere which means that you can access it from any device and from any location whenever you want. It provides the facility of working conveniently which means that it for you don’t have laptops then you can use mobile and do your work easily without any problem. Therefore, due to the large amount of flexibility that MS Excel provides, people like to work on MS Excel so that they can comfortably work without worrying about their device or location.

Answer 13

Online access

Question 14

Another interesting use of MS Excel is that you can keep all your data at one location. This will help you in saving your data from getting lost. It will keep all your data in one place and then you will not have to waste your time in searching for the files. So, it will save your time ad whenever need be, you can look up the categorized and sorted data easily.

Answer 14

Keeps data combine at one location

Question 15

You can represent data in the form of charts and graphs so it can help in identifying different trends. With the help of MS Excel, trend lines can be extended beyond graph and therefore, it helps one in analyzing the trends and patterns much easier. In business, it is very important to analyze the popularity of goods or the selling pattern that they follow to maximize sales. MS Excel simplifies this task and helps businessmen grow and maximize profits through the same.

Answer 15

Helps businessmen in developing future strategy

Question 16

MS Excel helps in_____. Suppose if a doctor is earning around 50,000 per month the he will make some expenses as well and if he wants to know how much he is exactly spending per month then he can do it with the help of MS Excel easily. He can write his monthly income as well as expenses in the excel tables and then he can get to know that how much he is spending and he can thus, control his expenses accordingly.

Answer 16

Manage expenses

Question 17

• Data Organization
  -Formula and Calculation Features
  -Third-Party Support
  -Office Integration

Answer 17

ADVANTAGES

Question 18

One of the biggest benefits of Excel is its primary function; The ability to organize large amounts of data into orderly, logical spreadsheets and charts. With the data organized, it’s a lot easier to analyze and digest, especially when used to create graphs and other visual data representations.

Answer 18

Data Organization

Question 19

Excel crunches numbers almost instantly, making batch calculations much easier than working things out yourself with a calculator. Depending on your understanding and skill with Excel, the formulas and equations are used to quickly compute both simple and complex equations using large amounts or data.

Answer 19

Formula and Calculation Features

Question 20

As part of Microsoft’s Office suite, Excel works with almost every other piece of software in Office. Excel spreadsheets can be easily added to Word documents and Power-Point presentations to create more visually dynamic reports or presentations.

Answer 20

Office Integration

Question 21

Excel is essentially considered the standard for spreadsheet software and as such enjoys considerable support on a number of platforms, including smartphones and tablets. Most other spreadsheets programs also support importing Excel sheets into their native formats and exporting their own spreadsheets as Excel files.

Answer 21

Third-Party Support

Question 22

Learning Curve
Calculation Errors
Time Consuming
Cost of Entry

Answer 22

DISADVANTAGES

Question 23

While just about anymore can pick up Excel and start filling in tables, getting the full benefit of its features takes a lot of practice. Users unfamiliar with Excel syntax may also find entering calculations and calling up other functions a bit frustrating until they get a solid understanding.

Answer 23

Learning Curve

Question 24

While Excel’s automatic calculate on functions make most large-scale batch calculations easy, it isn’t foolproof. Excel has no means of checking for human error data entry, which means that the wrong information can skew all the results sometimes disastrously. As Tim Worstall of Forbes reports, JP Morgan lost billions of dollars due to equation error in Excel introduced by users copying and pasting data.

Answer 24

Calculation Errors

Question 25

Manually entering data into Excel can take a very long time – especially if you have a lot of data to enter. The amount of time it takes to manually enter data can be extremely inefficient and as Lior Weinstein of Cogniview points out, can lead to boredom, which leads to potentially costly inattentiveness.

Answer 25

Time Consuming

Question 26

While there are several low or no-cost alternatives, getting genuine Microsoft Excel isn’t free. The cloud-based version of Excel requires a subscription to Office 365, while desktop editions have a purchase price of over $60 as of March 2015.

Answer 26

Cost of Entry

Question 27

PARTS OF MICROSOFT EXCEL

Answer 27

*Ribbon/Toolbar
*Quick Access Toolbar
*Menu bar/tabs
*zoom control
*View Buttons/ Worksheet View
*scroll bars
*name box
*active cell
*column
*ROW
*formula bar
*sheet tab/ leaf bar
*The Spreadsheet Area

Question 28

Under the diskette or save icon or the excel icon (this will depend on the version of the program), labels or bars which enable changing the sheet which is shown. These are the menu bar and contain a FILE, INSERT, PAGE LAYOUT, FORMULAS, DATA, REVIEW, VIEW, HELP and a SEARCH BAR with a light bulb icon. These menus are divided into subcategories which simplify the distribution of information and analysis of calculations.

Answer 28

Menu bar/tabs

Question 28

contains all of commands you will need to perform common task in Excel. It has multiple tabs, each with several groups of commands.

Answer 28

RIBBON/TOOLBAR.

Question 29

lets you access common commands no matter which tab is selected. By default, it includes the Save, Undo, and Repeat commands. You can add other commands depending on your preference.

Answer 29

QUICK ACCESS TOOLBAR

Question 30

is present at the lower-right side of the window. It enables us to ZOOM-IN or ZOOM – OUT a specific area of the specific area of the spreadsheet. It is represented by magnifying icons with the symbols of maximizing (+) or minimizing (-).

Answer 30

zoom control

Question 31

Excel 2016 has a variety of ______ that change how your workbook is displayed. These views can be useful for various tasks, especially if you’re planning to print the spreadsheet. To change worksheet views, locate commands in the bottom-right corner of the Excel window and select Normal view, page layout view, or Page Break view.

Answer 31

View Buttons/ Worksheet View.

Question 32

are the tools that enable us to move the document’s vertical and horizontal views. We can activate this by clocking on the platform’s internal bar or the arrows we have on the sides. Additionally, we can use the mouse wheel in order to automatically scroll up or down; or use the directional keys.

Answer 32

SCROLL BARS

Question 33

will show the location of the active cell, row, or column. We have the option of selecting multiple options

Answer 33

NAME BOX

Question 34

Excel worksheet, each small rectangle or box is known as a ____. The _____ isthe selected cell in which data is entered when you begin typing.

Answer 34

CELL - ACTIVE CELL

Question 35

is a vertical set of cells. A single worksheet contains _______total ______. Every _______has its own alphabet for identity, from A to XFD. We call it the COLUMN HEADINGS. You can select ________ by clicking on its header.

Answer 35

column - 16384 total column

Question 36

A ______is a horizontal set of cells. A single worksheet contains ______total ______. Every row has its own number for identity, starting from 1 to ______. We call it the ROW HEADINGS. You can select a ______by clicking on the row number marked on the left side of the window.

Answer 36

row - 1048576

Question 37

is an input bar, below the ribbon. It shows the content of the active cell and you can also use it to enter a formula in a cell.

Answer 37

formula bar

Question 38

will show all the workbook. By default you will see, three worksheets in your new workbook with the names Sheet 1, Sheet 2 and Sheet 3 respectively. Although you’re limited to 255 sheets in a new workbook, Excel doesn’t limit how many worksheets you can add after you’ve created a workbook.

Answer 38

sheet tab/ leaf bar

Question 39

is the place where we enter our data. It includes all the rows, cells, columns, and built-in data in the spreadsheet. We can use shortcuts to perform toolbar activities or formulas of arithmetic operations (add, subtract, multiply, etc.) The insertion point is the blinking vertical bar known as the “cursor”. It specifies the insertion location of the typing.

Answer 39

The Spreadsheet Area

Question 40

is the blinking vertical bar known as the “cursor”. It specifies the insertion location of the typing.

Answer 40

insertion point