Question 1

Formatting a cell in Number format you can't set

Accepted Answer

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

Question 2

Which of the following is not true regarding Conditional Formatting?

Accepted Answer

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 
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 C

Question 3

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

Accepted Answer

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 
B)  pressing an arrow key 
C)  pressing the tab key 
D)  clicking the enter button to the formula bar A

Question 4

How can you remove borders applied in cells?

Accepted Answer

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 
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 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

What is entered by the function =today()

Accepted Answer

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 
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 10

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

Accepted Answer

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

Question 11

Can you set 0. 5 inch left indentation for a cell in Excel?

Accepted Answer

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 
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 12

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

Accepted Answer

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

Question 13

The spelling tool is placed on ______ toolbar

Accepted Answer

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

Question 14

You can group non-contiguous worksheets with

Accepted Answer

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 
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 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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 
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 17

You can set Page Border in Excel from

Accepted Answer

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 
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 18

Merge cells option can be applied from

Accepted Answer

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

Question 19

Formatting a cell in Currency, you can specify

Accepted Answer

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

Question 20

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

Accepted Answer

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 
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

Formatting a cell in Number format you can't set

Which of the following is not true regarding Conditional Formatting?

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

How can you remove borders applied in cells?

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

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

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

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

What is entered by the function =today()

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

Can you set 0. 5 inch left indentation for a cell in Excel?

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

The spelling tool is placed on ______ toolbar

You can group non-contiguous worksheets with

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

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

You can set Page Border in Excel from

Merge cells option can be applied from

Formatting a cell in Currency, you can specify

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

Microsoft Word: Shortcut Keys, Formatting, and Features

MS Word: Tools, Formatting, and Mail Merge Features

Microsoft Word and Excel FAQ

Excel and Powerpoint Functions and Shortcuts

Powerpoint Features and Functions

Powerpoint and Excel Questions and Functions

Excel Functions, What-If Analysis, and Internet Basics

Internet and Technology Terminology

Internet and Technology Terminology

Microsoft Office and Technology

Filters

Exam 4: Excel Functions and Formatting Tips

Formatting a cell in Number format you can't set

Which of the following is not true regarding Conditional Formatting?

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

How can you remove borders applied in cells?

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

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

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

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

What is entered by the function =today()

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

Can you set 0. 5 inch left indentation for a cell in Excel?

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

The spelling tool is placed on ______ toolbar

You can group non-contiguous worksheets with

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

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

You can set Page Border in Excel from

Merge cells option can be applied from

Formatting a cell in Currency, you can specify

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

Microsoft Word: Shortcut Keys, Formatting, and Features

MS Word: Tools, Formatting, and Mail Merge Features

Microsoft Word and Excel FAQ

Excel and Powerpoint Functions and Shortcuts

Powerpoint Features and Functions

Powerpoint and Excel Questions and Functions

Excel Functions, What-If Analysis, and Internet Basics

Internet and Technology Terminology

Internet and Technology Terminology

Microsoft Office and Technology

Filters