MS Access MCQ

1.       What is the maximum length of text field  can be ? a)       120      b) 255    c)       70        d) 256     2.       A record applies to data entered into  ---- row of a table. a)       single          b) double c)    multiple      d) None 3.       A relational database is able to store and manipulate data across multiple -----. a)  column      b) row c)  tables        d) None 4.       A database is defined as a collection of -----. a)  Objects   b) fields c)  columns       d) b & c 5.       Storage size limit of attachment (data type) is ------. a)  700kb   b) 800kb c)  900kb   d) 850kb 6.       AutoNumber is termed as ------. a)  Unique Number   b) Sequential Number c)  a & b                    d) Identified Number 7.       Which of the following store command to retrieve data from database? a) Forms           b) Reports c) Tables           d) Queries 8.       In which tab form is found? a)  Create   b) Database Tools c)  Home    d) None 9.       Which is not the part of Queries group? a)  Query Wizard   b) Query Design c)  Query Report    d) None 10.    A report can be sorted on one or more fields with the exceptions of ------- data type fields. a)  OLE                   b) Text c)  AutoNumber     d) Date/Time

11. Which is the type of relationship? a)    one to one        c) one to many b)       many to many d) all of the above 12. Before a relationship a database must contain ----        tables. a)       Three    b) Four c)    More    d) None 13. When using the name of a primary key field to        create a field in another table and thereby a link,        the new field is referred as ------ key. a)       Main       c) Foreign b)    Helping   d) Unique Identifier      14. Sorting arranges the data within a table into ----       Order. a)       alphabetical     c) a & b   b)       numerical         d) none `      15. ----- are used to create a link between two or more              tables within a database.               a) Forms     c) a & b               b) Queries   d) None  `      16. ----- can be used to display and maintain records              within your database                       a) Forms                 c) Query               b) Query Wizard    d) None `      17. The actual currency symbol depends upon the ----               settings of windows Control Panel.               a) Region      c) a & b               b) Language d) None `      18. Where is the record navigation bar?               a) at the bottom of screen               b) at the top of screen               c) at the top-right of screen               d) at the top left of screen `      19. Deleting a form is similar to deleting a ------.               a) table     c) record               b) field      d) None `      20. The attachment navigation arrows are most useful               when viewing ----- image attachments.               a) single              c) double               b) multiple          d) none      .

POWERPOINT PRESENTATION ON BANGLADESH

SEE THE PRESENTATION IN THE TAB GIVEN BELOW

TAB

MS Word MCQ

1.  Keyboard shortcuts for ‘copy’ and ‘paste’-

a.

Ctrl+X, Ctrl+V
b.
Ctrl+V, Ctrl+X
c.
Ctrl+C, Ctrl+O
d.
Ctrl+C, Ctrl+V

2.  What is the main advantage of compressing files?

a.

Making a file smaller
b.
Making a file larger
c.
a & b
d.
None

3.Files are stored ------

a.

On a disk in folders
b.
Inside the processor
c.
Inside the sound card
d.
None

4. The Ribbon normally contains -----------

a.

files
b.
folders
c.
tabs
d.
files and folders

5. Windows 10 is a multitasking ------- system.

a.

users
b.
database
c.
Operating
d.
All of the above

6. The concept of selecting an item and then moving it while keeping the mouse button pressed is often called

----------

a.

Managing
b.
Manpulating
c.
Exploring
d.
Dragging

7. The basic storage unit is called ---------- .

a.

a megabyte

b. a byte

c.

a terabyte
d.
None

8. PDF is short for -----------

a.

Portable Document Format
b.
Portable Document Formet
c.
Portable Document Folder
d.
Portable Document File

9. Which keys are used to select multiple files ?

a.

Shift
b.
Control
c.
a & b
d.
None

10. To perform separate backups on a regular basis is called --------.

a.

Offsite backup
b.
Regular backup
c.
Complete backup
d.
None

