COMPUTER

Question 1

A computerized worksheet.
- It has the standard feature of an electronic spreadsheet.
- It can also organize information such as inventory, work schedules, projects, invoices, and address lists

Answer 1

Ms Excel

Question 2

• A single sheet within a workbook or onscreen spreadsheet.

Answer 2

Work Sheet

Question 3

• It is a file that contains one or more worksheets.

Answer 3

Workbook

Question 4

– are horizontal lines in the worksheet. Represents a number (“1 to 1048576”)

Answer 4

Rows

Question 5

are vertical lines in the worksheet. Represents a letter. (“A to XFD”)

Answer 5

Columns

Question 6

the basic unit of a worksheet into which you enter data in Excel.

Answer 6

Cell

Question 7

– shows the cell reference of the active cell and can also be used to assign names to cells or ranges of cells.

Answer 7

Name Box

Question 8

is the area where you can enter or edit text or formulas.

Answer 8

FORMULA BAR

Question 9

it contains the commands organized in three components:

Answer 9

Ribbon

Question 10

allows you to easily go to the top and bottom, left or right of the worksheet.

Answer 10

Scroll Bar

Question 11

provides access to the most common Excel commands including SAVE, UNDO, REPEAT, and COPY.

Answer 11

Quick Access Toolbar

Question 12

provides access to the only menu in MS Office 2016.

Answer 12

FILE MENU

Question 13

Workbook

Answer 13

is a file that contains one or more worksheets.

Question 14

displays different views of the worksheet.

Answer 14

View Buttons

Question 15

– it indicates the name of the file and name of the program.

Answer 15

FILE NAME

Question 16

• THREE BUTTONS IN WINDOWS CONTROL BUTTON

Answer 16

• Minimize
• Maximize
• Close

Question 17

• THREE BASIC COMPONENTS OF RIBBON

Answer 17

• Tabs
• Groups
• Commands

Question 18

it contains the commands organized in three components:

Answer 18

 RIBBON

Question 19

• FONT GROUP COMMANDS

Answer 19

• Font name
• Font size
• Bold
• Italic
• Underline
• Increase font size
• Decrease font size
• Border
• Fill color
• Font color

Question 20

The process of arranging the items of a column in some sequence or order .xlsx- a default extension of Excel Files

Answer 20

• Sorting

Question 21

feature of MS Excel quickly completes a series of data

Answer 21

• Auto Fill

Question 22

This will automatically copy the formula down to the end of your data, matching the rows in adjacent columns.

Answer 22

• Fill Handle

Question 23

• You can complete a cell entry by:

Answer 23

• Pressing enter
• Pressing any arrow key on the keyboard
• Clicking the Enter button on the Formula bar

Question 24

• You can activate a cell by:

Answer 24

• Pressing the Tab key
• Clicking the cell
• Pressing an arrow key

Question 25

• are letters, symbols, numbers and spaces or any combination that you enter into cell.

Answer 25

Labels

Question 26

• is a number that you enter into a cell, you may include symbols such as decimal point, comma and currency.

Answer 26

Value

Question 27

• is used to calculate values You may use an equal sign or the Auto sum function to build a formula.

Answer 27

FORMULA