MS EXCEL - BCST

1. How do you edit data in a cell? (Select 2)

• 1. First run a spell check

• 1. Press the F3 key

• 1. Increase the column width

• 1. Double click the cell

1. If you are on cell A5 and want to edit cell D10 to make it bold, what is the first thing you do?

• 1. Click the B button on the ribbon.

• Click the font dialog box launcher and then click bold.

• 1. Select cell D10

• 1. Click the font button

1. All formulas and functions in Excel begin with what character?

• 1. Either the plus sign or the equal sign

• 1. The equal sign

• 1. Any mathematical operator such as the plus sign

• 1. None of the above

1. Which option will allow you to choose the background color of a cell? 

• Format painter

• Fill Color

• Font Color

• Borders

Using only one click, which number format option was used here

• Percent Style

• Comma Style

• Accounting Number Format

• Decrease Font Size

1. The Clear Contents command

• 1. Clears cell formats and leaves the contents

• 1. Clears contents and leaves cell formats

• 1. Clears cell formats and contents

• 1. Clears borders

1. What button would you click on to change the format of a date? (Select 2)

• 1. The Number Format option on the ribbon.

• 1. The dialog box launcher in the Number group. 

• 1. The date button on the ribbon

What is the symbol for additions in MS Excel?

What is the symbol for subtractions in MS Excel?

What is the symbol for multiplications in MS Excel?