SJI5-ICT:WORKSHEETS

What type of data is used for identification or categorization, but not for calculations?

• Formula

• Label

• Value

• Function

Which of the following is an example of a Value in a worksheet?

• Address

• Name

• Test scores

• Phone number

In a worksheet, which of the following is an example of a Formula?

• 12345

• Address, City

• =SUM(A1,B1)

• Grade Level

A formula that calculates the total sum of values from cells A1 to A5 would look like:

• =SUM(A1)

• =SUM(A1)

• =AVERAGE(A1)

• =A1+A5

What does the AVERAGE function do in a worksheet?

• Finds the maximum value in a range of cells

• Calculates the total of the numbers

• Adds all values and divides by the count of numbers

• Displays text data

How do you change the font of a selected cell or range of cells?

• Right-click the cell and choose Font

• Click the Home Tab, then go to the Font group and select from the Font drop-down arrow

• Use the Insert Tab and click Font

• Double-click the cell and choose Font size

Where can you change the font size of text in a worksheet?

• In the Font group under the Home Tab

• In the Formula Bar

• In the Page Layout Tab

• Under the Insert Tab

What is the function of the Bold option in the Font group?

• Changes the text to italicized

• Makes the text bold and thicker

• Underlines the text

• Changes the color of the text

If you want to make a cell’s content italicized, which option do you use?

• Underline

• Bold

• Italic

• Font Size

If you want to make a cell’s content italicized, which option do you use?

• Underline

• Bold

• Italic

• Font Size