Only show me the Answers. No steps.
QUESTION 41
By default, Microsoft Excel 2016 displays pages ready to print in the landscape orientation.
True
False
1.5 points
QUESTION 42
Which of the following can you do to edit cell contents directly in a cell?
a. |
?Right-click the cell, and select format. |
|
b. |
?Select the cell, and press the F1 key. |
|
c. |
?Double-click the cell. |
|
d. |
?Drag the cell down to the sheet tab. |
1.5 points
QUESTION 43
Which of the following happens if you choose to wrap text within a cell?
a. |
?The cells next to the cell with text in it merge to fit the text. |
|
b. |
?The text font decreases to fit within the cell. |
|
c. |
?The column width increases as needed to fit the text. |
|
d. |
?The row height increases as needed to fit the text. |
1.5 points
QUESTION 44
To copy rather than move a sheet, press and hold the_____ as you drag and drop the sheet tab.
a. |
?Alt key |
|
b. |
?Ctrl key |
|
c. |
?Tab key |
|
d. |
?Shift key |
1.5 points
QUESTION 45
Which of the following allows you to cancel the changes you made while editing a cell?
a. |
?Selecting the cell and using the Remove Duplicates command |
|
b. |
?Selecting the cell and using the Delete cells command |
|
c. |
?Pressing the Insert key while editing the cell |
|
d. |
?Pressing the Esc key while editing the cell |
1.5 points
QUESTION 46
Which of the following happens when you rename a sheet from Sheet1 to Inventory?
a. |
?The sheet name is cut off and replaced with "…". |
|
b. |
?A ScreenTip appears asking the user to enter an alphanumeric name. |
|
c. |
?A new sheet is created instead of renaming the current sheet. |
|
d. |
?The sheet tab extends to accommodate the new sheet name. |
1.5 points
QUESTION 47
In Excel, _____ are actually numbers that are formatted to appear as text.
a. |
?equations |
|
b. |
?decimals |
|
c. |
?formulas |
|
d. |
?dates |
1.5 points
QUESTION 48
A pixel is a single point, or the smallest colorable area, on a computer monitor or printout.
True
False
1.5 points
QUESTION 49
Every Excel formula:
a. |
?begins with the appropriate operator for the formula. |
|
b. |
?can only return data in the form of text or dates. |
|
c. |
?begins with an equal sign followed by an expression. |
|
d. |
?can only return numerical data as a result. |
1.5 points
QUESTION 50
One of the ways to get more characters to fit into a cell is by:
a. |
?reducing the font size. |
|
b. |
?increasing the row height of the cell. |
|
c. |
?dragging the left-hand side border of the cell. |
|
d. |
?using the Cell Styles button on the Home tab to specify cell width. |
IMPORTANT:- AS "Only show me the Answers. No steps." HAS BEEN STATED SPECIFICALLY NO EXPLAINATION IS PROVIDED
ANSWER 41:- True
ANSWER 42:- Option C. Double click the cell
ANSWER 43:- Option B. The text font decreases to fit within the cell.
ANSWER 44:- Option B. Ctrl key.
? |
Only show me the Answers. No steps. QUESTION 41 By default, Microsoft Excel 2016 displays pages...
Data File needed for this Case Problem: Green.xlsx 0 Green Clean Homes Sean Patel is developing a business plan for Green Clean Homes, a new professional home cleaning service in Toledo, Ohio. As part of his business plan, Sean needs to predict the company's annual income and expenses. You will help him finalize and format the Excel workbook containing the projected income statement. Complete the following 1. Open the Green workbook located in the Excel2 >Case1 folder, and then save...
NOTE PLEASE ALL ANSWERS MUST BE IN EXCEL FORMULA. X 5 ? X . HOME Calculating yield to maturity - Excel FORMULAS DATA REVIEW - Sign In FILE INSERT PAGE LAYOUT VIEW Paste B I U- - - A Alignment Number 8.12 oints Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font Skipped D17 А в E F G H I к eBook Print A Japanese company has a bond outstanding that sells for 91.53 percent of...
MUST SHOW CORRECT EXCEL FORMULAS. ONLY ANSWER HIGHLIGHTED PORTIONS. XUR 5 + Calculating NPV - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign in Calibri 11 - A A 23 Paste BIU E! - A % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font . A1 fx A B C D E F G H 1 2 Quad Enterprises is considering a new three-year expansion project that requires an initial fixed...
Please do it in Excel and show all the steps for the five questions. Also, number each question. eKhaleesi") leases dragonglass weapons to customers. She gains a loyal ause dragong lass is of limited supply but high demand due to its tollowing of customers bec usefulness for the upcoming winter. Further, Khaleesi tends to offer more terms than competitors offering substitutive products (e.g.. Lannister, C favorable financing was recently approached by the Lords of the North, Inc. "the North") which...
3 Ratio Analysis: Using Excel for key performance indicators (KPIs) 5 The Boring Company has data for the four divisions for the year, and wants the results for the three specified key performance Indicators (KPIs). Return on Investment Profit Margin Ratio Asset Turnover Ratio (ROI $ 7 Division 8 East 9 North 10 South 11 West Operating Income 1.580,000.00 650,000.00 225.050.00 2,300,000.00 Average Total Assets $ 12.000.750.00 4,875,000.00 995.090.00 13,800,000.00 Net Sales 25.900.000,00 6,337,500.00 855.720.00 9,200,000.00 13 Requirements 15 16...
Can you solve the question CE 4-3. do not need to do #g & h. CE4-2. Create a new workbook and take the following actions: a. Name and save your workbook using your own choosing b. Enter the value This is the content of cell C7 into cell C7. a name of c. Use F2 to change the value in cell C7 to This is part of the content of cell C7 d. Add the value January to cells B2...
I am horrible at inputting formulas into excel. Please help me with the formulas. JPL, Inc. has provided its sales and expense data for the most recent period. The Controller has asked you prepare a spreadsheet that shows the related CVP Analysis computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. points • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel...
2 Use Excel to find the following confidence intervals 110points total The feollowing data show the namber of paid vacation days for a random sample of 20 employees from PSU A1 a) Find the 95% confidence interval fr the average number of vacation days. (2 points for output. I point fr ower limit, I point for upper limit Copy the data below your name in cell A3 in Excel. Select the tab labeled Duta, then select Data Analysis If your...
Chapter 10 Excel Saved Help Save & Exit Submit Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel's Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. 10 points (8 02:46:24 eBook Print References • Cell Reference: Allows you to refer to data from another...
Can someone help me solve 1 and 2? SE Homework 3 - Excel Sign in - o X Share File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Calibri On General General B D - X AutoSum" A - 11 D- O AA === A ESS ab Wrap Text Merge & Center - Cut LE Copy Format Painter Clipboard Fill ZIU Paste B IU , $ - % , 809 Insert Delete...