ITI COPA Electronic Spreadsheets: MS Excel MCQ Quiz

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

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

The intersection of a row and column is called

To close the active window. use the function key

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

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

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

The total size of the Excel worksheet is

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

Excel can display up to _______ fields of a data form

Ranges can be selected using the function key

To Exit the excel window, use function key

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

To insert a worksheet use the function key

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