CCA-LBO

S1

1. 1. 1. Fundamental
      2. OS
      3. Internet

S2

1. 1. 1. Writer
      2. Calc
      3. Impress

CCA-LBO-S1

1. 1. Funsamental
   2. OS
   3. Internet

Fundamental

1. 1. 1Computer is an electronic device which is designed to automatically perform the calculations.
   2. Computers are classified according to their size, and this purpose of work.
   3. Computer was preceded by number of devices, which’ve been developed for making computations faster and reliable.
   4. History of Computer can be divided into two, Mechanical and Electronic era.
   5. Computer can be used almost in every aspect of personal as well as professional life.
   6. The major components of a digital computer are Central Processing Unit (CPU), Input and Output Devices, Memory .
   7. Input/ Output devices are those devices which are used to enter information into a computer or display results of data processing devices.
   8. An input device is a piece of computer hardware equipment used to provide data and control signals to an information processing system such as a computer.
   9. Various input device is keyboard, mouse, joystick, etc. An output device is any piece of computer hardware equipment used to communicate the results of data processing carried out by an information processing system (such as a computer) which converts the electronically generated information into human-readable form.
   10. Various output devices are printer, monitor, plotter, etc.
   11. A computer needs memory to store data, and has both external and internal storage area, that holds data and instruction during processing of data in binary form. Computer is a combination of hardware and software, which instruct the computer to perform functions.
   12. Data is a general term used to denote any or all facts, numbers, letters, symbols, etc. that can be processed or manipulated or produced by a computer.
   13. Data type refers to the term used to represent the value the data is expected to hold.
   14. Data processing is defined as a series of actions or operations that converts data into information.
   15. E-Governance is the application of modern information and communication technologies, such as Internet, Local area networks, mobiles, etc., by Government to improve the —effectiveness, efficiency, service delivery and to promote democracy.
   16. multimedia and entertainment are almost interlinked terms in today’s increasingly evolving and tech.
   17. The Motherboard holds the ROM, CPU, RAM and expansion cards.
   18. The language that the computer can understand and execute is called Machine language
   19. The term ‘Computer’ is derived from Latin.
   20. Charles Babbage is the inventor of “Difference Engine”.
   21. Charles Babbage is the father of Computer.
   22. Allen Turing is the father of Computer science.
   23. Edward Robert is the father of personal computer.
   24. A CPU contains control unit and an arithmetic logic unit.
   25. The User interface is controls the process of interaction between the user and the operating System.
   26. Network is a combination of hardware and software that facilitates the sharing of information
   27. Between computing devices Coded entries which are used to gain access to a computer system are called Passwords.
   28. Minicomputer works is faster than Microcomputer.
   29. You organize files by storing them in Folders.
   30. Printers of resource is most likely to be a shared common resource in a computer Network.
   31. Modem device is required for the Internet connection?
   32. Optical input device is a light pen.
   33. UNIVAC is Universal Automatic Computer.
   34. CD-ROM stands for Compact Disk Read Only Memory.
   35. ALU is Arithmetic Logic Unit.
   36. VGA is to Video Graphics Array.
   37. IBM 1401 is Second Generation Computer.
   38. MSI stands for Medium Scale Integrated Circuits.
   39. The capacity of 3.5-inch floppy disk is 1.44 MB.
   40. WAN stands for Wide Area Network.
   41. MICR stands for Magnetic Ink Character Reader.
   42. EBCDIC stands for Extended Binary Coded Decimal Interchange Code.
   43. Arithmetic & Logic unit is a part of the Central Processing Unit.
   44. CAD stands for Computer aided design.
   45. Computer can help in decision making process
   46. ALU is a part of CPU.
   47. The floppy disk having program in it is a magnetic storage device.
   48. OCR is a device that scans written or typed text and transforms it into computer readable form.
   49. The processing of one program after the other without user intervention is an example of batch processing.
   50. Access to data stored on magnetic tape is not random.
   51. Computer software is a normally classified as system software and application software
   52. The group of bits is used to represent a byte
   53. Logical errors in a program can be identified by the computer
   54. Computer can be used for education
   55. Set of instructions given to computers are called a program.
   56. Register device store instruction of data that the CPU process.
   57. Medium level language is not a computer language
   58. Machin language is directly understood by the computer without translation program.

Operating System

1. 1. An operating system is a program which acts as an intermediary between a user and the computer hardware.
   2. Operating system has two main objectives: managing the computer hardware and providing the interface.
   3. World’s largest selling operating system for PCs is MS Windows.
   4. Desktop is the first screen which displays on a computer. ▪ Background image of a desktop is known as a Wallpaper.
   5. Everything on your computer is made up of files, present on your hard disk.
   6. Distributed shared memory is the full form of DSM.

1. 7. Operating system is the program that controls the entire operation of a computer.
   8. A block of text is highlighted will happen in Windows OS by pressing the Arrow Key with Ctrl + Shift.
   9. Windows is an Operating System.
   10. IOS stands for International Standard Organization.
   11. Task bar do the time and date appear on the desktop.
   12. Unix is an open- source software of the following statements is incorrect about Unix.
   13. Ctrl + Esc or Press Windows Key shortcut key is used to open the Start Menu in the Windows operating system.
   14. Unix is freeware.
   15. Kernel is Graphics interface of operating system, A chip has a store and an important center of Linux and Unix.
   16. If the time and date of computer is wrong, then by using Control panel of the following can you reset it.
   17. In order for all parts of each computer to function properly and all other types of programs to run, it must have an Operating System.
   18. Linux Is Multitasking and Multi-user.
   19. Alt + F4 is the shortcut key to pop-up shut-down option in Windows operating system.
   20. In Windows operating system Window + R shortcut key is used to open run command dialog box.
   21. Shift + Tab shortcut key will be used to go to the previous option in the dialog box of Windows.
   22. Windows + M shortcut key will we use to minimize all windows in Windows OS.
   23. Oracle is not an operating system.
   24. Image shows on the desktop of Windows is called Wallpaper.
   25. Microsoft owns the monopoly of Windows-11 Software.
   26. The category of operating system you run on your PDA computer is Single user, single task Operating system.
   27. Keeping files organized on disk does a folder.
   28. Windows 11 is the latest Windows OS.
   29. Detecting and correcting errors in the system it mean to debug a system.
   30. Apache does not fall under the category of operating systems.
   31. Embedded Operating System operating system is autocomplete in the device and resides in ROM.
   32. Right man organizations is popular in the field of computer and software.
   33. The shortcut key to lock Ubuntu Operating System is Ctrl + Alt + L.
   34. A collection of daily software mean by operating system.
   35. To search the file or folder is the use of Ctrl + F in Windows OS.
   36. Linux is Open-Source operating system.
   37. OS does not boot automatically when the system is Shutdown.
   38. LPR and LP command is used to print a file in Unix.
   39. Run the application cannot be done with Windows Control Panel.
   40. A cursor is flashing or blinking light called on the screen.
   41. MS Windows Name the operating system based on GUI.
   42. Microsoft Edge Name of browser present with Windows 10.
   43. F8 function keys is used to launch new in the boot option in Windows-10.
   44. Alt + Tab shortcut key is used to move from one program to another?
   45. Double clicking on it, after clicking on it, by pressing and holding the inter key from the keyboard, pressing and pressing the key can I start the program from the icon on the desktop.
   46. Alt + F4 is the shortcut key to Shut-Down Windows.
   47. The Start button is used in Windows OS for Device setting, Turn off the system and Run applications.
   48. BIOS is used by operating system
   49. Ctrl + Tab is used to move to the next tab in the dialog box of Windows.
   50. DOS operating system does not support more than one program at a time.
   51. Ubuntu was launched by Canonical Limited.
   52. The best LINUX DISTROS for Ubuntu programmers.
   53. Title bar is present at the top most line of a window bar.
   54. A folder contain files is not sub folders.
   55. Recycle bin does allow you to easily recover deleted files and folders in windows.

Internet

