DCA Office Automation 2024 Past Paper PDF

Q.4. Define table, row, column and cell in Ms excel. Roll No............................ Total Printed Pages-4 एमएस एÈसेल मɅ टे बल, रो, कॉलम और सेल को पǐरभाͪषत करɅ । Q.5. What are the 5 basic functions of Excel?...

Q.4. Define table, row, column and cell in Ms excel. Roll No............................ Total Printed Pages-4 एमएस एÈसेल मɅ टे बल, रो, कॉलम और सेल को पǐरभाͪषत करɅ । Q.5. What are the 5 basic functions of Excel? DCA104 एÈसेल के 5 मलू काय[ Èया हɇ? DCA (Part - I) Semester Examination, 2024 Q.6. Explain the term in reference with Ms-word: 1 Essential of office Automation Header and Footer, 2 Line spacing Time: Three Hours] [MaximumMarks:80 Q.7. What is DBMS? Instructions to candidates DBMS Èया है ? Q.8. How do you create a table in SQL? 1. Write your Roll Number on the question paper at the space specified आप SQL मɅ टे बल कैसे बनाते हɇ? for it. 2. Ensure that you have entered all details on the answer sheet and have Q.9. Explain the following Ǔनàनͧलͨखत को समझाइये obtained Invigilator’s Signature. Wrap Text, 2. Merge and centre 3. Do not write/mark anything on the question paper. Q.10. What are the 3 accounts in Tally? 4. Do not use question paper for rough work? टै लȣ मɅ 3 खाते कौन से हɇ?  Section –A Section – C Objective type questions. ( 1-10) Answer in 600-700 words. (Any 3) Answer all questions. Each question carries 1 mark) Q.1. Explain the following: Ǔनàनͧलͨखत को समझाइये Q.1. Which enables us to send the same letter to different people? जो हमɅ एक हȣ पğ ͪवͧभÛन लोगɉ को भेजने मɅ स¢म बनाता है ? 1 INSERT, 2 DELETE, 3 UPDATE, 4 DESC (a) Macros (b) Template Q.2. Explain sorting and filtering database? (c) Mail Merge (d) None of above डेटाबेस को सॉǑटɍ ग और ͩफ़ãटǐरंग के बारे मɅ बताएं? Q.3. What is meant by voucher entry? Describe various type of Q.2. Select all the text in MS Word document by. vouchers of tally in details MS Word दèतावेज़ मɅ सभी टे Èèट का चयन करɅ । वाउचर Ĥͪविçट से Èया ता×पय[ है ? टै लȣ के ͪवͧभÛन Ĥकार के वाउचरɉ (a) Ctrl + S (b) Ctrl + A (c) Ctrl + V (d) Ctrl + L का ͪवèतार से वण[न कȧिजए Q.4. Explain the following Ǔनàनͧलͨखत को समझाइये Q.3. What is the short cut key of Cut, Copy and Paste respectively? Cut, 2. Copy, 3. Paste, 4. Format painter Cut, Copy, तथा Paste कȧ Đमश: Short Cut key Èया है ?  System (a) Ctrl+X, Ctrl+C, Ctrl+V (b) Ctrl+X, Ctrl+L, Shift+C (c) Database (d) Data Backup Management Management System (c) Ctrl+X, Alt+L, Ctrl+C (d) Alt+X, Alt+C, Alt+V Service Q.9. What is a Microsoft PowerPoint? Q.4 In MS Excel, Ctrl+S can be used to_______. Microsoft PowerPoint Èया है ? MS Excel मɅ , Ctrl+S का उपयोग_______ के ͧलए ͩकया जा सकता है (a) Spreadsheet (b) Presentation Program Program (a) Save (b) Save As (c) Switch between (d) Start New Workbook (c) Database Program (d) All of the above opened tab Q.10. In the given query which of the keyword has to be Q.5. _______is NOT a Function in Microsoft Excel spreadsheets. inserted? _______Microsoft Excel èĤेडशीट मɅ एक फ़ंÈशन नहȣं है । दȣ गई Èवेरȣ मɅ कौन सा कȧवड[ डालना है ? INSERT INTO employee _____ (1002,Joey,2000); (a) HYPERLINK (b) COUNTIF (c) MIN (d) AVG (a) Table (b) Values (c) Values (d) Field Q.6. Which key on the keyboard can be used to view slide show? èलाइड शो दे खने के ͧलए कȧबोड[ कȧ ͩकस कंु जी का उपयोग ͩकया जा Section – B सकता है ? Answer in 300 – 400 words. (Any 8) (a) F1 (b) F2 (c) F5 (d) F10 Q.1. How can you create a bulleted or numbered list in Word? Q.7. Which of the following effects can you use for the slide आप Word मɅ बुलेटेड या Đमांͩकत सूची कैसे बना सकते हɇ? background? Q.2. What is DR and CR in Tally? आप èलाइड पçृ ठभͧू म के ͧलए Ǔनàनͧलͨखत मɅ से ͩकस Ĥभाव का टै लȣ मɅ DR एवं CR Èया है ? उपयोग कर सकते हɇ? Q.3. What is the use of picture in MS Word? (a) Gradient (b) Texture एमएस वड[ मɅ ͪपÈचर का Èया उपयोग है ? (c) Picture (d) All of above Q.8. What is the full form of DBMS? [ 1] DBMS का फुल फॉम[ Èया है ? (a) Data of Binary (b) Database Management Management System.