CompFun module 1

Microsoft Office

refers Microsoft’s entire suite of office productivity applications.

Office 365

is a service where you pay a monthly subscription fee (around $10 a month) to use Microsoft Office programs (as opposed to paying $100 or more up front, as was traditionally done)

Microsoft excel

is an electronic application and spreadsheet program developed by Microsoft. In this, it helps user to organize his data into rows and columns and to perform mathematical calculations

1048576

How many rows are in excel

16384

How many columns are in excel

workbook, spreadsheetsx

An Excel file is known as _______ which is a collection of worksheets (also known as ______).

Blank workbook

A new workbook is created by clicking on the Excel icon in your computer and selecting

Ctrl + N

A new workbook can also be created while working in an existing Excel workbook by typing Ctrl + N

Ctrl + O

Workbooks can also be opened from Excel by typing

Save button

Workbooks are saved by (option 1) clicking on the _______ on the Quick Access toolbar

Save As

The first time a file is saved, any one of these actions will bring up the _______ dialogue box

worksheet, cell

A ______ is made from the intersections of rows and columns which form what we call “___” where data is entered and interpreted

+

You may add, delete, rename, and change the order of the worksheets to your workbook by clicking the “__” symbol near to the sheet

Insert

A blank worksheet may be added by clicking the right click of the mouse, selecting ____... from the popup menu

Excel interface

It is the main interface of an Excel worksheet where we work, store and manipulate our data that contains various components.

Quick Access Toolbar

The ________ composes of different commands of Excel that is customizable to provide fast access to the user by adding any command in it, whichever is quite needed the most.

Save, undo, and repeat

By default, ____, ____, and ____ commands are added in the quick access toolbar commonly found at the upper left of the application. You can add many commands as possible but not all can be displaced.

Ribbon

The ____ includes multiple tabs, each with several groups of commands.

Clipboard, Font, Alignment, Number, Styles, Cells, Editing, analysis

Home tab groups

Tables, add-ins, Charts, Tours, Sparklines, Filter, Links, Comment

Insert tab groups

Drawing tools, touch, convert, replay

Draw tab groups

Themes, Page Setup, Scale to Fit, Sheet Options, Arrange

Page layout tab group

Function Library, Defined Names, Formula Auditing, Calculation

Formulas tab group

Get and Transform Data, Queries and Connections, Data Types, Sort & Filter, Data Tools, Forecast

Data tab group

Proofing, Accessibility, Insights, Language, Comments, Notes, Protect, Ink

Review tab group

Sheet View, Workbook Views, Show, Zoom, Window, Macros

View tab group

Help, Community

Help tab groups

Name box

This gives the location or "name" of a selected cell in the worksheet.

Formula Bar

It allows the user to write or edit data, formula, or a function that will take place in a specific cell

Normal view

Page Layout view

Page Break view

We have few options to view any workbook in the Excel. These are the ______, ______, or _______ found at the lower right of the application.

file menu, Backstage view

Whenever the File Tab is clicked, the _______ also known as ______ will arise which contains the information of the file and its options.

Zoom control

The _________ allows the user to view the worksheet on desired scale through clicking and dragging the slider on either to the left or right.

Ready mode

Enter mode

Edit mode

Point mode

STATUS BAR MODES

Ready mode

In this mode, nothing is being written or edited on the spreadsheet.

Enter Mode

This is when you are doing data entry in your workbook

Edit Mode

This means that the user is presently editing the contents of the current cell. To edit the content of a cell, double‐click the selected cell with data in it or click the inside of the formula bar.

Point mode

This is once the worksheet is used when linking to cell addresses within a formula or from an Excel dialog window