Subject : Collection of Objective Questions or Multiple Choice Questions (MCQs. (closed)
Collection of Objective Questions or Multiple Choice Questions (MCQs. 151. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the a. Unfreeze panes command on the window menu b. Freeze panes command on the window menu c. Hold titles command on the edit menu d. Split command on the window menu Correct Answer: b152. Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet? a. Use Ctrl to select all three cells, then click the paste button on the standard toolbar b. Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify c. Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to d. All of above Correct Answer: c 153. To edit data in an embedded Excel worksheet object in a Word document a. Use the Excel menu bar and toolbars inside the word application b. Edit the hyperlink c. Edit the data in a Excel source application d. Use the Word menu bar and toolbars Correct Answer: a. Use the Excel menu bar and toolbars inside the word application 154. Status indicators are located on the a. Vertical scroll bar b. Horizontal scroll bar c. Formula bar d. Formatting toolbar Correct Answer: c 155. You can open the scenario Manager dialog box by choosing scenarios from the ….. menu. a. View b. Insert c. Format d. Tools Correct Answer: d 156. You can open the Sort dialog box by choosing Sort from the ….. menu a. View b. Format c. Tools d. Data Correct Answer: d 157. when working in the page break preview, you can a. view exactly where each page break occurs b. add or remove page breaks c. change the print area d. all of above Correct Answer: d 158. A data map is helpful a. When you have too much data to chart b. To show a geographic distribution of data c. To compare data points d. To show changes in data over time Correct Answer: b 159. Rounding errors can occur a. When you use multiplication, division or exponentiation in a formula b. When you use addition and subtraction in a formula c. Because Excel uses hidden decimal places in computation d. When you show the results of formulas with different decimal places than the calculated results Correct Answer: a
no likes.
|