201. A typical worksheet has ________ number of columns.
A. 128
B. 256
C. 1024
D. 16384
✅ The correct answer is option D.
MS Office
202. Status indicators are located on the
A. Vertical scroll bar
B. Horizontal scroll bar
C. Formula bar
D. Standard toolbar
✅ The correct answer is option C.
203. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
A. Pie chart
B. Row chart
C. Line chart
D. Column chart
✅ The correct answer is option C.
204. You can enter which types of data into worksheet cells?
A. Labels, values, and formulas
B. Labels and values but not formulas
C. Values and formulas but not labels
D. Formulas only
✅ The correct answer is option A.
205. You can use drag-and-drop to embed excel worksheet data in a word document
A. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
B. By dragging a range of excel data to the word button on the taskbar while pressing Shift key
C. By dragging a range of excel data to the word button on the taskbar while pressing Alt key
D. None of above
✅ The correct answer is option A.
206. 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 that the calculated results
✅ The correct answer is option A.
207. A worksheet can have a maximum of ________ number of rows.
A. 256
B. 1024
C. 65535
D. 1048576
✅ The correct answer is option D.
208. To copy formatting from one area in a worksheet and apply it to another area you would use:
A. The Edit > Copy Format and Edit>Paste Format commands form the menu
B. The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
C. There is no way to copy and apply formatting in Excel – You have to do it manually
D. The Format Painter button on the standard toolbar
✅ The correct answer is option D.
209. An excel workbook is a collection of
A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and charts
✅ The correct answer is option D.
210. Data can be arranged in a worksheet in a easy to understand manner using
A. Auto formatting
B. Applying styles
C. Changing fonts
D. all of above
✅ The correct answer is option D.