Class 8 Computer Science Notes, Unit 2: Digital Skills -- Exercise Short Response and Miscellaneous (within the chapter) Questions and Answers.

Class 8 Computer Science Notes for 8th Centralized Exam 2023 
and onward, FDE, Islamabad 

Unit-2 

"Digital Skills"

************************************

Class 8 Computer Science MCQs (All Units Exercise) 

************************************

1. Exercise Short Response Questions and Answers:

Q1. Write down the uses of Microsoft Excel.

Ans:

Microsoft Excel is a spreadsheet software developed by Microsoft. It is used to organize and manipulate data using formulas and functions. It provides a visual representation of data that makes it easier to analyze. It is also used by businesses to perform financial analysis. It is now the most commonly used program for creating graphs and tables.

Q2.  What is the purpose of the formula bar?

Ans:.

The formula bar is located above the frame. It is used to enter or show the formula or function in a cell.

Q3. Differentiate between workbook and worksheet.

Ans:

Worksheet: 

The collection of rows and columns is called a worksheet. It consists of
cells to enter data. By default, there are three worksheets in a workbook.

Workbook: 
It is a collection of worksheets. By default, it has 3 worksheets but we
can add more sheets. An Excel document is called a workbook.

Q4. What are the steps to create a Pie chart?

Ans:

The steps to create a Pie chart are:

1. Select the cells that contain data to be used in the chart.
   
2. Click on the Chart button from the INSERT tab.
   
3. Click on the Pie chart button from the list.
4. Hence the Pie chart will be inserted.

2. Miscellaneous Questions and Answers (Within the Unit):

Q.1.  What do you mean by spreadsheet?

Ans:

A spreadsheet is a digital form of a paper-based worksheet. It consists of rows and columns. The intersection of row and column is known as a cell where all the data is filled to apply operations. Commonly used spreadsheet software are: 

Microsoft Excel, Open Office Calc, Google sheets

Q2. Why are spreadsheets used?

Ans:

Spreadsheets are used:

• To perform calculations
  
• For data analysis
  
• For interrogation and visualization
  
• For payroll and business accounts management

Q3. Define the following terms: 
Cell, Row, Columns, Worksheet, Workbook, Active cell, Cell address

Ans:

Cell: 

Each box in an Excel worksheet is called a cell. It is the intersection of rows and columns. Each cell is identified by a unique address.

Row: 

A horizontal collection of cells is called a row. Each row has a unique row number.

Column: 

A vertical collection of cells is called a column. Each column has a unique name consisting of one or more alphabets.

Worksheet: 

The collection of rows and columns is called a worksheet. It consists of cells to enter data. By default, there are three worksheets in a workbook.

Workbook: 

It is a collection of worksheets. By default, it has 3 worksheets but we can add more sheets. An Excel document is called a workbook.

Active cell: 

A cell that is ready to accept data is called an active cell. It is identified by a bold border.

Cell address: 

Each cell in an excel worksheet is identified by a unique name called cell

address. It consists of a name followed by a row number e.g. A2, X3, etc.

Q4. Differentiate between copy and cut commands.

Ans:

Cut: 
The cut command removes the selection and puts it on the clipboard. Which can be pasted anywhere. It simply moves the data

Copy: 
It makes a duplicate of the selection and puts it on a clipboard which can be pasted anywhere in many places.

Q5. What is a formula in MS Excel?

Ans: 

A formula is an expression that operates on values or cell addresses. It calculates the results. It always starts with “=” equal sign e.g. =C5+D5

Q6. Define a function.

Ans: 

A function is a predefined formula that quickly calculates the result of the given values. e.g. SUM(C5: E5)

Q7. Write the purpose of the following functions:
SUM(), AVERAGE(), IF(), MAX(), MIN()

Ans: 

SUM(): 
It is used to calculate the sum of the given values.
e.g. SUM(C5:B10) will find the sum of all the values of cells B5 to B10.

AVERAGE(): It is used to find the average of the selected cells.
e.g. AVERAGE(B5:B10) will find the average of all the values of cells B5 to B10.

IF(): 

It is used to return a value out of given values depending upon applied conditions.

e.g. IF(B5>=33, “PASS, FAIL”) will show PASS if marks are greater and FAIL otherwise.

MAX(): 

It is used to find the greatest value in the selected cells.
e.g. MAX(B5:B10) will find the greatest values among all values in cells B5 to B10.

MIN(): 

It is used to find the smallest values in the given range of cells.
e.g. MIN(B5:B10) will find the smallest values among all values in cells B5 to B10.

Q8.  What do you mean by sorting and Filtering?

Ans:

Sorting is the process by which data is arranged. It may be in descending or ascending order.

Q9.  What is a chart? How can you insert a chart in MS Excel?

Ans:

The chart is a graphical representation of data in a worksheet. It is used for easy and quick analysis. Some types of charts are:

• Bar chart
• Line chart
  
• Pie chart
  
  

The chart can be inserted as:

1. Select the cells containing data.
   
2. Click on the “chart option” in the insert ribbon.
   
3. Select the type of chart you want to insert.

Q10.  What is the use of the formula bar?

Ans:.

The formula bar is located above the frame. It is used to enter or show the formula or function in a cell.

Q11.  What is the use of merge and center in MS Excel

Ans:.

It combines two or more cells to form a single larger cell and centers the contents.

Q12.  What do you mean by formatting a worksheet?

Ans:.

Formatting means setting the layout of a document to make it readable and presentable.

Q13.  What is the use of a format painter?

Ans:.

Format painter is used to apply the formatting of a particular selection to the other part of the document. It offers an easier way to copy formatting from one part of our spreadsheet to another without spending a lot of time replicating our formatting manually.

Q14.  Why wrap text is used?

Ans:.

The wrap text option is used to present long text in multiple lines within a cell so that it can be viewed fully.

Q15.  What is Auto-sum?

Ans:.

Auto-sum is used to apply quick calculations automatically to worksheets. It can be done by using short-cut keys Alt+=

Q16.  Define Spelling and Thesaurus.

Ans:.

Spelling is used to check the correct spellings of text while thesaurus suggests alternative words of a particular word.

Q17.  Define the following short-cut commands.

Ans:.

Commands shortcut	Actions
Ctrl+N	Opens a new/blank workbook
Ctrl+A	Select All
Ctrl+B	Bold
Ctrl+C	Copy
Ctrl+X	Cut
Ctrl+V	Paste
Ctrl+S	Save
Ctrl+P	Print
Ctrl+Z	Undo
Ctrl+Y	Redo
Shift+F3	Insert Function
F1	Help
F7	Check Spelling
F11	Insert a new Chart
Shift+F7	Thesaurus
Shift+F11	Insert New worksheet
Alt+f4	Exit Workbook
Alt + =	Auto-sum

************************************

Shortcut Links For:

1.  5th Class All Subjects Notes

2.  8th Class All Subjects Notes

3.  Easy English Grammar Notes

1. Website for School and College Level Physics   

(https://askrarequiz.blogspot.com)

2. Website for School and College Level Mathematics  

(https://askraremaths.blogspot.com)

3. Website for Single National Curriculum Pakistan - All Subjects Notes 

(https://askrareclassnotes.blogspot.com/)

© 2023 & onwards Academic Skills and Knowledge (ASK)   

Note:  Write me in the comments box below for any query and also Share this information with your class-fellows and friends.