Excel Intermediate Test 2

The intersection of a row and a column is called a ________.

• cell

• chart

• sum

• worksheet

A group of cells is called a ________.

• chart

• cell cluster

• multicell

• cell range

You can click the tabs at the bottom of a workbook to switch between ________.

• permissions

• worksheets

• formulas

• number formats

True or False: You can use the function of daily changeable date by using the Following function =now()

• True

• False

Which of the formulas below are valid? Select all that apply.

• =R2*D2

• A3+100

• =5B+6B

• =F2+F3+F4-53

What are the shortcut keys for Printing?

• ALT and S

• CTRL and P

• ALT and =

• CTRL and =

You can link 2 sheets in the same Excel sheet or Outside the Excel sheet file by using the Following Function.

• Pivot Table

• Hyperlinks

• =Now()

• Data Validation

What are the keyboard shortcut keys to edit formula in a cell?

• F2

• F4

• CTRL + 1

• CTRL + F

What are the keyboard shortcut keys to create a table?

• ALT + T

• ALT + N + C

• ALT + N + V

• ALT + N + T

If you want to Merge and Center the Cell, you can select the relevant function below:-

• Center

• Merge & Center

• Bold

• Underline