11. Select a file, then press ----- key to name the file .

a.

F2
b.
F4
c.
F2 AND F4
d.
F10

12. Keyboard shortcut key to print document is ------

a.

Ctrl+P
b.
Ctrl+Q
c.
Ctrl+R
d.
Ctrl+Z

13.  -------- is a software that installs itself and spies computer’s activity.

a.

Viruses
b.
Cookies
c.
Spyware
d.
All of the above

14. 1 or 0 level of storage is called

a.

a bit
b.
byte
c.
1 byte
d.
None

15. A terabyte is approximately one thousands -------

a.

Bytes
b.
Megabytes
c.
Kilobytes
d.
None

16. ------- stores operating system and application programs  .

a.

USB flash drive
b.
Hard disk c.
Network drive
d.
Network drive & USB flash drive

17. Which is the icon  at the right of minimize and maximize ?

a. Open

b.

Close
c.
Start
d.
None

18. Taskbar clock located at the ------ edge of the Taskbar.

a.

Right
b.
Left
c.
Right and Left
d.
Center

19. To modify date and time in computer, we will click on control panel, then --------------

a.

System and Security
b.
Programs
c.
Appearance and personalization
d.
None

20. ------- is used as a temporary store for files that we delete.

a. Recycle Bin
b. C drive
c. D drive

d. Documents Folder

Excel MCQ

1.       Default text is aligned within a cell to the ---- a)       Right      b) Left    c)       Center    d) None      2.       AutoSum button is displayed towards the ---- end of the ribbon a)       Right          b) Left c)    Center        d) None 3.       By default, each new workbook contains ---- worksheet. a)  Single            b) Double c)  Multiple        d) None 4.       Press Ctrl+N is the keyboard shortcut key to create a new blank -----. a)  Workbooks      b) Workbook c)  Worksheet       d) b & c 5.       Press Ctrl+O is the keyboard shortcut key to open ----- file. a)  An existing   b) A new c)  Multiple        d) None 6.       Alt+Tab is the keyboard shortcut to switch between ---- programs. a)  Open            b) Close c)  Maximize    d) Minimize 7.       COUNTBLANK is used to count ------ within a cell range? a)  empty cells           b) cells of text c)  cells of numbers   d) None 8.       Getting data from a cell located in a different sheet is called ---- . a)  Accessing           b) Updating c)  Referencing        d) None 9.       If you press ---- , the cells accepts whatever you have typed as its content. a)  Ctrl+Enter   b) Shift+Enter c)  Shift            d) None 10.    Which of the following symbols is used for entering a formula?. a)  =         b) SUM c)  @        d) None

11. Which is not an operator? a)    +     c) * b)       -      d) & 12. Which is the formula for finding out Average        from A3 to A10 ? a)       =AVERAGE(A3.A10)  b) =AVERAGE(A3,A10)  c)    =AVERAGE (A3; A10) d)   None 13. In Excel, alignment group is found on the ----. a)       Home Tab   c) Data Tab b)    Insert Tab    d) View Tab    14. To select entire worksheet, we can press ----. a)       Ctrl+A      c) Ctrl+B    b)       Ctrl+C     d) Ctrl+L `      15. If we click between any two row headers, we can               drag the row height up or down to modify the ----.               a) column width     c) row height               b) column height    d) row width  `      16. Charts are found on the ---- tab.                    a) Home     c) Review               b) Insert     d) View `      17. We can  rotate  text diagonally or vertically from                ----- group.               a) Font           c) Cells               b) Alignment d) None `      18. Which of the following formula has been                entered correctly?               a) =A5*A7              c) =B7/B3               b) = SUM(A5:A7)  d) All of the above `      18. Which of the following formula has not been                entered correctly?               a) =A5*A7              c) =B7.B3               b) = SUM(A5:A7)  d) None `      20. In MS Excel worksheet, active cells are look like                ---- box.               a) square              c) triangle               b) parallelogram   d) None      .