1. 1. Repeater which operates on physical layer of an OSI model is used to connect two segments of a LAN.
   2. Hub acts as a centralized connection t several computers with central node or server
   3. Gateway connects two different network protocol together
   4. Modem convers digital signal to analog signal (demodulator) at receiver’s end.
   5. Switch joins multiple computers together with on LAN.
   6. Three common types of bounded media re: coaxial cable twisted pair cable, and fiber optics
   7. The internet is a network of
   8. Internet requires An account from an ISP, A computer with modem and Telephone line.
   9. Address number varies from 0-25.
   10. Absolute URL uses” Complete internet address.
   11. News groups are E-mail service.
   12. WAIS stands for Wide area information servers.
   13. WANs operate at the speed of less than I MBps while lans operate between 1 and 10 mbps.
   14. Web pages are uniquely identified by using
   15. Printer India has five workstations and two printers this is most likely a
   16. The world wide web is composed of Millions of web page.
   17. Some websites that network with friends and relatives are called Social Networking Sites.
   18. Many social media sites and services provide 2-Step Verification for valid account verification.
   19. Light storage is not an Information Technology Terminology.
   20. Simple Mail Transfer Protocol does SMTP signify.
   21. In SMTP, M stands for
   22. Full form of WWW is World Wide Web.
   23. E-Learning of reading or learning a subject with the help of Internet.
   24. Chatting, Photo Share and Video Clip Share among a group of people by instant messaging.
   25. Through VSNL Internet was started in India.
   26. Media Access Control is the meaning of MAC Address.
   27. When sending an e-mail, Subject line describes the content of the message.
   28. In Lower case often e-mail happens?
   29. Error is also called
   30. @ is use to add User name in an e-mail address.
   31. Apache is a web server.
   32. https://www.ucidream.com is an example of
   33. Address of a document or web page is a Uniform Resource Locator.
   34. Electronic mail address is made up of In two parts and true or false
   35. From an e-mail address, one can find out the domain name where this email address Is hosted
   36. web browser lets you to download only while surfing the internet.
   37. You can configure most e-mail application to check for mail as frequently as you desire.
   38. E -mail can be used to send broadcast messages.
   39. The internet is a commercial information service.
   40. Any computer on the internet can connect to nay other computer on the internet
   41. DNS provides mapping of IP with domain name
   42. News groups are also known as UseNet.

CCA-LBO-S2

1. 1. Writer
   2. Calc
   3. Inpreaa

Writer

1. 1. The Esc shortcut key in Writer Application of Libro Office which used for Closes an open menu.
   2. Alt + F shortcut key in Writer Application of Libro Office which used for opens the File menu.
   3. Alt + E shortcut key in Writer Application of Libro Office which used for opens the Edit menu.
   4. Alt + V shortcut key in Writer Application of Libro Office which used for opens the View menu.
   5. Alt + I shortcut key in Writer Application of Libro Office which used for open the Insert menu.
   6. Alt + O shortcut key in Writer Application of Libro Office which used for opens the Format menu.
   7. Alt + Y shortcut key in Writer Application of Libro Office which used for opens the Style menu.
   8. Alt + A shortcut key in Writer Application of Libro Office which used for opens the Table menu.
   9. Alt + R shortcut key in Writer Application of Libro Office which used for opens the Form menu.
   10. Alt + T shortcut key in Writer Application of Libro Office which used for opens the Tool menu.
   11. Alt + W shortcut key in Writer Application of Libro Office which used for opens the Window menu.
   12. Alt + H shortcut key in Writer Application of Libro Office which used for opens the Help menu.

• • • When a menu is opened, there may be sub-menu items with underlined characters. Press the underlined character directly to carry out the action or option.
    • Where two menu items have the same underlined character, press the character key again to move to the next menu item.
    • Menu items that have no underlined character have to be clicked on directly.

Navigation

1. 1. Left Arrow shortcut key in Writer Application of Libro Office which used for Moves the cursor one character to the left.
   2. Shift + Left Arrow shortcut key in Writer Application of Libro Office which used for Moves the cursor one character to the left and selects the character.
   3. Ctrl + Left Arrow shortcut key in Writer Application of Libro Office which used for Moves the cursor to the beginning of the previous word.
   4. Right Arrow shortcut key in Writer Application of Libro Office which used for Moves the cursor one character to the right.
   5. Shift + Right Arrow shortcut key in Writer Application of Libro Office which used for Moves the cursor one character to the right and selects the character.
   6. Ctrl + Right Arrow shortcut key in Writer Application of Libro Office which used for Moves the cursor to the beginning of the next word.
   7. Up Arrow shortcut key in Writer Application of Libro Office which used for Moves the cursor up one line.
   8. Shift + Up Arrow shortcut key in Writer Application of Libro Office which used for Moves the cursor up one line in the text and selects the lines of text.
   9. Ctrl + Up Arrow shortcut key in Writer Application of Libro Office which used for Moves the cursor to the beginning of the paragraph.
   10. Down Arrow shortcut key in Writer Application of Libro Office which used for Moves the cursor down one line.
   11. Ctrl + Down Arrow shortcut key in Writer Application of Libro Office which used for Moves the cursor to the end of the paragraph.
   12. Ctrl + Shift + Down Arrow shortcut key in Writer Application of Libro Office which used for Moves the cursor to the end of the paragraph. Selects the text in the paragraph from the cursor position to the end of the paragraph.
   13. Home shortcut key in Writer Application of Libro Office which used for Moves the cursor to the beginning of the current line.
   14. Shift + Home shortcut key in Writer Application of Libro Office which used for Moves the cursor to the beginning of the line and selects the text from the cursor position.
   15. Ctrl + Home shortcut key in Writer Application of Libro Office which used for Moves the cursor to the beginning of the document.
   16. End shortcut key in Writer Application of Libro Office which used for Moves the cursor to the end of the current line.
   17. Shift + End shortcut key in Writer Application of Libro Office which used for Moves the cursor to the end of the line and selects the text from the cursor position.
   18. Ctrl + End shortcut key in Writer Application of Libro Office which used for Moves the cursor to the end of the document.
   19. Page Up shortcut key in Writer Application of Libro Office which used for Scrolls up one page.
   20. Ctrl + Page Up shortcut key in Writer Application of Libro Office which used for Moves the cursor to the header.
   21. Page Down shortcut key in Writer Application of Libro Office which used for Scrolls down one page.
   22. Ctrl + Page Down shortcut key in Writer Application of Libro Office which used for Moves the cursor to the footer.

Text selection and deletion

1. 1. Select text while moving the cursor, hold down the Shift key as the cursor is moved.
   2. Double-click on a word with the cursor to select the word.
   3. Triple-click in a sentence with the cursor to select the whole of the sentence.
   4. Click four times in a paragraph with the cursor to select the whole of the paragraph.
   5. Select all of the text or objects in a document, use Ctrl + A.
   6. Use Ctrl + Delete to delete everything from the cursor position to the end of the word.
   7. Use Ctrl + Backspace to delete everything from the cursor position to the beginning of the word.

Controlling dialogs

1. 1. When opening any dialog, the Enter shortcut key in Writer Application of Libro Office which used for Activates selected button. When no button is selected, Enter is equivalent to clicking OK.
   2. When opening any dialog, the Esc shortcut key in Writer Application of Libro Office which used for Closes dialog without saving any changes made while the dialog was open. Esc is also equivalent to clicking Cancel. When a drop-down list is open and selected, Esc closes the list.
   3. When opening any dialog, the Spacebar shortcut key in Writer Application of Libro Office which used for Checks or clears an empty checkbox.
   4. When opening any dialog, the Up or Down Arrow shortcut key in Writer Application of Libro Office which used for Moves focus up or down a list. Increases or decreases value of a variable. Moves focus vertically within a section of dialog.
   5. When opening any dialog, the Left or Right Arrow shortcut key in Writer Application of Libro Office which used for Moves focus horizontally within a section of a dialog.
   6. When opening any dialog, the Tab shortcut key in Writer Application of Libro Office which used for Advances focus to the next section or element of a dialog.
   7. When opening any dialog, the Shift + Tab shortcut key in Writer Application of Libro Office which used for Returns focus to the previous section or element in a dialog.

