COMPUTER 8 Unit Test Quiz

Rows bar

Have numeric names

Spreadsheet Area

It is the place where we enter our data. It includes all the rows, cells, columns, and built-in data in the spreadsheet.

Ctrl+N

Open a new workbook

Ctrl + V

Paste the copied cell

Functions

Predefined formulas in Excel. They eliminate laborious manual entry of formulas while giving them human-friendly names.

average

Remind you of simple averages of data such as the average number of shareholders in each shareholding pool.

delete

Remove all the contents from the cell

Ctrl + S

Save a workbook

Excel offers two ways to save a file:

Save and Save As.

Name box

Show the location of the active cell, row, or column. We have the option of selecting multiple options.

Worksheet Views

These views can be useful for various tasks, especially if you're planning to print the spreadsheet. To change worksheet views, locate the commands in the bottom-right corner of the Excel window and select Normal view, Page Layout view, or Page Break view.

Show Tabs:

This option hides all command groups when they're not in use, but tabs will remain visible.

Show Tabs and Commands:

This option maximizes the Ribbon. All of the tabs and commands will be visible. This option is selected by default when you open Excel for the first time

Quick Access Toolbar

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.

Menu Bar/Tabs

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 menu bar and contain a File, Insert, Page Layout, Formulas, Data, Review, View, Help, and a Search Bar with a light bulb icon. These menus are divided into subcategories which simplify the distribution of information and analysis of calculations.

Ctrl + Z

Undo

File tab

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.

Save:

When you create or edit a workbook, you'll use the Save command to save your changes. You'll use this command most of the time. When you save a file, you'll only need to choose a file name and location the first time. After that, you can just click the Save command to save it with the same name and location.

Save As:

You'll use this command to create a copy of a workbook while keeping the original. When you use Save As, you'll need to choose a different name and/or location for the copied version.

Page Break view

allows you to change the location of page breaks, which is especially helpful when printing a lot of data from Excel.

View or Workview Buttons

are a set of three buttons arranged at the left of the Zoom control, close to the screen's right-bottom corner. We can see three different kinds of sheet views in Excel using this method.

Columns Bar

are a vertically ordered series of boxes across the full sheet. This column bar is located below the formula bar. 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. The number of columns that can be used is limited to 16,384.

Control Buttons

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.

Scrollbars

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.

Cells

are those parallelepipeds that divide the spreadsheet into many pieces, separating rows and columns. A spreadsheet's first cell is represented by the first letter of the alphabet and the number one (A1).

The Ribbon and Quick Access Toolbar

are where you will find the commands to perform common tasks in Excel.

Tell Me

box works like a search bar to help you quickly find tools or commands you want to use.

The Ribbon

contains multiple tabs, each with several groups of commands. You will use these tabs to perform the most common tasks in Excel.

Page Layout view

displays how your worksheets will appear when printed. You can also add headers and footers in this view.

Auto-hide Ribbon:

displays your workbook in full-screen mode and completely hides the Ribbon.

The Backstage view

gives you various options for saving, opening a file, printing, and sharing your document.

Backstage View

gives you various options for saving, opening a file, printing, and sharing your workbooks.

Microsoft Excel

is a powerful spreadsheet program developed by Microsoft.

Dialogue Box Launcher

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.

Excel

is designed to help users perform various tasks related to data manipulation, analysis, and presentation.

Leaf Bar

is present at the bottom of the spreadsheet, which says sheet is shown. This sheet bar describes the spreadsheet which is currently being worked on.

Status Bar

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.

Zoom Control

is present at the lower-right side of the window. It enables us to Z00M-IN or ZOOM-OUT a specific area of the spreadsheet.

Normal view

is the default view for all worksheets in Excel.

Rows 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. There are a total of 1,048,576 rows available.

Quick Access Toolbar

lets you access common commands no matter which tab is selected. By default, it includes the Save, Undo, and Repeat commands. You can add other commands depending on your preference.

Title Bar

of the spreadsheet is at the top of the window. It displays the active document's name.

Ctrl + O

open a saved workbook

Formula Bar

permits us to observe, insert or edit the information/formula entered in the active cell.

Ctrl + P

to print

sum

Aggregates values from a selection of columns or rows from your selected range.

Column bar

Alphabetic names

3 Modes in the Ribbon Display Options menu:

Auto-hide Ribbon, Show Tabs, Show Tabs and Commands

Ctrl + W

Close a workbook

Ctrl + C

Copy selected cells

Ctrl + X

Cut selected cells

Ribbon/Toolbar

Each menu bar contains several different elements. On the selection of the menu, a sequence of command options/icons will show on a ribbon.

Steps to save the workbook

1. Click on the Office Button or the File tab. 2. Click on Save As option, 3. Write the desired name of your file. 4. Click OK

It is widely used for tasks such as:

* Data Entry and Organization * Calculations and Formulas * Data Analysis * Charting and Visualization * Statistical Analysis

The Excel Main Interface

* Quick Access Toolbar * File Tab * Title Bar * Control Buttons * Menu Bar * Ribbon/Toolbar * Dialog Box Launcher * Name Box * Formula Bar * Scroll Bars * Spreadsheet Area * Leaf Bar * Column Bar * Row Bar * Cells * Status Bar * View Buttons * Zoom control

Worksheet

A spreadsheet can contain one or several worksheets (tabs). Adding worksheets can be done by clicking the (+) on the right side of the existing worksheet tab(s).

Cell

Subsequently exist of a letter and a number that conveniently point out their position in the grid.