Top 250+ Solved Office Automation Tools MCQ Questions Answer
Q. Which of the following is not an option of the spelling dialog box?
a. ignore
b. ignore all
c. edit
d. change
Q. Which of the following methods will not enter data in a cell?
a. pressing the esc key
b. pressing an arrow key
c. pressing the tab key
d. clicking the enter button to the formula bar
Q. What is the keyboard shortcut for creating a chart from the selected cell range?
a. f2
b. f4
c. f8
d. f11
Q. The Software which contains rows and columns is called ______
a. database
b. drawing
c. spreadsheet
d. word processing
Q. You can group non-contiguous worksheets with
a. the alt+enter key
b. the ctrl key and mouse
c. the shift key and the mouse
d. the group button on the standard toolbar
Q. If you need a text to show vertically in a cell. How will you achieve this?
a. choose vertical on text alignment in format cells dialog box
b. choose 90 degrees in orientation of format cells dialog box
c. choose distributed from the vertical drop down list of format cells dialog box
d. choose centre across selection from horizontal combo box in format cells dialog box
Q. Can you set 0.5 inch left indentation for a cell in Excel?
a. excel does not have indentation feature
b. you can specify indentation only if you turn the rulers on
c. indentation can be set from format cells dialog box
d. the indentation can be specified only when printing
Q. You can automatically adjust the size of text in a cell if they do not fit in width by
a. double clicking on the right border of column header
b. from format choose columns and then auto fit selection
c. from format cells dialog box mark shrink to fit check box
d. all of above
Q. Formatting a cell in Currency, you can specify
a. decimal places
b. currency symbol
c. both of above
d. none of above
Q. Formatting a cell in Number format you can’t set
a. decimal places
b. use 1000 separator
c. negative numbers
d. currency symbol
Q. What is entered by the function =today()
a. the date value for the day according to system clock
b. the time value according to system clock
c. today’s date as text format
d. all of above