Excel Class Quiz 1

The numeral Order in Excel shows:

• Rows

• Column

The alphabetical order in Excel shows:

• Rows

• Columns

For what purpose this sign used?

• resizing of Cells

• delete cell

• add cell

• merge and center

Which of the formula is correct for addition in excel?

• =sum(E6.F6)

• =Sum(E6:E8)

• =sumE5:E6

• =(E6:F6)

What is the cell number of sadia'S Obtain Marks?

• C7

• F7

• C8

• D7

WHICH OF THESE FORMULAS ARE CORRECT TO FIND THE PERCENTAGE OF MAAZ

• =500/200*100

• =D5/E5*100

• =E5*100/D5

• =200*100/500

HOW CAN WE CALCULATE THE AVERAGE SALE OF MARIA WITHOUT FORMULA

WAHT IS THE FORMULA OF FINDING AVERGAE?

• =Average(E6:E8)

• =average(E6:E8)

• average(E6:E8)

• =average(E6.E8)