Controlling documents and windows

1. 1. Ctrl + O shortcut key in Writer Application of Libro Office which used for Opens the Open dialog to select and open a document.
   2. Ctrl + S shortcut key in Writer Application of Libro Office which used for Saves the current document. If the document is a previously unsaved file, the shortcut opens the Save As dialog.
   3. Ctrl + N shortcut key in Writer Application of Libro Office which used for Creates a new document.
   4. Shift + Ctrl + N shortcut key in Writer Application of Libro Office which used for Opens the Templates dialog.
   5. Ctrl + P shortcut key in Writer Application of Libro Office which used for Opens the Print dialog to print the document.
   6. Ctrl + F shortcut key in Writer Application of Libro Office which used for Opens the Find toolbar.
   7. Ctrl + H shortcut key in Writer Application of Libro Office which used for Opens the Find and Replace dialog.
   8. Ctrl + Shift + F shortcut key in Writer Application of Libro Office which used for Searches for the last entered search term.
   9. Ctrl + Shift + J shortcut key in Writer Application of Libro Office which used for Toggles the view between full-screen mode and normal mode in Writer or Calc.
   10. Ctrl + Shift + R shortcut key in Writer Application of Libro Office which used for Opens and closes the rulers.
   11. F1shortcut key in Writer Application of Libro Office which used for Opens the LibreOffice Help contents in your default browser. If the local Help package is not installed, LibreOffice opens the online Help located at https://help.libreoffice.org.
   12. Shift + F1 shortcut key in Writer Application of Libro Office which used for Turns the cursor into a What’s This? question mark. Shows the tip for an item underneath the cursor. The shortcut does not work with the online help.
   13. Shift + F2 shortcut key in Writer Application of Libro Office which used for Turns on Extended Tips for the currently selected command, icon or control. The shortcut does not work with the online help.
   14. Ctrl + Shift + F10 shortcut key in Writer Application of Libro Office which used for Docks and undocks floating toolbars, Sidebar and Navigator.
   15. Ctrl + F4 or Alt + F4 shortcut key in Writer Application of Libro Office which used for Closes the current document. Closes LibreOffice when the last open document is closed.
   16. Ctrl + Q shortcut key in Writer Application of Libro Office which used for Exits LibreOffice.

Editing or formatting documents

1. 1. Enter shortcut key in Writer Application of Libro Office which used for When an OLE object is selected, activates the software used to create the OLE object. When a drawing object is selected, activates text mode.
   2. Ctrl + X shortcut key in Writer Application of Libro Office which used for Cuts selected text or objects from a document and places them in the clipboard.
   3. Ctrl + C shortcut key in Writer Application of Libro Office which used for Copies selected text or objects and places them in the clipboard.
   4. Ctrl + V shortcut key in Writer Application of Libro Office which used for Places text or objects from the clipboard that have copied or cut into the document.
   5. Ctrl + Alt + Shift + V shortcut key in Writer Application of Libro Office which used for Pastes unformatted text from the clipboard. The text is pasted using the format that exists at the insertion point.
   6. Ctrl + Shift + V shortcut key in Writer Application of Libro Office which used for Opens the Paste Special dialog.
   7. Ctrl + A shortcut key in Writer Application of Libro Office which used for Selects all text and objects in a document.
   8. Ctrl + Z shortcut key in Writer Application of Libro Office which used for Undoes last action.
   9. Ctrl + Y shortcut key in Writer Application of Libro Office which used for Redoes last action.
   10. Ctrl + Shift + Y shortcut key in Writer Application of Libro Office which used for Repeats last command.
   11. Ctrl + I shortcut key in Writer Application of Libro Office which used for Applies the Italic attribute to selected characters and text.
   12. Ctrl + B shortcut key in Writer Application of Libro Office which used for Applies the Bold attribute to selected characters and text.
   13. Ctrl + U shortcut key in Writer Application of Libro Office which used for Applies the Underline attribute to selected characters and text.
   14. Ctrl + M shortcut key in Writer Application of Libro Office which used for Removes direct formatting from selected text or objects. This command is also available in Format > Clear Direct Formatting in the Menu bar.

Sidebar keyboard shortcuts

1. 1. Tab shortcut key in Writer Application of Libro Office which used for Moves the focus in the Sidebar.
   2. Shift + Tab shortcut key in Writer Application of Libro Office which used for Moves the focus in the reverse direction in the Sidebar.
   3. Shift + F10 shortcut key in Writer Application of Libro Office which used for Opens a context menu for the selected element in the Sidebar.
   4. Home shortcut key in Writer Application of Libro Office which used for Moves focus to first entry.
   5. End shortcut key in Writer Application of Libro Office which used for Moves focus to last entry.
   6. Up or Down Arrow shortcut key in Writer Application of Libro Office which used for Moves the selection up or down and opens the panels in the selected deck.
   7. Right Arrow shortcut key in Writer Application of Libro Office which used for Opens any sub-elements in the selected element.
   8. Left Arrow shortcut key in Writer Application of Libro Office which used for Closes any sub-elements in the selected element.
   9. Ctrl + Enter shortcut key in Writer Application of Libro Office which used for Opens the Properties dialog for the selected element.
   10. Ctrl + R shortcut key in Writer Application of Libro Office which used for Opens the Enter Title dialog. Only themes added to LibreOffice can be renamed. Themes installed with LibreOffice cannot be renamed.
   11. Ctrl + D shortcut key in Writer Application of Libro Office which used for Deletes themes that have been added to LibreOffice. Themes installed with LibreOffice cannot be deleted.
   12. Insert shortcut key in Writer Application of Libro Office which used for Inserts a new theme into the Gallery and opens the Insert of New Theme dialog.
   13. Ctrl + Shift + Insert shortcut key in Writer Application of Libro Office which used for Inserts the selected object as a linked object into the current document.
   14. Ctrl + I shortcut key in Writer Application of Libro Office which used for Inserts a copy of the selected object into the current document.

Calc

