NEW
Font size
WorksheetsMS - EXCEL
Total questions: 30
Worksheet time: 10mins
Excel file is saved as a ____________
Document
workbook
worksheets
Presentation
What is a sheet in Excel?
A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.
A single document that typically contains labels, values, formulas, functions, and graphical representations of data.
A single file that typically contains labels, values, formulas, functions, and graphical representations of data.
Name of the workbook is displayed in the ___________
Menu bar
Title bar or ribbon
Tool bar
option bar
The name box or the address bar contains
Formulas
menu options
Cell address
Numbers
Letters in Excel represent
rows
data
columns
functions
Numbers in the worksheet represent
data
columns
rows
functions
Define Cell?
The dark bordered box in excel.
A box in Excel that has formulas.
The intersection of a column or row in a worksheet or table.
Fx Bar where you input data
1. What is the "Active Cell" in Excel?
The Bottom cell in a worksheet. It is indicated by a dark border onscreen
The current cell in a worksheet. It is indicated by a dark border onscreen.
The top cell in a worksheet. It is indicated by a dark border onscreen
The past cell in a worksheet. It is indicated by a dark border onscreen
When starting a formula what is the first thing you type in the cell?
&
=
%
+
The intersection of a row and a column is called this.
Active Cell
Chart
Column
Row
Which is NOT a term used in Excel?
Workbook
Worksheet
Cell
Document
Microsoft Excel is categorized as a ________________ software.
Database
Spreadsheet
Presentation
Word Processing
The bar where information appears as you input data is called ______________.
file bar
help bar
window bar
formula bar
The first cell in a worksheet is what?
A1
1A
FX
Cell Name
The option that reduces the font size of the data to accommodate it within the column width
Shrink to fit
Columns
Text orientation
Wrap text
The option which accommodates the text in a column by using multiple lines
Text orientation
Wrap text
Merge cells
None of these
To apply formatting on cells, select the option "Cells" from _________ menu
Edit
Format
Home
Allignment
Numbers in excel is automatically aligned to the
Left
Right
Centre
Justified
Cells that run horizontally on a spreadsheet are know as
Row
Column
Workbook
Range
Vertical arrangement of cells is known as
Range
Cell
Row
Column
Area within the red box is called
Active cell
Fill handle
Cell
Row
Name the cell address selected in the picture
C3
B2
B:3
B3
Which key should be used to move to the left of the cell
Tab key
Enter key
Shift+ Enter key
Shift+ Tab key
Which tool is used to change the text direction (subjects), like in the following example?
Page Orientation
Superscript
Picture - WordArt
Alignment
The Merge and Center icon will combine the contents of the selected cells into one larger cell.
True
False
