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