Railway Science (Computer – Microsoft Office)

Numeric values represent rows. Alphabets represent columns.Total number of rows and columns on a worksheet → 1,048,576 rows by 16,384 columns.

Alt + U - used to change text to uppercase. Ctrl + U - used to underline text.

It can also be used to edit data or formulas in the active cell. Name Box - It displays the cell that is currently selected in the spreadsheet.
Title Bar - It is the bar, holding the title of the excel file. Status bar at the bottom of Office programs displays status on options that are selected to appear on the status bar.

It is a character, symbol or number set slightly below the normal line of text. Superscript - It is a character, symbol or number set slightly above the normal line of text. A drop cap is where the first character of the first paragraph is made larger, taking up several lines of text or the first few sentences.

Alt + S - Used to open the slide show settings in PowerPoint. Ctrl + S - Used to save the current document. Ctrl + Tab - Used to switch between open tabs in a browser.

In vertical alignment, information in a cell can be located at the top of the cell, middle of the cell, or bottom of the cell.

Ctrl + R - Right aligns a paragraph or object in the current document.

The alignment group allows the user to control how text is displayed in cells. By default, Excel aligns numbers to the ‘right’ and text to the ‘left’.

Ctrl + L - Aligns the line or selected text to the left of the screen. Ctrl + K - It inserts a hyperlink at the text cursor's current location. Windows logo key + K - It opens Cast from Quick Settings.

Esc key allows the user to cancel, or close an operation. Spacebar key used to create space. The Ctrl key has no function on its own.