WorksheetsExcel Test Review
Total questions: 20
Worksheet time: 7mins
In Excel, how do you fix the cell when these ######## appear?
Delete the cell
Widen the column
Make the row taller
Add an extra column
What is the title of the blank workbook that opens when you first start Excel from the Windows Start menu?
Workbook1
Books1
Excel1
The number of worksheets that a workbook can contain ________.
Depends on your computer memory
Is selected by you
Predetermined when you open the file
Depends on the information you are entering in the worksheet
The intersection of each column and row is called a (a) .
When a cell entry is positioned at the far left in the cell, it is considered ________.
Wrap text
Right Aligned
Centered
In Excel, is there a way to find an average of numbers in a column?
No
Yes
Only when you show formulas
When the worksheet is opened for more than 5 minutes
A (a) is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
Saving the workbook frequently is important for the following reason:
So your teacher will be happy
To make sure your answers are correct
In case the power on the computer goes out
If your keyboard goes missing
A file name can have a maximum of 255 characters, including spaces. You can use any character to create a file name?
False
True
Changing the font type, changing the font style to bold, increasing the font size, and changing the font color is called ________.
adjusting
coloring and sizing
formatting
all of the above
Combining two or more cells together is called ________ cells.
merging
mixing
combining
spanning
Dividing a cell into more than one cell is called ________.
splitting
merging
dividing
uncoupling
What effect does the Comma Style format have on the selected cells?
Converts decimals to commas within a cell
Converts decimals to commas within merged cells
Causes the cells to display with two decimal places and commas as thousands separators
Allows for substitution of selected characters
A(n) ________ chart is drawn on the same worksheet as the data.
embedded
sketch
author-signature
all-outline
Which keyboard keys move the insertion point to the last row of the worksheet?
Ctrl + right arrow
A and C
Ctrl + down arrow
Home + end key
What tab do you use if you want to show the formulas in the worksheet?
Home
Formulas
Format
Page Layout
What feature do you use to make the spreadsheet fit on one page?
Scale to fit
Portrait orientation
Landscape orientation
Print Preview
Under what tab is horizontal and vertical centering located?
Home, page layout, centering
Page layout, page set up, margins
Format, margins, centering
View, page, centering
How do you insert a chart on a new sheet?
Copy and paste
Right Click and move
Add/move chart sheet
Spreadsheet relocate chart
What formula do you use to find the smallest number in a column?
(a)
![REVISION 4 : TOPIC 9 [ACCOUNTING FOR NON-CURRENT ASSETS]](https://cf.quizizz.com/image/image-loader.svg)
