Grade 6 Ms. Excel

What is Microsoft Excel used for?

• Writing code

• Microsoft Excel is used for data organization, analysis, and visualization.

• Creating presentations

• Editing images

What do you see at the top of the Excel window?

• Status bar

• Formula bar

• Title bar, Quick Access Toolbar, and Ribbon.

• Navigation pane

What is the name of the area where you can enter data?

• data entry box

• text area

• form field

• input field

What is a cell in Excel?

• A cell in Excel is a basic unit of a spreadsheet where data is entered.

• A cell in Excel is a type of formula.

• A cell in Excel is a type of chart.

• A cell in Excel is a feature for printing.

How do you add numbers in Excel?

• Use the CONCATENATE function, e.g., =CONCATENATE(A1,A2) to add numbers.

• Use the AVERAGE function, e.g., =AVERAGE(A1:A10) to add numbers.

• Use the SUM function, e.g., =SUM(A1:A10) to add numbers in a range.

• Click on the cell and type the numbers directly without any function.

What formula do you use to find the average?

• Average = (Maximum value) - (Minimum value)

• Average = (Product of all values) / (Number of values)

• Average = (Sum of all values) + (Number of values)

• Average = (Sum of all values) / (Number of values)

What is the toolbar in Excel used for?

• The toolbar in Excel is used for quick access to commands and features.

• To print documents directly.

• To create charts and graphs only.

• To save files in different formats.

What does the SUM function do?

• The SUM function counts the number of entries in a dataset.

• The SUM function sorts a list of numbers in ascending order.

• The SUM function calculates the total of a set of numbers.

• The SUM function finds the average of a set of numbers.

Can you name a part of the Excel window?

• Toolbar

• Worksheet

• Ribbon

• Cell

What is a spreadsheet?

• A spreadsheet is a type of physical notebook for writing notes.

• A spreadsheet is a digital tool for organizing and analyzing data in tabular form.

• A spreadsheet is a database management system for storing large amounts of data.

• A spreadsheet is a software used for creating presentations.