Scribd
Upload
13 views2 pages

ICT Assignment Overview and Guidelines

The document is an assignment from Mewar University covering various features and functions in Microsoft Word, Excel, and PowerPoint, including text wrapping, mail merge, find and replace, cell referencing, macros, and data analysis tools like pivot tables. It also addresses academic integrity topics such as plagiarism, citation styles, and the importance of citing sources. The assignment consists of multiple questions requiring detailed explanations and steps for using specific software functionalities.

Uploaded by

Anuradha Gupta
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views2 pages

ICT Assignment Overview and Guidelines

The document is an assignment from Mewar University covering various features and functions in Microsoft Word, Excel, and PowerPoint, including text wrapping, mail merge, find and replace, cell referencing, macros, and data analysis tools like pivot tables. It also addresses academic integrity topics such as plagiarism, citation styles, and the importance of citing sources. The assignment consists of multiple questions requiring detailed explanations and steps for using specific software functionalities.

Uploaded by

Anuradha Gupta
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

MEWAR UNIVERSITY CHITTORGARH, RAJASTHAN

ICT, ASSIGNMENT
1. What is the "Wrap Text" feature in Microsoft Word? And How do you wrap text
around an image in Microsoft Word?
2. What is Mail Merge, and how do you use it in Ms Word ?
3. Explain how the "Find and Replace" feature works in Microsoft Word. How do you
replace a word with another throughout the document? and also define How can you
insert a header or footer in a Microsoft Word document?
4. What do you mean by Relative cell referencing and Absolute cell referencing in MS
Excel?
5. Write the Steps that how do you create and use macros in Word to automate
repetitive tasks, such as formatting a document or inserting a specific set of text?
6. What is the difference between a “section break” and a “page break,” and when
would you use each? And also define What are the benefits of using the "Restrict
Editing" feature in Word, and how do you enable it?
7. What is the difference between count, counta, and countblank? And also define How
is VLOOKUP different from the LOOKUP function?
8. How would you embed an Excel chart into a PowerPoint presentation? And also
define How would you use the eyedropper tool in PowerPoint?
9. Explain what a "pivot table" is in Excel and how it is used for Analyzing data. And
also define what are the difference between Pivot charts and Standard charts.
10. What is Spreadsheet and its Application. How Can worksheet be connected with
Database? Explain.
11. Write down the Steps to create a dropdown list in excel? And also Define How do
you identify repeated values in a column?
12. What is the purpose of the "OFFSET" function, and how can it be used in creating
dynamic ranges for charts or data validation?
13. What is the difference between VLOOKUP and INDEX-MATCH, and when should
you use INDEX-MATCH over VLOOKUP?
14. What is the difference between a regular chart and a Sparkline in Excel, and when
would you use each type of data visualization? And also define what is the basic
structure of VBA (Visual Basic for Applications) code in Excel?
15. How would you convert a PowerPoint presentation into a video? And define Which
steps would you use to set up password protection for a presentation?
16. Write down the Steps that how do you set up automatic slide transitions and timings
in PowerPoint for a hands-free presentation?
17. What is the purpose of citing sources in academic Writing . And What are the
different types of citation styles (e.g., APA, MLA, Chicago), and when might you use
each?
18. . Distinguish between plagiarism, paraphrasing, and summarizing, and explain how
each relates to citation.
19. What is plagiarism? And Write down the different types of plagiarism ? and also
define the Punishments for plagiarism .
20. Why is plagiarism considered a serious offence in the academia? What are the
consequences of plagiarism? Any famous cases of plagiarism you recall in the news?

You might also like