QUESTION 6
Which of the following is a predefined set of formatting choices that can be applied to an entire workbook in one simple step?
1. |
Theme |
|
2. |
Screenshot |
|
3. |
AutoFormat |
|
4. |
SmartArt |
5 points
QUESTION 7
How many cells are included in the range A1:B3?
1. |
2 |
|
2. |
4 |
|
3. |
6 |
|
4. |
9 |
5 points
QUESTION 8
What is the name of the square in the lower-right corner of a selection that is used to copy cells?
1. |
Copy handle |
|
2. |
Range handle |
|
3. |
Fill handle |
|
4. |
Replicate handle |
5 points
QUESTION 9
Which of the following workbook views opens the header and footer areas, as well as margin areas and rulers?
1. |
Normal view |
|
2. |
Page layout view |
|
3. |
Page break view |
|
4. |
Custom view |
5 points
QUESTION 10
Which of the following displays when you point to different areas in a chart and identifies the chart element that will be affected by your action?
1. |
Mini toolbar |
|
2. |
Context menu |
|
3. |
ScreenTip |
|
4. |
Value label |
5 points
QUESTION 11
Information in a database is typically stored in this, which consists of vertical columns and horizontal rows.
1. |
Field |
|
2. |
Record |
|
3. |
Table |
|
4. |
File |
Answer 6. 1 Theme
Theme is a predefined set of formatting choices that can be applied to an entire workbook
Answer 7. 3 6 cells
A1, A2, A3, B1, B2, B3
Answer 8. 3 Fill Handle
The fill handle appears as a small square in the bottom-right corner of the selected cell.
Answer 9. 2 Page layout view
Page layout view opens the header and footer areas, as well as margin areas and rulers
QUESTION 6 Which of the following is a predefined set of formatting choices that can be...
You are the systems manager for Blue City Movies Rentals and you have been asked to create a report on historical sales data. To complete your task you will combine and edit data from multiple sources using Excel’s Power add-ins, XML, and text functions.Instructions:For the purpose of grading the project you are required to perform the following tasks:StepInstructionsPoints Possible1Open e10c2MovieRentals.xlsx and save the workbook with the name e10c2MovieRentals_LastFirst.02Import the movie data from the delimited file e10c2Movies.txt and rename the new worksheet Inventory.Hint: On the Data tab,...
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...
Question 3 (2 points) Which of the following statements accurately describes the following reaction? Peptides + Dipeptides Perles Dipepidares > Free amino acids A-A-A A-A A A А A A Enzymatic digestion of proteins in the stomach by enzymes secreted by the pancreas Enzymatic digestion of proteins in the stomach by enzymes such as pepsin Enzymatic digestion of proteins in the small intestine by the enzyme trypsin secreted by the pancreas O two of the choices are correct none of...
Which of the following statements about Excel is Correct? We should copy numbers rather than formulas It's a good idea to put actual numbers in the cells Check cell references before copying It's useless to check the copied cells to make sure formulas are correctly setup. Question 5 (1 point) Which of the following copies formulas to all the cells below till the last cell? Drag None Ctri+C and Ctri+V Drop down Question 6 (1 point) In Excel spreadsheet, the...
Microsoft Excel Question Which of the following 4 options is the correct answer for this question ? How does the SUM function handle cells that do not contain a number? Excel treats text cell values as 1. If there are no numbers in the SUM range, Excel displays an error message. Excel doesn't let you enter a SUM function if the range contains any nonnumerical values. Excel displays an error if any of the cells in the SUM range contain...
PLEASE HELP!!!!
1) CONDITIONAL FORMATTING - Add conditional formatting to the
Hours Worked field data so that any hours worked greater
than 8 will show in white font with a dark fill.
2) DATABASE FUNCTION - Create a database function in cell E5
that calculates the average hours worked by males in Dept. No. 2.
If criteria are needed, start in cell E1.
3) VLOOKUP - In the Department field (column D) use the
VLOOKUP function to place the appropriate...
I have completed these but wanting to compare such as Question 14. Is the word "Total" added in the row or written as "Average" or "Total Average" Also Question 8 is not clear what fill color. Is it supposed to stay as blue and just select gradient fill? Very unclear questions. Thank you. Question: EX16_XL_VOL1_GRADER_CAP_AS – Travel Vacations 1.4 ( Excel, Chapter 4) Project Description: 1 Start Excel. Download and open the file named exploring_ecap_grader_a1.xlsx. 2 On the DC worksheet,...
Can someone help me on part 1
Course Madules: PV 2019 SUM X Practice Set: Module 01 Account Classificati x V 2019 SUMMR ACC111 Practice Set Instructio Practice Set James Regal, Esquire is an Attorney and has formed his own law fim, Regal Law Firm. You have been hired by James as his bookkeeper. After talking to James, you prepare his chart of accounts, which is below. Regal Law Firm Chart of Accounts Accoun Name Cash AGCOums Rccoiveble 201 Accounts...
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...
In this project, you will work with sales data from Top’t Corn, a popcorn company with an online store, multiple food trucks, and two retail stores. You will begin by inserting a new worksheet and entering sales data for the four food truck locations, formatting the data, and calculating totals. You will create a pie chart to represent the total units sold by location and a column chart to represent sales by popcorn type. You will format the charts, and...