Write the functions of different tabs used in ms word and spreadsheet ms excel
Answers
Answer:
The mainly used shortcut Key+Fun Button features briefly point out in below.
File Button
Quick Access Tool Bar
Different Tab Ribbons
Title Bar
Home
Insert
Page Layout
Formulas
Data
Review
View
Control Buttons
Name Box
Formula Bar
Row, Column, and Cells
Sheet Tabs
Horizontal and vertical Scroll Bar
Zoom Slider
Groups
Dialog box luncher
So, Are going to Describe whole things in Excel Worksheet.
Here’ we started from 1st to the last countdown. Please don’t skip any point if you really want to learn everything in excel.
Main components of Ms. Excel Worksheet
File Button: The leftmost tab on the Ribbon at the top of the Excel window — replaces the Excel 2007 Office button and the Excel 2003 and earlier versions File menu. This is where you will find commands and settings to manage and share your files…
Ms Excel file button
Quick Access Tool Bar: The Quick Access toolbar contains a few command icons. By default, this toolbar holds buttons Save (Ctrl+S), Undo (Ctrl+Z), and Redo (Ctrl+Y). Although you can customize the Quick Access toolbar to include your favorite command that you frequently use.
Different Tab Ribbons: It contains tabs of Home, Insert, Page Layout, Formulas, Data, Review, and Views. Each tab holds a group of commands associated with the tab.
Title Bar: The title bar displays the name of the active Spreadsheet.
Ribbon: Below the title bar is the Ribbon, which includes all Excel commands available in a single area so that you can work with the program efficiently. The commands in the Ribbon vary depending on which tab is selected. Workbook commands are represented as buttons on the tabs that make up the Ribbon. By default, the Home tab is active. Other tabs can be activated by clicking on one of the other tabs, such as Insert, which displays the buttons of that tab. The Ribbon is arranged in groups of related commands. Here’s a quick overview of the Excel tabs. To get the respective ribbon, click on different tabs.
Home: You’re probably going to spend most of your time with the selected home tab. ‘ This tab contains basic clipboard commands, formatting commands, style commands, insert and delete commands for rows or columns, as well as a variety of worksheet editing commands.
Insert: If you need to insert something into a worksheet, select this tab — a table, a diagram, a chart, a symbol, etc.
Page Layout: This tab contains commands that affect your worksheet’s overall appearance, including printing settings.
Formulas: Use this tab to insert a formula, name a range, access the tools for formula auditing, or control how Excel performs calculations.
Data: Excel’ s data-related commands are on this tab.
Review: This tab contains tools for spell checking, translating words, adding comments, or protecting sheets.
View: The View tab contains commands that control different aspects of viewing a sheet. There are also some commands on this tab in the status bar.
Control Buttons:
At the right end of the title, the bar is the three familiar buttons that all windows programs have the same functions. You can temporarily hide the word window by clicking the Minimize button, adjust window size with the Restore Down / Maximize button, and close the active document or quit Excel with the close button.
Name Box:
The address bar shows the active cell’s address. That’s why we get A1 in the name box in the active cell above.
Formula Bar:
The formula bar is located in the top of the Excel worksheet below the toolbar. Use the formula bar to enter and edit the data from the worksheet. In the formula bar, the contents of the active cell will always appear.
Rows, Columns, and Cells:
Each worksheet consists of rows (numbered 1 to 1,048576) and columns (numbered A through XFD). Each column is identified by one, two, or three letters: letters A to Z is used in the first 26 columns. The next 26 columns are using AA to AZ, the following 26 BA to BZ, and so on. Excel uses three letters when the two-letter combinations are exhausted: AAA, B AAB, and so on. A number identifies each row, ranging from 1 to 1048576.
Each cell is identified by its column lettering and its row number. For example, the cell at the intersection of Column A and Row 1 is cell A1.
Sheet Tabs: By default, sheet tabs contain a list of worksheets, which includes three worksheets named Sheet 1, Sheet 2, and Sheet 3.
Horizontal and Vertical Scroll Bar: The Scroll Bar is used to drop up / down / right and left and see changes in the column/row number until you release the mouse button.
Zoom Slider: A slider that magnifies or reduces the content in the worksheet area.
Groups: Buttons are organized into groups on each tab. Depending on the size of the program window, the button you are most likely to use in some groups is larger than the rest.
Dialog box launcher:
Related but less common commands are not represented as group buttons. Instead, they are available in a dialog box that you can display by clicking the Launcher dialog at the right end of the group title bar.
It includes 7 tabs:Home ,Insert,Design ,Formulas ,
Layout Data ,Review ,View
Explanation:
Each tab has its own unique associated command groups. These groups have some additional commands that can be accessed by clicking the arrow in each group's right bottom corner.
Home tab: It includes a number of different clipboard, font, text, types and editing ribbons.
Insert tab: It have ribbons i.e, pages,tables,illustrations,add-ins,media,links,comments ,header and footer,text,symbols.
Design: It is used for editing in thee or you can say look of your text.
You can change the color and fonts and give watermark for your doc.
Formula:It is to add any calculations you have in the sheet you can check from this tab.
Layout: It is used for the margins and orientation setting for the doc you want. Also, there is spacing for your text that you can give in the sheet your working.
Review: In this tab you can see the options for proofing ,language translate,comments ,you can protect the sheet also you will get option for.
View:In this you will get option for macros ,switch the window,print Layout and read mode options,plus you can zoom in and pout option is present here.
Learn More:
brainly.in/question/8529025
brainly.in/question/16861003