Top 250+ Solved Office Automation Tools MCQ Questions Answer

From 121 to 135 of 272

Q. The default header for a worksheet is

a. username

b. date and time

c. sheet tab name

d. none

  • c. sheet tab name

Q. Which of the following is not an option of the spelling dialog box?

a. ignore

b. ignore all

c. edit

d. change

  • c. edit

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

  • a. pressing the esc key

Q. The cell reference for cell range of F2 to P12 is _______

a. f2.p12

b. f;p12

c. f2:p12

d. f2-p12

  • c. f2:p12

Q. The Software which contains rows and columns is called ______

a. database

b. drawing

c. spreadsheet

d. word processing

  • c. spreadsheet

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

  • b. the ctrl key and mouse

Q. The spelling tool is placed on ______ toolbar

a. standard

b. formatting

c. drawing

d. reviewing

  • a. standard

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

  • b. choose 90 degrees in orientation of 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

  • c. indentation can be set from format cells dialog box

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

  • c. from format cells dialog box mark shrink to fit check box

Q. Formatting a cell in Currency, you can specify

a. decimal places

b. currency symbol

c. both of above

d. none of above

  • c. both 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

  • 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

  • b. the time value according to system clock
Subscribe Now

Get All Updates & News