Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

54. What name does Excel automatically assign to a new workoook that you open? O Bookt Sheet1 O Workbook O Worksheet1 55. Which of the

image text in transcribed

54. What name does Excel automatically assign to a new workoook that you open? O Bookt Sheet1 O Workbook O Worksheet1 55. Which of the following is not a true statement? All workbooks must be open when you use the Consolidate command. Link workbooks using the Consolidate command. Link workbooks building formulas that refer to cells in other workbooks When you use the point method to create an external reference, it is built with mixed references. 56. Which of the following chart elements provides a vertical background for a 3D chart? O Chart area O Chart floor O Chart wall O Gridline 57. Which of the following functions adds cell values together and divides the total of the values by the number of values? O AVERAGE O COUNT O MAX MIN 58. Which of the following is true about inserting and deleting columns? When you insert a column, Excel moves existing data to make room for new data. When you insert a row, functions or formulas are automatically updated When you insert a row or column, functions and O formulas reflect deleted rows or columns in the argument or range. All of the above 59. What would you call a table added to the bottom of your chart that contains the values of each data series? O trendine O data label O data table source data

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

978-0077431808

More Books

Students also viewed these Accounting questions