Scribd
Upload
15 views2 pages

Data Management Basics in MS Office

This document contains definitions and descriptions of concepts related to MS Word, MS Excel, databases, and HTML. It defines MS Word as Microsoft word processing software that saves files in .doc or .docx format. It describes functions, logical operators, and features in MS Excel like auto fill, formulas, and worksheets. It defines database terms like records, fields, keys, and relational databases. It also provides definitions for HTML tags and concepts like bulleted lists, opening/closing tags, and password boxes.

Uploaded by

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

Data Management Basics in MS Office

This document contains definitions and descriptions of concepts related to MS Word, MS Excel, databases, and HTML. It defines MS Word as Microsoft word processing software that saves files in .doc or .docx format. It describes functions, logical operators, and features in MS Excel like auto fill, formulas, and worksheets. It defines database terms like records, fields, keys, and relational databases. It also provides definitions for HTML tags and concepts like bulleted lists, opening/closing tags, and password boxes.

Uploaded by

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

Anil’s Commerce +3 2nd yr Data Management Bits

UNIT - 1
1. MS word is software of Microsoft.
2. MS Word is a Word processing software.
3. The valid format of MS Word is .doc or .docx.
4. To show the font dialog box press Ctrl + D.
5. A Bookmark identifies a location or a selection of text that you name and identify for
future reference.
6. Text wrapping is the change the way text warps around the selected object.
7. In the View option toolbar we can change the view of the document and set the zoom
option.
8. To view paragraph marks, clicks on the home tab, in the paragraph group, click Show/Hide.
9. Mark entry include the selected text in the index of the document.
10. To print a document, press Ctrl + P.
11. Line spacing is in the Home tab of MS Word.
12. Minimize button reduces the window to an icon but word still remains active.
13. Restore Button brings word window to the maximum original size.
14. Arial, Cambria, Verdana, Times New Roman are the name of Font face.
15. The feature that keeps track of the right margin is Ragged right.
16. To make the selected text bold, the shortcut key is Ctrl+ B.
17. Bring to front refers to forward the object one level or to the front of all objects.
18. Changing the appearance of a document is called as Formatting.
19. Sort feature is for Alphabetize in MS Word document.
20. Microsoft Office Word creates a Hyperlink for you when you press ENTER or the
SPACEBAR after you type the address of an existing Web page.

UNIT – 2
1. Functions in MS Excel must begin with An Equal Sign.
2. Which function in Excel checks whether a condition is true or not? Ans. IF
3. The Greater Than sign (>) is an example of Logical operator.
4. The Auto Fill feature of MS Excel quickly completes a series of data.
5. Work sheet tabs appear at the bottom of the Excel window.
6. Another name for a pre-programmed formula in Excel is Function.
7. Excel is a program that is used to prepare a Spreadsheet.
8. A formula in Excel always begins with an Equal sign.
9. A(n) range is a series of two or more adjacent cells in a column or row or rectangular
group of cells.
10. LCM() returns the least common multiple.
11. Typed text showed in active cell and also in Formula bar.
12. Excel documents are stored as files called Worksheets.
13. Formulas in Excel are made up of Arithmetical operators and functions.
14. The result is a Logical value either TRUE or FALSE in Excel.
15. The legend helps to identify various plotted data series.
16. In a spreadsheet , a value is a number you will use in a calculation.

Harish Sir – 8908283654 Page 1 of 2


Anil’s Commerce +3 2nd yr Data Management Bits
17. Workbook is a collection of worksheets.
18. Cell is the intersection of a row with a column.
19. The worksheet names appear on tabs at the Bottom left of the workbook window.
20. The results of a formula in a cell is the value.

UNIT - 3
1. DBMS means Database Management System.
2. A database that contains tables linked by common fields is called a Relational database.
3. Query language allows users to easily interrogate a database.
4. The set of related data items is known as a Record.
5. A table in a database may have a primary key.
6. An identification field in a record is called a Key field.
7. RDBMS stands for Relational Database Management System.
8. Microsoft Access is a RDBMS.
9. A subset of characters within a data field is known as Data string.
10. A field is an area reserved for a specific piece of data.
11. In Access, table are used to store the data.
12. Auto number enables the user to automatically insert numbers in a sequential or random
number.
13. A file containing relatively permanent data is Master file.
14. The checking operation performed on input data is called the Validation of data.
15. A search value can be exact value or it can be Wild card character.
16. Datasheet displays multiple records, one per row, in the form window.
17. In a database table, the category of information is called Field.
18. The columns in a Microsoft Access table are called as Fields.
19. To switch between to Form view from design view, press F5.

