This function determines the number of calendar days between two dates. The correct answer is Home. End Moves active cell to the last column of current row that contains data. Page Up Moves active cell up to one screen. The text items can be text strings, numbers, or single-cell references. Vertical scroll bar Horizontal scroll bar Formula bar Standard toolbar None of the above.
The correct answer is Formula bar. Key Points The Formula Bar is where data or formulas are entered into a worksheet that appears for the active cell. The Formula Bar can also be used to edit data or formula in the active cell. The active cell displays the results of its formula while we see the formula itself in the Formula Bar. The Insert Function dialog box shows what functions are available, what they do, and how to use them.
Additional Information The Standard toolbar is located just below the menu bar. It contains buttons representing commands such as New, Open, Save, and Print. The Formatting toolbar is located by default next to the Standard toolbar.
Columns, rows Rows, slides Slides, rows Rows, columns. The correct answer is Rows, columns. Important Points Worksheet and workbook specifications and limits: Rows can have a maximum height of Total number of rows and columns on a worksheet - 1,, rows by 16, columns Column width - characters Page breaks - 1, horizontal and vertical Row height - points Download Solution PDF Share on Whatsapp.
You can add individual values , cell references or ranges, or a mix of all three. Key Points If cell A1 is copied in cell D5. Then , the same pattern will be followed in the D5 cell.
It means C5 cell is horizontally and vertically 3 and 5 cells down respectively. Similarly, F9 is horizontally and vertically 3 and 5 cells down respectively from D5 cell.
A4 is three cells downward from the A1 cell. In the same way, D8 is three cells downward from the D5 cell. F12 Save the active workbook under a new name, displays the Save as dialog box.
The correct answer is Spreadsheet. Important Points MS Excel , a worksheet, also known as a Spreadsheet , is a table into which you enter data and data label. Worksheet used in Excel documents is a collection of cells organized in rows and columns.
It is the working surface you interact with to enter data. Each worksheet contains rows and columns and serves as a giant table that allows you to organize information. Typically, a workbook contains several worksheets with related content and only one of the worksheets is active at a time. Key Points The main characteristics of worksheets: Cells: Each worksheet has a significant number of cells that can be assigned values and various formatting options.
Rows and Columns: Cells in a worksheet are organized into rows and columns. The API of a worksheet allows you to insert, manipulate and delete rows and columns. Names Named Ranges : The Worksheet class exposes a Names property of type NameCollection that allows you to create, update and manage names.
Collection of Hyperlinks: Each worksheet can contain numerous hyperlinks to web pages, particular cells in the workbook, or email addresses. Find and Replace: You can easily find and replace text and numbers in the content of a worksheet. Protection: You can restrict the user from modifying the content and structure of the worksheet. Additional Information Data set A Data set is a set or collection of data.
This is a part of data management. Data Room Data room is a cloud solution specially made for the secure storing and sharing of confidential business information.
One Three Five Seven. The correct answer is Three. By default, a new workbook contains three worksheets , but you can change the number of worksheets that you want a new workbook to contain These three worksheets are named Sheet1, Sheet2, and Sheet3.
The workbook is an excel file containing many worksheets. A worksheet has a single spreadsheet containing data. The workbook cannot be added to the worksheet. Key Points A workbook is the name given to an Excel file and contains one or more worksheets.
When you open an electronic spreadsheet program , it loads an empty workbook file consisting of one or more blank worksheets for you to use. In Microsoft Excel, a workbook is a collection of one or more spreadsheets, also called worksheets , in a single file.
Each workbook contains, at least, one worksheet and often holds several sheets with related information. The workbook is designed to hold together multiple worksheets in order to allow efficient organization and consolidation of data. Typically, a workbook has a single theme and contains worksheets with related data. RAND : This function is used to returns a random number greater than or equal to 0 and less than 1.
MOD : This function is used to find the remainder after dividing a number by another number. Get Started for Free Download App. Column heading Name box Formula bar Row heading. The correct answer is Name box. Key Points Name Box is a box in the input left in the left corner of the ribbon i. In each box, the name of the active sheet cell is shown and we can also search any cell by inserting the name of the cell in it.
It can also be used to create a named range. Answer Detailed Solution Below Option 3 : The correct answer is The EVEN function rounds a positive number up to the nearest even integer. ODD 20 equals EVEN 39 equals Hence, the Sum is Answer Detailed Solution Below Option 1 : Key Points The selected date format is ' xx-xx-xxxx ' which means ' dd-mm-yyyy '. It is the main function used to calculate dates in Excel.
The TODAY function takes no arguments and returns the current date , updated whenever a worksheet is changed or opened. TIME function is a built-in function that allows you to create a time with individual hour, minute, and second components.
Sheet Font Border Alignment.
0コメント