DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
workbook
|
|
|
worksheet
|
|
|
folder
|
|
|
table
|
Detailed explanation-1: -A spreadsheet is a configuration of rows and columns. Rows are horizontal vectors while columns are vertical vectors. A spreadsheet is also known as a worksheet. It is used to record, calculate and compare numerical or financial data.
Detailed explanation-2: -A workbook contains one or more worksheets. A worksheet (also known as a spreadsheet) consists of cells in which you can enter and calculate data.
Detailed explanation-3: -Some commonly used spreadsheet software programs today: Microsoft Excel as part of the Microsoft Office suite and cloud-based subscription service Microsoft 365 (formally Office 365). It is available for Windows, macOS, Android and iOS. Google Sheets: Part of Google’s web-based application suite, Google Workspace.
Detailed explanation-4: -The table feature makes it easy to enter, edit, and manipulate data.
Detailed explanation-5: -On the worksheet, click a cell. Type the numbers or text that you want to enter, and then press ENTER or TAB. To enter data on a new line within a cell, enter a line break by pressing ALT+ENTER.