Font size
WorksheetsAutofit
Total questions: 15
Worksheet time: 9mins
When a label is too long to fit within a worksheet cell, you typically must
a. Shorten the label
b. Increase the column width
c. Decrease the column width
d. Adjust the row height
Cells are named using:
The Row Number and then the Column Letter, like 6B
The Column Letter and then the Row Number, like B6
Either format (B6 or 6B) is correct
The name of the selected cell in this image is:
B4
C4
4B
4C
Not enough information
Which of the following will not cut information?
a. Pressing Ctrl + C
b. Selecting Edit>Cut from the menu
c. Clicking the Cut button on the standard
d. Pressing Ctrl+X
Which of the following is not a term of MS-Excel?
A. Cells
B. Rows
C. Columns
D. Document
How do you change the width of a column so that the widest entry will fit?
A. SmartFit
B. AutoFit
C. BestFit
D. TrueFit
A method of adjusting column width where one cell of the column is resized just wide enough to hold the text in the cell you selected.
Autofit
Dialogue Box
Pattern
Border Tab
To create a table, click on the Table button on the ________________ tab in the tables group
File
Insert
Home
Design
_________________ a cell means dividing the selected cell into separate cells
Merging
Splitting
Selecting
What are lines that can be applied bold or thickened around worksheet cells or objects?
Gridlines
Borders
Underlines
Boundaries
Using the keyboard, you could navigate from one cell to another cell by using the ____ ____.
Shift Key
Arrow Keys
Piano Keys
Caps lock Key
To draw any chart on Microsoft Excel program, I will need to go to the __________ ribbon.
Home
Data
Insert
View
Which row in this spreadsheet has been merged?
Row 1
Row 2
Row 3
Row 4
What can a cell contain?
A column
A number, text, formula or function
A row
The cell address
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
