Forwarded from M.S. Office, Excel, PowerPoint, Word
Which function in Excel tells how many numeric entries are there ?
Anonymous Quiz
30%
NUM
50%
COUNT
14%
SUM
7%
CHKNUM
Shortcut Keys
Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
Ctrl+K - Insert Hyperlink
Ctrl+N - New Workbook
Ctrl+O - Open
Ctrl+P - Print
Ctrl+R - Fill Right
Ctrl+S - Save
Ctrl+U - Underline
Ctrl+V - Paste
Ctrl W - Close
Ctrl+X - Cut
Ctrl+Y - Repeat
Ctrl+Z - Undo
Ctrl+A - Select All
Ctrl+B - Bold
Ctrl+C - Copy
Ctrl+D - Fill Down
Ctrl+F - Find
Ctrl+G - Goto
Ctrl+H - Replace
Ctrl+I - Italic
Ctrl+K - Insert Hyperlink
Ctrl+N - New Workbook
Ctrl+O - Open
Ctrl+P - Print
Ctrl+R - Fill Right
Ctrl+S - Save
Ctrl+U - Underline
Ctrl+V - Paste
Ctrl W - Close
Ctrl+X - Cut
Ctrl+Y - Repeat
Ctrl+Z - Undo
Shortcut Keys with use of Function keys.
F1 - Help
F2 - Edit
F3 - Paste Name
F4 - Repeat the last action
F4 - While typing a formula, switch between absolute/relative reference
F5 - Goto
F6 - Next Pane
F7 - Spell check
F8 - Extend mode
F9 - Recalculate all workbooks
F10 - Activate Menu bar
F11 - New Chart
F12 - Save As
F1 - Help
F2 - Edit
F3 - Paste Name
F4 - Repeat the last action
F4 - While typing a formula, switch between absolute/relative reference
F5 - Goto
F6 - Next Pane
F7 - Spell check
F8 - Extend mode
F9 - Recalculate all workbooks
F10 - Activate Menu bar
F11 - New Chart
F12 - Save As
If you want to go/Jump from cell A1 to C1, what shortcut will you use?
Anonymous Poll
42%
F5
24%
F1
23%
F3
10%
F10
Forwarded from M.S. Office, Excel, PowerPoint, Word
YouTube
MS Excel Shortcut Keys || Free Excel Guide #microsoftexcel #shortcut #mis #microsoftoffice #excel
#exceltips #computerexcel #cricket #freeexcel #freeexcelcourse #MSoffice#MSexcel #mis #shortcut #microsoftexcel #microsoftoffice #automobile #excel #
Forwarded from M.S. Office, Excel, PowerPoint, Word
YouTube
Paste Special option 'All except borders' English
Use of “All except borders” option in Paste Special Command.
In continuation of last topic of “Paste Special”. Let us discuss Fifth Option “All except borders”.
This will help in a situation where you want to copy the complete data with formulas and formatting…
In continuation of last topic of “Paste Special”. Let us discuss Fifth Option “All except borders”.
This will help in a situation where you want to copy the complete data with formulas and formatting…
What is a Spreadsheet?
A spreadsheet is a type of digital document that uses rows and columns to organize, calculate, and analyze data.
In Simple words
A spreadsheet is like a type of document.
It has rows and columns where you put numbers or text.
Many apps can make spreadsheets (Google Sheets, Excel, Numbers, etc.)
A spreadsheet is a type of digital document that uses rows and columns to organize, calculate, and analyze data.
In Simple words
A spreadsheet is like a type of document.
It has rows and columns where you put numbers or text.
Many apps can make spreadsheets (Google Sheets, Excel, Numbers, etc.)
What is Excel?
Excel is a spreadsheet software program made by Microsoft that is used to create, edit, and analyze spreadsheet documents.
In Simple Words
Excel is one specific app (made by Microsoft) used to create spreadsheets.
Excel is a spreadsheet program.
Excel is a spreadsheet software program made by Microsoft that is used to create, edit, and analyze spreadsheet documents.
In Simple Words
Excel is one specific app (made by Microsoft) used to create spreadsheets.
Excel is a spreadsheet program.
One line Difference Between Spreadsheet and Excel
➡️Spreadsheet = the document.
➡️Excel = a program used to create spreadsheets.
➡️Spreadsheet = the document.
➡️Excel = a program used to create spreadsheets.