UNIT - 4
1. Bulleted list is known by another name which is Unordered list.
2. Opening and closing tag are used in container tags.
3. HTML document is opened in Web browser.
4. HTML extension is used to save HTML document.
5. In HTML document first and last tag should be HTML.
6. Unordered list is also called un-numbered list.
7. Ordered list represents numbers.
8. When a list is created is another list, it is named nested list.
9. In the <hr> tag, hr stands for Horizontal Row.
10. <li> is used to create items of an Ordered list.
11. A password box shows the characters being typed by user in the form of *.

Harish Sir – 8908283654 Page 2 of 2

Common questions

Powered by AI

The legend in Excel charts plays a critical role in data interpretation by identifying and distinguishing various plotted data series. It acts as a key that explains the symbols, colors, and patterns used in the chart, aiding users in understanding the represented data effectively and helping to prevent misinterpretation. This is especially important in complex datasets where multiple series are plotted simultaneously as it ensures viewers can clearly associate data points with the correct data series .

Logical operators, such as the Greater Than sign (>), play a crucial role in data processing within Excel by allowing users to create formulas that can evaluate conditions as TRUE or FALSE. These operators enhance computational capabilities by facilitating complex decision-making processes and enabling the use of conditional operations in functions like IF, which can then drive further calculations or data manipulation depending on the outcome .

Microsoft Excel's Auto Fill feature improves data entry efficiency by automatically completing a sequence or series in adjacent cells, reducing manual input and chances for error. For example, if a user selects two cells containing the numbers 1 and 2, and then drags the Fill Handle, Excel will extend the sequence, filling subsequent cells with 3, 4, 5, etc. This feature is particularly useful for filling repetitive data such as dates, numerical sequences, or other patterns .

A Database Management System (DBMS) provides the basic framework for storing and retrieving data in a structured way. In contrast, a Relational Database Management System (RDBMS) provides more advanced features by organizing data into related tables through common fields, which allows for data to be more flexibly accessed and restructured. The RDBMS supports complex queries and enhances integrity and consistency with the use of relational constraints .

Text wrapping in MS Word offers several advantages when incorporating images into a document. It allows for text to flow around images, giving a more polished and professional appearance to documents. This is particularly useful in scenarios where visual elements need to accompany textual content without disrupting the flow of information. Text wrapping can be customized to fit text in various styles around the image, enabling designers to take creative control over the layout and improve readability and aesthetic appeal of the document .

Maintaining an organized structure in a long MS Word document through bookmarks and indices is crucial for efficient navigation and referencing. Bookmarks allow users to mark specific points or selections of text, which can be easily returned to later, enhancing user experience especially in lengthy documents. Indices, on the other hand, consolidate important terms and references into a singular location, enabling quick lookups and cross-referencing. Together, these tools facilitate a more systematic approach to document handling and improve information retrieval .

In a relational database, the primary key is a specific choice of a minimal set of attributes (or columns) that uniquely identifies a record within a table. The primary key ensures that no two rows have the same value, preventing duplicate records, thus maintaining data integrity. It influences data management by serving as a reference point for creating relationships among tables in the database, enabling easier data retrieval and manipulation .

In HTML, bulleted (unordered) and ordered lists serve distinct purposes based on the context of the information being presented. Bulleted lists, created with the <ul> tag, are used for listing items that do not have a specific numerical order or ranking, emphasizing equality among listed elements. Ordered lists, created with the <ol> tag, are used when a sequence or prioritization is necessary, such as in steps of a process or hierarchical information, allowing users to follow a stipulated order .

Tags in HTML are fundamental to defining the structure and design of a webpage. They determine which parts of the content render as text, headings, links, lists, or multimedia. By using tags such as <html>, <body>, <h1> to <h6>, and many others, developers create a navigable and logical structure which is crucial for accessibility compliance, enabling screen readers and other assistive technologies to interpret and present the webpage content appropriately .

Automatic numbering in databases, such as the Auto number feature in Microsoft Access, is important for maintaining data consistency and uniqueness. It assigns automatic sequential identifiers to records, ensuring each entry can be uniquely identified without manual input errors. This feature is particularly useful for primary keys where consistency and uniqueness are critical. It reduces the risk of human error in manual entry and simplifies operations such as data sorting and referencing .

You might also like