1. 1. Shift + F1 shortcut key in Calc Application of Libro Office which used for Display context sensitive help.
   2. Ctrl + F1 shortcut key in Calc Application of Libro Office which used for Display the comment attached to the current cell.
   3. Ctrl + Shift + F2 shortcut key in Calc Application of Libro Office which used for Moves the cursor to the Input line where you can enter a formula for the current cell.
   4. Ctrl + Shift + F5 Ctrl + Shift + T shortcut key in Calc Application of Libro Office which used for Moves the cursor to the Name Box field on the Formula bar.
   5. Ctrl + A shortcut key in Calc Application of Libro Office which used for Selects all cells in the current sheet.
   6. Ctrl + Shift + R shortcut key in Calc Application of Libro Office which used for Redraws the document view.
   7. Ctrl + Shift + Z shortcut key in Calc Application of Libro Office which used for Reverses the action of the last undo command.
   8. Up Arrow shortcut key in Calc Application of Libro Office which used for Moves the cell focus up.
   9. Ctrl + Up Arrow shortcut key in Calc Application of Libro Office which used for Moves the cursor in the up direction to the edge of the current data range (if the cell adjacent to the cursor is empty, the cursor moves to the next cell that contains data).
   10. Shift + Up Arrow shortcut key in Calc Application of Libro Office which used for Selects the adjacent cell or cells located in the up direction.
   11. Ctrl + Shift + Up Arrow shortcut key in Calc Application of Libro Office which used for Selects in the up direction to the edge of the current data range (if the cell adjacent to the cursor is empty, the cursor moves to the next cell that contains data).
   12. Alt + Shift + Up Arrow shortcut key in Calc Application of Libro Office which used for Optimizes the row height based on the current cell.
   13. Right Arrow shortcut key in Calc Application of Libro Office which used for Moves the cell focus right.
   14. Ctrl + Right Arrow shortcut key in Calc Application of Libro Office which used for Moves the cursor in the right direction to the edge of the current data range (if the cell adjacent to the cursor is empty, the cursor moves to the next cell that contains data).
   15. Shift + Right Arrow shortcut key in Calc Application of Libro Office which used for Selects the adjacent cell or cells located in the right direction.
   16. Ctrl + Shift + Right Arrow shortcut key in Calc Application of Libro Office which used for Selects in the right direction to the edge of the current data range (if the cell adjacent to the cursor is empty, the cursor moves to the next cell that contains data).
   17. Alt + Right Arrow shortcut key in Calc Application of Libro Office which used for Increases the width of the current column.
   18. Alt + Shift + Right Arrow shortcut key in Calc Application of Libro Office which used for Optimizes the column width based on the current cell.
   19. Down Arrow shortcut key in Calc Application of Libro Office which used for Moves the cell focus down.
   20. Ctrl + Down Arrow shortcut key in Calc Application of Libro Office which used for Moves the cursor in the down direction to the edge of the current data range (if the cell adjacent to the cursor is empty, the cursor moves to the next cell that contains data).
   21. Alt + Down Arrow shortcut key in Calc Application of Libro Office which used for Opens a drop-down selection list of text items that have been previously typed into other cells in the same column.
   22. Shift + Down Arrow shortcut key in Calc Application of Libro Office which used for Selects the adjacent cell or cells located in the down direction.
   23. Ctrl + Shift + Down Arrow shortcut key in Calc Application of Libro Office which used for Selects in the down direction to the edge of the current data range (if the cell adjacent to the cursor is empty, the cursor moves to the next cell that contains data).
   24. Alt + Shift + Down Arrow shortcut key in Calc Application of Libro Office which used for Optimizes the row height based on the current cell.
   25. Left Arrow shortcut key in Calc Application of Libro Office which used for Moves the cell focus left.
   26. Ctrl + Left Arrow shortcut key in Calc Application of Libro Office which used for Moves the cursor in the left direction to the edge of the current data range (if the cell adjacent to the cursor is empty, the cursor moves to the next cell that contains data).
   27. Shift + Left Arrow shortcut key in Calc Application of Libro Office which used for Selects the adjacent cell or cells located in the left direction.
   28. Ctrl + Shift + Left Arrow shortcut key in Calc Application of Libro Office which used for Selects in the left direction to the edge of the current data range (if the cell adjacent to the cursor is empty, the cursor moves to the next cell that contains data).
   29. Alt + Left Arrow shortcut key in Calc Application of Libro Office which used for Decreases the width of the current column.
   30. Alt + Shift + Left Arrow shortcut key in Calc Application of Libro Office which used for Optimizes the column width based on the current cell.
   31. Home shortcut key in Calc Application of Libro Office which used for Moves the cursor to the first cell of the current row.
   32. Ctrl + Home shortcut key in Calc Application of Libro Office which used for Moves the cursor to the first cell (A1) in the current sheet.
   33. Shift + Home shortcut key in Calc Application of Libro Office which used for Selects cells from the cursor to the first cell of the current row.
   34. Ctrl + Shift + Home shortcut key in Calc Application of Libro Office which used for Selects all cells from the cursor to the first cell (A1) in the current sheet.
   35. End Moves the cursor along the current row to the cell in the last column containing data in the sheet.
   36. Ctrl + End shortcut key in Calc Application of Libro Office which used for Moves the cursor to the cell in the last column and row that contain data in the current sheet.
   37. Shift + End shortcut key in Calc Application of Libro Office which used for Selects cells along the current row from the cursor to the cell in the last column containing data in the sheet.
   38. Ctrl + Shift + End shortcut key in Calc Application of Libro Office which used for Selects all cells from the cursor to the cell in the last column and row that contain data in the current sheet.
   39. Pg up shortcut key in Calc Application of Libro Office which used for Moves up one screen page.
   40. Ctrl + Pg up shortcut key in Calc Application of Libro Office which used for Moves to the previous sheet.
   41. Shift + Pg up shortcut key in Calc Application of Libro Office which used for Selects cells from the cursor to the row one page up.
   42. Alt + Pg up shortcut key in Calc Application of Libro Office which used for Moves one screen page to the left.
   43. Alt + Shift + Pg up shortcut key in Calc Application of Libro Office which used for Selects cells from the cursor to the column one page to the left.
   44. Pg down shortcut key in Calc Application of Libro Office which used for Moves down one screen page.
   45. Ctrl + Pg down shortcut key in Calc Application of Libro Office which used for Moves to the next sheet.
   46. Shift + Pg down shortcut key in Calc Application of Libro Office which used for Selects cells from the cursor to the row one page down.
   47. Alt + Pg down shortcut key in Calc Application of Libro Office which used for Moves one screen page to the right.
   48. Alt + Shift + Pg down shortcut key in Calc Application of Libro Office which used for Selects cells from the cursor to the column one page to the right.
   49. Escape shortcut key in Calc Application of Libro Office which used for Cancels the current cell edit.
   50. Insert shortcut key in Calc Application of Libro Office which used for After making a selection, opens the Paste Special dialog.
   51. Ctrl + Insert shortcut key in Calc Application of Libro Office which used for Copies the selected cell or cell range to the clipboard in preparation for a later paste operation.
   52. Shift + Insert shortcut key in Calc Application of Libro Office which used for Pastes the contents of the clipboard into the selected cells.
   53. Delete shortcut key in Calc Application of Libro Office which used for Deletes cell contents without a dialog (does not remove formatting).
   54. Shift + Delete shortcut key in Calc Application of Libro Office which used for Removes and copies the selection to the clipboard.
   55. Ctrl + Backspace shortcut key in Calc Application of Libro Office which used for Refocuses the view back on the cursor if it is not currently in view.
   56. Shift + Backspace shortcut key in Calc Application of Libro Office which used for Deselects the current cell selection without deleting contents.
   57. Alt + Backspace shortcut key in Calc Application of Libro Office which used for Reverses the last command or the last entry you typed.
   58. Ctrl + [ shortcut key in Calc Application of Libro Office which used for Selects the cells on which the current cell is dependent.
   59. Ctrl + ] shortcut key in Calc Application of Libro Office which used for Selects the cells that are dependent on the current cell.
   60. Ctrl + / shortcut key in Calc Application of Libro Office which used for Selects the cells in the matrix formula range that contains the cursor.
   61. Ctrl + ’ shortcut key in Calc Application of Libro Office which used for Copies the contents of the cell above the cursor into the current cell, but remains in cell edit mode so that you can make further changes.
   62. Enter shortcut key in Calc Application of Libro Office which used for Moves the cursor to the next cell in the selected range, from top to bottom, then left to right. To specify in which direction the cursor moves, go to Tools > Options > LibreOffice Calc > General on the Menu bar.
   63. Ctrl + Enter shortcut key in Calc Application of Libro Office which used for Inserts a manual line break in the current cell while editing a cell.
   64. Ctrl + Shift + Enter shortcut key in Calc Application of Libro Office which used for Creates a matrix in the current range using the information entered on the input line.
   65. Alt + Enter shortcut key in Calc Application of Libro Office which used for Fills the selected cell range with the formula that you entered on the input line.
   66. Alt + = shortcut key in Calc Application of Libro Office which used for Equivalent to selecting Select Function > Sum on the Formula bar.
   67. Chart keyboard shortcuts
   68. Tab shortcut key in Calc Application of Libro Office which used for Selects the next chart element.
   69. Shift + Tab shortcut key in Calc Application of Libro Office which used for Selects the previous chart element.
   70. Home shortcut key in Calc Application of Libro Office which used for Selects the first chart element.
   71. End shortcut key in Calc Application of Libro Office which used for Selects the last chart element.
   72. Esc shortcut key in Calc Application of Libro Office which used for Cancels selection.
   73. Arrow keys shortcut key in Calc Application of Libro Office which used for Moves the element in the direction of the arrow.
   74. Arrow keys in pie charts shortcut key in Calc Application of Libro Office which used for Moves the selected pie segment in the direction of the arrow.
   75. F2 shortcut key in Calc Application of Libro Office which used for in titles Enters text input mode.
   76. F3 shortcut key in Calc Application of Libro Office which used for in legends and data series Opens groups so that you can edit the individual components.
   77. Ctrl + F3 shortcut key in Calc Application of Libro Office which used for in legends and data series Exits groups.
   78. + /- shortcut key in Calc Application of Libro Office which used for Enlarges or shrinks the chart (use the + / – keys in the numeric keypad).
   79. + /- shortcut key in Calc Application of Libro Office which used for in pie charts Moves the selected pie segment off or into the pie chart (use the + / keys in the numeric keypad).
   80. Tab shortcut key in Calc Application of Libro Office which used for Cycles through each outline indicator from top to bottom or left to right.
   81. Shift + Tab shortcut key in Calc Application of Libro Office which used for Cycles through each outline indicator in the opposite direction.
   82. Ctrl + 1 to Ctrl + 8 shortcut key in Calc Application of Libro Office which used for Show all levels up to the specified number while hiding all highernumbered levels in the outline.
   83. + /- shortcut key in Calc Application of Libro Office which used for Shows ( + ) or hides (-) the focused outline group (use the + / – keys in the numeric keypad).
   84. Enter shortcut key in Calc Application of Libro Office which used for Activates the focused indicator button.
   85. Arrow keys shortcut key in Calc Application of Libro Office which used for Cycles through indicator buttons in the direction of the arrow.

