Spreadsheet Applications Using MS Excel Flashcards
This toolbar is located in the upper left corner of the screen. Its objective is to show the most frequently used Excel commands. We can customize this toolbar based on our preferred commands.
Quick Access Toolbar
Excel 2007’s Office button has been replaced by the _____________. We can click it to check the Backstage view, where we can open or save files, create new sheets, print sheets, and perform other file-related operations.
File Tab
The ________ of the spreadsheet is at the top of the window. It displays the active document’s name.
Title Bar
are the symbols that are present in the upper-right side of the window, enabling us to change the labels, minimize, maximize, share, and close the sheet.
Control Buttons
Under the diskette or save icon or the excel icon (this will depend on the version of the program), labels or bars which enable changing the sheet which is shown. These are the _______ and contain a File, Insert, Page Layout, Formulas, Data, Review, View, Help, and a Search Bar with a light bulb icon. These _______ are divided into subcategories which simplify the distribution of information and analysis of calculations.
Menu Bar
Each menu bar contains several different elements. On the selection of the menu, a sequence of command options/icons will show on a ___________. For example, if we select the “Home” tab, we will see cut, copy, paste, bold, italic, underline, and more commands. In the same way; we can click on the “Insert” tab, we will see tables, illustrations, additional, recommended graphics, graphics maps, among others. On the other hand, if we select the “Formulas” option. Insert functions, auto sum recently used, finances, logic, text, time, date, etc.
Ribbon/Toolbar
is a set of commands organized into three sections.
Ribbon/Toolbar
They are the Ribbon’s top part, and they include groups of related commands. ___________ include Home, Insert, Page Layout, Formula, Data.
Ribbon Tabs
They organize related commands; the name of each ________ is displayed below the Ribbon. For example, a set of commands related to fonts or a group of commands related to alignment, etc.
Groups
They appear within each group, as previously stated.
Commands
is a very little down arrow that is present in the lower-right corner of a command group on the Ribbon. By clicking on this arrow, we can explore more options related to the concerned group.
Dialog Box Launcher
Show the location of the active cell, row, or column. We have the option of selecting multiple options.
Name Box
permits us to observe, insert or edit the information/formula entered in the active cell.
Formula Bar
are the tools that enable us to move the document’s vertical and horizontal views. We can activate this by clicking on the platform’s internal bar or the arrows we have on the sides. Additionally, we can use the mouse wheel in order to automatically scroll up or down: or use the directional keys.
Scroll Bar
It is the place where we enter our data. It includes all the rows, cells, columns, and built-in data in the spreadsheet. We can use shortcuts to perform toolbar activities or formulas of arithmetic operations (add, subtract, multiply, etc.). The insertion point is the blinking vertical bar known as the “cursor.” It specifies the insertion location of the typing.
Spreadsheet Area
is present at the bottom of the spreadsheet, which says sheet1 is shown. This sheet bar describes the spreadsheet which is currently being worked on. Using this, we can alternate a number of sheets or add a new one as per our convenience.
Leaf Bar
are a vertically ordered series of boxes across the full sheet. The letters of the alphabet are used to label the columns. Begin with the letter A to Z, and then after Z, it will continue as AA, AB, and so on.
Columns Bar
is the left part of the sheet where a sequence of numbers is expressed. Begin with number one (1), and further rows will be added as we move the pointer down.
Rows Bar
The number of columns that can be used is limited to
16,384
The number of rows are limited to
1,048,576
are those parallelepipeds that divide the spreadsheet into many pieces, separating rows and columns.
Cells
is present at the bottom of the window that displays critical information. It also indicates whether something is incorrect or whether the document is ready to be printed or delivered.
Status Bar
are a set of three buttons arranged at the left of the Zoom control, close the screen’s right-bottom corner. We can see three different kinds of sheet views in Excel using this method.
View Buttons
displays the Excel page in normal view.
Normal view
view shows the precise layout of an Excel page it will be printed.
Page Layout View
This displays page break preview before printing.
Page Break View
is present at the lower-right side of the window. It enables us to ZOOM-IN or ZOOM-OUT a specific area of the spreadsheet. It is represented by magnifying icons with the symbols of maximizing (+) or minimizing (-).
Zoom Control
Microsoft Excel 2019 enables us to zoom out up to _______ and zoom in up to ______
10% and zoom up to 400%.
Enumerate the benefits of using Excel Shortcut Keys
- Save Time
- Increase Speed
- Reduce Errors
- Improve Focus
- Minimize Strain
(Shortcut) To move to the next cell
Tab
(Shortcut) To move to the previous cell
Shift + Tab
(Shortcut) To move one cell down
Enter
