Microsoft Excel

What is the meaning of 'IF' statement?

• is a programming language that produces software for multiple platforms.

• the process of assigning a code to something for classification or identification.

• sample program that ask the user to enter two values

• is a programming conditional statement that, if proved true, performs a function or displays information.

To sort names in a worksheet, we can use ____ button

• 
• 
• 
• 

If you want to find an average of cells A1 through A25, which formula would you use?

• =average(A1:A25)

• =avg(A1:A25)

• =average(A1-A25)

• =avg(A1-A25)

Which of the following is the correct syntax for the SUMIFS function?

• =SUMIFS(Criterion_Range1, Criterion1, [Criterion_Range2, Criterion2, …],Sum_Range)

• =SUMIFS([Sum_Range], Criterion_Range1, Criterion1, [Criterion_Range2, Criterion2, …])

• =SUMIFS(Sum_Range, Criterion_Range1, Criterion1, [Criterion_Range2, Criterion2, …])

• Don't know

Answer explanation

Unlike the SUMIF syntax, the argument Sum_Range is not optional.

What does COUNTA ( ) function do?

• Counts cells having alphabets

• Counts empty cells

• Counts cells having number

• Counts non-empty cells

Answer explanation

COUNTA function counts cells containing any type of information, including error values. COUNTA function does not count empty cells.

What is a chart in Microsoft Excel?

• A chart in Microsoft Excel is a type of formula.

• A chart in Microsoft Excel is a way to organize files.

• A chart in Microsoft Excel is a graphical representation of data.

• A chart in Microsoft Excel is a feature for creating animations.

What is the typical sequence for creating a chart?

• A. Click the cell to contain the chart, select the chart type, and then select the data source.

  
  

• B. Select the data source, select the chart type, and then size and position the chart.

• C. Select the data source, size the chart, select the chart type, and then position the chart.

  
  

• D. Select the chart type, select the data source, and then size and position the chart.

  
  

Answer explanation

You can merge the main document with data source in Excel. In mail merge operation, Word is usually Client

What type of chart is good for single series of data ?

• Column Chart

• Bar Chart

• Line Chart

• Pie Chart

This is a horizontal or vertical line that extends across the plot area to make it easier to read and follow the values

• Grid line

• Data point

• Value Axis

• Tick mark

How can you create a chart in Excel?

• Go to Format tab, click on Chart button, choose chart type

• Click on the data, press Ctrl+C, go to Insert tab, click on Chart button, choose chart type

• Select data, go to Insert tab, click on Chart button, choose chart type

• Right-click on the data, select Create Chart