Excel Test for Beginners

What is the second name of the Microsoft Excel.?

• Spreadsheet

• Multiplan

• Powerpoint

• Microsoft

What is the primary use of Microsoft Excel in the business world?

• Database

• Presentation

• Mailing

• Document

Bunch of Ribbons is known as _____

• Quick Access Toolbar

• Taskbar

• Tab

• Worksheet

Bunch of Worksheet is known as _____

• Workbook

• Database

• Workplan

• Spreadsheet

To calculate the total marks obtained by Neha, Arjun, and Sanya in the selected range, which formula should we apply?

• Total

• Add the marks of each student one by one using +

• Calculate the average

• Sum

To calculate the percentage of the total marks obtained by Aarush, which formula should we apply?

• Percentage

• Average

• Averagable

• IF

What MAX function do.?

• It gives you the Maximum number of the selected range

• It gives you the maximum number column name

• It separates the maximum numbers from the selected range

• It gives you the minimum value of the selected range

What do we call this part in Excel.?

• Tabs

• Ribbon

• Quick Access Toolbar

• Zoom Controller

Shaan, Rahul, and Ananya are working on a spreadsheet. They need to understand the basic structure of the spreadsheet. Which of the following correctly describes the arrangement of columns and rows?

• Columns starts A,B,C, ...

  Rows starts 1,2,3, .....

• Rows starts from A,B,C, ...

  Columns starts from 1,2,3, ....

• Columns starts AA,AB ...

  Rows starts 1.1,1.2,1.3, .....

• Columns starts Sheet1, Sheet2...

  Rows starts Workbook1, Workbook2, .....

What is the default name of the Workbook/File in Excel 2021 version.?

• Book1

• Workbook1

• Spreadsheet1

• Sheet1