Multiple Choice
An Excel table contains columns named Salary and Commission.Which of the following formulas uses a structural reference to add the values in the Salary column to the values in the Commission column?
A) '=[Salary]+[Commission]
B) =[Salary+Commission]
C) =(Salary) +(Commission)
D) ="Salary" + "Commission"
Correct Answer:
Verified
Correct Answer:
Verified
Q28: Your worksheet appears with a reduced view
Q30: How many actions does the Undo button
Q46: A predesigned combination of formats, such as
Q66: When a PivotTable has two levels of
Q67: Which of the following are methods you
Q68: In a PivotTable, the<u> Row </u>Labels appear
Q72: Jose inserts the formula =DATE(2021, 2, 15)
Q73: In the Scenario Manager dialog box, the
Q75: Which of the following functions are text
Q76: You can import text data into Excel