Dashboard Control panel | Completed Exam

Sr Student Name
Semester
Branch Subject Question User Answer Right Answer
1 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

CPU stand for ...............................................

Central Processing Unit. Central Processing Unit.
2 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Which of the following is not an input device?

 

 

 

 

 

 

Speaker Speaker
3 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Collection of Rows and columns is called ...............................

Table Table
4 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

A device that allows users to feed data into a computer for analysis and storage and to give commands to the computer is called

Processing Input
5 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Identify the given formula 

=pmt(Annual Rate /12,Duration,Loan Amount )

Principal Amount Monthly EMI
6 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Save As shortcut command 

Ctrl +S F12
7 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

VGA cable available in which three color

 

Above All three Color Above All three Color
8 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Tool Bar consist of.................... .

Tabs Groups
9 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Which short cut key is used to make selection lock.

F3 F4
10 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

In which tab these are present “Table, Header & Footer, WordArt and chart”?

Home tab Insert tab
11 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Concatenate formula is used for ........................................

Combine two different words written in different - 2 cells Combine two different words written in different - 2 cells
12 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Identify the Following formula

=rept("|",num)

 

Mini Chart Mini Chart
13 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

How to find the current date

=today() =today()
14 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

How to find the current date and time in MS Excel?

=date and time() =today()
15 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Identify the following :-

.png, .jpg, .txt, .rtf, .docx, .ppt

Application Extensions
16 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Which tab is available in Wordpad Application

Edit view
17 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Hlookup formula is used to find valuse in ............................... form

Horizontal Horizontal
18 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

By Default No. of sheet in Ms Excel

2 3
19 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC) Shortcut key used for Slide Show in Powerpoint presentation. F4 F5
20 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Hlookup formula is used to find data 

Horizontal Horizontal
21 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

To remove the all changes from the selected text is knows as ____________________

Clear Formatting Clear Formatting
22 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Excel is a program that is used to prepare a ................................

Database Spreadsheet
23 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC) What are the basic rectangular building blocks of a spreadsheet? Cells Cells
24 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Shortcut key for New Page in current documentation

Ctrl +N Ctrl +Enter
25 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Shortcut key of superscripts

Ctrl+shift+= Ctrl +shift+"+"
26 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC) ILLUSTRATION group contains ________, _________, _________, ________, ________. Picture, clip art, shapes, smart art, chart Picture, clip art, shapes, smart art, chart
27 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Use of Format Painter

Used to apply same format on selected text Used to apply shading on text
28 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

What is the formula for inserting the Random numbers in excel

 

=Random () =Randbetween (Bottom,Top)
29 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

How many Groups in Insert Tab

7 7
30 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Ctrl + Enter is shortcut key for ...............................

New Slide New Sheet
31 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Use of Clear Formatting

To remove all bold changes in document To remove all italic changes in Document
32 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Types of selection in Mspaint

Both (A) and (B) None of these
33 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

RTF Full Form

Random Text Formation Rich Text Format
34 Varun Gehlot
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

How many Alignment are there?

4 4
35 Varun Gehlot
Semester 1
MGI 456 Diploma in Computer Application (DCA) Which of the following tools is used to draw given picture Line Pencil
36 Varun Gehlot
Semester 1
MGI 456 Diploma in Computer Application (DCA) Identify the following Tools and arrange in Proper sequence Picture, Chart, Clip Art, Shapes, SmartArt Picture, ClipArt, Shapes, SmartArt, Chart
37 Varun Gehlot
Semester 1
MGI 456 Diploma in Computer Application (DCA) PNG Full Form Portable Network Graphic Portable Network Graphic
38 Varun Gehlot
Semester 1
MGI 456 Diploma in Computer Application (DCA) Show & hide Show & hide