Excel Quiz (Round 1)

The software with rows and columns is referred to as

• Database
• Worksheet
• Spreadsheet
• Sheet

Which of these is not a phrase used in Microsoft Excel?

• Document
• Column
• Cell
• Workbook

Which is an example of a formula?

• =A1+A2
• =add(A1:A2)
• A1+A2
• =SUM(A1:A2)

Example of cell Address is?

• 11A
• 555
• D55
• A 121

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

• COUNT
• SUM
• NUM
• CHECKNUM

If you copy the formula =$B38 into another cell, the result will be:

• The column part will remain the same
• The row part will remain the same
• Both the column and row will remain the same.
• Both will change

I want to multiply these two cells and display the results in C6 if A1 = 30 and A2 = 20. Which formula ought I to employ

• Write in cell C6, = Multiply A1:A2
• Write in cell C6, =30*20
• Write in cell C6, Mutiply A1 to A2
• Write in cell C6, =A1*A2

What formula should be used to determine the average value between cells B3 and B6

• =SUM(B3+B4+B5+B6)/4
• =AVE(B3:B6)
• =AVERAGE(B3:B6)
• =AVERAGE(B3+B4+B5+B6)/4

Which of the following is NOT a valid Excel function?

• MINIMUM
• SUM
• MAX
• COUNT

What does "A1" represent in Excel?

• Numerically
• Alphabatically
• By Date
• All of the above