Font size
WorksheetsSpreadsheet
Total questions: 12
Worksheet time: 3mins
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.
(a)
Select the ways in which data can be sorted (multiple answers)
Ascending
Descending
Filter
Custom
Sorting by Classification THEN by Title is a ..................
single column sort
multi column sort
custom sort
none of the above
Select the options that are TRUE of a formula in excel
A formula ends with an equal sign
A formula contanis arguments called cell address/es
A formula contains mathematical operators
A formula can be copied to many/other cells
