9th_1st quarter Excel Examination

What does every formula in MS EXCEL start with?

• +

• -

• =

• *

Excel file is saved as a ____________

• Document

• workbook

• worksheets

• Presentation

The function that lets you add up a range of cells or values

• AVERAGE

• SUM

• MIN

• MAX

What function was used to find the highest data ?

• AVERAGE

• MIN

• SUM

• MAX

To colour those cells blue where temperature is above 50 degree you will

• Apply filtering

• Use fill colour option

• Shade Cells

• Use Conditional Formatting

What is the meaning of ####### in a cell?

• Entered formula is wrong

• Invalid date or time

• The width of the cell is not enough to show the number

• The height of the cell is very little

See the following formula. Which of the following formula is the another method of the given formula?

=(B2+C2+D2+E2)/4

• = SUM (B2,C2,D2,E2)

• = MAX(B2:E2)

• = SUM(B2,E2/4)

• = AVERAGE (B2:E2)

The result of the following Excel formula is____?

=SUM(Max(9,5,1),Average(3,4,8))

• 9

• 14

• 5

• 18

You have a list which contains students information from all classes. But, you want to see only one class. Which Excel feature should you use?

• Validation

• Filter

• Data Validation

• Format as Table

Cell A1 contains a Function that shows the following data. What can be the function in A1?

22.10.2020

• =TIME()

• =ABS(-18.12)

• =TODAY()

• =NOW()