April 16, 2020
121. 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
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
122. Status indicators are located on the
a. Vertical scroll bar
b. Horizontal scroll bar
c. Formula bar
d. Formatting toolbar
123. You can open the scenario Manager dialog box by choosing scenarios from the ….. menu.
a. View
b. Insert
c. Format
d. Tools
124. You can open the Sort dialog box by choosing Sort from the ….. menu a. View
b. Format
c. Tools
d. Data
b. Insert
c. Format
d. Tools
124. You can open the Sort dialog box by choosing Sort from the ….. menu a. View
b. Format
c. Tools
d. Data
125. 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
126. 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
127. 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
128. You can copy data or formulas
a. With the copy, paste and cut commands on the edit menu
b. With commands on a shortcut menu
c. With buttons on the standard toolbar
d. All of the above
129. You can activate a cell by
a. Pressing the Tab key
b. Clicking the cell
c. Pressing an arrow key
d. All of above
130. Which of the following setup options can not be set in the page setup dialog box?
a. view exactly where each page break occurs
b. add or remove page breaks
c. change the print area
d. all of above
126. 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
127. 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
128. You can copy data or formulas
a. With the copy, paste and cut commands on the edit menu
b. With commands on a shortcut menu
c. With buttons on the standard toolbar
d. All of the above
129. You can activate a cell by
a. Pressing the Tab key
b. Clicking the cell
c. Pressing an arrow key
d. All of above
130. Which of the following setup options can not be set in the page setup dialog box?
a. Printer selection
b. Vertical or horizontal placement
c. Orientation
d. Row and column titles
131. What term refers to a specific set of values saved with the workbook?
a. Range
b. Scenario
c. Trend line
d. What-if analysis
132. Got functions? No? You need the insert function dialog box.
How do you get it?
a. Right click a cell and then click insert
b. Click the insert menu and then click function
c. Type = in a cell
d. All of the above
133. Which of the following describes how to select all the cells in a single column?
a. Right click on column and select Pick from list
b. Use data – text to columns menu item
c. Left click on the gray column title button
d. Pressing Ctrl + A on the keyboard
134. when you use the fill effects in the format data series dialog box, you can not
a. rotate text on the chart
b. select a fore ground color
c. select a pattern
d. select a background color
135. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following? a. Rows and columns
b. Headings
c. Speed
d. None
b. Vertical or horizontal placement
c. Orientation
d. Row and column titles
131. What term refers to a specific set of values saved with the workbook?
a. Range
b. Scenario
c. Trend line
d. What-if analysis
132. Got functions? No? You need the insert function dialog box.
How do you get it?
a. Right click a cell and then click insert
b. Click the insert menu and then click function
c. Type = in a cell
d. All of the above
133. Which of the following describes how to select all the cells in a single column?
a. Right click on column and select Pick from list
b. Use data – text to columns menu item
c. Left click on the gray column title button
d. Pressing Ctrl + A on the keyboard
134. when you use the fill effects in the format data series dialog box, you can not
a. rotate text on the chart
b. select a fore ground color
c. select a pattern
d. select a background color
135. Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following? a. Rows and columns
b. Headings
c. Speed
d. None
136. Which of the following is not a basic step in creating a worksheet?
a. Save the workbook
b. Modify the worksheet
c. Enter text and data
d. Copy the worksheet
137. What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
a. Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
b. Select the range you want, include both cells, point to fill on the Edit menu, and then click down.
c. Copy the second cell, click in the cell below it, on the standard
toolbar click the down arrow on the Paste button, and then click
Paste Special
d. All of above
a. Save the workbook
b. Modify the worksheet
c. Enter text and data
d. Copy the worksheet
137. What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
a. Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
b. Select the range you want, include both cells, point to fill on the Edit menu, and then click down.
c. Copy the second cell, click in the cell below it, on the standard
toolbar click the down arrow on the Paste button, and then click
Paste Special
d. All of above
138. To insert three columns between columns D and E you would
a. Select column D
b. Select column E
c. Select columns E, F and G
d. Select columns D, E, and F.
139. To center worksheet titles across a range of cell, you must
a. Select the cells containing the title text and use the fill handle to
center the text across a range of cells
b. Widen the columns
c. Select the cells containing the title text and use the fill handle to
center the text across a range of cells
d. Widen the column
a. Select column D
b. Select column E
c. Select columns E, F and G
d. Select columns D, E, and F.
139. To center worksheet titles across a range of cell, you must
a. Select the cells containing the title text and use the fill handle to
center the text across a range of cells
b. Widen the columns
c. Select the cells containing the title text and use the fill handle to
center the text across a range of cells
d. Widen the column
140. When integrating Ms-Word and Excel, Word is usually the
a. Server
b. Source
c. Client
d. None
a. Server
b. Source
c. Client
d. None
Answers.
121 - a
122 - c
123 - d
124 - d
125 - d
126 - b
127 - a
128 - d
129 - d
130 - a
131 - b
132 - b
133 - c
134 - a
135 - c
136 - d
137 - a
138 - c
139 - c
140 - c
121 - a
122 - c
123 - d
124 - d
125 - d
126 - b
127 - a
128 - d
129 - d
130 - a
131 - b
132 - b
133 - c
134 - a
135 - c
136 - d
137 - a
138 - c
139 - c
140 - c
0 comments:
Post a Comment