Excel Quiz

Which functioning Excel tells how many numeric entries are there ?

• NUM

• COUNT

• SUM

• None of these

Statistical calculations and preparation of tables and graphs can be done using?

• Notepad

• Power Point

• Excel

• Adobe Photoshop

Which one is not a Function in MS Excel ?

• SUM

• MAX

• MIN

• AVG

Functions in MS Excel must begin with ___

• An Equal Sign

• A Plus Sign

• A > Sign

• An () sign

In Excel, Columns are labelled as ___

• A, B, C, etc

• 1,2,3 etc

• A1, A2, etc.

• $A$1, $A$2, etc.

Which bar show the used formula of selected active cell?

• Menu bar

• Ribbon

• Formula bar

• Scroll bar

When all the number between 0 to 100 in a range should be displayed in Red color, Apply

• Use =if() function to format the required number red.

• Apply Conditional Formatting command on format Menu

• Select the cell that contain number between 0 to 100 then click Red color on Text color tool

• All of the above

What function will produce results that indicate whether a student has passed or failed a course by enter the text "Pass" or "Fail"?

• Count

• IF

• SUM

• CountA

Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array?

• Lookup

• VLookup

• NOW

• CountIF

Which ONE of the following is not true?

• Excel sheets have the extension *.doc

• A new workbook is called Book 1

• You can have Word and Excel open together

• You can also create graph in excel sheets