1.	The most common subtotal used Subtotals command is the function, which causes Excel to display a sum each time the control field change ?
	ADD
	SUM
	TOTAL
	LIST
	Answer: SUM Explanation: The most common subtotal function used with the Subtotals command in Excel is the SUM function. It causes Excel to display the sum each time the control field changes. Therefore, the correct answer is (2) SUM.
	View Answer Discuss in Forum Report Question

2.	Which of the following is the latest version of Excel ?
	Excel 2000
	Excel 2002
	Excel ME
	Excel XP
	Answer: Excel XP Explanation: Excel XP is the latest version of Excel
	View Answer Discuss in Forum Report Question

3.	A data map is helpful ?
	When you have too much data to chart
	To show a geographic distribution of data
	To compare data points
	To show changes in data over time
	Answer: To show a geographic distribution of data Explanation: The correct answer is (2) To show a geographic distribution of data. A data map is a visual representation that displays data points or values on a map, usually using colors or symbols to indicate different values or categories. It is commonly used to show the geographic distribution of data, such as population density, economic indicators, or disease outbreaks. While some of the other options you mentioned may be useful for data visualization, such as comparing data points or showing changes over time, a data map specifically focuses on presenting data in relation to geographical locations.
	View Answer Discuss in Forum Report Question

4.	How should you print a selected area of a worksheet, if you'll want to print a different area next time ?
	On the file menu, point to print area, and then click set print are
	On the file menu, click print, and then click selection under print what
	On the view menu, click custom views, then click add
	All of above
	Answer: On the file menu, click print, and then click selection under print what Explanation: The correct answer is (2) On the file menu, click print, and then click selection under print what. This option allows you to print only the selected area of the worksheet. The other options mentioned in (1), (3), and (4) do not specifically address printing a selected area of a worksheet.
	View Answer Discuss in Forum Report Question

5.	To copy formatting from one area in a worksheet and apply it to another area you would use ?
	The Edit>Copy Format and Edit>Paste Format commands form the menu.
	The Copy and Apply Format- ting dialog box, located un- der the Format>Copy and Apply menu.
	There is no way to copy and apply formatting in Excel - You have to do it manually
	The Format Painter button on the standard toolbar
	Answer: The Format Painter button on the standard toolbar Explanation: To copy formatting from one area in a worksheet and apply it to another area, you would typically use (4) the Format Painter button on the standard toolbar. The Format Painter button is a tool available in spreadsheet applications like Microsoft Excel. It allows you to copy the formatting from one cell or range of cells and apply it to another cell or range of cells.
	View Answer Discuss in Forum Report Question

6.	To activate the previous cell in a pre-selected range, press ?
	The Alt key
	The Tab key
	The Enter key
	None of the above
	Answer: None of the above Explanation: None of the above
	View Answer Discuss in Forum Report Question

7.	Book1 is an example of how ... are numbered and named during each work session ?
	Active cell
	Formula bar
	Menu bar
	Name box
	Answer: Name box Explanation: Book1 is an example of how option (4) Name box is used to number and name workbooks during each work session. In Excel, the Name box is located next to the formula bar and displays the cell reference of the active cell. It also allows you to assign or change a name for a selected range of cells or a workbook. By default, when you open a new workbook in Excel, it is typically named as "Book1" or a similar default name. However, you can change the name of the workbook by using the Name box or other options available in Excel.
	View Answer Discuss in Forum Report Question

8.	The cell labeled 23.54 the cell labeled F5 refers to ?
	row F column 5
	column F row 5
	function available in cells
	function key F4
	Answer: column F row 5 Explanation: The cell labeled F5 refers to option (2) column F row 5. In Excel, cell references are identified by their column letter and row number. The letter represents the column, and the number represents the row. In this case, the cell labeled F5 means it is in column F and row 5.
	View Answer Discuss in Forum Report Question

9.	A certain spreadsheet shows in Page Break Preview that cells in Rows 1-25 have white back- ground. The cells in row 26 that contain data have a dark grey background, when you click the Print button ...... ?
	nothing will print because some cells with data have been omitted
	only the cells with gray background will print
	the whole sheet will print
	only the cells with white background will print
	Answer: only the cells with white background will print Explanation: In page break preview, the selected print area shown in white background with blue line around each page, and dark grey area is not a print area, this area contain blank cell which not require to print.
	View Answer Discuss in Forum Report Question

10.	The cell reference from a range of cells that starts in cell Bl and goes over to column G and down to row 10 is ...... ?
	B1:G10
	B1:G10
	B1:G10
	B1:G10
	Answer: B1:G10 Explanation: The correct cell reference from a range of cells that starts in cell B1 and goes over to column G and down to row 10 is option (4) B1:G10. The cell reference is written by specifying the starting cell and the ending cell of the range, separated by a colon (:). In this case, the range starts in cell B1 and ends in cell G10. So, the correct cell reference is B1:G10.
	View Answer Discuss in Forum Report Question

«
1
2
3
4
5
6
7(curent)
8
»