Deck 4: Excel Functions and Formatting Tips

Question 1

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

Answer 1

pressing the esc key

Question 2

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

A) f2. p12
B) f;p12
C) f2:p12
D) f2-p12

Answer 2

f2:p12

Question 3

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

A) f2
B) f4
C) f8
D) f11

Answer 3

f11

Question 4

The Software which contains rows and columns is called ______

A) database
B) drawing
C) spreadsheet
D) word processing

Question 5

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

Question 6

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

A) 75
B) 100
C) 200
D) 500

Question 7

The spelling tool is placed on ______ toolbar

A) standard
B) formatting
C) drawing
D) reviewing

Question 8

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

Question 9

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

Question 10

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

Question 11

Formatting a cell in Currency, you can specify

A) decimal places
B) currency symbol
C) both of above
D) none of above

Question 12

Formatting a cell in Number format you can't set

A) decimal places
B) use 1000 separator
C) negative numbers
D) currency symbol

Question 13

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

Question 14

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

A) today()
B) =now()
C) =time()
D) =current time()

Question 15

Special category of Number tab in Format Cells dialog box can be used to apply formats like

A) zip code
B) phone number
C) both of above
D) none of above

Question 16

Merge cells option can be applied from

A) format cells dialog box alignment tab
B) formatting toolbar
C) both of above
D) none of above

Question 17

Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can be applied from

A) from format >> cells
B) from format >> auto format
C) from table >> auto format
D) all of above

Question 18

Which of the following format you can decide to apply or not in AutoFormat dialog box?

A) number format
B) border format
C) font format
D) all of above

Question 19

How can you remove borders applied in cells?

A) choose none on border tab of format cells
B) open the list on border tool in formatting toolbar then choose first tool (no border)
C) both of above
D) none of above

Question 20

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

A) choose required colour form patterns tab of format cells dialog box
B) choose required colour on fill colour tool in formatting toolbar
C) choose required colour on fill colour tool in drawing toolbar
D) all of above

Question 21

You can set Page Border in Excel from

A) from border tab in format cells dialog box
B) from border tool in formatting toolbar
C) from line style tool in drawing toolbar
D) you cannot set page border in excel

Question 22

When all the numbers between 0 and 100 in a range should be displayed in Red Colour, apply

A) use =if() function to format the required numbers red
B) apply conditional formatting command on format menu
C) select the cells that contain number between 0 and 100 then click red colour on text colour tool
D) all of above

Question 23

You can check the conditions against __________ when applying conditional formatting

A) cell value
B) formula
C) both of above
D) none of above

Question 24

Which of the following is not true regarding Conditional Formatting?

A) you can add more than one condition to check
B) you can set condition to look for bold and apply italics on them.
C) you can apply font, border and pattern formats that meets the specified conditions
D) you can delete any condition from conditional formatting dialog box if it is not required

Question 25

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

A) quick access tool bar
B) formula bar
C) ribbon
D) ms button