Week 6 - Spreadsheet

Which of the statement of the spreadsheet below is incorrect?

• An arrangement of cells in columns and rows used to organize, analyze, calculate and report information usually in numerical form

• It is used to create a wide range of different types of files. example Word files (.doc, .docx)

• Allows user to create large spreadsheets, reference information and it allows for better storage of information

• 
  User can organize and manipulate data create chart and perform calculations

Answer explanation

It is used to create a wide range of different types of files. example Word files (.doc, .docx). This statement is belong to MS words

Which Statement is correct? The benefits of using spreadsheet is...

• It makes data disorganized and difficult to manipulate

• 
  It does not allow for the creation of visual representations of data

• 
  Enable dynamic calculations with built-in formulas

• Dynamic auto-correct grammar with built-in formulas

Answer explanation

By using Formula Bar.

Enable Dynamic Calculations with built in Formulas

Based on the video, what are the different types of spreadsheet being mentioned?

• AirTable, Smartsheet, Numbers (iOS), Apache Openoffice Calc and LibreOffice Calc

• Zoho Sheet, Apple Numbers, WPS sheet, Quattro Pro and MS Excel

• Google Sheets, Free Office Planmaker, LibreOffice, Zoho sheets and WPS Office

• Ms Excel, Ms Words, Ms Powerpoint, Ms Project and Ms Forms

Answer explanation

AirTable, Smartsheet, Numbers (iOS), Apache Openoffice Calc, and LibreOffice Calc are also spreadsheet apps.

But Based on the video, the correct answers are Google Sheets, Free Office Planmaker, LibreOffice, Zoho Sheets, and WPS Office.

This is to verify whether you are attentive while watching the video or not.

One of the basic functionalities of spreadsheet is "Filtering", What does "Filtering" do?

• Adjusting font, color, size, and other features of individual cells or cell groupings

• Addition, subtraction, multiplication, and division

• Narrowing down data based on specified criteria

• Ascending or descending order

Answer explanation

Adjusting font, color, size, and other features of individual cells or cell groupings - Cell Formatting.

Addition, subtraction, multiplication, and division - Basic formulas 

Sorting ascending or descending order - Sort

How many rows and columns does MS Excel have?

• 16, 384 Columns

  1,0482,576 Rows

• 16, 384 Rows

  1,0482,576 Column

Answer explanation

Based on the picture, what is this box called?

• Cell

• View Option

• Name Box

• Formula Bar

Answer explanation

Which function is used to add up a range of numbers in Excel?

• ADD
• SUM
• TOTAL
• COUNT

Answer explanation

To add up a range of numbers in Excel. For example =SUM(A1:A98}