RSCIT Formula Sheet

Important shortcuts, Excel formulas, and computer concepts for RSCIT exam

Category: RSCIT

Select Formula Category

MATH PHYSICS CHEMISTRY RSCIT REASONING COMPUTER SCIENCE BIOLOGY ENGLISH

Formula Collection

MS Excel Formulas

SUM

📐

=SUM(range) - Adds all numbers in a range

AVERAGE

📐

=AVERAGE(range) - Returns average of numbers

COUNT

📐

=COUNT(range) - Counts cells with numbers

COUNTA

📐

=COUNTA(range) - Counts non-empty cells

MAX

📐

=MAX(range) - Returns the largest number

MIN

📐

=MIN(range) - Returns the smallest number

IF

📐

=IF(condition, value_if_true, value_if_false)

VLOOKUP

📐

=VLOOKUP(value, table, col_index, [range_lookup])

CONCATENATE

📐

=CONCATENATE(text1, text2, ...) - Joins text strings

COUNTIF

📐

=COUNTIF(range, criteria) - Counts cells meeting criteria

SUMIF

📐

=SUMIF(range, criteria, [sum_range])

LEFT/RIGHT

📐

=LEFT(text, n) / =RIGHT(text, n) - Extracts characters

LEN

📐

=LEN(text) - Returns length of text string

UPPER/LOWER

📐

=UPPER(text) / =LOWER(text) - Changes text case

MS Word Shortcuts

Copy

📐

Ctrl + C

Cut

📐

Ctrl + X

Paste

📐

Ctrl + V

Undo

📐

Ctrl + Z

Redo

📐

Ctrl + Y

Select All

📐

Ctrl + A

Bold

📐

Ctrl + B

Italic

📐

Ctrl + I

Underline

📐

Ctrl + U

Save

📐

Ctrl + S

Find

📐

Ctrl + F

Replace

📐

Ctrl + H

Page Break

📐

Ctrl + Enter

Print

📐

Ctrl + P

HTML Basics

Document Type

📐

<!DOCTYPE html>

HTML Tag

📐

Head Section

📐

Title

📐

<title>Page Title</title>

Body

📐

Heading

📐

<h1> to <h6> - Heading tags

Paragraph

📐

Link

📐

Image

📐

List

📐

<ul> (unordered) / <ol> (ordered) / <li> (item)

Table

📐

Form

📐

Division

📐

<div>...</div> - Block container

Span

📐

<span>...</span> - Inline container

Computer Fundamentals

Memory Units

📐

Byte (B) < KB < MB < GB < TB < PB

1 KB

📐

1024 Bytes

1 MB

📐

1024 KB

1 GB

📐

1024 MB

1 TB

📐

1024 GB

CPU Components

📐

ALU (Arithmetic Logic Unit) + CU (Control Unit) + Registers

Computer Generations

📐

1st: Vacuum Tubes, 2nd: Transistors, 3rd: IC, 4th: Microprocessor, 5th: AI

Network Types

📐

LAN (Local) < MAN (Metropolitan) < WAN (Wide)

IP Address

📐

IPv4: 32-bit (192.168.1.1), IPv6: 128-bit

Internet & Email

Email Parts

📐

To, CC, BCC, Subject, Body, Attachments

CC

📐

Carbon Copy - all recipients visible

BCC

📐

Blind Carbon Copy - recipients hidden

Common Protocols

📐

HTTP/HTTPS (Web), FTP (File), SMTP (Email send), POP3/IMAP (Email receive)

Web Browser

📐

Software to access websites (Chrome, Firefox, Edge)

Search Engine

📐

Tool to find web content (Google, Bing, Yahoo)

Quick Shortcuts & Tips

⚡

Excel: Every formula starts with = sign

⚡

Excel: Use $A$1 for absolute cell reference

⚡

Word: F7 for spell check, F12 for Save As

⚡

Windows: Alt+Tab to switch between programs

⚡

Windows: Windows+E to open File Explorer

⚡

Internet: https:// indicates a secure website

⚡

Email: Always use BCC when emailing multiple recipients who don't know each other

⚡

General: Take screenshot using Windows+Shift+S (Windows 10/11)

How to Use This Formula Sheet

Learn, Don't Memorize

Understand the derivation and application of each formula. Knowing why a formula works is more important than memorizing it.

Practice Application

Immediately after learning a formula, solve 5-10 problems using it. This reinforces learning and builds problem-solving skills.

Create Your Own Sheet

Copy formulas you frequently forget onto a physical sheet. The act of writing helps memory retention.

Regular Revision

Review formulas weekly. Use spaced repetition: next day, after 3 days, after 1 week, then monthly.

Common Formula Mistakes to Avoid

Unit Confusion

Always check units before applying formulas. Convert all measurements to consistent units (all in meters or all in centimeters).

Formula Misapplication

Ensure you're using the right formula for the given problem type. Don't force a formula that doesn't fit the situation.

Sign Errors

Pay attention to positive/negative signs, especially in physics and coordinate geometry formulas.

Approximation Errors

When using π = 22/7 or √2 = 1.414, be consistent. Don't mix exact and approximate values in the same calculation.

Practice with Formulas

Apply Formulas

Practice questions where you can use these formulas

Quick Revision

Review key concepts along with formulas

Study Guide

Detailed explanations of formulas and concepts

Previous Year Questions

Practice with past exam questions using these formulas