Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1. Which of the following CANNOT be used to add another spreadsheet to a workboo

ID: 3680166 • Letter: 1

Question

1. Which of the following CANNOT be used to add another spreadsheet to a workbook?

On the insert ribbon, add a table

In the cell area of the home ribbon, insert pulldown and insert sheet.

On the tab area at the bottom of the worksheet, right click a sheet tab and insert.

2.The SIN, COS, and TAN functions in Excel all use angle argument in RADIANs. What would NOT work to use these functions if you had degrees in cell C4?

Convert the cell C4 in degrees to radians in another intermediate cell, such as D4, using RADIANS or Pi/180, and then have a third cell =SIN(D4)

Calculate the degrees to Radians multiplying angle by 1 with (Pi Radians/180 degrees) so that degrees cancel leaving radians, such as =SIN(C4*(PI()/180))

Put comma degrees in the argument, such as =SIN(C4,Degrees)

Convert the degrees to Radians using RADIANS(), such as =SIN(RADIANS(C4))

On the tab area at the bottom of the worksheet, click the last (unnamed) sheet tab

1. Which of the following CANNOT be used to add another spreadsheet to a workbook?

:
Answers: a.

On the insert ribbon, add a table

b.

In the cell area of the home ribbon, insert pulldown and insert sheet.

c.

On the tab area at the bottom of the worksheet, right click a sheet tab and insert.

2.The SIN, COS, and TAN functions in Excel all use angle argument in RADIANs. What would NOT work to use these functions if you had degrees in cell C4?

Answers: a.

Convert the cell C4 in degrees to radians in another intermediate cell, such as D4, using RADIANS or Pi/180, and then have a third cell =SIN(D4)

b.

Calculate the degrees to Radians multiplying angle by 1 with (Pi Radians/180 degrees) so that degrees cancel leaving radians, such as =SIN(C4*(PI()/180))

c.

Put comma degrees in the argument, such as =SIN(C4,Degrees)

d.

Convert the degrees to Radians using RADIANS(), such as =SIN(RADIANS(C4))

d.

On the tab area at the bottom of the worksheet, click the last (unnamed) sheet tab

Explanation / Answer

1. Which of the following CANNOT be used to add another spreadsheet to a workbook?

a. On the insert ribbon, add a table

2.The SIN, COS, and TAN functions in Excel all use angle argument in RADIANs. What would NOT work to use these functions if you had degrees in cell C4?

c. Put comma degrees in the argument, such as =SIN(C4,Degrees)