Some basics about MS-Excel 2010?
What is MS Excel 2010?
Microsoft Excel 2010 - is a program for which to display, format, analyze, and calculate numbers that display data in rows and columns.
Ms. Numbers makes it easy to count and allows different ways of organizing data, including charts and reports, it's a very powerful electronic spreadsheet that lets users enter and use statistical data with formulas and built-in functions. Let's go The workbook is a file in MS Excel that holds the worksheets.
A worksheet is composed of columns and rows that correspond to one calculation. It displays characters such as letters, numbers, and numbers, and the Cando calculation.
How Many Sheets in Excel?
With over 1000, you can add more sheets you want.
As you want It starts with 3 but can be up to several sheets depending on your computer's memory limit. How many columns in excel?
There are 16,384 columns in Excel 2010.
Too many rows in Excel
There are 1,048. , 576 rows (excel2010).
Parts of MS Excel and their functions?
1. Title bar - Displays the name of the program and workbook that you are currently using.
2. Menu bar (7 tabs) - List the menu or tab names in Excel.
3. Toolbar - Displays display commands that are commonly used for easy access.
4. Minimize button - Minimize the button window on the taskbar.
5. Distinguish between maximizing the window in the Max / Restore button and restoring the window to its previous size.6. Name Box - Displays the address of the active cell.
7. Formula Bar - Displays information about the selected command.
8. Sheet Tabs - Displays the open worksheet in the open booklet
9. The head of the row used a letter to identify the column.
10. Column Head Ù€ Number - The number used to identify the column.
11. Active Cells - cells that have a thin border that contains your text or entering data.
12. Scrollbar - includes vertical and horizontal scroll bars and four arrows are used to move the screen display horizontally or vertically.
13. Close Button- What is a window.
Some Excel Shortcuts of Ms. Excel 2010
CRTL Composition in ECXEL 2010
Ctrl + shift + (hide rows in the selection)
Ctrl + shift +) Hide the hidden columns in the section.
Ctrl + shift + and show the outline on the selected box.
Ctrl + shift + _ Deletes the selected fields as two outlines.
Ctrl + shift + ~ Applies to normal number format
Ctrl + shift + $ implements the current format with two decimal places (negative numbers in parentheses).
Ctrl + shift + 1 percent format with a numeric location.
Ctrl + shift + ^ Applies the output number format to two decimal places.
Ctrl + shift + # Applies to date format by day, month, and year.
Ctrl + shift + @ applies hours and minutes in time format. And am or pm + Shift +! The data can be applied to the TOI design space, thousands of separations, and negative values (-),
Ctrl + shift + * Selects the active area or active area around the bar.
Ctrl + Shift +: enter the current time.
Ctrl + shift + “Suppresses the pricing value or formulas over the dynamic box.
Ctrl + Shift + Shows the dialog box for entering a blank box.
Ctrl + Shift + - Displays the dialog for deleting the selected cells.
Tape + shift +; Sign up for current date.
Ctrl + Shift + 1
Displays the value of the cell between the job and formulas displayed in the worksheet. Ctrl + 1 shows the cells dialog box.
Apply Ctrl + 2 or remove the bold formatting.
Ctrl + 3 Applies or eliminates Italian formatting
Ctrl + 4 is down or deletes the highlight.
Ctrl + 5 implements or eliminates strategic.
Ctrl + 6 Alternate between hiding items, showing items, and storing items
Ctrl + 8 Shows or hides the outward symbols.
Ctrl + 9 Hide selected rows.
Ctrl + 0 hides the selected columns. Ctrl + A selects the entire worksheet. If the worksheet contains data, CTRL + A selects the current region. CTRL + press time selects the timesheet.
Ctrl + B Enables or removes bile formatting.
Ctrl + C Duplicate selected fields.
Ctrl + C shows the clipboard behind the second CTRL + C.
Ctrl + D uses the full download command to copy the contents and format of the box below.
Find and delete the Crtl + F display box. Along with the Search tab.
CTRL + shift + F selects the Format Cells dialog box with the selected Font tab.
Ctrl + G Go to the dialog box. Ctrl + H Search and Delete dialog box, with selected tabs.
Ctrl + I Applies or removes an Italian shape.
Ctrl + k Display the Hyperlink Dialog Box for the new hyperlink or the Edit Hyperlink dialog box for the selected hyperlink.
Ctrl + N Creates a new, blank worksheet.
Ctrl + O Displays an open dialog box for opening or searching for fire.
Ctrl + shift + O selects all the boxes containing the comments.
Ctrl + p The Print dialog box displays.
Ctrl + shift + P The Fancy tab opens the selected shape cells dialog box
Ctrl + R uses the left-right command to move the left-hand command to copy the contents and format of the link box used.
CTRL + S saves the active file with its current file name, location, and file format. Ctrl + T Displays the create table dialog box.
Ctrl + U underling applies or removes.
Ctrl + shift + U switches between expanding and collapsing the formula bar.
Ctrl + V Insert the contents of the clipboard at the insertion point.
Ctrl + Alt + V Displays the paste special dialog box.
Ctrl + W Closes the selected workbook window.
Ctrl + X Cuts the selected cells.
Ctrl + Y Repeats the last command or action, if possible.
Ctrl + Z Uses the Undo command to reverse the last command or delete the last entry that you typed.
0 Comments
Please do not enter any spam link and vulgar sentence in the comment box.