What are the elements of microsoft excel brainly

Brainly is a company based in Kraków, Poland, with headquarters in New York City. It is a social learning platform where millions of students and educators solve their academic problems together. Brainly's mission is to inspire students to share and explore knowledge in a collaborative community.[4] It can also be used as a forum for students, parents, and teachers to ask and answer homework questions. The platform has elements of n in the form of points and ranks. It encourages users to engage in the online community by answering other users’ questions. As of November 2020, Brainly reported having 350 million monthly users, making it the world's most popular education app.[5]

History[edit]

Initially called Zadane.pl, the company was founded in 2009 in Poland by Michał Borkowski (current chief executive officer), Tomasz Kraus, and Łukasz Haluch. The first million unique monthly users were achieved within 6 months after the release.[6]

In January 2011, the company founded Znanija.com, the first international project dedicated to Russian language speakers.[7] Several other versions in multiple languages for the following markets included Turkey (eodev.com), Latin America and Spain (brainly.lat), and Brazil (brainly.com.br).

Brainly was initially funded by the co-founders, but raised funds from Point Nine Capital in 2012.[8][9]

In December 2013, seven new language versions of Brainly were released, including English, Indonesian, Indian and more.

In October 2014, the company announced that it had raised another round of funding from General Catalyst Partners, Runa Capital, and other venture capital firms.[10] The total amount of the investment was $9 million, and the company opened headquarters in New York City.[11][12]

In May 2016, another funding round of $18 million of combined debt and equity was disclosed.[13] In June 2016, Brainly acquired the US-based OpenStudy.[14][15]

In March or April 2017, Zadane.pl changed to Brainly.[16]

In October 2017, Brainly raised $14 million in a funding round led by Kulczyk Investments.[17]

In January 2018, Brainly announced it had acquired the video education start-up, Bask,[18] to bring video technology to the Brainly platform.[19]

In July 2019, Brainly raised $30 million in a Series C funding round led by Naspers, with participation from Runa Capital and Manta Ray.[20]

In 2020, the company experienced a significant increase in the number of users, caused by the global COVID-19 pandemic, from 150 million in 2019 to around 350 million in 2020.[5][21]

In 2020, numerous users on the Art of Problem Solving website found that Brainly had compromised the integrity of the American Mathematics Competitions after posting the questions on its website with the correct answers. This led to Brainly updating its honor code.[22]

Platform[edit]

Overview[edit]

Brainly provides a platform where students, parents, and teachers help others with homework questions. The website is intended to strengthen student's skills across subjects such as English, mathematics, science, and social studies. The platform is utilises a peer-to-peer system where students can ask questions, and answer them for other students. Ranks are provided to students who provide high-quality answers. Users are asked to provide an explanation and a source for the answers they provide. Questions are categorized by subject, respective of country and school level.[23] Each user is given a fixed amount points upon registration, which are used to ask questions. Users can gain points by answering questions posted by others.[24] A leaderboard exists for users who have answered the most questions or earned the most points.

Brainly is moderated by both volunteers and staff and uses machine learning algorithms[25] to filter its Knowledge Base.[26][27] Moderators are trained users whose answers are excellent in content quality. Moderators are given permissions to respond to users who violate rules, including individuals who plagiarize, post spam, or post assessment questions.[citation needed]

Criticism[edit]

