ashi is designing a database for all its students . she wants to link an excel sheet and photography of each student . can you suggest which data type should she use.
Answers
Answer:
Every Excel grandmaster needs to start somewhere. In this chapter, you’ll learn how to create a basic spreadsheet. First, you’ll find out how to move around Excel’s grid of cells, typing in numbers and text as you go. Next, you’ll take a quick tour of the Excel ribbon, the tabbed toolbar of commands that sits above your spreadsheet. You’ll learn how to trigger the ribbon with a keyboard shortcut, and collapse it out of the way when you don’t need it. Finally, you’ll go to Excel’s backstage view, the file-management hub where you can save your work for posterity, open recent files, and tweak Excel options.
Explanation:
Chapter 1. Creating Your First Spreadsheet
Every Excel grandmaster needs to start somewhere. In this chapter, you’ll learn how to create a basic spreadsheet. First, you’ll find out how to move around Excel’s grid of cells, typing in numbers and text as you go. Next, you’ll take a quick tour of the Excel ribbon, the tabbed toolbar of commands that sits above your spreadsheet. You’ll learn how to trigger the ribbon with a keyboard shortcut, and collapse it out of the way when you don’t need it. Finally, you’ll go to Excel’s backstage view, the file-management hub where you can save your work for posterity, open recent files, and tweak Excel options.
Starting a Workbook
When you first fire up Excel, you’ll see a welcome page where you can choose to open an existing Excel spreadsheet or create a new one (Figure 1-1).
Excel’s welcome page lets you create a new, blank worksheet or a ready-made workbook from a template. For now, click the “Blank workbook” picture to create a new spreadsheet with no formatting or data.
Figure 1-1. Excel’s welcome page lets you create a new, blank worksheet or a ready-made workbook from a template. For now, click the “Blank workbook” picture to create a new spreadsheet with no formatting or data.
Excel fills most of the welcome page with templates, spreadsheet files preconfigured for a specific type of data. For example, if you want to create an expense report, you might choose Excel’s “Travel expense report” template as a starting point. You’ll learn lots more about templates in Chapter 16, but for now, just click “Blank workbook” to start with a brand-spanking-new spreadsheet with no information in it.
NOTE
Workbook is Excel lingo for “spreadsheet.” Excel uses this term to emphasize the fact that a single workbook can contain multiple worksheets, each with its own grid of data. You’ll learn about this feature in Chapter 4, but for now, each workbook you create will have just a single worksheet of information.
You don’t get to name your workbook when you first create it. That happens later, when you save your workbook (Saving Files). For now, you start with a blank canvas that’s ready to receive your numerical insights.
Adding Information to a Worksheet
When you click “Blank workbook,” Excel closes the welcome page and opens a new, blank worksheet, as shown in Figure 1-2. A worksheet is a grid of cells where you type in information and formulas. This grid takes up most of the Excel window. It’s where you’ll perform all your work, such as entering data, writing formulas, and reviewing the results.
The largest part of the Excel window is the worksheet grid, where you type in your information.
Figure 1-2. The largest part of the Excel window is the worksheet grid, where you type in your information.
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.