Flash Card Study CCC - libreoffice calc

What is Workbook

A workbook is a collection of worksheets where the user works. A workbook can contain maximum 255 sheets to work in. Whenever a workbook opens, it display three workbook by default.

What is Worksheet

a worksheet is a place where the user works and perform arithmetical and functional calculations. By default is named as sheet1,sheet2,sheet3,…etc. A sheet can renamed too.

What is Name Box

it is the box on the left of formula bar that gives the address of address of each cell.

What is Active Cell

Which cell is selected or ready to accept data known as active cell. It will display with dark outline

What is Range in Excel?

A range is a group of contiguous cell, which form the shape of rectangle . You can specify a range by writing the starting cell address followed by a colon ( : ) and the end cell address

How many Types of Cell Reference in Excel

There are 3 types of Cell Reference:
Relative
Absolute
Mixed

What are charts in MS-Excel?

To enable graphical representation of the data in Excel, charts are provided. A user can use any chart type, including column, bar, line, pie, scatter, etc. by selecting an option from Insert tab's Chart group.

What is the use of NameBox in MS-Excel?

Name Box is used to return to a particular area of the worksheet by typing the range name or cell address in the name box.

What is Freeze Panes in MS-Excel?

To lock any row or column, freeze panes is used. The locked row or column will be visible on the screen even after we scroll the sheet vertically or horizontally.

Explain Spreadsheet and its Basics.

Spreadsheet can be compared to a paper ledger sheet. It consists or rows and columns and their intersection called cells.

Explain Macro in MS-Excel.

Macros are used for iterating over a group of tasks. Users can create macros for their customized repetitive functions and instructions. Macros can be either written or recorded depending on the user.

What is Microsoft Excel?

Microsoft Excel is an electronic worksheet or spreadsheet application which is used for organizing, storing, and manipulating and analyzing data. It is developed by Microsoft.

What are cells?

The area where data is stored is known as cell.

Does each cell have unique address?

Yes, each cell has a unique address depends on the row and column value of the cell.

What does the IF function in Excel?

IF function is used in Excel to check whether certain conditions are true or false. If the condition is true then it will give the result accordingly and if the condition is false the result or output will be different.

What are the advantages of using formula in Excel sheet?

Formula makes it easy to calculate the numbers in Excel sheet. It also calculates automatically the number replaced by another number or digit. It is used to make complex calculations easy.

Active cell

The selected cell in the worksheet; indicated with a dark border.

Active sheet

The worksheet currently displayed in the workbook window.

Adjacent range

A single rectangular block that includes a group of contiguous cells.

Arithmetic operator

A symbol, such as +, - , *, or /, used in a formula to perform arithmetic calculations.

AutoComplete

The feature that helps make entering repetitive text easier. As you enter text in a worksheet, text that begins with the same letters as a previous entry in the same column is displayed.

Autofit

To eliminate empty space by matching the column width to the longest cell entry or the row height to the tallest cell entry.

AutoSum

A button that quickly inserts Excel functions that summarize all the values in a column or row using a single statistic

Cell

The intersection of a column or row in a worksheet.

Cell range

A group of worksheet cells, which can be adjacent or nonadjacent. (Example - A2:G19)

Cell reference

The address of a cell indicating its column and row location.

Column heading

In Excel, the part of the worksheet that identifies each column by a different letter.

Cut

To remove data from a cell and place it on the Office Clipboard.

Date data

A value in a recognized date format.

Drag and drop

To move an item (either text or a graphic) by selecting it and dragging it with the mouse.

CCC Flash card for Practice Exam

CCC Online Learning - Libreoffice calc