We read your photo as:
Create a worksheet named "Student_Data" and enter the following data: Adm No, Name, Course, Gender, Fee Paid, Date Paid.
Computer Science
ScanSolve AI Answer
Here are the steps and formulas to complete the tasks in Excel:
QUESTION 1: DATA ENTRY & STRUCTURING
- Step 1: Create "Student_Data" worksheet and enter data.
- Open a new Excel workbook. Rename "Sheet1" to
Student_Data. - Enter the provided data into cells A1:F6:
- A1:
Adm No, B1:Name, C1:Course, D1:Gender, E1:Fee Paid, F1:Date Paid - A2:
101, B2:John, C2:ICT, D2:M, E2: `19
- A1:
- Open a new Excel workbook. Rename "Sheet1" to
Was this helpful?
Still stuck on this one?
Ask a follow-up, and the answer starts from this question.
Got a different question?Ask your own question
More Computer Science Questions
QOpen a spreadsheet program and key in the following data as it appears. Save the work book as…QComplete the spreadsheet tasks as outlined in sections 2.1 to 2.9, modifying text, inserting…QRecord your calculations and results on the worksheet. Present your findings and explain your…QHow do I format and add dates for a second pay period in an Excel spreadsheet for a payroll…QCreate a database called FinanceDB with tables Member, Transaction, and Operation. Populate these…