Random Access Memory MCQ Test

Diploma in Computer Application

Final Semester Examination

Total Questions: 50

Full Marks: 100 (50 x 2)

Time: 60 Minutes

NamePhone NumberEmail

1 / 50

Category: Computer Fundamentals

1) The basic operations performed by a computer are:

Input, Processing, Output, and Storage

Data entry, Data process, Data output

Input, Output, and Storage

Data entry, Data analysis, Data output

2 / 50

Category: Computer Fundamentals

2) Which of the following is an example of system software?

Microsoft Office

Google Chrome

Operating System

Adobe Photoshop

3 / 50

Category: Computer Fundamentals

3) Basic architecture of computer was developed by

Charls Babbage

Steve Jobes

John Von Neumann

Thomas Adison

4 / 50

Category: Computer Fundamentals

4) Which language does a computer understand directly?

English

High-Level Language

Machine Language

Assembly Language

5 / 50

Category: Computer Fundamentals

5) What is the name of this computer component?

SSD

Hard Disk

CPU

RAM

6 / 50

Category: Computer Fundamentals

6) Which of the following is not a characteristic of a computer?

Accuracy

Versatility

IQ

Diligence

7 / 50

Category: Computer Fundamentals

7) What is the key feature of third-generation computers?

Use of vacuum tubes

Use of microprocessors

Use of Integrated Circuits (ICs)

Use of transistors

8 / 50

Category: Computer Fundamentals

8) Identify input device of computer in this picture.

Mouse

Scanner

Keyboard

Web Cam

9 / 50

Category: Computer Fundamentals

9) The main function of the ALU is to:

Perform arithmetic and logic operations

Perform logical calculation

Store data

Control the input and output

10 / 50

Category: Computer Fundamentals

10) Which device is used to point and select objects on the screen?

Printer

Keyboard

Scanner

Mouse

11 / 50

Category: MS Word

11) How can you apply a bullet list in Word?

Layout > Bullets

Insert > Bullets

Review > Bullets

Home > Bullets

12 / 50

Category: MS Word

12) In Word, which view displays the document as it would appear when printed?

Outline

Draft

Web Layout

Print Layout

13 / 50

Category: MS Word

13) How do you insert a page border in Word?

Design > Page Borders

Insert > Shapes > Border

View > Borders

Layout > Borders

14 / 50

Category: MS Word

14) Which menu tab allows you to add a table to a document?

Review

Insert

View

Home

15 / 50

Category: MS Word

15) How do you close a Word document without exiting the Word application?

Click File > Close

CTRL + N

Press Ctrl + W

Click the 'X' in the top-right corner

16 / 50

Category: MS Word

16) How do you save a document for the first time?

Can you all

Click File > Save

Click File > Save As

Press Ctrl + S

17 / 50

Category: MS Word

17) What is the function of “Ctrl + A” in Word?

Saves the document

Select Page option

Opens a new document

Selects all content

18 / 50

Category: MS Word

18) What is the default file extension for a Microsoft Word document?

.xls

.pdf

.docx

.txt

19 / 50

Category: MS Word

19) Which tab would you use to add pictures to your document?

Layout

Insert

View

Design

20 / 50

Category: MS Word

20) What does the ‘Spelling & Grammar’ feature in Word do?

Checks and suggests corrections for errors

Highlights grammatical mistakes only

Checks for typing errors only

Provides suggestions for punctuation

21 / 50

Category: MS Excel

21) Which of the following cannot be used as a cell reference?

A1

B$2

C

1A

22 / 50

Category: MS Excel

22) Which of the following allows you to create a drop-down list in a cell?

Conditional Formatting

Data Validation

Cell Formatting

AutoFilter

23 / 50

Category: MS Excel

23) What does the CONCATENATE function do?

Finds a substring in a string

Changes the case of a string

Combines multiple strings into one

Splits a string into multiple parts

24 / 50

Category: MS Excel

24) What is the default file extension for an Excel workbook?

.xls

.xlsx

.csv

.xlsm

25 / 50

Category: MS Excel

25) Which option allows you to protect a worksheet?

Home > Format

View > Protection

Review > Protect Sheet

Data > Protect

26 / 50

Category: MS Excel

