ICT Spreadsheet Essentials - Lesson 1 (Part 2)

Maria is inputting a birthday into a cell for a spreadsheet about her friends and family. She types in:

May 7, 1975

What is the default display for this date in most popular spreadsheet programs?

• May-7-1975

• 5-7-1975

• 7-May-75

• 7 May 1975

Which example shows a number formatted with two decimal places within a spreadsheet?

• 00.1

• 10/5/2014

• 21.00

• 10.0

Study the image.

FIGURE: A

Which example shows a number formatted as text by entering a single quote at the start of the cell value?

• Row 3

• Row 2

• Row 5

• Row 4

Which example is a spreadsheet date format?

• April

• 4

• 2012

• 4/4/2012

Which example is a spreadsheet time format?

• Noon

• 12:34:45

• 12 hours, 34 minutes

• 12pm

Consider the following entry in a spreadsheet cell:

December 25, 2015

This entry is an example of which data format?

• The date format

• The percent format

• The time format

• The currency format

Which of the following examples has been formatted as a time in the active cell?

• Five Forty-Five AM

• 5:45:00 AM

• $5.45

• 5.45%

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.

• BACKSPACE

• ENTER

• F1

• SHIFT

Identify the keyboard shortcut that will allow a user to copy data within a cell.

• CTRL + A

• CTRL + C

• CTRL + X

• CTRL + V

You have entered a date function in a cell. Now you want to change the format to display the day of the week rather than the date, month and year. In what part of a spreadsheet can you display the function in order to make the necessary changes?

• The column header

• The formula bar

• The shortcut toolbar

• The row header