A worksheet is a page containing a grid of cells made up of rows and columns.
A workbook is a collection of worksheets.
A cell is the smallest unit of a worksheet.
The Formula bar displays the data or formula used in a selected cell.
A range is a rectangular block of contiguous cells.
State whether True or False. Correct the False statement(s):
The title bar is located at the bottom of the Excel window. (FALSE)
(At the top)
You can enter only numbers in an Excel cell. (FALSE)
(Numbers, Text, Formula)
To move to the cell below the active cell, press the Enter key. (TRUE)
A workbook can contain a maximum of 255 worksheets. (TRUE)
The last column is labelled XED. (FALSE)
Choose the correct option:
By default, which of the following buttons are available on the Quick Access toolbar?
d. All of these
A worksheet in Excel 2013 has ________ rows.
d. None of these
________ are labelled using letters of the alphabet.
d. None of these
A worksheet in Excel 2013 by default shows ________ worksheet(s).
Excel files are called ________.
d. None of these
Descriptive Type Questions
Answer the following:
What is the default extension of an Excel 2013 workbook?
The default extension of an Excel 2013 workbook is .xlsx.
What is the use of Name Box?
The Name Box is used to display the address (cell reference) of the active cell.
What information is displayed on the Formula Bar?
The Formula Bar displays the data or formula present in the active cell.
What are the different types of data that can be entered in an Excel worksheet?
The types of data that can be entered in an Excel 2013 worksheet are numbers, text and formulas.
How will you refer to a range of cells from A1 to G5?
We will write A1:G5 to refer to the range of cells from A1 to G5.
Fill in the blanks:
Spreadsheet is an application software that makes a computer work as a data analyzer.
Excel 2013 is a spreadsheet program that helps users in doing calculations and in analyzing data using formulas and tables.
The first spreadsheet program was Visicalc, which was released in 1979.
Excel 2013 is a part of the Microsoft Office 2013 package.
Quick Access Toolbar is meant to give users quick access to commands that are used frequently.
The Title Bar displays the name of the workbook.
The ribbon contains commands required to perform various tasks in an Excel workbook.
The small arrow at the bottom-right corner of some groups in the ribbon is called a dialog box launcher.
The scroll bars appear only if you have data more than the screen can display at a time.
The two scroll bars are vertical bar and horizontal bar.
The status bar is present at the bottom of the window.
By default, a worksheet opens in Normal view.
The Page Layout View divides a worksheet into printable pages.
The Page Break View gives you an overview of a worksheet with page breaks.
The Zoom Control lets you increase or decrease the zoom level.
By default, Excel 2013 shows only one worksheet, named Sheet1.
You can click the plus sign to add more worksheets.
An Excel 2013 worksheet has 16,384 columns.
To name a worksheet, double-click its tab.
A cell is formed at the intersection of a row and a column.
A range of cells is referenced using colon (:) between two cell addresses.
The × button is called the Cancel button which is used to cancel the data entry.
The button is called the Enter button.
The fx button is the Insert Function button.
To move to the cell that is to the right of the active cell, press the Tab key.
To overwrite cell contents, just select the cell and type the new content.
The shortcut key for partial modification of cell contents is F2.
The shortcut key to undo an action is Ctrl + Z or Alt + Backspace.
If an action cannot be repeated, the repeat command changes to Can’t Repeat.
Answer the following:
What is an active workbook?
An active workbook is one that accepts entries and commands.
What is an active cell?
An active cell is the cell that receives the data and responds to the command entered.
What are the two ways of entering data in Excel 2013?
Following are the two ways of entering data in Excel 2013:
a. By overwriting the previous data, thus changing the content completely.
b. By modifying the previous data only partially.
What is the use of the Undo command?
The Undo command is used to reverse the last action performed on the worksheet.
What is the use of the Redo or Repeat command?
The Redo or Repeat command is used to reverse the undo action.
What is a cell pointer?
A cell pointer is the highlighted cell boundary specifying the active cell at that moment.
State whether True or False:
Each cell has a unique address or reference. (TRUE)
A highlighted cell boundary shows that the cell is active. (TRUE)
Only one cell can be active at any given time. (TRUE)
A formula starts with an ‘equal to’ sign. (TRUE)
Clicking on the FILE tab opens up the Backstage View. (TRUE)
You click the Save As option if you want to save the file with a new name. (TRUE)
When you save a file for the first time, Save and Save As commands behave alike. (TRUE)
Some actions like Delete Sheet and saving a file cannot be undone. (TRUE)
To refer to the cell in column F and row 1: F1
The range of cells in column D and rows 1 through 20: D1:D20
The range of cells in row 5 and columns B through F: B5:F5
All cells in row 12: 12:12
All cells in rows 2 through 5: 2:5
All cells in column C: C:C
All cells in columns D through F: D:F
The range of cells in columns A through D and rows 5 through 10: A5:D10