Excel

What does this button mean?

• Align the text on the borders of the page.

• Extend the content on the entire length of the cell.

• Group together the selected cells and center the content.

• None of the above

What type of chart is this?

• Doughnut

• Radar

• Bar

• Pie

If you copy the formula =$B38 into another cell, the result will be:

• The column part will remain the same

• The row part will remain the same

• Both the column and row will remain the same

• Both will change

What will be the formula in the C5 cell if you want to copy it the the cells just below?

• =$C3/B6

• =C$3/B6

• =C3/$B6

• =C3/B$6

What tool is used to split the window into different parts of the same worksheet?

• The title bar

• The scroll bar

• The toolbar

• The split box

What is the combination of keys required to come back to the top of the worksheet?

• PageUp (PgUp)

• Alt and PageUp

• CTRL and Home

• CTRL and left arrow

What key is used to select multiple ranges of cells?

• Shift

• CTRL

• Alt

• AltCar or AltGr

What key should be used to change the content of a cell?

• F1

• F2

• F3

• F4

This button represents:

• The AutoCorrect button

• The AutoFormat button

• The AutoSum button

• The conditional format button

What is the most appropriate formula you can put in the B2 cell to calculate a 7% tax? (Select all that apply)

• =A2*0.07

• =A2*7%

• =A2*1.07

• =A2+(A2*0.07)