Computer Science, asked by abhiroy0850900w, 1 day ago

Please answer this question​

Attachments:

Answers

Answered by nejithashervin
0
a) A cell is an area on a spreadsheet where data can be entered.

b) A workbook is a file that contains one or more worksheets to help you organize data.

c) Default alignment of text or label entry is left alignment and for numbers and formula it is right alignment.

d) Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria.
Answered by shilpi437913
1

Answer:

1-A- Cells are the basic building blocks of all living things. The human body is composed of trillions of cells. They provide structure for the body, take in nutrients from food, convert those nutrients into energy, and carry out specialized functions. ... Cells have many parts, each with a different function

B- Workbooks are paperback textbooks issued to students. Workbooks are usually filled with practice problems, with empty space so that the answers can be written directly in the book. More recently, electronic workbooks have permitted interactive and customized learning.

C- Default alignment of text or label entry is left alignment and for numbers and formula it is right alignment.

D- Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet.

2-A-A cell range in an Excel file is a collection of selected cells. In a spreadsheet, a cell range is defined by the reference of the upper left cell (minimum value) of the range and the reference of the lower right cell (maximum value) of the range

B- A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. In one or several formulas, you can use a cell reference to refer to: ... Data on other worksheets in the same workbook.

C- Formatting is necessary for following reasons: Formatting makes any document look more presentable and professional. It makes it more interesting and easy to read for the reader. Proper punctuation marks and spelling is preferred for making it look effective.

D- Data sorting is any process that involves arranging the data into some meaningful order to make it easier to understand, analyze or visualize.Data is typically sorted based on actual values, counts or percentages, in either ascending or descending order, but can also be sorted based on the variable value labels.

E- Select the text you want to copy and press Ctrl+C. Place your cursor where you want to paste the copied text and press Ctrl+V.

F- spreadsheet, computer program that represents information in a two-dimensional grid of data, along with formulas that relate the data. Historically, a spreadsheet is an accounting ledger page that shows various quantitative information useful for managing a business.

3- To insert new cells, rows, or columns in an Excel worksheet, follow these steps: Select the cells, rows, or columns where you want the new, blank cells to appear. Click the drop-down arrow attached to the Insert button in the Cells group of the Home tab. Click Insert Cells on the drop-down menu

4- To freeze columns:

a--Select the column to the right of the column(s) you want to freeze. ...

b‐-On the View tab, select the Freeze Panes command, then choose Freeze Panes from the drop-down menu.

c--The column will be frozen in place, as indicated by the gray line.

Similar questions