SP-Lesson 1 Certification Questions

What is the most efficient way to access multiple worksheets in the same spreadsheet file?

• Open multiple copies of the spreadsheet file and display a different worksheet in each copy of the file.

• Select New Worksheet to access the worksheet you want to view.

• Create a named custom view and open it for each sheet.

• Click the tab at the bottom of the file that represents the worksheet you want to view.

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

• 
• 
• 
• 

Harold is working on a science project that includes a spreadsheet containing calculated results based on the data. An obviously incorrect result is being calculated and displayed. The data is correct, but the formula must be flawed. To get the correct information, Harold clicks on the cell containing the incorrect results and adjusts information contained in the:

• the formula bar

• the shortcut toolbar

• the calculator pop-up

• the column header

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 row

• a cell

• a formula bar

• a column

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

Kara has selected the cell range A1:D8 in the worksheet shown. Which option would allow Kara to sort the data in alphabetical order according to the employees' first names?

• Sort by: Column A, A to Z

• Sort by: Column B, A to Z

• Sort by: Column B, Z to A

• Sort by: Column C, Z to A

Which toolbar button is used to format cell data to a currency value?

• 
• 
• 
• 

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.

• F1

• SHIFT

• BACKSPACE

• ENTER

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?

• 7 May 1975

• May-7-1975

• 5-7-1975

• 7-May-75

Horatio has made a mistake with his spreadsheet. He has accidentally deleted the data in a cell. How would you describe the button that he could click on the toolbar to undo this mistake?

• A bold letter B

• A forward-pointing arrow

• A backward-pointing arrow

• A paint brush or roller