Online class
Online class of Sir
of Sir Danish Danish 03033586340
03033586340
By Sir Danish 03033586340
Youtube:smart study with D A
Facebook:Smart study with Danish Ali-DA
Computer : Storage Device
1. The capacity of a storage device is expressed as number of.
(a) Byte (b) Bits (c) Character (d) All these
2. A bit can be.
(a) 1 or 0 (b) 1 and 0 (c) 1 only (d) 0 only
3. The storing capacity of a computer is measured in.
(a) Bit (b) Byte (c) Kilogram (d) Gigabyte
4. Computes storage is basically divided into.
(a) Ram & Rom (b) Main memory & Secondary Storage
(c) Main memory & Hard disk (d) Floppy & Hard disk
5. Main memory is an extension of.
(a) Ram (b) Rom (c) Hard disk (d) Both a & b
6. Which memory provides very fast performance.
(a) Cash memory (b) Secondary memory
(c) Random access memory (d) Read only memory
7. If the memory of a computer is 32000 bytes. It means it can
store how many characters.
(a) 32 (b) 32000 (c) 64 (d) 2400
8. Which one of the following is referred to as volatile
memory.
(a) Read only memory (b) Random access memory
(c) Flash memory (d) Cache memory
Online class
Online class of Sir
of Sir Danish Danish 03033586340
03033586340
9. Generally RAM (random access memory) is measured in.
(a) Bytes (b) K bytes (c) M bytes (d) Both b and c
10. More RAM can make computer.
(a) Expensive (b) Run slower (c) Run faster (d) Powerful
11. RAM is called volatile memory because the data stored in
it.
(a) Do not disappear whenever the computer turns off
(b) Disappear whenever the computer turns off
(c) CPU can directly access the RAM (d) It is very fast
12. A variation of ROM is.
(a) Flash Memory (b) Cache Memory
(c) Programmable read only memory (PROM) (d) Direct access
storage
13. We can search any item by simply specifying.
(a) The hard disk tracks (b) ROM size
(c) Address in direct access storage (d) None of the above
14. The surface of a hard disk is logically divided into.
(a) Firmware (b) SIMMs
(c) Physically marking tracks (d) Pie-shaped sectors
15. The number of sectors of a hard disk depends upon the.
(a) Density of the hard disk (b) Speed of the motor
(c) Number of read/write head (d) Capacity of RAM
16. Typically the storage capacity of a sector can be
(a) 512 bytes (b) 512 kilobytes
(c) Always 2 bits (d) 1/2 the capacity of RAM.
17. The capacity of a hard disk depends upon the.
Online class
Online class of Sir
of Sir Danish Danish 03033586340
03033586340
(a) High speed motor (b) Movement of read/write head
(c) Complexity of software (d) Number of disk platters
18. Computer storage is also referred as.
(a) Computer device (b) Computer RAM
(c) Computer memory (d) None of above
19. Main memory performance is.
(a) Fast (b) Slow (c) Very fast (d) None
20. Auxiliary storage provides.
(a) Minimum capacity (b) Maximum capacity
(c) Both a & b (d) None
21. Computer memory is.
(a) Mechanical File (b) An electronic file (c) both of above
(d) None
22. "1" represents the data.
(a) On (b) Off (c) both of above (d) None
23. Each byte contains.
(a) Information (b) 1 Character (c) both of above (d) None
24. Computer storage is divided into classes.
(a) Two (b) Three (c) Four (d) Five
25. Main memory is directly accessible by.
(a) CPU (b) Printer (c) Scanner (d) Keyboard
26. The basic information unit is called a.
(a) Character (b) Word (c) Nibble (d) None
27. A word of 16 bits size can be called.
Online class
Online class of Sir
of Sir Danish Danish 03033586340
03033586340
(a) 4 Byte word (b) 1 Byte word c)2 byte (d) 1 Nibble
28. 1 kilobyte equals
(a) 212 byte (b) 220 byte (c) 210 byte (d) 2" byte
29. The ROM has types.
(a) Two (b) Three (c) PROM (d) EPROM
30. When the power shuts off the contains are lost.
(a) From ROM (b) From RAM (c) Both of above (d) None
31. The most common RAM technologies are.
(a) Two (b) Three (d) Four (d) Five
32. The much more expensive and require more space and
power is.
(a) RAM (b) SRAM (c) DRAM (d) ROM
33. The capacity of RAM effect the computer.
(a) Size (b) Length (c) Power (d) Life
34. DRAM needs to be refreshed
(a) Periodically (b) Hourly (c) Weekly (d) Yearly
35. DRAM is most commonly used technology to build
(a) Software's (b) Dynamic RAM (c) RAM chips (d) Static
RAM
36. Which RAM is faster?
(a) SRAM (b) DRAM (c) PRAM (d) Both (a) & (b)
37. SRAM is known as the
(a) Main memory (b) Secondary memory (c) Cache memory (d)
None
Online class
Online class of Sir
of Sir Danish Danish 03033586340
03033586340
38. MSB stands for
A) Microsoft significant byte (b) Most significant byte
(c) Microsoft significant bit (d) Most significant bit
39. In EEPROM data is erased by
(a) Magnetically devices (b) Electrical devices
(c) Electrochemical devices (d) None
40. Which RAM is less expensive?
(a) SRAM (b) DRAM (c) PRAM (d) Both (a) & (b)
41. Which disk is mostly used for transferring data
(a) Floppy disk (b) Hard disk (c) CD (d) DVD
42. The most common size of floppy disk is
(a) 2.5" (b) 3.5" (c) 4 5" (d) 5.5"
43. Floppy disk is encased in a rigid
(a) Aluminum case (b) Iron body (c) Envelope (d) Silicon case
44. A floppy disk is a storage medium
(a) Electric (b) Electronic (c) Chemical (d) Magnetic
45. Floppy disks
(a) Are slower but less expressive (b) Have less storage capacity
(c) Are portable (d) All of these
46. Basic sizes of floppy disks are
(a) 8-inch (b) 5 1/4 —inch (c) 3 1/2-inch (d) All of
these
47. Which size of floppy disk is most commonly used
(a) 8-inch (b) 5 1/4 -inch (c) 3 1/2-inch (d) 1 1/4 -inch
Online class
Online class of Sir
of Sir Danish Danish 03033586340
03033586340
48. How many hard disks digital computers use
(a) One (b) At most one (c) At least one (d) None
49. Typically a track is divided into sectors
(a) 1 (b) 5 (c) 7 (d) 8
50. A sector usually contains a fixed number of bytes of data
i.e.
(a) 256 bytes (b) 512 bytes (c) 28 bytes (d) 1024-5ytes
Excel Formulas
Basic math
Function Formula Example
To add up the total =SUM(cell range) =SUM(B2:B9)
To add individual items =Value1 + Value 2 =B2+C2
Subtract =Value1 - Value 2 =B2-C2
Multiply =Value1 * Value2 =B2*C2
Divide =Value1 / Value2 =B2/C2
Exponents =Value1 ^ Value2 =B2^C2
Average =AVERAGE(cell range) =AVERAGE(B2:B9)
Median =MEDIAN(cell range) =MEDIAN(B2:B9)
Max =MAX(cell range) =MAX(B2:B9)
Min =MIN(cell range) =MIN(B2:B9)
Online class
Online class of Sir
of Sir Danish Danish 03033586340
03033586340
Simple formatting tricks
Function Formula Example
To change a cell to proper =PROPER(cell) =PROPER(A2)
case
To change a cell to upper =UPPER(cell) =UPPER(A2)
case
To change a cell to lower =LOWER(cell) =LOWER(A2)
case
Conditional statements
Function Formula Example
If statement =IF(logical test, “result if =IF(B2>69,”Pass”,”Fail”)
the test answer is true”,
“result if the test answer is
false”)
Exact =EXACT(Value1, value2) =EXACT(B2, C2)
Putting things together
Function Formula Example
To combine cells with a =CONCATENATE(text, “ ”, =CONCATENATE(A2, “ “,
space in-between text) B2)
To combine cells with a =text & “ “ & text =A2 & “ “ & B2
space in-between (second
option)
Dealing with dates
Function Formula Example
Return the year =YEAR(datefield) =YEAR(A2)
Return the month =MONTH(datefield) =MONTH(A2)
Return the day =DAY(datefield) =DAY(A2)
Return the day of the week =WEEKDAY(datefield) =WEEKDAY(A2)
(1 = Sunday, 2 = Monday,
3 = Tuesday, etc.)
To create a date from year, =DATE(year, month, day) =DATE(B2, C2, D2)
month, and day
Online class
Online class of Sir
of Sir Danish Danish 03033586340
03033586340
Pulling things apart
Function Formula Example
To select a certain number =LEFT(cellwithtext, =LEFT(A2, 6)
of characters from the left number of characters to be
returned)
To select a certain number =RIGHT(cellwithtext, =RIGHT(A2, 6)
of characters from the right number of characters to be
returned)
Find text in a field =SEARCH(“text you want =SEARCH(“,”, A2)
to find”, where you want to
find it)
Extract information from =MID(cellwithtext, start =MID(A2, 9, 4)
the middle position, number of
characters you want
returned)
Separate a last name LEFT and SEARCH =LEFT(A2, SEARCH(“,”,
(Example: Smith, Jane) functions A2)‐1)
Separate a first name MID and SEARCH =MID(A2, SEARCH(“,”,
(Example: Smith, Jane) functions A2)+2, 20)
PREPARED BY :Danish Ali
Whatsapp Group:03033586340
YouTube Channel: [Link]
Face book page : [Link]
Instagram : [Link]
Whatsapp Group 1
[Link]
Whatsapp Group 2
[Link]
Whatsapp Group 3:
[Link]