Unit 4 Lesson 1 (Part 2): Excel Tabs and Ribbons

Question 1

Parts of Excel Tab and Ribbons:

-shows tools for opening an existing workbook, creating a new workbook, saving a workbook, printing a workbook, and other functional tools that are not necessarily connected to data manipulation or formatting

Answer 1

File Tab

Question 2

Parts of Excel Tab and Ribbons:

-gives you tools to format your table and its data You can change the font size, font color, alignment, and other basic formatting options

-you can also copy, paste, insert,
and delete cells using the tools in this tab

Answer 2

Home Tab

Question 3

Parts of Excel Tab and Ribbons:

-gives you tools to insert objects such as images, shapes, tables, graphs, and charts

-there are predefined templates available for graphs and charts that can be found on this tab

Answer 3

Insert Tab

Question 4

Parts of Excel Tab and Ribbons:

• gives you tools so that you can draw flexibly on your table or charts when discussing it

-It contains different drawing tools such as pen tool, eraser tool, highlighter, and lasso selection tool

Answer 4

Draw Tab

Question 5

Parts of Excel Tab and Ribbons:

• gives you tools and commands to format the orientation of your
  spreadsheet on the screen and the paper after printing

-these tools allow you to edit the print area, margins, colors, etc

Answer 5

Page Layout Tab

Question 6

Parts of Excel Tab and Ribbons:

-gives you commands to edit, define, audit, and control formulas.

-you can easily find functions and formulas here because they are grouped depending on the use

Answer 6

Formulas Tab

Question 7

Parts of Excel Tab and Ribbons:

• gives you commands to connect to external data or databases to import pre-existing data tables

-there are also commands that can help you sort data; this is
particularly useful for large data sets

Answer 7

Data Tab

Question 8

Parts of Excel Tab and Ribbons:

• gives you tools and commands for spell checking, sheet protection, workbook protection, and changes tracking
• helps you to protect the data and check the accuracy of
  the input in your spreadsheet through proofreading

Answer 8

Review Tab

Question 9

Parts of Excel Tab and Ribbons:

gives you commands to control the view of your spreadsheet and how you would interact with it

Answer 9

View Tab