ToS;DR (Terms of Service; Didn't Read), a project which analyzes terms of services (ToS) and privacy policies of websites, ranks Brainly at grade E.[28]

The truth is: before you go for a job interview, you must have basic knowledge of Microsoft Excel. From an accountant to a receptionist, human resources to administration departments all are using Microsoft Excel.

It is not only limited to large companies, small entrepreneurs and college students are using it for their day-to-day work. That’s something that you can’t skip.  To get a job, learning basic Excel tasks (at least some) is a must in today’s era, that’s a firm truth.

And, to help you with this I have compiled this guide. This guide will help you to learn all those basics using some examples. And some of the most important beginner’s tutorials. 

So without further ado let’s get down to the business.

Introduction to Microsoft Excel

There is a number of spreadsheet programs but of all of them, Excel is the most widely used. People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features.

The best part about Excel is, that it can apply to many business tasks, including statistics, finance, data management, forecasting, analysis, tracking inventory & billing, and business intelligence. Following are the few things which it can do for you:

  • Number Crunching
  • Charts and Graphs
  • Store and Import Data
  • Manipulating Text
  • Templates/Dashboards
  • Automation of Tasks
  • And Much More…

The three most important components of Excel you need to understand first:

1. Cell

A cell is a smallest but most powerful part of a spreadsheet. You can enter your data into a cell either by typing or by copy-paste. Data can be a text, a number, or a date. You can also customize it by changing its size, font color, background color, borders, etc. Every cell is identified by its cell address, cell address contains its column number and row number (If a cell is on the 11th row and on column AB, then its address will be AB11).

2. Worksheet:

A worksheet is made up of individual cells which can contain a value, a formula, or text. It also has an invisible draw layer, which holds charts, images, and diagrams. Each worksheet in a workbook is accessible by clicking the tab at the bottom of the workbook window. In addition, a workbook can store chart sheets; a chart sheet displays a single chart and is accessible by clicking a tab.

3. Workbook

A workbook is a separate file just like every other application has. Each workbook contains one or more worksheets. You can also say that a workbook is a collection of multiple worksheets or can be a single worksheet. You can add or delete worksheets, hide them within the workbook without deleting them, and change the order of your worksheets within the workbook.

Microsoft Excel Window Components

Before you start using it, it’s really important to understand what’s where in its window. So ahead we have all the major components which you need to know before entering the world of Microsoft Excel.

excel basic with window components

  1. Active Cell: A cell that is currently selected. It will be highlighted by a rectangular box and its address will be shown in the address bar. You can activate a cell by clicking on it or by using your arrow buttons. To edit a cell, you double-click on it or use F2 as well.
  2. Columns: A column is a vertical set of cells. A single worksheet contains 16384 total columns. Every column has its own alphabet for identity, from A to XFD. You can select a column by clicking on its header.
  3. Rows: A row is a horizontal set of cells. A single worksheet contains 1048576 total rows. Every row has its own number for identity, starting from 1 to 1048576. You can select a row by clicking on the row number marked on the left side of the window.
  4. Fill Handle: It’s a small dot present in the lower right corner of the active cell. It helps you to fill numeric values, text series, insert ranges, insert serial numbers, etc.
  5. Address Bar: It shows the address of the active cell. If you have selected more than one cell, then it will show the address of the first cell in the range.
  6. Formula Bar: The formula bar 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.
  7. Title Bar: The title bar will show the name of your workbook, followed by the application name (“Microsoft Excel”).
  8. File Menu: The file menu is a simple menu like all other applications. It contains options like (Save, Save As, Open, New, Print, Excel Options, Share, etc).
  9. Quick Access Toolbar: A toolbar to quickly access the options which you frequently use. You can add your favorite options by adding new options to the quick access toolbar.
  10. Ribbon: Starting from Microsoft Excel 2007, all the options menus are replaced with ribbons. Ribbon tabs are a bunch of specific option group which further contains the option.
  11. Worksheet Tab: This tab shows all the worksheets which are present in the workbook. By default you will see, three worksheets in your new workbook with the names Sheet1, Sheet2, and Sheet3 respectively.
  12. Status Bar: It is a thin bar at the bottom of the Excel window. It will give you instant help once you start working in Excel.

Perform Basic Activities (Excel Knowledge Tutorials)

  • Add and Delete a Worksheet in Excel
  • Add and Remove Hyperlinks in Excel
  • Add Watermark in Excel
  • Apply Accounting Number Format in Excel
  • Apply Background Color to a Cell or the Entire Sheet in Excel
  • Delete Hidden Rows in Excel
  • Deselect Cells in Excel
  • Draw a Line in Excel
  • Fill Justify in Excel to Merge Text from Multiple Cells
  • Formula Bar in Excel (Hide, Unhide, and Expand)
  • Print Excel Gridlines (Remove, Shortcut, & Change Color)
  • Add a Button in Excel
  • Add a Column in Excel
  • Add a Header and Footer in Excel
  • Add Page Number in Excel
  • Apply Comma Style in Excel
  • Apply Strikethrough in Excel
  • Convert Negative Numbers into Positive in Excel
  • Group Worksheets in the Excel
  • Highlight Blank Cells in Excel
  • Insert a Timestamp in Excel
  • Insert Bullet Points in Excel
  • Make Negative Numbers Red in Excel
  • Merge – Unmerge Cells in Excel
  • Rename Sheet in Excel
  • Select Non-Contiguous Cells in Excel
  • Show Ruler in Excel
  • Spell Check in Excel
  • Fill Handle in Excel
  • Format Painter in Excel

  • View Two Sheets Side by Side in Excel
  • Increase and Decrease Indent in Excel
  • Insert an Arrow in a Cell in Excel
  • Quick Access Toolbar in Excel
  • Remove Pagebreak in Excel
  • Rotate Text in Excel (Text Orientation)
  • Row Vs Column in Excel (Difference)
  • Automatically Add Serial Numbers in Excel
  • Insert Delta Symbol in Excel in a Cell
  • Insert (Type) Degree Symbol in Excel
  • Top 10 Benefits of Microsoft Excel
  • Set Print Area in Exm,cel
  • Delete Blank Rows in Excel
  • Convert a Formula to Value in Excel
  • Excel for Accountants
  • Sort By Date, Date, and Time & Reverse Date Sort in Excel
  • Find and Replace in Excel
  • Status Bar in Excel
  • Make a Paragraph in a Cell in Excel
  • Cell Style (Title, Calculation, Total, Headings…) in Excel
  • Hide and Unhide a Workbook in Excel
  • Change Date Format in Excel
  • Center a Worksheet Horizontally and Vertically in Excel
  • Make a Copy of the Excel Workbook (File)
  • Write (Type) Vertically in Excel
  • Insert Text Box in Excel
  • Change Tab Color in Excel (Worksheet Tab Background Color)
  • Delete a Single Row or Multiple Rows in Excel
  • Copy and Paste a Column in Excel
  • Zoom In or Zoom Out in Excel

Keyboard Shortcuts for Excel

Following are some of the useful keyboard shortcuts that you learn to perform activities quickly.

  • Absolute Reference
  • Add Column
  • Add Comments
  • Add Indent
  • Add New Sheet
  • Align Center
  • Apply Border
  • Apply-Remove Filter
  • Auto Fit
  • AutoSum
  • Check Mark
  • Clear Contents
  • Close
  • Copy and Paste
  • Currency Format
  • Cut and Paste
  • Delete Cell
  • Delete Row(s)
  • Delete Sheet
  • Drag Down
  • Edit Cell
  • Fill Color
  • Find & Replace
  • Format Painter
  • Freeze Pane
  • Full Screen
  • Group
  • Hyperlink
  • Insert Cell
  • Insert Row(s)
  • Lock Cells
  • Merge-Unmerge Cells
  • Open Format Cells Options
  • Paste Values
  • Percentage Format
  • Print Preview
  • Save As
  • Select Row
  • Show Formulas
  • Strikethrough
  • Subscript
  • Superscript
  • Switch Tabs (Worksheets)
  • Transpose
  • Undo – Redo
  • Unhide Columns
  • Wrap Text
  • Zoom in – Zoom Out

Excel Functions

Following are some of the useful keyboard shortcuts that you learn to perform activities quickly.

  • Excel Date Functions
  • Excel Financial Functions
  • Excel Information Functions
  • Excel Logical Functions
  • Excel Lookup Functions
  • Excel Math Functions
  • Excel Statistical Functions
  • Excel String (Text) Functions
  • Excel Time Functions
  • INT
  • SUMPRODUCT
  • What is a Function in Excel
  • MROUND
  • MOD
  • SUMIFS
  • ABS

Below are my two favorite Excel books for beginners which every person who is starting out with Excel should read.

What are the elements of the Microsoft Excel?

The following are the basic parts of the Microsoft Excel Window:.
Quick Access Toolbar..
File Tab..
Title Bar..
Control Buttons..
Menu Bar..
Ribbon/Toolbar..
Dialog Box Launcher..
Name Box..

What are the elements of MS Excel 2010?

Let us now understand the various important parts of this window..
File Tab. The File tab replaces the Office button from Excel 2007. ... .
Quick Access Toolbar. ... .
Ribbon. ... .
Title Bar. ... .
Help. ... .
Zoom Control. ... .
View Buttons. ... .
Sheet Area..

What are the 5 features of Microsoft Excel?

Microsoft Excel Features.
#1 – You Can Insert a New Worksheets at Will..
#2 – Time Saving Shortcut Keys..
#3 – Get Quick Sum of Numbers..
#4 – Filtering Data..
#5 – Paste Special Feature..
#6 – Insert Random Numbers..
#7 – Insert Random Fraction Numbers..
#8 – Goal Seek Analysis Tool..