|=12:30 PM’ – ‘9:00’||3:30|
Almost, all mathematical expressikons are formed using these operators only.
- Operations On Dates and times: Since, Excel treats dates and times as numbers, they can be math operands. For example, subtract two dates to find the number of days in between.
- Text nd logical Operations: You can also perform logical and? text operations. The operator connects two values to produce one text value. Comparison perators, which include =,<,>,>=, <= and <>, compare two values and return the logical value.
TRUE or FAlSE
|123 & 456||123456|
|= ‘Route’ & 66||Route 66|
|= ‘Net’ and ‘Sales’||Net salesaz,’|
The major elements of the Excel screens are menus, toolbars, woksheets nd status bar-menu bar has several menus which can be invoked by clicking them using mouse or using the hot key combination fom the keyboard. Menus has the following commands:
File – Alt+ F
Edit – Alt + E
View – Alt + V
Insert – Alt + I
Format – Alt + O
Tool – Alt + T
Data – Alt + D
Windows – Alt + W
Help – Alt + H
Q.4. What is a macro? Briefly discuss its utility. How do you record and execute a macro?
Ans. Macro: Macro can be defined in two ways related to computer along with keyboard shortcut and also along with a small program.
Keyboard shortcuts are key combinations that perform commands, such as saving a file, closing a window or copying and pasting of data. A macro can also be a small program or script that automates common tasks. These scripts are usually run within programs and can often be created by the user. For example, a user might record a macro for MS-Word that inserts his entire address when he presses a custom key combination. An MS-Excel user might record a macro to format the data in the selected column of a spreadsheet.
While Word and Excel both make it easy to create custom macros, many other programs allow users to create macros as well. However, not all programs refer to the automated commands as macros. Macros can save a lot of time by automating repetitive tasks.
Recording macros in word is easy and useful. Macros are a series of effects or enhancements that can be applied with one click of the mouse. In word, macros are commands and instructions that you group together as a single command to accomplish a task automatically.
Macros can be used to combine multiple commands, such as inserting a table with a specific size and borders and with a specific number of rows and columns, making a dialog box option more accessible and automatically running a series of tasks. Any set of actions can easily be recorded and played back as a macro. When you are recording a macro, you can temporarily pause recording and then resume recording where you stopped.
Use Of Ms Office Word MBA 1st Year Semester Long Questions Answers Notes
While word’s macro recorder handles commands, text entry and menus it can’t deal with mouse movements inside document Windows. For example, you can’t use the mouse to items by clicking or dragging but you have to use the keyboard to record such actions. You can copy a macro project to use in another document or template using organizer.
Q.5. Explain the use of charts in PowerPoint.
Ans. Uses of Chart in PowerPoint: PowerPoint uses Microsoft Graph to let you create simple chart in a presentation. However creating the chart and graph are one of the more complex features in PowerPoint with many options, you probably will need to experiment with charts to see the many options available.
Chart Tool: To create a chart, click the chart tool or choose the Chart Auto Layout and double-click inside the chart place holder to create a chart.
A new Window opens showing a dummy spreadsheet, a graph based on that dummy data and chart menu and toolbar option.
To insert your own data, replacing the dummy data type in each cell as you would in any spreadsheet application. As you do so, you will see the graph change to reflect the changes in data, you can also change the chart types, colors and other formatting by making the appropriate menu and toolbar choices.
Tip: If the ‘Spreadsheet’ Window is obscuring the graph, you can press and drag the coloured strip at the top of the Window to move it to a new location.
1. To accept the data modification and insert the chart into the PowerPoint slide, click anywhere outside the border of the chart.
2. To modify the chart in the future, double click it to restart Microsoft Graph. To delete the chart, select it, then press delete.