Very Short Answer Type Questions
(a) Where do you find the title bar in Microsoft Excel ?
(b) How many rows and columns are in a worksheet in Microsoft Excel?
(c) What is the alignment by default in Microsoft Excel for numbers and text?
(d) What are the types of data that can be input into a cell in Excel?
(e) How do you select a complete row in a worksheet?
Answers
Answer:
1) It lies next to the quick access toolbar or on top of the excel window. It displays the name of the open document.
2) 16384
For MS Excel 2010, Row numbers ranges from 1 to 1048576; in total 1048576 rows, and Columns ranges from A to XFD; in total 16384 columns.
3) As a default in Microsoft Excel, text typed into a cell is aligned to the left border of the cell while numbers are aligned to the right.
4) You enter three types of data in cells: labels, values, and formulas. Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters. Values (numbers) are generally raw numbers or dates.
5) Select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space. To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers.
Explanation: