152. 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