Excel test

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

• NUM

• COUNT

• SUM

• COUNTIF

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

• Formula

• Filtering

• Sorting

• Pivot

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

• Coloumn

• Pie

• Line

• Dot

Which one is not a Function in MS Excel?

• SUM

• MIN

• AVG

• PRODUCT

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

• Pie

• Line

• Column

• Dot

Which term is used to join the selected cells in to one cell?

• Filter

• Wrap

• Pivot

• Merge

You can activate a cell by

• Pressing Tab key

• Clicking a cell

• Pressing an arrow key

• All of the above

Hyperlinks can be

• Texy

• Drawing objects

• Pictures

• All of the above

Which button do you click to add a series of numbers?

• Auto sum button

• Formula button

• Quick total button

• Total button

You can use the drag and drop method to

• Copy cell contents

• Move Cell contents

• Add cell contents

• a and b