26) Which function would you use to find the highest value in a range?

HIGH

LARGE

MAX

TOP

27 / 50

Category: MS Excel

27) What feature allows you to repeat column titles on every printed page?

Print Area

Header/Footer

Page Layout

Print Titles

28 / 50

Category: MS Excel

28) Which Excel feature allows you to visually analyze data?

Sorting

Conditional Formatting

Data Validation

Filtering

29 / 50

Category: MS Excel

29) Which shortcut key is used to open the Format Cells dialog?

Ctrl + F

Ctrl + Shift + F

Alt + F1

Ctrl + 1

30 / 50

Category: MS Excel

30) How can you quickly sum a column of numbers?

Select the column and press Ctrl + S

Right-click and choose Sum

Use the SUM function manually

Click the AutoSum button

31 / 50

Category: AI Applications

31) Which version of GPT does ChatGPT currently use (as of December 2024)?

GPT-3

GPT-5

GPT-4

GPT-2

32 / 50

Category: AI Applications

32) Which AI framework is developed by Facebook for deep learning?

TensorFlow

PyTorch

Keras

Theano

33 / 50

Category: AI Applications

33) Which AI application is commonly used for personalized recommendations on e-commerce

Image Recognition

Self-driving algorithms

Natural Language Processing

Collaborative Filtering

34 / 50

Category: AI Applications

34) Which AI technology is used in healthcare for predicting patient diagnoses based on medical data?

Deep Learning

Robotic Process Automation

Virtual Reality

Speech Recognition

35 / 50

Category: AI Applications

35) Which AI application powers voice assistants like Siri, Alexa, and Google Assistant?

Convolutional Neural Networks

Reinforcement Learning

Machine Translation

Natural Language Processing

36 / 50

Category: Advance Excel

36) What does the REPLACE function do?

Replaces part of a string with another string

Changes the case of a string

Finds a substring

Joins two strings

37 / 50

Category: Advance Excel

37) What does the function TRIM() do?

Changes text to uppercase

Removes spaces from a string

Finds a substring

Concatenates strings

38 / 50

Category: Advance Excel

38) What is the purpose of the Fill Handle?

To copy formulas and data to adjacent cells

To format cells

To delete rows and columns

To fill cells with color

39 / 50

Category: Advance Excel

39) What is the purpose of the Slicers in Excel?

To sort data

To create charts

To format cells

To filter data visually

40 / 50

Category: Advance Excel

40) What does the LOOKUP function do?

Filters a range

Sorts a range

Finds a value in a range

Validates a range

41 / 50

Category: MS PowerPoint

41) Which of the following is a valid chart type that can be created in PowerPoint?

Pie Chart

All Types

Bubble Chart

Bar Chart

42 / 50

Category: MS PowerPoint

42) What feature in PowerPoint lets you insert charts and graphs?

Insert > Picture

Insert > Tables

Insert > Chart

Insert > SmartArt

43 / 50

Category: MS PowerPoint

43) Which tab would you use to add transitions between slides?

Transition tab

Insert tab

Design tab

Animations tab

44 / 50

Category: MS PowerPoint

44) Which tab would you use to insert a table in PowerPoint?

Home

Insert

Design

Slide Show

45 / 50

Category: MS PowerPoint

45) Which of the following is NOT a valid PowerPoint slide layout?

Blank

Title Slide

Text Effects

Title and Content

46 / 50

Category: MS PowerPoint

46) In PowerPoint, which of the following options helps you add a background color or image to your slides?

View > Backgrounds

Home > Background

Insert > Background

Design > Background Styles

47 / 50

Category: MS PowerPoint

47) What is the maximum number of slides you can add to a PowerPoint presentation?

999

1250

90

There is no limit

48 / 50

Category: MS PowerPoint

48) How do you add a new slide in PowerPoint?

Click File > New

Right-click in the slide sorter pane

Press Ctrl + M

Press Ctrl + N

49 / 50

Category: MS PowerPoint

49) Which of the following is a predefined design that controls the look of the slides?

Youth Skill

Leave a Reply Cancel reply

Certificate in Computer Application

Become A System Administrator

Start your academy today

Company

Quick Links

Contact Us

Blog Post