MS Excel Quiz

It is a system, which organizes data in columns and rows. It is a data visualization and analysis tool.

• MS Powerpoint

• MS Word

• MS Excel

• MS Access

What is a cell reference in Excel?

• name of a worksheet

• cell address

• color of a cell

• size of a cell

Which tab in Excel provides basic facilities like changing font and size of text?

• Review Tab

• Insert Tab

• Home Tab

• Data Tab

What is the purpose of the Data Tab in Excel?

• To insert images

• To check spelling

• To perform operations on data

• To format cells

How can you create a new spreadsheet in Excel?

• By clicking on the File tab> New Sheet

• By pressing Ctrl+N

• By clicking the + icon in the lowermost pane

• By clicking on the Office Button

What is the function of the Review Tab in Excel?

• To format cells

• To insert charts

• To manage data

• To check spellings and protect the workbook

Freezing panes in Excel is useful for reducing the file size.

• True

• False

What does the Ctrl+S shortcut do in Excel?

• Copy selected cells

• Close the workbook

• Open a new workbook

• Save a workbook

What is the latest version of Microsoft Excel?

• Excel 2019

• Excel 2020

• Excel 2021

• Excel 365

What is the Ribbon in MS Excel?

• A type of chart

• A row of tabs for functionalities

• A data type

• A formula