Font size
WorksheetsQ4 Final ICT-05 General Quiz
Total questions: 75
Worksheet time: 34mins
What is the intersection of a column and a row on a worksheet called ?
Column
Value
Address
Cell
In Excel, Columns are labelled as ___
A, B, C, etc
1,2,3 etc
A1, A2, etc.
$A$1, $A$2, etc.
In Excel, Rows are labelled as ______
A, B, C, etc
1,2,3 etc
A1, A2, etc.
D.$A$1, $A$2, etc.
An Excel file is generally called a / an
Spreadsheet
Worksheet
Workbook
Sheet
After we save a excel file, what will be it's extension?
.doc
.txt
.pptx
.xlsx
What is the temporary & default name of a WORKSHEET that opens up when we start excel?
Text1
Book1
Sheet1
Doc1
The name of a cell is given by the ___________.
Letter + Number
Number + Letter
Letter only
Number only
Which sign is the icon for Microsoft Excel?
Who can use Microsoft Excel?
Teachers
Students
Parents
Anyone
None of the above
in which tab you could see save, save as, print, etc.
File
home
Design
Insert
True or False:
You can use Microsoft Excel to listen to Music.
True
False
What is a Cell?
Where a column and row intersect or meet
A block
The column
Plant Cell
What is the cell reference for the active cell?
A2
E2
B9
D5
What is the cell reference for the active cell?
A1
B8
C8
B10
An Excel file is generally called a .......................................... .
workbook
document
presentation
Columns in a spreadsheet are:
Vertical
Horizontal
right side
Microsoft Excel is what type of software?
Word Processing
Spreadsheet
Presentation
Drawing
The part of the excel screen that displays the cell address of the active cell.
formula bar
title bar
name box
The part of the excel screen that is used for entering and editing data and formulas.
formula bar
view buttons
sizing buttons
The part of the screen that contains the worksheet, cell pointer, and sheet tab bar.
sizing buttons
worksheet area
zoom slider
It is used for adjusting the magnification of the current view.
zoom slider
name box
ribbon
A customizable toolbar that contains a set of buttons that are frequently used like SAVE, UNDO and REDO.
zoom slider
name box
quick access toolbar
The bar that sits on the top of the window and displays the filename of the workbook.
title bar
scroll bar
menu bar
The set of buttons that are used to change the size of the window, hide the window, and close the window.
close button
sizing buttons
menu bar
A tabbed bar that contains all commands, controls, and options for creating, editing, and formatting a workbook.
zoom slider
ribbon
menu bar
Type True or False: A spreadsheet organizes data in a tabular format using rows and columns.
(a)
Type True or False: MS Excel is the least popular spreadsheet program available today.
(a)
Type True or False: An MS Excel file is known as a workbook.
(a)
Type True or False: The Quick Access Toolbar is not a part of the MS Excel window.
(a)
Type True or False: To open a new workbook, you can only double-click the icon on the desktop.
(a)
Type True or False: To save a workbook for the first time, you must select the Save option directly from the File tab.
(a)
Type True or False: The Backstage view opens when you choose the File tab on the Ribbon.
(a)
Type True or False: To open an existing workbook, you must go to the location of the workbook and select it.
(a)
Type True or False: You cannot save changes to existing workbooks by pressing Ctrl+S.
(a)
Type True or False: Exiting MS Excel is done by selecting the Close button on the leftmost side of the Title bar.
(a)
Type True or False: Worksheets are what make a workbook complete.
(a)
Type True or False: To add a worksheet, you select the minus sign (-) beside the Worksheet tab.
(a)
Type True or False: Renaming a worksheet involves right-clicking the sheet, choosing Rename, and typing the desired name.
(a)
Type True or False: To delete a worksheet, you can only use the Delete key on your keyboard.
(a)
Type True or False: Tab colors cannot be added to worksheets in MS Excel.
(a)
Type True or False: Cells are the intersection of a column and a row.
(a)
Type True or False: A cell's name consists of its row letter and its column number.
(a)
Type True or False: A group of cells is called a cell cluster.
(a)
Type True or False: To name a cell range, you put a semicolon (;) in between the cell names.
(a)
Type True or False: There are only two types of data: numerical data and text data.
(a)
Type True or False: Formulas and functions are not considered data in MS Excel.
(a)
Type True or False: Inserting data into a cell requires selecting any desired cell and pressing Enter.
(a)
Type True or False: After pressing Enter, the active cell does not move to the next cell below it.
(a)
Type True or False: A cell can contain either numerical data or formulas, but not both.
(a)
Type True or False: The Quick Access Toolbar provides quick access to common commands in MS Excel.
(a)
Type True or False: The Ribbon contains only formatting options in MS Excel.
(a)
Type True or False: The Name Box displays the name of the active worksheet in MS Excel.
(a)
Type True or False: You can only save a workbook by selecting the Save option from the Quick Access Toolbar.
(a)
Type True or False: To insert data into a cell, you can only use the mouse; keyboard input is not accepted.
(a)
Type True or False: MS Excel workbooks cannot contain multiple worksheets.
(a)
