Lab-5 Quiz-1

Write Your Registration Number

What is an Excel file called?

• Spreadsheet

• Document

• Workbook

• Worksheet

In Excel, which of the following is the correct way to identify a cell?

• By its column number and row letter

• By its row number and column letter

• By its column letter and row number

• By its color

Where can you find the commands for formatting cells in Excel?

• Insert tab

• Home tab

• Formulas tab

• View tab

What symbol is used to start a formula in Excel?

• +

• =

• -

• /

Which function in Excel will calculate the sum of the values in cells A1 through A5?

• =ADD(A1)

• =TOTAL(A1)

• =SUM(A1)

• =COMBINE(A1)

Which of the following functions is used to find the highest value in a range of cells in Excel?

• =MIN

• =MAX

• =AVERAGE

• =SUM

In Excel, what is the purpose of the 'Filter' option?

• To delete rows

• To arrange data in alphabetical order

• To show only rows that meet certain criteria

• To change the cell color

How do you create a chart in Excel?

• Highlight the data and go to the Home tab

• Select the data, go to Insert > Chart

• Highlight the data and go to the View tab

• Use the Data tab options

Which tab allows you to sort data in Excel?

• Home

• Data

• Insert

• View