Question

QUESTION 6 Which of the following is a predefined set of formatting choices that can be...

QUESTION 6

  1. 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

  1. How many cells are included in the range A1:B3?

    1.

    2

    2.

    4

    3.

    6

    4.

    9

5 points   

QUESTION 8

  1. 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

  1. 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

  1. 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

  1. 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

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
QUESTION 6 Which of the following is a predefined set of formatting choices that can be...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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 tex

    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...

    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 +...

    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...

    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...

    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 ...

    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"...

    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...

    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....

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT