Showing posts with label middle test. Show all posts
Showing posts with label middle test. Show all posts

3/31/2011

formula of microsoft excel

If the Value is less than 76,”FAIL” and if its value is more than 76, then “SUCCES”. Please, write a formula that should be used!



=IF(data range<76,"FAIL",IF(data range>76,"SUCESS"))

function and formula of microsoft excel

a. Format cells : Used to setting the place, size, font, aligment of word, size of cell or range.
b. Sum : used to total the number in the range of cell
c. Count Number: used to total the number in the range, of cells
d. Max : used to find the maximum in the range of cells
e. Min : used to find the minimum in the range of cells
f. COUNTIF : used to total number of data which agree with the logically formula’ settings.
g. VLOOKUP : used to read the table vertically
h. HLOOKUP : used to read the table Horizontally
i. MID : used to find text on the cell as from the middle
j. ROUND 0, ROUND 1, ROUND 2 : to make to fraction in data

3/27/2011

All the members of Microsoft Office 2007

Microsoft Office Access 2007 provides a powerful set of tools that help you to quickly start tracking, reporting, and sharing information. You can rapidly create attractive and functional tracking applications by customizing one of several predefined templates, converting an existing database, or creating a new database, and you can do so without deep database knowledge. By using Office Access 2007, it is easy to adapt database applications and reports to changing business needs. The enhanced support for Windows SharePoint Services 3.0 in Office Access 2007 helps you to share, manage, audit, and back up your data.

· Microsoft Office Excel 2007 To organize the data in the form of numbers. Microsoft Office Excel 2007 provides powerful tools and features that you can use to analyze, share, and manage your data with ease. To organize the data in the form of numbers.

· Microsoft® Office Groove® 2007 is Internet software for making direct connections with the people who are important to you. With Office Groove 2007, you can bring together team members from both inside and outside your company, with no IT assistance required and no need to waste time thinking about firewalls, servers, security, or network access. Additionally, you can enjoy the efficiency of always knowing each other's virtual location, or online presence, thus allowing for organic and quick conversation and collaboration.
· Microsoft InfoPath 2010 helps organizations streamline business processes and design sophisticated electronic forms.

· Microsoft Office OneNote 2007, the easy-to-use note-taking and information-management program in the Microsoft Office System. Use OneNote to capture your thoughts and ideas in electronic notebooks, where you can easily organize, search, and share them.
· Microsoft Office Outlook 2007 provides you with a comprehensive time and information manager. Using new features such as Instant Search and the To-Do Bar, you can organize and instantly locate the information that you need. New calendar sharing capabilities, Microsoft Exchange Server 2007 technology, and improved access to Microsoft Windows SharePoint Services 3.0 information enable you to safely share data that is stored in Office Outlook 2007 with coworkers, friends, and family, no matter where those people are located. Office Outlook 2007 makes it easier for you to prioritize and control your time, allowing you to focus on the things that matter most. This article provides an overview of Office Outlook 2007, with an emphasis on new and improved features.
· Microsoft Office Outlook 2007. To help you produce professional-looking presentations, PowerPoint 2007 provides a comprehensive set of features that you can use to create and format your information. You can create and add designer-quality SmartArt graphics with only a few clicks of your mouse.
· Microsoft Office Publisher 2007 is the business publishing program that helps you create, design, and publish professional-looking marketing and communication materials. You can create materials for print, e-mail, and the Web with an intuitive, task-based environment that guides you from initial concept to final delivery in-house without professional design and production expertise.

number of columns and rows inmicrosoft excel

Microsoft Excel 2007 ( columns = A-XED, row = 1048576 )



* Microsoft Excel 2003 ( columns = A-IV , row = 1048576 )

members of Microsoft Office 2007 !

* Microsoft Excel 2007
Function : Is a spread sheet program for processing number.

* Microsoft Word 2007
Function : Is a Word sheet program for processing word

* Microsoft Power Point 2007
Function : Use to presentation document

* Microsoft Publisher 2007
Function : Use to make brochure, poster, and banner

* Microsoft Outlook 2007
Function : use to send and receive email

* Microsoft Access 2007

Microsoft Office 2007

Microsoft Office 2007 . Formerly known as Office 12 in the initial stages of its beta cycle, it was released to volume license customers on November 30, 2006 [ 4 ] and made available to retail customers on January 30, 2007.. These are, respectively, the same dates Windows Vista was released to volume licensing and retail customers. . Office 2007 contains a number of new features, the most notable of which is the entirely new graphical user interface called the Fluent User Interface [ 5 ] (initially referred to as the Ribbon User Interface ), replacing the menus and toolbars – which have been the cornerstone of Office since its inception – with a tabbed toolbar, known as the Ribbon. . Office 2007 requires Windows XP with Service Pack 2 or higher, Windows Server 2003 with Service Pack 1 or higher, Windows Vista or Windows 7. [ 6 ] Office 2007 is the last version of Microsoft Office which is officially supported on Windows XP Professional x64 Edition .

Middle Test Semester II 2010/2011

Please, answer the following questions, short and right! Please, use Full English Version!

Question :

1. Please, specify all the members of Microsoft Office 2007 !
2. Please, specify all the members of Pull Down in Microsoft Office 2007 !
3. Please, specify the number of columns and rows in :
a. Microsoft Excel 2007 !
b. Microsoft Excel 2003 !
4. Whether its function in Ms Excel 2007 ?
a. Format Cells ?
b. Sum ?
c. Count Numbers ?
d. Max ?
e. Min ?
f. COUNTIF ?
g. VLOOKUP ?
h. HLOOKUP ?
i. MID ?
j. ROUND 0, ROUND 1, ROUND 2 ?
5. If the value is less than 76, then" FAIL" and if its value is more than 76, then "SUCCESS". Please, write a formula that should be used !


Answer!

Subscribe to: Posts (Atom)
mohhasan22.blogspot.com. Powered by Blogger.

Popular Posts