Test How Much Do You Know About Excel Sheets! Trivia

Select the column you need to sort. Click the Data tab and click the Sort button

Select the column you need to sort. Click the Insert tab and click the Group button

Manually arrange the data properly

I click the page layout option and the click breaks, insert break in top row

I click the view tab and in the window group I click "Freeze Pane" and then click freeze top row

Insert a pivot table with including the top row

After highlighting the data you need, select the insert tab and click on the Table button.

From the window tab, click the insert button and select table

Select your data and click the Page Layout tab. Click on the Table button

Right Click on the mouse and change the font of the cell

I click the Home Tab and then change the colors in the Font Options

I select the group of cells that I want to work with, then on the Home Tab,I click conditional fomating on the menu

Click the format button under the cells tab.

Click the conditional formatting button under the styles tab

Click the Margings button under the Page Settup tab

Under the Data tab, click the Filter button and select the search option.

Under the View tab, click the Zoom button and select the Find option

Under the Home tab, click the find & select button and select the find option

=Median(A2:B3)

=Average(A2:C14)

=Max(B2:B88)

=Sum(B4,B5)

=Max(B2:B88)

=Min(B2:B88)

=If(A2>2,"Yes")

=sumcells(A1:A5)

=count(A1:A5)

Table Array

Lookup Value

Col Index Num