Dashboard Control panel | Completed Exam

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

RTF Full Form

Rich Text Format Rich Text Format
2 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

What is the formula for inserting the Random numbers in excel

 

All of these =Rand ()
3 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Shortcut key for New Page in current documentation

Ctrl +M Ctrl +M
4 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC) What are the basic rectangular building blocks of a spreadsheet? Cells Cells
5 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

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

Text Documentation Text Documentation
6 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Which shortcut keys is used for Cell Edit in MS Excel

F2 Ctrl +T
7 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC) Shortcut key used for Slide Show in Powerpoint presentation. F5 F5
8 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

By Default No. of sheet in Ms Excel

3 3
9 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

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

Insert tab Insert tab
10 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Which short cut key is used to make selection lock.

F3 F3
11 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

VGA cable available in which three color

 

Black Black
12 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Save As shortcut command 

Ctrl +S Ctrl+Space
13 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

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

Cell Cell
14 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Which of the following is not an input device?

 

 

 

 

 

 

None None
15 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

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

Central Processing Unit. Central Processing Unit.
16 AAYUSH
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

Output Output
17 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)
18 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)
19 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Identify the given formula 

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

Principal Amount Commission
20 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

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

Tabs Tabs
21 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

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

remove extra space upper
22 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Identify the Following formula

=rept("|",num)

 

Mini Chart Mini Chart
23 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

How to find the current date

=now() =now()
24 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

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

=now() =now()
25 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Identify the following :-

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

Devices Devices
26 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Which tab is available in Wordpad Application

Insert Insert
27 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

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

Verticle Verticle
28 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Hlookup formula is used to find data 

Horizontal Horizontal
29 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

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

Format painter Format painter
30 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Shortcut key of superscripts

Ctrl +shift+"+" Ctrl +shift+"+"
31 AAYUSH
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
32 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Use of Format Painter

Used to apply shading on text Used to apply shading on text
33 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

How many Groups in Insert Tab

7 7
34 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

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

New Document New Document
35 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Use of Clear Formatting

To Remove all Change made in document To Remove all Change made in document
36 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

Types of selection in Mspaint

Both (A) and (B) None of these
37 AAYUSH
Semester 1
MGI 456 BASIC COMPUTER COURSE (BCC)

How many Alignment are there?

4 4
38 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) To activate Purchase Order/Sales Order press: F10 F10
39 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) How to Delete any Master By pressing Alt D By pressing Alt D
40 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Wages treated as: Direct Expense Direct Expense
41 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP)

Short Cut key is used to open Payroll Voucher:

Ctrl+ F4 Ctrl+ F4
42 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Drawing Account Treated as: Capital Account Capital Account
43 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) The Feature of Interest Accounting Accounting
44 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) In Tally ERP9 to create company press: Alt F3 Alt F3
45 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Which key is used to activate the calculator? Ctrl N Ctrl N
46 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Salary due but not paid is called: Not Paid Salary Outstanding Salary
47 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Return Outward stands for: Purchase Return Purchase Return
48 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Stock Journal is used to: To transfer the stock one godown to other To transfer the stock one godown to other
49 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Key to Open Stock Journal Alt F7 Alt F7
50 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Tds Stands for: Tax Deducted at Source Tax Deducted at Source
51 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) To Open Receipt Voucher Press: f6 f6
52 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) The amount which is withdraw by the owner is called: Drawing Drawing
53 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) The amount which is credited by the bank called Bank Interest treated as: Indirect Income Indirect Income
54 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) At Accounting / Inventory Voucher creation and alteration screen To select the Debit Note Voucher Type. Alt F5 Alt F5
55 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) At gateway of Tally Screen to select the company info menu F3 F3
56 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) At all reports screens in TALLY to export the report in ASCII, SDF, HTML or XML format Alt E Alt E
57 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Which key is used to go in the Contra Voucher? F4 F4
58 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) At accounting/Inventory Voucher creation and alteration screen which key to select the Journal Voucher F7 F7
59 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Which option is used to make change in the Ledger? Alter Alter
60 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) What is the currency of India? Rupees Rupees
61 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) What is the shortcut key of profit and Loss? P P
62 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Who has Developed the Tally Software? Tally Software Pvt. Ltd. Tally Solutions Pvt. Ltd.
63 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Which Shortcut keys are used to take print out in tally? Ctrl P Ctrl P
64 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) At almost all screens in TALLY To remove what you typed into a field. ESC ESC
65 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Debit All Expenses, Credit All Income is the golden rule based on Nominal Account Nominal Account
66 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) To activate the feature of Bills of Material:- F11 F12
67 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Liabilities are the ......................... of the business:- Assets Negative Balance
68 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Assets are called:- Nominal Account Real Account
69 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Discount Allowed and Discount Received are the types of:- Trade Discount Cash Discount
70 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Short cut Key to Create any master:- Ctrl C Alt C
71 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP) Short cut Key to change the financial year or current period:- Alt F2 Alt F2
72 AAYUSH
Semester 1
MGI 456 Certificate in Tally Package (CTP)

Tally is an ........................... software?

Accounting Accounting