Office Automation Tools Set 4 MCQs

Q1 | Which of the following methods will not enter data in a cell?

pressing the esc key

pressing an arrow key

pressing the tab key

clicking the enter button to the formula bar

Q2 | The cell reference for cell range of F2 to P12 is _______

f2.p12

f;p12

f2:p12

f2-p12

Q3 | What is the keyboard shortcut for creating a chart from the selected cell range?

f2

f4

f8

f11

Q4 | The Software which contains rows and columns is called ______

database

drawing

spreadsheet

word processing

Q5 | You can group non-contiguous worksheets with

the alt+enter key

the ctrl key and mouse

the shift key and the mouse

the group button on the standard toolbar

Q6 | Which of the following is not a valid Zoom percentage in Excel?

75

100

200

500

Q7 | The spelling tool is placed on ______ toolbar

standard

formatting

drawing

reviewing

Q8 | If you need a text to show vertically in a cell. How will you achieve this?

choose vertical on text alignment in format cells dialog box

choose 90 degrees in orientation of format cells dialog box

choose distributed from the vertical drop down list of format cells dialog box

choose centre across selection from horizontal combo box in format cells dialog box

Q9 | Can you set 0.5 inch left indentation for a cell in Excel?

excel does not have indentation feature

you can specify indentation only if you turn the rulers on

indentation can be set from format cells dialog box

the indentation can be specified only when printing

Q10 | You can automatically adjust the size of text in a cell if they do not fit in width by

double clicking on the right border of column header

from format choose columns and then auto fit selection

from format cells dialog box mark shrink to fit check box

all of above

Q11 | Formatting a cell in Currency, you can specify

decimal places

currency symbol

both of above

none of above

Q12 | Formatting a cell in Number format you can’t set

decimal places

use 1000 separator

negative numbers

currency symbol

Q13 | What is entered by the function =today()

the date value for the day according to system clock

the time value according to system clock

today’s date as text format

all of above

Q14 | Which function will you use to enter current time in a worksheet cell?

today()

44711.89343

0

Q15 | Special category of Number tab in Format Cells dialog box can be used to applyformats like

zip code

phone number

both of above

none of above

Q16 | Merge cells option can be applied from

format cells dialog box alignment tab

formatting toolbar

both of above

none of above

Q17 | Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can be appliedfrom

from format >> cells

from format >> auto format

from table >> auto format

all of above

Q18 | Which of the following format you can decide to apply or not in AutoFormat dialogbox?

number format

border format

font format

all of above

Q19 | How can you remove borders applied in cells?

choose none on border tab of format cells

open the list on border tool in formatting toolbar then choose first tool (no border)

both of above

none of above

Q20 | Where can you set the shedding colour for a range of cells in Excel?

choose required colour form patterns tab of format cells dialog box

choose required colour on fill colour tool in formatting toolbar

choose required colour on fill colour tool in drawing toolbar

all of above

Q21 | You can set Page Border in Excel from

from border tab in format cells dialog box

from border tool in formatting toolbar

from line style tool in drawing toolbar

you cannot set page border in excel

Q22 | When all the numbers between 0 and 100 in a range should be displayed in RedColour, apply

use =if() function to format the required numbers red

apply conditional formatting command on format menu

select the cells that contain number between 0 and 100 then click red colour on text colour tool

all of above

Q23 | You can check the conditions against __________ when applying conditionalformatting

cell value

formula

both of above

none of above

Q24 | Which of the following is not true regarding Conditional Formatting?

you can add more than one condition to check

you can set condition to look for bold and apply italics on them.

you can apply font, border and pattern formats that meets the specified conditions

you can delete any condition from conditional formatting dialog box if it is not required

Q25 | In Microsoft Excel 2007, the ----------- is used to issue commands

quick access tool bar

formula bar

ribbon

ms button