ITI COPA Electronic Spreadsheets: MS Excel MCQ Quiz

To change the cell reference C4:C9 to an absolute row and column reference, you would enter it as

Ranges can be selected using the function key

The intersection of a row and column is called

To Exit the excel window, use function key

To close the active window. use the function key

In excel the intersection of a row and a column is called a

The base area of XY plane in a 3D chart is known as

In order to tell Excel that you are entering a formula in a Cell you must begin the entry with an operator such as

Excel can display up to _______ fields of a data form

_______ function Returns all the characters in the input string in lowercase

_______ function Returns all the characters in the input string in uppercase

It provides information about a data marker that represents a single data point or value that originates from a worksheet cell

To convert the keyboard extend selection mode, you will press the Function key

To insert a worksheet use the function key

The total size of the Excel worksheet is