Mircosoft Excel Study Guide

In Excel, Rows are labelled as ______

1,2,3 etc

What is the intersection of a column and a row on a worksheet called ?

Cell

What do you use to create a chart?

Chart Wizard

What type of chart is useful for comparing values over categories ?

Column Chart

What type of chart will you use to compare performance of sales of two products ?

Column Chart

Statistical calculations and preparation of tables and graphs can be done using

Excel

A feature that displays only the data in column (s) according to specified criteria

Filtering

Which functionin Excel checks whether a condition is true or not ?

IF

What type of chart is useful for showing trends or changes over time ?

Line Chart

What type of chart will you use to compare performance of two employees in the year 2016 ?

Line Chart

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

Pie Chart

What type of chart is useful for comparing parts of a whole ?

Pie Chart

The process of arrenging the items of a column in some sequence or order is known as :

Sorting

The basic unit of a worksheet into which you enter data in Excel is called a

cell

In Excel, Columns are labelled as ___

A, B, C, etc

Functions in MS Excel must begin with ___

An Equal Sign

The ____ feature of MS Excel quickly completes a series of data

Auto Fill

Which one is not a Function in MS Excel ? A. SUM B. AVG C. MAX D. MIN

B. AVG

In Excel, which one denoted a range from B1 through E5 A. B1 - E5 B. B1:E5 C. B1 to E5 D. B1$E5

B. B1:E5

Which function in Excel tells how many numeric entries are there ?

COUNT