Table of Contents
- 1 What is the name for the cell with a heavy black border that is ready to accept new data or a formula?
- 2 What conveys a visual representation of data?
- 3 Which cell is with a dark border around it?
- 4 Is a thick green boundary that surrounds the active cell?
- 5 What are the four types of data you can enter in a cell?
- 6 What are the 11 data formats in Excel?
What is the name for the cell with a heavy black border that is ready to accept new data or a formula?
A cell having a dark border is called as the active cell. The active cell can refer to the cell present in the Excel spreadsheet which is selected currently by clicking the mouse or the keyboard keys.
What conveys a visual representation of data?
In the simplest terms, a chart is a graphical representation of data. Charts use visual symbols like line, bars, dots, slices, and icons to represent data points.
What types of data are commonly entered into a cell?
You enter three types of data in cells: labels, values, and formulas.
- Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters.
- Values (numbers) are generally raw numbers or dates.
What are the labels along the lower border of the Excel window that identify each worksheet?
Sheet tabs The labels along the lower border of the Excel window that identify each worksheet.
Which cell is with a dark border around it?
active cell
The current active cell can be identified as being the one that has a darker black border around it. Also, the active cell reference is listed in the Name Box directly above the spreadsheet’s column headings. Anchor Cell: The anchor cell is the first cell that is highlighted in a range.
Is a thick green boundary that surrounds the active cell?
The thick border gridlines around the cell indicates that it is the Active cell inside Excel Worksheet. The Active cell is where the focus is on and where the data will be entered when a key is typed on keyboard.
When a cell entry is positioned at the far left in the cell it is considered?
Cards
| Term REQUIREMENTS | Definition THE PERSON OR PERSONS REQUESTING THE WORKSHEET SHOULD SUPPLY THEIR REQUIREMENTS IN A __________ DOCUMENT. |
|---|---|
| Term LEFT-ALIGNED | Definition WHEN A CELL ENTRY IS POSITIONED AT THE FAR LEFT IN THE CELL, IT IS CONSIDERED __________. |
When you enter numeric data in a cell Excel?
EXAM MS EXCEL 2013
| A | B |
|---|---|
| When you enter numeric data in a cell, Excel recognizes the values as numbers and _____ the values. EX 13 | Right-aligns |
| A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells. EX 14 | Range |
What are the four types of data you can enter in a cell?
Identifying Types of Data Excel worksheets contain four types of data: text, values, dates, and formulas.
What are the 11 data formats in Excel?
The most common data formats used to store data in files that can be read data into Excel are:
- Existing Excel workbook or worksheet with extension .xls.
- Existing Excel workbook or worksheet with extension .xlsx.
- Comma-separated values text file with extension .csv.
- Text file, often with extension .txt or extension .asc.
What is the print area?
A print area is one or more ranges of cells that you designate to print when you don’t want to print the entire worksheet. When you print a worksheet after defining a print area, only the print area is printed. Each print area will print as a separate page.
Which symbol inserted between two cell addresses indicates a range?
The colon, comma and the space. Colon ( : ) – This is used to define a range of cells (e.g. “A1:D4”). A range of cells is described in terms of the top left cell and the bottom right cell references separated by a colon. Comma ( , ) – This is used to define non adjacent cells (e.g. “A1”, “B2”).