DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Workbook
|
|
|
Conditional Formatting
|
|
|
Quick Access Toolbar
|
|
|
Merge
|
Detailed explanation-1: -A workbook is a spreadsheet program file that you create in Excel. 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. The cells are organized into columns and rows.
Detailed explanation-2: -How many worksheets are there in Excel? In one workbook you can add 255 separate sheets.
Detailed explanation-3: -The correct answer is Three. By default, a new workbook in Excel 2013 contains three worksheets, but we can change the number of worksheets that we want a new workbook to contain. By default, in Excel 2016 any new workbook you create in Excel will contain one worksheet, called Sheet1.
Detailed explanation-4: -Detailed Solution. The Correct Answer is “3". When we open an Excel workbook, there are three sheets by default, and the default name on the tabs are Sheet1, Sheet2, and Sheet3.