ICT Spreadsheet Essentials - Practice Test A

Jermaine has started an inventory spreadsheet for all of the items in the school store. He is unsure of any of the individual item costs, so he will set all of them at zero and input the correct data later. How would the cost of each item be displayed if he has formatted the cost field as US currency?

• 0

• 0.00$

• 0.00

• $0.00

Study the chart. Which type of chart is shown?

• Line chart

• Pie chart

• Bar chart

• Column chart

What is a spreadsheet?

• A document that displays text within defined margins

• A document that stores images for use in other documents

• A document that stores audio/video files for use in other documents

• A document that stores data in a grid of horizontal rows and vertical columns

Study the image. Which function is calculating the value in cell B6?

• =TOTAL(B2:B5)

• =SUM(B2:B5)

• =AVERAGE(B2:B5)

• =COUNT(B2:B5)

James needs to select multiple cells that are directly next to one another. Identify which key James should press and hold that will allow him to select multiple adjacent cells at once.

• shift

• backspace

• enter

• F1

Rows within a spreadsheet are identified by:

• numbers.

• Roman numerals.

• icons.

• letters.

Rosalind needs to undo a change she just made in her spreadsheet. Which toolbar button should she use?

• 
• 
• 
• 

Consider this entry in a spreadsheet cell:

December 25, 2015

This entry is an example of which data format?

• time format

• currency format

• date format

• percent format

When you insert a column in a spreadsheet, where does the new column appear?

• Immediately to the left of the current selected column

• As the first column in the spreadsheet

• As the last column in the spreadsheet

• Immediately to the right of the current selected column

Bernard is creating an inventory of his comic book collection. He has documented the title, publisher name, production year, and series number for each comic in his collection. He creates a spreadsheet of this information. Typically, each one of these categories, such as production year, would be contained in:

• a column.

• a formula bar.

• a cell.

• a row.