How do you rearrange the data in ascending or descending order?
Data, Sort
Data, Form
Data, Table
Data Subtotals
The Count function:
Allows you to cancel the last changes made
Adds all the numbers in a range of cells
Counts the number of cells
Returns the largest value in a set of values.
Which of the following bar displays all the menu available for use in MS EXCEL ?
Menu bar
Title bar
Formatting tool bar
Formula bar
What refers to the process of getting data from a cell located in a different sheet ?
Accessing
Referencing
Updating
Functioning
Which of the following button represent Redo action ?
Which bar contains the name of the program and the name of the file which is currently opened?
Standard toolbar
Formatting toolbar
Which option is used to correct the errors automatically?
AutoCorrect
Spell Check
Protection
Customize
Which one is used to change the appearance of cell entry?
Insert Chart
Adding formulas
Formatting
Clip art
Which among the following display the address of current cell ?
Status bar
Name box
The Average function:
Returns the largest value in a set of values
Helps you to copy data from one cell or range of cells to another
Returns the average of the arguments.