Options: a. When you use multiplication, division or exponentiation in a formula b. When you use addition and subtraction in a formula c. Because Excel uses hidden decimal places in computation d. When you show the results of formulas with different decimal places than the calculated results
To copy formatting from one area in a worksheet and apply it to another area you would use:
Options: a. The Edit>Copy Format and Edit>Paste Format commands form the menu. b. The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu. c. There is no way to copy and apply formatting in Excel â€“ You have to do it manually d. The Format Painter button on the standard toolbar
Data System management has long-term viability as a separate business function because
Options: It requires much technical knowledge, It requires large investments, Specialists in data systems cannot be integrated into a marketing or manufacturing organization, An integrated database accessible to all requires independent management
You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .
. How should you print a selected area of a worksheet, if youâ€™ll want to print a different area next time?
Options: a. On the file menu, point to print area, and then click set print area. b. On the file menu, click print, and then click selection under print what c. On the view menu, click custom views, then click add d. All of above