A workbook is a collection of one or more worksheets, in a single file. In cell C10 type MAX(C3:C7)In cell D10 type MAX(D3:D7)In cell E10 type AVERAGE(C3:C7)In cell F10 type AVERAGE(D3:D7)SECTION 5: SHORT ANSWER TYPE QUESTIONS-(UNSOLVED)1. Copy cell F3 and paste it to cells F4 to F7.c. Copy cell E3 and paste it to cells E4 to E7.b. Copy cell E1 and paste it to cells E2, E3, E4 and E5.2. For Example, COUNT(A4: G4) will count the cells that containnumbers in the cells A4 through G4.BRAIN DEVELOPERSECTION 4: APPLICATION BASED QUESTIONS-(UNSOLVED)1. COUNT() function counts the number of numeric entries, formulas, and date entries in agiven range of cells. If there are no valid arguments within the MIN function, it returns a value of0. This function only considers numeric entries and logical values as itsarguments. For Example, MAX(B4:E4).MIN(): The MIN function returns the smallest value among the set of values in a givenrange of cells. If there are no valid arguments within the MAX function, it returns a value of0. MAX(): The MAX function returns the largest value among the set of values in a givenrange of cells. The functions are made up of two parts - Argumentsand Structure.4. They eliminate thechance to write wrong formulas. Whereas, functions arepre-designed formulas to perform simple and complex calculations. The result of thecalculation is displayed in the cell where the formula is entered. It is an expression that caninclude cell addresses, numbers, arithmetic operators, and parenthesis. Formulas are equations that perform calculations on values. Compound formulas are used when you need more than one operator. You can enter three types of data in a spreadsheet, such as Numbers, Text, and Formulas.2. For example, a range starting from C3 and ending in J10 would be written asB2:H8.Ĭhapter – 11: EDITING DATA IN A SPREADSHEETAnswer the Following Questions1. You can specify a range bywriting the starting cell address followed by the ending cell address, both separated by acolon (:). It canbe as small as a single cell or as big as an entire worksheet. A range is a group of contiguous cells, which are selected or denoted collectively. It displays the location of the cell pointer.6. The unique cellname/cell reference is displayed in this box. Whereas, the Name box islocated above the column heading on the left hand side of the window. In Excel, if a function or formula is written in a cell, the celldisplays the result or value, and the formula bar displays the function or formula applied.A formula or function always starts with an equal( ) sign. This bar shows the characters and formulas that you enter in an active cell. It is located to the right of the Namebox. The Formula bar is located at the top of the sheet. The workbook is designed to holdtogether multiple worksheets in order to organise and consolidate data efficiently.5. Each workbook hasa single theme and contains, at least, one worksheet. MICROSOFT EXCEL ONLINE CELL REFRENCING SOFTWARESome spreadsheet software are: Microsoft Excel, LibreOffice Calc, Gnumeric, GoogleSheets.4. Auto Updation of Data: The data is automatically recalculated in the wholeworksheet if any change is made in a single cell.3. Formatting Features: These features are used for improving the appearance ofdata.c. Functions are the built-informulas which are used for calculating percentage, interest, average, etc., in MSExcel.b. Formulas and Functions: Formulas are mathematical expressions that are mainlyused for performing simple and complex calculations. Among many, three important features of Spreadsheet are:a. Ithas an additional feature of representing data in the form of a chart that helps you toanalyse data quickly.2. It provides inbuiltfeatures and data analysis tools that make it easy to work with a large amount of data. Spreadsheet software allows you to store, organise, calculate, and manipulate theavailable data in a tabular format, consisting of rows and columns. UNIT 4: ELECTRONIC SPREADSHEETChapter – 10: INTRODUCTION TO SPREADSHEETSAnswer the Following Questions1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |