Working with Multiple Worksheets and Workbooks

Question 1

Which external reference is formatted correctly?

Revolt · Accepted Answer

=‘[My_Sales.xlsx]Quarter1’!$C$12

Question 2

colorformulafunction✔ worksheet

Revolt · Accepted Answer

✔ worksheet

Question 3

EnterEsc + Enter Shift + Enter✔ Ctrl + Enter

Revolt · Accepted Answer

✔ Ctrl + Enter

Question 4

What are the steps for grouping worksheets in a workbook?

Revolt · Accepted Answer

✔ bottom; Click on the first worksheet’s tab at the of the open workbook.: bottom; Then, select all the open tabs by holding down the key and select the last worksheet, OR select individual sheets by holding the key and clicking the sheets you wish to group.: Shift; Then, select all the open tabs by holding down the key and select the last worksheet, OR select individual sheets by holding the key and clicking the sheets you wish to group.: Ctrl

Question 5

✔ ShiftCtrlTabEnter

Revolt · Accepted Answer

✔ Shift

Question 6

TabEnterShift✔ Ctrl

Revolt · Accepted Answer

✔ Ctrl

Question 7

What are the steps for inserting a 3-D reference?

Revolt · Accepted Answer

Complete the formula by pressing these two buttons: and .: Ctrl; Complete the formula by pressing these two buttons: and .: Enter

Question 8

Alt✔ CtrlEscShift

Revolt · Accepted Answer

✔ Ctrl

Question 9

Alt✔ EnterEscShift

Revolt · Accepted Answer

✔ Enter

Question 10

What are the steps for inserting an internal link?

Revolt · Accepted Answer

✔ =; Type into a cell.: =; Then, select the that includes the cell you wish to link to.: worksheet; Finally, press .: Ctrl + Enter

Working with Multiple Worksheets and Workbooks Answers

More from this Course

TRY EDGENUITY HACKS