Spreadsheet

What feature was used to center the heading “The Small Bookstore”?

• Center

• Merge and center

• Merge

• Wrap text

When a Spreadsheet is printed the gridlines are not automatically printed. What feature is used to get the gridlines as seen in the Spreadsheet above?

• add gridlines

• style

• borders

• table

What cell alignment feature is used so that the text looks like this?

• Merge and center

• Center

• Wrap Text

• Alignment

If the table is sorted in Ascending order by Classification, state the title of the book that will appear at the top from the list given below

• In Touch with God

• Eagle and the Falcon

• The Dark Side

• Outer Plant Experience

Besides being in the home tab, identify another tab in which the Sort option be found.

• Data

• Insert

• View

• Review

What is the number format of the values in the column Unit cost?

• text

• currency

• number

• two decimal places

What is the format of the content in the column, "Title"?

• text

• currency

• number

• accounting

What is the formula in Excel to calculate the Total cost of the book entitled Apocalypse using relative cell referencing?

• 24 * $51.00 =

• = 24 * $51.00

• E5 * F5 =

• =E5 * F5

• = E5 x F5

Type the formula in Excel to calculate the Total number of copies sold by the author James Brown. Use CAPS lock when typing your answer.

Select the ways in which data can be sorted (multiple answers)

• Ascending

• Descending

• Filter

• Custom