1. 1. F1 shortcut key is used for LibreOffice Help option and you can also Equivalent Menu bar / toolbar option Help > LibreOffice Help.
   2. F2 shortcut key is used for LibreOffice Cell Edit Mode option and you can also Equivalent Menu bar / toolbar option Edit > Cell Edit Mode.
   3. Ctrl + F2 shortcut key is used for LibreOffice Function option and you can also Equivalent Menu bar / toolbar option Insert > Function.
   4. Ctrl + F3 shortcut key is used for LibreOffice Manage option and you can also Equivalent Menu bar / toolbar option Sheet > Named Ranges and Expressions > Manage.
   5. Shift + F3 shortcut key is used for LibreOffice Cycle Case option and you can also Equivalent Menu bar / toolbar option Format > Text > Cycle Case.
   6. F4 shortcut key is used for LibreOffice Cycle Cell Reference Types option and you can also Equivalent Menu bar / toolbar option Sheet > Cycle Cell Reference Types.
   7. Ctrl + Shift + F4 shortcut key is used for LibreOffice Data Sources option and you can also Equivalent Menu bar / toolbar option View > Data Sources.
   8. F5 shortcut key is used for LibreOffice Navigato option and you can also Equivalent Menu bar / toolbar option View > Navigator.
   9. Ctrl + F5 shortcut key is used for LibreOffice Sidebar option and you can also Equivalent Menu bar / toolbar option View > Sidebar.
   10. Shift + F5 shortcut key is used for LibreOffice Trace Dependents option and you can also Equivalent Menu bar / toolbar option Tools > Detective > Trace Dependents.
   11. F7 shortcut key is used for LibreOffice Spelling option and you can also Equivalent Menu bar / toolbar option Tools > Spelling.
   12. Ctrl + F7 shortcut key is used for LibreOffice Thesaurus option and you can also Equivalent Menu bar / toolbar option Tools > Thesaurus.
   13. Ctrl + Shift + F7 shortcut key is used for LibreOffice Hangul/Hanja Conversion option and you can also Equivalent Menu bar / toolbar option Tools > Language > Hangul/Hanja Conversion. The availability of this menu option depends on selections on Tools > Options > Language Setting > Languages.
   14. Shift + F7 shortcut key is used for LibreOffice Automatic Spell-Checking option and you can also Equivalent Menu bar / toolbar option Tools > Automatic Spell Checking.
   15. Ctrl + F8 shortcut key is used for LibreOffice Value Highlighting option and you can also Equivalent Menu bar / toolbar option View > Value Highlighting.
   16. F9 shortcut key is used for LibreOffice Recalculate option and you can also Equivalent Menu bar / toolbar option Data > Calculate > Recalculate.
   17. Shift + F9 shortcut key is used for LibreOffice Trace Precedents option and you can also Equivalent Menu bar / toolbar option Tools > Detective > Trace Precedents.
   18. Ctrl + Shift + F9 shortcut key is used for LibreOffice Recalculate Hard option and you can also Equivalent Menu bar / toolbar option Data > Calculate > Recalculate Hard.
   19. F11 shortcut key is used for LibreOffice Styles option and you can also Equivalent Menu bar / toolbar option View > Styles.
   20. Shift + F11 shortcut key is used for LibreOffice Save as Template option and you can also Equivalent Menu bar / toolbar option File > Templates > Save as Template.
   21. F12 shortcut key is used for LibreOffice Group option and you can also Equivalent Menu bar / toolbar option Data > Group and Outline > Group.
   22. Ctrl + F12 shortcut key is used for LibreOffice Ungroup option and you can also Equivalent Menu bar / toolbar option Data > Group and Outline > Ungroup.
   23. Alt + F12 shortcut key is used for LibreOffice Options, option and you can also Equivalent Menu bar / toolbar option Tools > Options.
   24. Ctrl + 1 shortcut key is used for LibreOffice Cells option and you can also Equivalent Menu bar / toolbar option Format > Cells.
   25. Ctrl + Shift + 1 shortcut key is used for LibreOffice Number option and you can also Equivalent Menu bar / toolbar option Format > Number Format > Number (use the “1” key on the main keyboard).
   26. Ctrl + Shift + 2 shortcut key is used for LibreOffice Scientific option and you can also Equivalent Menu bar / toolbar option Format > Number Format > Scientific (use the “2” key on the main keyboard).
   27. Ctrl + Shift + 3 shortcut key is used for LibreOffice Date option and you can also Equivalent Menu bar / toolbar option Format > Number Format > Date (use the “3” key on the main keyboard).
   28. Ctrl + Shift + 4 shortcut key is used for LibreOffice Currency option and you can also Equivalent Menu bar / toolbar option Format > Number Format > Currency (use the “4” key on the main keyboard).
   29. Ctrl + Shift + 5 shortcut key is used for LibreOffice Percent option and you can also Equivalent Menu bar / toolbar option Format > Number Format > Percent (use the “5” key on the main keyboard).
   30. Ctrl + Shift + 6 shortcut key is used for LibreOffice General option and you can also Equivalent Menu bar / toolbar option Format > Number Format > General (use the “6” key on the main keyboard).
   31. Ctrl + B shortcut key is used for LibreOffice Bold shortcut key is used for LibreOffice Bold option and you can also Equivalent Menu bar / toolbar option Format > Text > Bold.
   32. Ctrl + Shift + B shortcut key is used for LibreOffice Subscript option and you can also Equivalent Menu bar / toolbar option Format > Text > Subscript.
   33. Ctrl + C shortcut key is used for LibreOffice Copy option and you can also Equivalent Menu bar / toolbar option Edit > Copy.
   34. Ctrl + Alt + C shortcut key is used for LibreOffice Comment option and you can also Equivalent Menu bar / toolbar option Insert > Comment.
   35. Ctrl + D shortcut key is used for LibreOffice Fill Down option and you can also Equivalent Menu bar / toolbar option Sheet > Fill Cells > Fill Down.
   36. Ctrl + E shortcut key is used for LibreOffice Centered option and you can also Equivalent Menu bar / toolbar option Format > Align > Centered.
   37. Ctrl + Alt + E shortcut key is used for LibreOffice Extension Manager option and you can also Equivalent Menu bar / toolbar option Tools > Extension Manager.
   38. Ctrl + F shortcut key is used for LibreOffice Find option and you can also Equivalent Menu bar / toolbar option Edit > Find.
   39. Ctrl + H shortcut key is used for LibreOffice Find and Replace option and you can also Equivalent Menu bar / toolbar option Edit > Find and Replace.
   40. Ctrl + I shortcut key is used for LibreOffice Italic option and you can also Equivalent Menu bar / toolbar option Format > Text > Italic.
   41. Ctrl + J shortcut key is used for LibreOffice Justified option and you can also Equivalent Menu bar / toolbar option Format > Align > Justified.
   42. Ctrl + Shift + J shortcut key is used for LibreOffice Full Screen option and you can also Equivalent Menu bar / toolbar option View > Full Screen.
   43. Ctrl + K shortcut key is used for LibreOffice Hyperlink option and you can also Equivalent Menu bar / toolbar option Insert > Hyperlink.
   44. Ctrl + L shortcut key is used for LibreOffice Left option and you can also Equivalent Menu bar / toolbar option Format > Align > Left.
   45. Ctrl + Shift + L shortcut key is used for LibreOffice AutoFilter option and you can also Equivalent Menu bar / toolbar option Data > AutoFilter.
   46. Ctrl + M shortcut key is used for LibreOffice Clear Direct Formatting option and you can also Equivalent Menu bar / toolbar option Format > Clear Direct Formatting.
   47. Ctrl + Shift + M shortcut key is used for LibreOffice Edit Mode option and you can also Equivalent Menu bar / toolbar option Edit > Edit Mode.
   48. Ctrl + N shortcut key is used for LibreOffice Spreadsheet option and you can also Equivalent Menu bar / toolbar option File > New > Spreadsheet.
   49. Ctrl + Shift + N shortcut key is used for LibreOffice Templates option and you can also Equivalent Menu bar / toolbar option File > New > Templates.
   50. Ctrl + O shortcut key is used for LibreOffice Open option and you can also Equivalent Menu bar / toolbar option File > Open.
   51. Ctrl + Shift + O shortcut key is used for LibreOffice Print Preview option and you can also Equivalent Menu bar / toolbar option File > Print Preview.
   52. Ctrl + P shortcut key is used for LibreOffice Print option and you can also Equivalent Menu bar / toolbar option File > Print.
   53. Ctrl + Shift + P shortcut key is used for LibreOffice Superscript option and you can also Equivalent Menu bar / toolbar option Format > Text > Superscript.
   54. Ctrl + Q shortcut key is used for LibreOffice Exit LibreOffice option and you can also Equivalent Menu bar / toolbar option File > Exit LibreOffice.
   55. Ctrl + R shortcut key is used for LibreOffice Right option and you can also Equivalent Menu bar / toolbar option Format > Align > Right.
   56. Ctrl + S shortcut key is used for LibreOffice Save option and you can also Equivalent Menu bar / toolbar option File > Save.
   57. Ctrl + Shift + S shortcut key is used for LibreOffice Save As option and you can also Equivalent Menu bar / toolbar option File > Save As.
   58. Ctrl + V shortcut key is used for LibreOffice Paste option and you can also Equivalent Menu bar / toolbar option Edit > Paste.
   59. Ctrl + Shift + V shortcut key is used for LibreOffice Paste Special option and you can also Equivalent Menu bar / toolbar option Edit > Paste Special > Paste Special.
   60. Ctrl + Alt + Shift + V shortcut key is used for LibreOffice Paste Unformatted Text option and you can also Equivalent Menu bar / toolbar option Edit > Paste Special > Paste Unformatted Text.
   61. Ctrl + W shortcut key is used for LibreOffice Close Window option and you can also Equivalent Menu bar / toolbar option Window > Close Window.
   62. Ctrl + X shortcut key is used for LibreOffice Cut option and you can also Equivalent Menu bar / toolbar option Edit > Cut.
   63. Ctrl + Y shortcut key is used for LibreOffice Redo option and you can also Equivalent Menu bar / toolbar option Edit > Redo.
   64. Ctrl + Shift + Y shortcut key is used for LibreOffice Repeat option and you can also Equivalent Menu bar / toolbar option Edit > Repeat.
   65. Ctrl + Z shortcut key is used for LibreOffice Undo option and you can also Equivalent Menu bar / toolbar option Edit > Undo.
   66. Ctrl + Shift + Pg up shortcut key is used for LibreOffice Select to Previous Sheet option and you can also Equivalent Menu bar / toolbar option Edit > Select > Select to Previous Sheet.
   67. Ctrl + Shift + Pg down shortcut key is used for LibreOffice Select to Next Sheet option and you can also Equivalent Menu bar / toolbar option Edit > Select > Select to Next Sheet.
   68. Backspace shortcut key is used for LibreOffice Clear Cells option and you can also Equivalent Menu bar / toolbar option Sheet > Clear Cells.
   69. Ctrl + Tab shortcut key is used for LibreOffice To Next Sheet option and you can also Equivalent Menu bar / toolbar option Sheet > Navigate > To Next Sheet.
   70. Ctrl + Shift + Tab shortcut key is used for LibreOffice To Previous Sheet option and you can also Equivalent Menu bar / toolbar option Sheet > Navigate > To Previous Sheet.
   71. Ctrl + Space shortcut key is used for LibreOffice Select Column option and you can also Equivalent Menu bar / toolbar option Edit > Select > Select Column.
   72. Shift + Space shortcut key is used for LibreOffice Select Row option and you can also Equivalent Menu bar / toolbar option Edit > Select > Select Row.
   73. Ctrl + Shift + Space shortcut key is used for LibreOffice Select All option and you can also Equivalent Menu bar / toolbar option Edit > Select All.
   74. Ctrl + + Insert shortcut key is used for LibreOffice Cells option and you can also Equivalent Menu bar / toolbar option Sheet > Insert Cells (use the + key on the numeric keypad).
   75. Ctrl + – Delete shortcut key is used for LibreOffice Cells option and you can also Equivalent Menu bar / toolbar option Sheet > Delete Cells.
   76. Ctrl + * shortcut key is used for LibreOffice Select Data Area option and you can also Equivalent Menu bar / toolbar option Edit > Select > Select Data Area (use the * key on the numeric keypad).
   77. Ctrl + Shift + ; shortcut key is used for LibreOffice Time option and you can also Equivalent Menu bar / toolbar option Insert > Time.
   78. Ctrl + Alt + = shortcut key is used for LibreOffice Formula Object and you can also Equivalent Menu bar / toolbar option Insert > Object > Formula Object.
   79. Ctrl + ` shortcut key is used for LibreOffice Show Formula option and you can also Equivalent Menu bar / toolbar option View > Show Formula. The grave (`) character can be found to the left of the “1” key on many English keyboards.
   80. Shift + Esc shortcut key is used for LibreOffice Search Commands option and you can also Equivalent Menu bar / toolbar option Help > Search Commands.

