google search

Wednesday, October 16, 2019

Pie Charts


Pie charts

Charts

See Also

Column Charts & Column chart Subtypes
Line charts - Subtypes
a. Line and line with markers
Lines chart are displayed with or without markers to indicate individual data values, line charts are useful to show trends over time or ordered categories particularly if there are many data points.
The order in which they are presented is very important. If there are many categories or the values are approximately, I consider using a line chart without markers.

Line Chart


Line charts

The Arranged Data in columns or rows can also be plotted in line chart

This line charts shows permanent data over time, Line charts are always set against a regular scale which make them ideal for displaying trends in data at equal intervals. 

Friday, October 4, 2019

Chart Types

Available chart types

Excel 2007 provides various types of charts to lets you display data in different ways that are significant to your audience desired. When changing an existing chart, Excel allows you to choose from a wide range of chart subtypes available for you to use.
Here you will learn about  Column chart subtypes.

Column charts

Column charts are used to compare values across categories. Data arranged in rows or columns in a worksheet can be plotted in a column chart. This column charts are helpful for displaying data changes over a period of time or for exemplifying similarities between objects. 
Categories in column charts are usually well thought-out all along the horizontal axis and values along the vertical axis.

Changing the default Country or Region in Excel


How to Change the Default Country or Region

Changing the default country/region changes the standard settings for numbers, currencies, time, and date to those most commonly used for that country/region. This setting affects various features in various Microsoft Office programs. Examples of features affected include:
  • Calendar in Microsoft Office Outlook.
  • Cells formatted with certain date, time, or currency options in Microsoft Office Excel.
Find links to more information on the Microsoft Office features affected by this setting in the See also section.
In Microsoft Windows Vista
  1. Click the Start button, and then click Control Panel.
  2. Click Clock, Language, and Region, and then click Change the date, time, or number format.
 Note    In Classic view, double-click Regional and Language Options.
  1. On the Formats tab, select the country/region that you want to use in the list under Current format.
In Microsoft Windows XP
  1. Exit all Microsoft Office programs.
  2. Click the Start button, and then click Control Panel.
  3. Click Date, Time, Language, and Regional Options, and then click Regional and Language Options.
 Note    In Classic view, double-click Regional and Language Options.
  1. On the Regional Options tab, select the country/region that you want to use in the list under Standards and formats


Display numbers as currency

In the Number group, you have some other options. For example, you can change the U.S. dollar sign to another currency format, switch numbers to percents, add commas, and change the decimal location.

Hide All
  1. Select the cells that contain the numbers that you want to display with a currency symbol.
How to select cells, ranges, rows, or columns
  1. On the Home tab, click the Dialog Box Launcher next to Number.  This will display the format cells dialog box.
  1. In the Category box, click Currency or Accounting.
  1. In the Symbol box, click the currency symbol that you want.
Note: If you want to display a monetary value without a currency symbol, you can click None.
  1. In the Decimal places box, enter the number of decimal places that you want to display.
  2. In the Negative numbers box, select the display style for negative numbers.
 Note    The Negative numbers box is not available for the Accounting number format.



COMPUTER APPLICATION - JAVA


COMPUTER APPLICATION

some of the computer program 
1 JAVA
2 Java Script
3 Python
4 Objective-c
5 Ruby
6 perl
7 C,CH and CH
8 Sql
9 Swift


Things we use the program listed above for


JAVA
Ø JAVA is considered as the perfect language for the developer and programmer’
Ø It  is also used to develop program e.g android  operating system
Ø It is also be utilized for  mobile –based applications
Ø IT is used for establishment of android  application on tablets and smart phone
PHP
Ø It is used for enlarging a web application very quickly and effortlessly.

JevaScript

  • Ø It is used in generating communication for the web
  • Ø It is used in constructing  superb user interface
  • Ø It is used in making of interactive web page
  • Ø It is also used for animation on the web pages
  • Ø It is used for loading fresh images
Python

  • Ø It is used for evaluation of vast data sets
  • Ø It is also used for expanding web application
  • Ø It is used for data analysis
  • Ø It is the user interface
Objective-c

  • Ø It is used for  constructing application for (ios), language effectively
  • Ø Also for producing (ios) applications that can be noticeable in application store
Ruby

  • Ø It is used for beginner to learn easily
C’ CH and C

  • Ø It is used for forming hardware speeding game
  • Ø It is also used in ideal selection for strong desktop software
  • Ø It is used as application for mobile and desktop
Sql

  • Ø It is used for designing data base , such as Microsoft Sql server, Oracle, mysql.
Sweft

  • Ø It is used for expanding application for apple product



Parts of Computer

1 Monitor
2 C.P.U
3 Mouse
4 Printer
5 Keyboard
6 Speakers
7 Joystics

Programs used for  QS work 
1 Microsoft word
2 Microsoft excel
3 QS card
4 WINQS
5 Computer aided design
6 Microsoft word

The programs are used for
1 Estimating Cost-planning
2 Cost Modeling
3 Contract documentation
4 Contract administrations

It also use for application of networking such as
1 L.A.N(Local Area Network)
2 W.A.N (Wide Area Network)
3 M.A.N (Metropolitan Area Network) for
          a cost management
          b contract administration

The work we do with the computer programs (QSwork)
1 For Estimating
2 Cost –planning cost modeling
3 Contract document
4 Contract administrations

Tuesday, September 17, 2019

Working with Chart











To create a chart 

What is a Chart?

A chart is a diagram or an effective tool you use in Excel in exchange graphically with data you have in a given table.

Solve a problem with Excel Solver

Solve a problem using Solver
Month
Q1
Q2
Q3
Q4
Total
Seasonality
0.9
1.1
0.8
1.2



Units Sold
3,592
4,390
3,192
4,789
15,962
Sales
$143,662
$175,587
$127,700
$191,549
$638,498
Color Code

Cost
89,789
109,742
79,812
119,718
399,061


Gross
53,873
65,845
47,887
71,831
239,437


   Target




Salesforce
8,000
8,000
9,000
9,000
34,000


   Changing
Advertising
10,000
10,000
10,000
10,000
40,000


Overhead
21,549
26,338
19,155
28,732
95,775


   Constraints
Total Costs
39,549
44,338
38,155
47,732
169,775






Prod. Profit
$14,324
$21,507
$9,732
$24,099
$69,662
Profit Margin
10%
12%
8%
13%
11%
Product Price
$40.00
Product Cost
$25.00

Solve a problem using Solver


values to maximize or minimize another price, enter and change constraints, and save a difficulty model.