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
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
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
154. Status indicators are located on
the
a. Vertical scroll
bar
b. Horizontal scroll
bar
c. Formula bar
d. Formatting toolbar
155. You can open the scenario Manager
dialog box by choosing scenarios from the….. menu.
a. View b. Insert
c. Format d. Tools
156. You can open the Sort dialog box
by choosing Sort from the….. menu
a. View b. Format
c. Tools d. Data
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
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
No comments:
Post a Comment