Lesson 1: Familiarizing with Spreadsheet Application

Question 1

A spreadsheet software used to input and analyze data. It contains grids where you
can place values.

Answer 1

Excel

Question 2

The document when you open Excel.

Answer 2

Workbook

Question 3

The portion of your document.

Answer 3

Spreadsheet

Question 4

Works as your normal arithmetic operation but you need to place an equal sign (=) before performing any operation between two or more values.

Answer 4

Formulas

Question 5

Are specialized operations with assigned names that use predefined formulas and return a value

Answer 5

Functions

Question 6

Is a rectangular box where you can input your values. Each one
can contain texts, numbers, images, or formulas.

Answer 6

Cell

Question 7

Shows the number in a row of the currently selected cell. These numbers are arranged in numeric order.

Answer 7

Row Number

Question 8

Shows the letter in a column of the currently selected cell. These letters are in alphabetical order from A-Z and will have a combination afterwards such as AA, AB, AC, and so on.

Answer 8

Column Letter

Question 9

Shows the cell currently selected if you are selecting only one cell. It also shows
the number of rows and columns if you are trying to select a big portion of your document which contains several cells.

Answer 9

Name Box

Question 10

Is the long rectangle beside the name box where you can input your formulas for your data. You can also use this to input a value in a cell.

Answer 10

Formula Bar

Question 11

Is found on the top of the grid in Excel. You can find different buttons and tools to edit and customize your data.

Answer 11

Ribbon

Question 12

Allows you to access frequently used tools such as save, undo, and redo.

Answer 12

Quick Access Toolbar

Question 13

Also known as sheets, is where you can select a different sheet to look at its contents.

Answer 13

Spreadsheet Tab

Question 14

Shows different information about the document. You can set the layout of how you like your spreadsheet to appear on your screen.

Answer 14

Status Bar

Question 15

Show 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 15

File Tab

Question 16

Gives you tools to format your table and it’s data. You can change the font size, font color, alignment, and other basic formatting tools. You can also copy paste insert and deletes using the tools in this tab.

Answer 16

Home Tab

Question 17

Gives you tools to insert certain 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 17

Insert Tab

Question 18

Gives you tool so you can draw flexibly on your table or charts when discussing it. It contains different drawing tools such as a pen tool, eraser tool, highlighter, and lasso selection tool.

Answer 18

Draw Tab

Question 19

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 19

Page Layout Tab

Question 20

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 20

Formulas Tab

Question 21

Gives you commands to connect to external data or databases to import pre-existing data tables.

Answer 21

Data Tab

Question 22

Gives you tools and commands for spell checking, sheet protection, workbook
protection, and changes tracking.

Answer 22

Review Tab

Question 23

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

Answer 23

View Tab