Advanced Excel

Excel is a spreadsheet application, developed and published by Microsoft

• Yes

• No

Excel organizes data in .........

• Pages

• Slides

• cells

Each new excel file contains one spreadsheet by default, but we can add unlimited new spreadsheets

• True

• False

........... is a visual representation of data from a worksheet

• Cell

• Row

• Function

• Chart

If I need to represent my survey visually, I have to inset .......... Chat

• Column

• Line

• Pie

To create graph in Excel , we have to go to ............... tab

• Home Tab

• Data Tab

• Insert Tab

• View Tab

To Count the number of cells in a range that contain numeric values only, We have to use ................ function

• Sum

• COUNT

• COUNTA

• Average

A function is a predefined formula that calculates values in a range of cells.

• True

• False