MGMT 2303-Spreadsheets

which of the following two methods allow a user to move the data in cell to another cell?

-Drag the data to the desired cell since the drag-hand is already showing -Right-click the cell and then cut and paste the data into the desired cell

The active cell in a spreadsheet is the cell into which the user can input data. In most spreadsheet programs the active cell can be identified by which of the following items?

-Name box (in the upper left corner of the sheet) -Heavy border -Highlighted column and row headings

Put the steps in order for converting an iCloud Numbers file to an Excel file.

1. Click the tools button 2. Select download a copy and choose a format 3. Name the file 4. Save the file

Place the steps for saving a spreadsheet file in Excel, Numbers, and Calc in correct order,

1. Open the File menu 2. Name the file 3. Determine where the file shall be stored 4. Select save (or save as)

You need to add elements to your chart in Excel. Place the following steps in order with the first step at the top.

1. Select the chart (by clicking on it) 2. If not already open, select the design tab 3. open the add chart element menu 4. add the desired elements

Steps to create VLookup

1. select the name and range of cell for the vlookup to search 2. click the insert function button 3. search for and select the vlookup button 4. enter the necessary arguments 5. click OK

You made a simple spreadsheet for an online class assignment for a group project and want all group members to be able to open it regardless of what spreadsheet program they use. Which format would be the best to use?

CSV Reason: The CSV (comma-separated values) format can be opened with any spreadsheet program. Remember that styles and formulas are not saved with .csv files.

If you see the Apache OpenOffice icon on your desktop, you know that there probably is spreadsheet software on the computer. The spreadsheet program in OpenOffice is called __.

Calc

To quickly show if the values in a column or row are greater than, less than, or equal to a certain value, use the ____ function

IF

The formula above multiplies the value in C5 times the value in C8. Why are there dollar signs in the C8 notation?

It is an absolute reference

Which 3 of the following arguments are usually entered when using the PMT function?

Nper Rate Pv

If you are using OpenOffice Calc and wish to send your spreadsheet to a colleague who uses Microsoft Excel, use the ___ feature.

Save As

You created a spreadsheet in Calc and wish to send the data to a friend who only uses Excel. You can do this by using the ___ feature.

Save As

Saving a spreadsheet allows you to keep your file for future use. One difference between Microsoft Excel, Google Sheets, Apple Numbers, and Open Office Calc is that ___ saves changes automatically.

Sheets

A spreadsheet created in Google Sheets can be downloaded as a Microsoft Excel file (.xlsx).

True

There are various pointer functions included with most spreadsheet programs. It is important to check on the style of the pointer to ensure you are executing the correct command.

True

True or False? A spreadsheet created in Google Sheets can be downloaded as a Microsoft Excel file (.xlsx).

True

In Numbers (above) the freeze options are located under the Table tab. In Microsoft Excel and Google sheets the freeze cells or panes options are found in the:

View

To make a calculation always refer to a specific cell when copying it using the fill handle, make the cell a(n) ______ reference

absolute

In spreadsheets all functions and calculations begin with __.

an equals sign (=)

In most spreadsheet programs the active cell is shown with a thick black border. In Google Sheets (as shown above), the active cell has a thin _______ colored border.

blue

The basic unit of any spreadsheet, essentially a box where data can be entered, is called a(n) ___.

cell Reason: A cell is identified by its cell reference which is a letter/number combination.

Labels

do not interact with other cells. A label is used to assist users in identifying data in a spreadsheet.

If you wish to keep a column visible while you scroll through the rest of a spreadsheet file, you can use the ___ options.

freeze

#VALUE!

means that the operation or function that is entered in the cell is not possible.

Values

reflect the belief that certain actions or behaviors are preferable to others

________ clicking on the row heading for row 3 and selecting Insert will put a blank row above row 3. Multiple choice question.

right

To insert a column to the left of column D, select column D and then ___ and select insert.

right-click

Holding down the ___ allows users to select a range of adjoining cells

shift

There are various pointer functions included with most spreadsheet programs. It is important to check on the style of the pointer to ensure you are executing the correct command.

true

The IF function uses logical tests. A logical test is any value that can be evaluated as:

true or false

Many businesses send data such as product, customer, and orders information between different offices. Since these data do not include any formulas or styling it is commonly sent as a CSV file. CSV stands for comma-separated ______

value