1. 1. In Calc Application of Libro Office, when the column is too narrow to display the complete formatted contents of the cell then the ### error massage is display within a cell. This is not really an error value, so there is no corresponding numerical error code. The solutions to this problem are to increase the width of the column.
   2. In Calc Application of Libro Office, when the column is too narrow to display the complete formatted contents of the cell then the ### Error massage is display within a cell. This is not really an error value, so there is no corresponding numerical error code. The solutions to this problem are to increase the width of the column, or select Format > Cells > Alignment and click either Wrap text automatically or Shrink to fit cell size in the Properties area so as to make the text match the current column width.
   3. In Calc Application of Libro Office, when a value is outside of the valid limits for this number format then the #FMT Error massage is display within a cell. This. This is not really an error value, so there is no corresponding numerical error code.
   4. In Calc Application of Libro Office, when a result for the formula expression is not available then the #N/A Error massage is display within a cell and in Status bar message is showing that error Value not available. The formula cannot find what it has been asked to look for. This is not really an error value, so there is no corresponding numerical error code.
   5. In Calc Application of Libro Office, when a Invalid floating-point operation then Error code number 503 and the #NUM! Error massage is display within a cell and in Status bar message is Invalid numeric value. Calculation results outside of the defined value range. A calculation that results is in an overflow of the defined value range – a value too big or too small.
   6. In Calc Application of Libro Office, when a No valid result is possible then Error code number 519 and the #VALUE! Error massage is display within a cell and in Status bar message is No value. A function cannot supply a value corresponding to its definition; or a cell referenced in the formula contains text instead of an expected number.
   7. In Calc Application of Libro Office, when a intersection of ranges produced zero cells then Error code number 521 and the #NULL! Error massage is display within a cell and in Status bar message is No code or intersection.
   8. In Calc Application of Libro Office, when a Compiler: a row or column heading could not be detected. Interpreter: the formula refers to a cell whose column, row, or table/sheet has been deleted or which is outside the table/sheet then Error code number 524 and the #REF! Error massage is display within a cell and in Status bar message is Not a valid reference. The formula within the cell uses a reference that does not exist. Either a column or a row description name could not be resolved, or the column, row, or sheet that contains a referenced cell is missing or it is outside the sheet.
   9. In Calc Application of Libro Office, when an identifier could not be evaluated: no valid reference, no valid function name, no column/row label, no macro, incorrect decimal separator, add-in not found then Error code number 525 and the #NAME? Error massage is display within a cell and in Status bar message is Invalid name.
   10. In Calc Application of Libro Office, when the denominator of a division operation (“/”) is 0 (zero). Several functions can also return this error then Error code number 532 and the #DIV/0! Error massage is display within a cell and in Status bar message is Division by zero.
   11. In Calc Application of Libro Office, when a intersection of ranges produced zero cells then Error code number 501 is display and in Status bar message is No code or intersection.
   12. In Calc Application of Libro Office, when Similar to the Invalid Name error (525) except that it occurs within a formula then Error code number 501 is display and in Status bar message is Invalid character in formula.
   13. In Calc Application of Libro Office, when an argument of a function has an invalid value then Error code number 502 is display and in Status bar message is Invalid argument. This error also occurs if more than one matching cell is found by the DGET() function.
   14. In Calc Application of Libro Office, when Invalid floating-point operation then Error code number 503 (#NUM!) is display and in Status bar message is Invalid numeric value. Calculation result outside of the defined value range. A calculation that results in an overflow of the defined value range – a value too big or too small.
   15. In Calc Application of Libro Office, when the type of a parameter of a function is invalid then Error code number 504 is display and in Status bar message is in parameter list. For instance, a parameter of a function is text instead of a number.
   16. In Calc Application of Libro Office, when Missing bracket or parenthesis then Error code number 507 is display and in Status bar message is in bracketing.
   17. In Calc Application of Libro Office, when Missing bracket or parenthesis then Error code number 508 is display and in Status bar message is in bracketing. For instance, closing parenthesis without an opening parenthesis, or a missing closing parenthesis in the middle of a formula.
   18. In Calc Application of Libro Office, when An operator is missing then Error code number 509 is display and in Status bar message is Operator missing.
   19. In Calc Application of Libro Office, when Two operators, where the second is not a unitary operator, follow each other then Error code number 510 is display and in Status bar message Variable missing.
   20. In Calc Application of Libro Office, when Formula too long / complex then Error code number 512 is display and in Status bar message Formula overflow. For example, the total number of internal tokens (that is, operators, variables, brackets) in the formula exceeds 8192.
   21. In Calc Application of Libro Office, when Character string too long then Error code number 513 is display and in Status bar message String overflow.
   22. In Calc Application of Libro Office, when Internal capacity exceeded. An internal calculation stack overflow occurred then Error code number 514 is display and in Status bar message Internal overflow.
   23. In Calc Application of Libro Office, when Unknown error. An internal calculation stack overflow occurred then Error code number 515 is display and in Status bar message I Internal syntactical error.
   24. In Calc Application of Libro Office, when Matrix is expected on the calculation stack, but it is not available. An internal calculation stack overflow occurred then Error code number 516 is display and in Status bar message Internal syntactical error. The calculation stack should contain a matrix but it is not there.
   25. In Calc Application of Libro Office, when Matrix is expected on the calculation stack, but it is not available then Error code number 517 is display and in Status bar Internal syntactical error. Unknown operation code. A document containing a newer feature is loaded in an older version of Calc that did not support that feature.
   26. In Calc Application of Libro Office, when Variable not available then Error code number 518 is display and in Status bar message Internal syntactical error. A variable was supposed to be popped from the calculation stack but it is not available / not there.
   27. In Calc Application of Libro Office, when No valid result is possible then Error code number 519 (#VALUE!) is display and in Status bar message No value. A function cannot supply a value corresponding to its definition; or a cell referenced in the formula contains text instead of an expected number.
   28. In Calc Application of Libro Office, when The compiler has generated a code which it cannot interpret then Error code number 520 is display and in Status bar message Internal syntactical error.
   29. In Calc Application of Libro Office, when No code or no intersection then Error code number 521 (#NULL!) is display and in Status bar message No code or intersection. The intersection of ranges produced zero cells.
   30. In Calc Application of Libro Office, when a formula refers directly or indirectly to itself and the Iterations option is not activated under Tools > Options > LibreOffice Calc > Calculate then Error code number 522 is display and in Status bar message Circular reference.
   31. In Calc Application of Libro Office, when a calculation procedure does not converge then Error code number 523 is display and in Status bar message Calculation does not converge. A function missed a targeted value (tends towards a given value but does not reach it), or iterative references do not reach the minimum change within the defined maximum steps (increments) that are set.
   32. In Calc Application of Libro Office, when Compiler: a row or column heading could not be detected then Error code number 524 (#REF!) is display and in Status bar message Not a valid reference.
   33. In Calc Application of Libro Office, when An identifier could not be evaluated: no valid reference, no valid function name, no column/row label, no macro, incorrect decimal separator, add-in not found then Error code number 525 (#NAME?) is display and in Status bar message Invalid name.
   34. In Calc Application of Libro Office, when Add-in not found then Error code number 530 (#ADDIN?) is display and in Status bar message Add-in not found.
   35. In Calc Application of Libro Office, when Macro not available / not found then Error code number 531 (#MACRO?) is display and in Status bar message Macro not found.
   36. In Calc Application of Libro Office, when The denominator of a division operation (“/”) is 0 (zero). Several functions can also return this error then Error code number 532 (#DIV/0!) is display and in Status bar message Division by zero.
   37. In Calc Application of Libro Office, when Nested arrays are not supported is 0 (zero). Several functions can also return this error then Error code number 533 is display and in Status bar message Nested arrays are not supported.
   38. In Calc Application of Libro Office, when Invalid size of array then Error code number 538 is display and in Status bar message Array or matrix size. The maximum limit for sorting has been exceeded. The limit is twice the maximum number of rows, so for 1,048,576 rows the limit is 2,097,152 entries. Also obtained whenever a temporary matrix could not be allocated due to its size requirement.
   39. In Calc Application of Libro Office, when Bad inline array content, non-value/non-string then Error code number 539 is display and in Status bar message Unsupported inline array content.
   40. In Calc Application of Libro Office, when A function that requires (re)loading of external sources is encountered and the user has not confirmed reloading of external sources yet then Error code number 540 is display and in Status bar message External content disabled.

Impress

1. 1. Left Arrow shortcut key in Impress Application of Libro Office which used for Moves the cursor one character to the left.
   2. Shift + Left Arrow shortcut key in Impress Application of Libro Office which used for Moves the cursor one character to the left and selects the character.
   3. Ctrl + Left Arrow shortcut key in Impress Application of Libro Office which used for Moves the cursor to the beginning of the previous word.
   4. Right Arrow shortcut key in Impress Application of Libro Office which used for Moves the cursor one character to the right.
   5. Shift + Right Arrow shortcut key in Impress Application of Libro Office which used for Moves the cursor one character to the right and selects the character.
   6. Ctrl + Right Arrow shortcut key in Impress Application of Libro Office which used for Moves the cursor to the beginning of the next word.
   7. Up Arrow shortcut key in Impress Application of Libro Office which used for Moves the cursor up one line.
   8. Shift + Up Arrow shortcut key in Impress Application of Libro Office which used for Moves the cursor up one line in the text and selects the lines of text.
   9. Ctrl + Up Arrow shortcut key in Impress Application of Libro Office which used for Moves the cursor to the beginning of the paragraph.
   10. Down Arrow shortcut key in Impress Application of Libro Office which used for Moves the cursor down one line.
   11. Ctrl + Down Arrow shortcut key in Impress Application of Libro Office which used for Moves the cursor to the end of the paragraph.
   12. Ctrl + Shift + Down Arrow shortcut key in Impress Application of Libro Office which used for Moves the cursor to the end of the paragraph. Selects the text in the paragraph from the cursor position to the end of the paragraph.
   13. Home shortcut key in Impress Application of Libro Office which used for Moves the cursor to the beginning of the current line.
   14. Shift + Home shortcut key in Impress Application of Libro Office which used for Moves the cursor to the beginning of the line and selects the text from the cursor position.
   15. Ctrl + Home shortcut key in Impress Application of Libro Office which used for Moves the cursor to the beginning of the document.
   16. End shortcut key in Impress Application of Libro Office which used for Moves the cursor to the end of the current line.
   17. Shift + End shortcut key in Impress Application of Libro Office which used for Moves the cursor to the end of the line and selects the text from the cursor position.
   18. Ctrl + End shortcut key in Impress Application of Libro Office which used for Moves the cursor to the end of the document.
   19. Page Up shortcut key in Impress Application of Libro Office which used for Scrolls up one page.
   20. Ctrl + Page Up shortcut key in Impress Application of Libro Office which used for Moves the cursor to the header.
   21. Page Down shortcut key in Impress Application of Libro Office which used for Scrolls down one page.
   22. Ctrl + Page Down shortcut key in Impress Application of Libro Office which used for Moves the cursor to the footer.

Controlling dialogs

1. 1. Enter shortcut key in Impress Application of Libro Office which used for Activates selected button. When no button is selected, Enter is equivalent to clicking OK.
   2. Esc shortcut key in Impress Application of Libro Office which used for Closes dialog without saving any changes made while the dialog was open. Esc is also equivalent to clicking Cancel. When a drop-down list is open and selected, Esc closes the list.
   3. Spacebar shortcut key in Impress Application of Libro Office which used for Checks or clears an empty checkbox.
   4. Up or Down Arrow shortcut key in Impress Application of Libro Office which used for Moves focus up or down a list. Increases or decreases value of a variable. Moves focus vertically within a section of dialog.
   5. Left or Right Arrow shortcut key in Impress Application of Libro Office which used for Moves focus horizontally within a section of a dialog.
   6. Tab shortcut key in Impress Application of Libro Office which used for Advances focus to the next section or element of a dialog.
   7. Shift + Tab shortcut key in Impress Application of Libro Office which used for Returns focus to the previous section or element in a dialog.

Controlling documents and windows

1. 1. Ctrl + O shortcut key in Impress Application of Libro Office which used for Opens the Open dialog to select and open a document.
   2. Ctrl + S shortcut key in Impress Application of Libro Office which used for Saves the current document. If the document is a previously unsaved file, the shortcut opens the Save As dialog.
   3. Ctrl + N shortcut key in Impress Application of Libro Office which used for Creates a new document.
   4. Shift + Ctrl + N shortcut key in Impress Application of Libro Office which used for Opens the Templates dialog.
   5. Ctrl + P shortcut key in Impress Application of Libro Office which used for Opens the Print dialog to print the document.
   6. Ctrl + F shortcut key in Impress Application of Libro Office which used for Opens the Find toolbar.
   7. Ctrl + H shortcut key in Impress Application of Libro Office which used for Opens the Find and Replace dialog.
   8. Ctrl + Shift + F shortcut key in Impress Application of Libro Office which used for Searches for the last entered search term.
   9. Ctrl + Shift + J shortcut key in Impress Application of Libro Office which used for Toggles the view between full-screen mode and normal mode in Writer or Calc.
   10. Ctrl + Shift + R shortcut key in Impress Application of Libro Office which used for Opens and closes the rulers.
   11. F1 shortcut key in Impress Application of Libro Office which used for Opens the LibreOffice Help contents in your default browser.
   12. Shift + F1 shortcut key in Impress Application of Libro Office which used for Turns the cursor into a What’s This? question mark. Shows the tip for an item underneath the cursor. The shortcut does not work with the online help.
   13. Shift + F2 shortcut key in Impress Application of Libro Office which used for Turns on Extended Tips for the currently selected command, icon or control. The shortcut does not work with the online help.
   14. Ctrl + Shift + F10 shortcut key in Impress Application of Libro Office which used for Docks and undocks floating toolbars, Sidebar and Navigator.
   15. Ctrl + F4 or Alt + F4 shortcut key in Impress Application of Libro Office which used for Closes the current document. Closes LibreOffice when the last open document is closed.
   16. Ctrl + Q shortcut key in Impress Application of Libro Office which used for Exits LibreOffice.

Editing or formatting documents

1. 1. Enter shortcut key in Impress Application of Libro Office which used for an OLE object is selected, activates the software used to create the OLE object. When a drawing object is selected, activates text mode.
   2. Ctrl + X shortcut key in Impress Application of Libro Office which used for Cuts selected text or objects from a document and places them in the clipboard.
   3. Ctrl + C shortcut key in Impress Application of Libro Office which used for Copies selected text or objects and places them in the clipboard.
   4. Ctrl + V shortcut key in Impress Application of Libro Office which used for Places text or objects from the clipboard that have copied or cut into the document.
   5. Ctrl + Alt + Shift + V shortcut key in Impress Application of Libro Office which used for Pastes unformatted text from the clipboard. The text is pasted using the format that exists at the insertion point.
   6. Ctrl + Shift + V shortcut key in Impress Application of Libro Office which used for Opens the Paste Special dialog.
   7. Ctrl + A shortcut key in Impress Application of Libro Office which used for Selects all text and objects in a document.
   8. Ctrl + Z shortcut key in Impress Application of Libro Office which used for Undoes last action.
   9. Ctrl + Y shortcut key in Impress Application of Libro Office which used for Redoes last action.
   10. Ctrl + Shift + Y shortcut key in Impress Application of Libro Office which used for Repeats last command.
   11. Ctrl + I shortcut key in Impress Application of Libro Office which used for Applies the Italic attribute to selected characters and text.
   12. Ctrl + B shortcut key in Impress Application of Libro Office which used for Applies the Bold attribute to selected characters and text.
   13. Ctrl + U shortcut key in Impress Application of Libro Office which used for Applies the Underline attribute to selected characters and text.
   14. Ctrl + M shortcut key in Impress Application of Libro Office which used for Removes direct formatting from selected text or objects. This command is also available in Format > Clear Direct Formatting in the Menu bar.

Sidebar keyboard shortcuts

1. 1. Tab shortcut key in Impress Application of Libro Office which used for Moves the focus in the Sidebar.
   2. Shift + Tab shortcut key in Impress Application of Libro Office which used for M1oves the focus in the reverse direction in the Sidebar.
   3. Shift + F10 shortcut key in Impress Application of Libro Office which used for Opens a context menu for the selected element in the Sidebar.
   4. Home shortcut key in Impress Application of Libro Office which used for Moves focus to first entry.
   5. End shortcut key in Impress Application of Libro Office which used for Moves focus to last entry.
   6. Up or Down Arrow shortcut key in Impress Application of Libro Office which used for Moves the selection up or down and opens the panels in the selected deck.
   7. Right Arrow shortcut key in Impress Application of Libro Office which used for Opens any sub-elements in the selected element.
   8. Left Arrow shortcut key in Impress Application of Libro Office which used for Closes any sub-elements in the selected element.
   9. Ctrl + Enter shortcut key in Impress Application of Libro Office which used for Opens the Properties dialog for the selected element.

Gallery

1. 1. Ctrl + R shortcut key in Impress Application of Libro Office which used for Opens the Enter Title dialog. Only themes added to LibreOffice can be renamed. Themes installed with LibreOffice cannot be renamed.
   2. Ctrl + D shortcut key in Impress Application of Libro Office which used for Deletes themes that have been added to LibreOffice. Themes installed with LibreOffice cannot be deleted.
   3. Insert shortcut key in Impress Application of Libro Office which used for Inserts a new theme into the Gallery and opens the Insert of New Theme dialog.
   4. Ctrl + Shift + Insert shortcut key in Impress Application of Libro Office which used for Inserts the selected object as a linked object into the current document.
   5. Ctrl + I shortcut key in Impress Application of Libro Office which used for Inserts a copy of the selected object into the current document.