1.what is excel?
2. List out four features of excel.
3. Differenciate between a workbook and a worksheet.
4. What are themes in power point?
5. How can SmartArt tool of power point be helpful?
6. Explain any one way to insert table in your slide.
7. What is normal view?
8. What is photo album?
9. What is Print layouts?
10. What is themes?
11. What is merginging and splitting cell?
Answers
Answer:
1. Microsoft Excel is a helpful and powerful program for data analysis and documentation. It is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a “cell.”
2. Features of Microsoft Excel
1. Add Header and Footer
MS Excel allows us to keep the header and footer in our spreadsheet document.
2. Find and Replace Command
MS Excel allows us to find the needed data (text and numbers) in the workbook and also replace the existing data with a new one.
3. Password Protection
It allows the user to protect their workbooks by using a password from unauthorized access to their information.
4. Data Filtering
Filtering is a quick and easy way to find and work with a subset of data in a range. A filtered range displays only the rows that meet the criteria you specify for a column. MS Excel provides two commands for filtering ranges:
• AutoFilter; which includes filter by selection, for simple criteria
• Advanced Filter; for more complex criteria
3. The worksheet is single page spreadsheet or page in Excel, where you can write, edit and manipulate data, whereas the collection of such worksheets is referred as a workbook. It is very similar to a single page (worksheet) and a complete book (workbook)
4. A theme is a predefined set of colors, fonts, and visual effects that you apply to your slides for a unified, professional look. Using a theme gives your presentation a harmonious appearance with minimal effort.
5. There are many advantages to using SmartArt: SmartArt lets you visually represent a variety of concepts and ideas that might not work too well with just text. SmartArt looks coordinated with your presentation, and you can match it with the look of your presentation.
6. I. Select the menu sequence, Insert → Table. Fill
number of rows and columns desired for the table
in the next coming window and click on OK button.
II. Click on Table button on Standard toolbar or
Table toolbar. Drag mouse and highlight desired
number of rows and columns for the table in the
next coming window and click on OK button.
7. Normal view is the editing mode where you'll work most frequently to create your slides.
8. A digital photo album is a software application that allows the user to import image files from a digital camera, memory card, scanner, or computer hard disk to a central database.
9. This provides us with a view of the document where we can see page breaks and other features, as well as the basic character and paragraph formatting. This is helpful when we want to see where text ends on a page or where paragraphs break over two pages.
10. In contemporary literary studies, a theme is a central topic, subject, or message within a narrative. Themes can be divided into two categories: a work's thematic concept is what readers "think the work is about" and its thematic statement being "what the work says about the subject"
11. Combining multiple cells (two or more) that are in the same row and/or in the same column to a single cell is known as merging cells. Separating the cells that are merged is known as splitting cells. Steps to merge cells – First method: • Select the cells you want to merge (row wise or column wise).