Create a Spreadsheet in Microsoft Excel 2010

A. Fill in the blanks.

a) ———————— is a spreadsheet software used to store, organise, manipulate and analyses data.

b) ———————– is often referred to as ‘The Father of the Spreadsheet.’

c) The ——————— are labelled from left to right starting with A, B, ….. and so on.

d) The ———————- are numbered from top to bottom starting from 1, 2, 3 and so on.

e) Each worksheet consists of ——————————– rows and —————————————– columns.

f) Popular electronic spreadsheet software includes Lotus 1-2-3 and ———————————–.

g) A column may contain up to ————————- characters.

h) _______________________ is the bar that displays the contents in the current cell.

i) To undo a mistake or last action select ————————– option.

j) ————————– is the intersection of a column and a row.

k) ————————- is the work area arranged in horizontal rows and vertical columns.

l) ——————————–is a collection of one or more worksheets stored under a single filename.

m) ————————– is the arrangement of cells in the vertical direction.

Answer: a) Microsoft Excel b) Daniel Bricklin c) columns d) rows e) 1048576 , 16384. f) Quattro Pro. g) 32767 h) Formula Bar i) undo

j) cell k) worksheet l) Workbook m) Columns

B. Tick the correct answer.

a) What is the name of the last column?

i) XFD ii) XDF

b) You press these keys to move to the previous cell in the row.

i) Shift + Enter ii) Shift + Tab

c) You press these keys to move to select all cells on a worksheet.

i) Ctrl + A ii) Ctrl + C

d) It is the collection of one or more worksheets stored under a single filename.

i) Worksheet ii) Workbook

e) If we want to go to one screen left we press

i) Al t+ Page down ii) Ctrl + Page down

f) If you want to go to next cell in the row you need to press

i) Tab ii) Shift + Tab

Answer: a) XFD b) Shift + Tab c) Ctrl + A d) Workbook e) Alt + Page down f) Tab

C. State True of False.

a) Microsoft Excel is a presentation software.

b) Bob Frankston is often referred to as The Father of the Spreadsheet.

c) A column may contain up to 32,767 characters.

d) You can enter only numbers type of data in a worksheet.

e) You cannot rename a worksheet.

f) Microsoft Excel is a spreadsheet software.

g) You can reposition, add, rename, delete and switch between worksheets.

h) We press Alt + F4 to exit Microsoft Excel.

Answer: a) False b) False c) True d) False e) False f) True g) True h) True

D. Answer the following questions.

a) What is the purpose of Microsoft Excel as an application software?

Answer: Microsoft Excel is an application software that allows you to create, edit, and analyze data in spreadsheets and workbooks. You can use Excel to perform calculations, create charts and graphs, organize and sort data, and more. Excel is a powerful tool that can help you with various tasks, such as budgeting, invoicing, reporting, forecasting, data visualization, and more.

b) Explain how to write a cell address.

Answer: A cell address is a way of identifying a specific cell in a spreadsheet of Microsoft Excel. A cell address consists of a column letter and a row number, separated by a colon. For example, the cell address A1 refers to the cell in the first column and the first row of the spreadsheet. The cell address B5 refers to the cell in the second column and the fifth row of the spreadsheet.

c) Give examples of different data types you can enter in a worksheet. (Any three)

Answer: Text: This data type stores any kind of text, such as words, names, sentences, or symbols.

For example, you can enter “Hello”, “John Smith”, “3.14”, or “😊” as text in a worksheet.

Number: This data type stores numerical values, such as integers, decimals, fractions, percentages, or scientific notation.

For example, you can enter 10, 3.14, 1/2, 75%, or 1.23E+4 as numbers in a worksheet.

Logical: This data type stores boolean values, which are either TRUE or FALSE.

For example, you can enter TRUE or FALSE as logical values in a worksheet.

Error: This data type stores error values, which indicate that something is wrong with the data or the formula in a cell.

For example, you can see #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! as error values in a worksheet.

d) Differentiate between worksheet and workbook.

Answer: A worksheet and a workbook are two different concepts in Excel. A worksheet is a single page or sheet of a spreadsheet, where you can enter data, formulas, and charts. A workbook is a file that contains one or more worksheets, usually related to each other. You can think of a workbook as a book, and a worksheet as a page in that book.

Some differences between a worksheet and a workbook are:

1) A workbook can have multiple worksheets, but a worksheet can only belong to one workbook.

2) A workbook has a file name and extension, such as Book1.xlsx, but a worksheet has only a sheet name, such as Sheet1.

3) A workbook can be saved, opened, closed, or shared as a whole, but a worksheet can only be manipulated within the workbook.

4) A workbook can have different views, such as Normal, Page Layout, or Page Break Preview, but a worksheet can only have one view at a time.

5) A workbook can have different properties, such as author, title, or keywords, but a worksheet does not have any properties.

e) Write the steps to insert and rename a worksheet.

Answer: To insert a new worksheet, you can either select the New Sheet plus icon at the bottom of the workbook⁴, or select Home > Insert > Insert Sheet⁵.

• To rename a worksheet, you can either double-click the sheet name on the Sheet tab and type the new name⁴, or right-click on the *Sheet tab, click *Rename, and type the new name⁵.