What is an active cell in excel. Cell in Excel - basic concepts. Move across a table field
Purpose and main features of the programMSEXCEL... Program interface. The main elements of the interface. Concept of spreadsheet, cell, row, column, addressing system. Movement across the table field. Data input. Data types. Editing the contents of a cell. Change the width and height of the cell. Cell properties (“Format Cells” command).
Goal:Explore the capabilities of a spreadsheet MSEXCEL, the concept of "spreadsheet" (cell, row, column, addressing system, etc.) Repeat the software classification.
MS table processor EXCELbelongs to the class of application programs. Since 1994, it has been the most popular table processor in the world.
The purpose of the program is to automate calculations, build business graphics, create tabular documents, maintain databases.
Table processor MS EXCEL is a program that is used by office managers, economists, financiers, statisticians in their professional activities.
Program features
Data entry and editing.
Formatting Table Cells, Rows, and Columns
Formula input (calculation automation)
Application of a wide range of diverse functions
Building, editing and printing diagrams.
Preview and print a table
Creation and maintenance of databases
Download the program
START - PROGRAMS -MS EXCEL
Program interface
Interface elements:
Title bar
Top Menu
Toolbar
Input string
Table field
Status bar
Spreadsheet -a set of rows and columns, columns are designated by letters of the Latin alphabet, and rows by numbers. The intersection of a row and a column is called a cell or cell. Thus, the cell address is formed from the column name and row number, for example, A1, B12 ... In total, a worksheet can contain 247 columns and 65536 rows. With an area of \u200b\u200bone cell of 169 mm 2 for a screen with a diagonal of 14 ', one worksheet occupies an area of \u200b\u200b2735.7 m 2, which is about 60% of the area of \u200b\u200ba football field.
3 sheets are displayed in the working field of the screen in Excel, the active is Sheet 1 ... To switch to another sheet, you need to click on its tab with the mouse.
For making a copy from the sheetyou need to activate it, then with the key pressed Ctrlgrab the tab of the copied sheet with the left mouse button, without releasing it, drag it to the left or right and release the mouse button first, then Ctrl... At the same time, an image of a sheet with a "+" sign is added to the cursor arrow. The copy is automatically named, for example Sheet 1 (2)for the first copy, Sheet 1 (3)for the second, etc. You can change the sheet name by clicking the tab rightby clicking the mouse and selecting the command from the context menu Rename ... You can swap sheets in places by dragging them by the tabs while holding down the key Shift.
Active cell is the cell where the cursor is positioned. It is highlighted with a dark frame when you click on it with the mouse. The transition between cells is made using the mouse or cursor keys.
Spacing (block) of cells given by the addresses of the upper left and lower right cells, separated by colons, for example, A1: C4... To select a block of cells, you can use the mouse or arrow keys while holding down the key Shift... To select a column or row, click on the header of the required column or row. One of the techniques for selecting non-contiguous areas, for example, A1: A10and C1: C10, is using the mouse while the key is pressed Ctrl.
The selected elements of the table or worksheet are moved and copied using the mouse, or via the clipboard: commands Cut, Copy, Paste.
You can increase the width of the cell by placing the cursor on the border between the letters of the columns until it turns into a double-headed arrow and by pressing the left mouse button move the border to the required distance.
Increasing the cell height is performed in the same way when the cursor is positioned at the border between line numbers.
In addition, the height of the rows and the width of the columns of the table are adjusted using the commands Line and Column from the menu Format... To change the width of a column using the mouse, select a cell or the entire column, select the command Format \\ Column \\ Width ...and enter the desired width in millimeters in the window Column width ... Command AutoFit Width increases the width of the cell by the length of the entered characters, commands Hide or Display remove or insert the marked column. Similarly, the line height, its auto-fit, deletion or insertion of a line is changed when using menu commands Format \\ String.
Move across a table field
With the mouse
Using the cursor keys
Using the paging keys PgUp, PgDn
Using the HOME, END keys
The active (selected, current) cell is the cell of the worksheet with which you are currently working. An active cell is always marked either by thickening the lines of its borders when it is the only selected cell, or by the inverse of its background color when it is one of several selected cells (a block of cells).
By default, data entry and many other operations in MS Excel are associated with the active cell.
15.Ms Excel program interface
MS Excel along with other application programs MSWindows supports both "mouse" and keyboard interface - a set of tools for controlling the operation of an application program and information processing techniques. The fact is that sometimes it is more convenient to use a mouse to perform some operations, and a keyboard for others. As a result, it is useful for the user of the MS Excel program to know the features of the application and to have the skills to work with both the one and the other interface. Moreover, if a mouse is not installed on the computer or it, for various reasons, does not work reliably, then the only available means of controlling the operation of the MS Excel program is the keyboard.
In addition, the variety of ways to perform the same operations that the MS Excel program provides at the disposal of the user allows him to independently form his own style of working with this program, based on his personal preferences and primary skills of working with previously mastered PC software.
Laboratory work No. 1
"INTRODUCTION TO THE MS EXCEL PROGRAM"
1.1. Running ms Excel
Start MS Excel by executing the command "Start / Programs / (MicrosoftOffice) / MicrosoftExcel".
In the MS Windows operating system, the MS Excel shortcut can also be found on the desktop or in the Quick Launch.
1.2. Structure and elements of the working window of ms Excel
Open the working window of MS Excel to the full display screen. With the standard (initial) setting of the parameters of the MS Excel program, its working window looks as shown in Fig. 1.
Figure: 1. The structure and elements of the working window of MS Excel.
Below is a brief description of the elements of the graphical interface of the MS Excel working window.
1. Buttons of the system menus to control the behavior of the MS Excel window (upper button) and the window with an active workbook (lower button). Double clicking on any of these buttons closes the corresponding window.
2. A header line containing the name of the program (Microsoft Excel) and the name of the active workbook (Book 1). The name of the workbook corresponds to the name of the file in which it is stored. Each newly created book gets a default name: "Book N", where N is the ordinal number of the newly created workbook in this session of work with MS Excel.
3. The line of the main menu of MS Excel.
4. Buttons to control the behavior of the MS Excel window (upper group of buttons) and windows with an active workbook (lower button).
5. Lines with toolbars: "Standard" and "Formatting".
6. The button of selection (selection) of all cells of the current sheet of the workbook at once with the help of a single mouse click.
7. Name field. This window displays the address (name) of the active cell or block of cells.
8. Formula bar (it displays the information entered into the active cell and the previously entered information is edited).
9. Control buttons for entering information into the active cell. The left button cancels the current input of information, the middle button confirms the correctness of information input and the right button is used to introduce the desired function into the cell using the "Function Wizard".
10. Buttons with headings (names) of columns. They are used to select (select) all the cells in a column at once or to resize them in width.
11. Marker of horizontal division of the sheet into two working areas.
12. Buttons with titles (names) of lines. They are used to select (select) all cells of a row at once or change their size in height.
13. Active (selected, current) cell (C7) on the worksheet.
14. Buttons for navigating through the sheets of the workbook. The outer buttons are used to quickly move to the beginning or end of the list of sheets, while the inner buttons are used to step by step in forward and backward directions.
15. Labels with the names of the sheets of the workbook. The name of the active (current) sheet is displayed in bold on a light background.
16. Marker for changing the width of the display area of \u200b\u200bthe workbook sheet labels.
17. Vertical and horizontal scroll bars (broaches).
18. Marker of vertical division of the sheet into two working areas.
19. Status bar. It displays messages about the operating mode of the MS Excel program in which it is currently located.
20. Display area of \u200b\u200bthe activated operating modes of the MS Excel program (VDL - work in the mode of keyboard selection of cells; CAPS - input mode for uppercase letters; NUM - mode for entering numbers using the keys of the small numeric keypad; SCRL - mode for stopping the scrolling of the ET sheet when navigating in the working window; OVR - entering information into a cell in the mode of replacing its contents).
EXERCISE 1.Without performing any mouse clicks, one by one place its cursor on all the above elements of the MS Excel working window.
Please note and remember that:
- in the process of such navigation, the geometric shape of the mouse cursor sometimes changes depending on which object (element of the object) it is currently pointing to;
- if you place the mouse cursor on any of the toolbar buttons and do not move it for one or two seconds, you can get a hint about the purpose of this button.
there is no right answer
10. Indicate what the cell address of the worksheet consists of in a programme Excel.
column designation, line number
column designation
column number
line number
11 . In a programme Excel specifying a cell address in a formula is called ...
function
operator
cell name
12. The active cell in an Excel spreadsheet is a cell ...
to record commands
selected cell
13. How to select non-adjacent cells in Excel?
< Ctrl>
click on the first cell, click < Shift> and, while holding it, click on other cells
click on the first cell, click < Alt> and, while holding it, click on other cells
perform actions: Editing– Go – Highlight.
14. How to select a range of cellsin the program tableExcel?
click on the first cell, click < Shift>
click on the first cell, click < Ctrl> and, while holding it, click on the last cell
click on the first cell, click < Alt> and, while holding it, click on the last cell
perform actions Editing– Go – Highlight
15 ... Specify the correct actions when you finish entering data into a cell in a programme Excel.
press the key < Enter>
click on the button < Cancellation> formula bars
press the key < End>
press the key < Space>
16 ... Which function key in Microsoft Excel can I edit and enter data in the active cell?
17. How to delete the contents of cells in a programme Excel?
select a cell and press < Del>
select a cell and press < Ctrl> + < Del>
select a cell, press the left mouse button, select the command in the dialog box that appears Clear content
select a cell and execute the commands: View– Usual.
18. What commands can be used to add cells to the tablein a programme Excel?
Format– Cells ...
Insert – Add to – Cells ...
Insert – Sheet
Insert– Cells ...
19 ... Before enteringinformation into a cell in a programme Excel, you need ...
a) make the cell active
b) create a new cell
c) call the context menu by right-clicking
d) press the key Delete.
20. Indicate how the names of the lines on the worksheet are indicated in the program Excel.
are numbered
21. Indicate how the names of the columns are indicated on the worksheet in the program Excel.
randomly named by users
denoted by letters of the Russian alphabet
denoted by letters of the Latin alphabet
are numbered
22. If you click on the row header in a programme Excel, ...
the line will be highlighted
the content of the line will appear
expected to enter a formula expression
a new line will be inserted
Option 2
1. The main data are called the program table data Excel, ...
data that can be determined by the values \u200b\u200bof other cells
derived data
all spreadsheet data is basic
2. Derived data are called table data Excel, …
data that cannot be determined from other cells
data that is determined by the values \u200b\u200bof other cells
basic data
all spreadsheet data is derived
3. Provide correct worksheet column labels in a programme Excel.
4. Specify the correct worksheet row designation in a programme Excel.
5. Enter the correct cell addressin a programme Excel.
6 . The range of a table in Excel is ...
a collection of cells that form a rectangular region in a table
all cells of one row;
all cells in one column;
set of valid values.
7. Specify the correct designations for the ranges of the table in the programExcel.
8. Ordering the values \u200b\u200bof a range of cells in the program Excel
in a certain sequence are called ...
formatting
filtration
grouping
sorting
9 . What data can be entered into the cell in a programme Excel?
all listed
10. What formatting is applicable to cells in Excel?
framing and filling
text alignment and font format
data type, width and height
all options are correct
11. Command dialog box Format in a programme Excel used by ...
filling table records
table formatting
spell checker on worksheet
filtering table records by condition
12. You can change the data format in a separate cell using the panel ...
Formatting
Formula bar
Standard
Menu bar
13. You can format cells from a specific range using the commands ...
Format - Cells
Service - Cells
Table - Cells
Insert - Cells
14. You can change the width and height of the cells using the commands ...
Format - String; Format - Column
Service - String;Service - Column
Insert - String;Insert - Column
Edit - String;Edit - Column
15 . If you double-click on a filled table cell in Excel, the mode is activated ...
edit cell content
Text
copy cell contents
data entry, if they are Formula expression
16. Scroll barsin the program window Excel is needed for….
a) viewing the diagram
b) view tables
c) viewing books
d) view the contents of the sheet
17. Is the program capableExcelto automatically continue the sequence of homogeneous data?
only a sequence of natural numbers
only sequence of dates
18.Using the functionAutocomplete in the program tableExcelcan…
create series of numbers, days, dates, quarters, etc.
automatically perform basic calculations
perform complex calculations automatically
make changes to the contents of a cell
19.Afill in the program table automaticallyExcel homogeneous data using the commands ...
Edit - Fill - Progression
View - Fill - Progression
Format - Fill - Progression
Service - Autocomplete
20.How to multiply the contents of the current cell into several cells in a column or row of a table in a programExcel?
by dragging the fill handle
moving the mouse cursor
by copying the formula in the formula bar
filling the status bar
21. What is a document in the programExcel?
a set of tables - a workbook that consists of one or many worksheets *
a set of numerical data interconnected by arithmetic and logical connections
a set of columns designated by Latin letters A, B, C ...
a set of strings numbered with integers
22. Vertical scroll bar in the program windowExcel allows ...
a) view different parts of the sheet
b) view the document in the form in which it will be printed
c) rescale the document
d) resize the window
Test number 6
"Calculations and charting in the programExcel ".
Option 1
1.What character should the formula begin with Excel?
irrelevant
2. Is it possible to edit formulas in a programme Excel?
there is no right answer
3. How to type a formula for calculation in the program Excel?
select a cell, enter a formula
select a cell, enter the answer immediately
select a cell, type the “\u003d” sign, write a formula without omitting operation signs *
select a cell, type the “\u003d” sign, write a formula, omitting operation signs
4. What character is not a designation of an arithmetic operation in a programExcel?
5. Expression "Data cells A1 divide bycell data B1 "in the programExcellooks like ...
6 . Is it possible when entering formulasin a programmeExcel use brackets?
Yes, but only when using absolute links
Yes, but only when using links to other sheets
7. Expression 5 (A2 + C3): 3in a spreadsheet looks like:
8. Specify the correct formula expression in the documentprogramsExcel …
=50 : 100
9. To insert a formula into a cellin a programme Excel, you need to enter a sign:
10. Select the correct formula entry for the spreadsheet:
11. Which of the following formulas multiplies all data in the top 10 rows of the current column tables in the programExcel ?
A1 * A2 * A3 * A4 * A5 * A6 * A7 * A8 * A9 * A10
Option 2
1. How to fix an error in a formula in a programExcel ?
write it again
click on the formula and correct the errors in the formula bar
copy the correct formula
execute the commands sequentially: Format - Formula
2. Specify what the function defines AVERAGE in a programme Excel?
arithmetic mean of a given range of cells
average of cell division
find the shortest text
3. What the function is used forSUM in a programme Excel?
to get the sum of the squares of the specified numbers
to get the sum of the specified numbers
to get the difference of the sums of numbers
to get the square of the specified numbers
4. Indicate what the function is doing MIN in Excel?
smallest value search
average search
descending ordering of numbers
find the shortest text
5. Indicate what the function is doingMAX in Excel?
find the shortest text
descending ordering of numbers
average search
finding the greatest value
6 ... Command Autosum in Excel need for…
non-graphical presentation of information
counting the sum of cells
graphical presentation information
plotting columns or rows graphically
7 ... Sorting datain a programme Excel is ...
sorting data in ascending or descending order
data ordering only in ascending order
ordering data in descending order only
data filtering
8 . What kinds of sorts exist in Excel?
a) descending order; sort by deletion
b) sorting in ascending order; descending sort
c) sorting by multiplication; sort by promotion
d) descending order; descending sort
9 . Digram- this is…
a) graphical presentation of data
b) external design of data, as well as format correction
their content data
c) a sequence of cells that form a logical
d) numbered labels that are located on the left side
each line
1 0 ... Diagrams in a programme Excel is created for ...
graphical presentation of information
plotting columns
graphical construction of columns, or rows;
graphical construction of columns, and rows
1 1 . What commands can you use add diagram to program bookExcel?
Insert - Chart - Chart Wizards
Chart - Add Chart
Service - Chart sequential steps Chart Wizards
View - Chart - Add Chart
Test number 7
"Work inPowerPoint... Creating colorful presentations "
Option 1
1. What is Power Point?
microsoft Office application for creating presentations
code table application
computer device that manages its resources while processing data in tabular form
system program that manages computer resources
2. What is presentationPowerPoint?
demonstration set of slides prepared on a computer
spreadsheet application
computer slideshow control device
a text document containing a set of drawings, photographs, diagrams
3. PowerPoint needed to create….
tables in order to improve the efficiency of calculating formula expressions
text documents containing graphic objects
Internet pages in order to provide wide access to available information
presentations to improve the efficiency of perception and memorization of information
4. An integral part of a presentation containing various objects is called ...
5. A set of slides, collected in one file, form ...
presentation
6. LaunchprogramsPowerPoint
Start - Main Menu - Programs -Microsoft Power Point
Start - Main Menu - Find -Microsoft Power Point
Taskbars - Settings - Control Panel -Microsoft Power Point
Working table– Start – Microsoft Power Point
7. In which section of the program window menuPowerPoint there is a teamCreate new) slide ?
Slideshow
File
Insert
8 . Choosing a slide layout in the programPowerPoint carried out using the commands ...
Format - Slide layout
Format - Slide color scheme
1. Microsoft Excel is ...
a) an application program designed to store, process data in the form of a table *
b) code table processing application
c) a computer device that manages its resources in the process of processing data in tabular form
d) a system program that manages computer resources
2. The spreadsheet is:
a) a set of numbered lines and columns named by letters of the Latin alphabet *
b) a set of lines and numbered columns named by letters of the Latin alphabet;
c) a collection of numbered rows and columns;
d) a collection of rows and columns, arbitrarily named by the user.
3.With which commands can you run the program Excel?
a) Start - Programs - Microsoft Office - Microsoft Office Excel *
b) Start - Programs - Windows Catalog
c) Start - Programs - Accessories - Notepad
d) Programs - Microsoft Office - Microsoft Excel
4. What is the name of the processing object in Excel?
b) page
5. What you need to do to create a new book in the program Excel?
a)execute command Create a on the menu File*
b)push the button Return on the toolbar
c)execute command Open menu File
d)push the button Openon the toolbar
6. What extension do the program files have Excel?
7.The minimum component of the table in the program Excelis an...
a) cell *
c) formula
d) there is no correct answer
8.Specify what the cell address of the worksheet consists of in the program Excel.
a) column designation, line number *
b) column designation
c) column number
d) line number
9. The active cell in the Excel spreadsheet is the cell ...
a) to record commands
d) selected cell *
10. How to select non-adjacent cells in Excel?
c) click on the first cell, press
d) perform the actions: Edit - Pass - Select.
11. How to select a range of cells in an Excel spreadsheet?
a) click on the first cell, press
b) click on the first cell, press
c) click on the first cell, press
d) perform the actions Edit - Pass - Select
A cell in Excel is the main structural element of a worksheet where you can enter data and other content. In this lesson, we will master the basics of working with cells and their contents in order to calculate, analyze and organize data in Excel.
Understanding cells in Excel
Every sheet in Excel is made up of thousands of rectangles called cells. A cell is the intersection of a row and a column. Columns in Excel are denoted by letters (A, B, C), while rows are denoted by numbers (1, 2, 3).
Based on the row and column, each cell in Excel is given a name, also called an address. For example, C5 is a cell that is at the intersection of column C and row 5. When you select a cell, its address is displayed in the Name field. Notice that when you select a cell, the row and column headers where it intersects are highlighted.
Microsoft Office Excel has the ability to select multiple cells at once. A set of two or more cells is called a range. Any range, just like a cell, has its own address. In most cases, a range address consists of the upper-left and lower-right cell addresses, separated by colons. This range is called contiguous or continuous. For example, a range that consists of cells B1, B2, B3, B4, and B5 would be written as B1: B5.
In the image below, two different ranges of cells are highlighted:
Select cells in Excel
To enter data or edit the contents of a cell, you must first select it.
You can also select cells using the arrow keys on your keyboard (cursor keys).
Select a range of cells in Excel
When working with Excel, it is often necessary to select a large group of cells or a range.
