Create a set of worksheets for storing records of marks of different subject in
PT1, PT2 and half yearly Exam and find the average of all these on a separate
worksheet.
a) Rename each sheet as PT1, PT2, Half yearly, average
b) Save the workbook as Marklist
c)Open New Workbook (name it as MyNewMarklist) and find the sum of all
mark of Marklist(Hint: Sharing across workbook)
d)insert hyperlink and get the workbook Marklist into it.
7)Create a worksheet as shown and with help of macros record the
Sequence and do it for at least 5 records
Name Thamana
Class 10K
Mark in subjects
Math 78
Science 87
English 65
Hindi 98
English 76
Total =B4+B5+B6+B7+B8
can anyone please help . please explain step by step
Answers
Answer:
Here are a few basics about Excel’s grid:
The grid divides your worksheet into rows and columns. Excel names columns using letters (A, B, C…), and labels rows using numbers (1, 2, 3…).
The smallest unit in your worksheet is the cell. Excel uniquely identifies each cell by column letter and row number. For example, C6 is the address of a cell in column C (the third column) and row 6 (the sixth row). Figure 1-3 shows this cell, which looks like a rectangular box. Incidentally, an Excel cell can hold approximately 32,000 characters.
A worksheet can span an eye-popping 16,000 columns and 1 million rows. In the unlikely case that you want to go beyond those limits—say, if you’re tracking blades of grass on the White House lawn—you’ll need to create a new worksheet. Every spreadsheet file can hold a virtually unlimited number of worksheets, as you’ll learn in Chapter 4.
When you enter information, enter it one cell at a time. However, you don’t have to follow any set order. For example, you can start by typing information into cell A40 without worrying about filling any data in the cells that appear in the earlier rows.
Answer:
See you TB pg-94 Comparing Documents
Explanation: