WorksheetsMicrosoft Excel
Total questions: 17
Worksheet time: 9mins
To arrange data in alphabetical or numerical order is what?
coding
sorting
graphing
grouping
If you click on a letter at the top of an Excel spreadsheet, what have you done?
selected a cell
selected a range of cells
selected a row of data
selected a column of data
A four-sided arrow does what in Excel?
copies the contents of one cell to others around it
moves the contents of one cell to another location
selects the cell
If you center or merge and center it does exactly the same thing.
True
False
Margins are the white space on the spreadsheet where nothing prints.
True
False
If you see the following, what does it mean? ######
the formula has an error
the contents are too large to display
text was entered where numbers should be
If you change the value in a cell then the associated graph will NOT change.
True
False
What happens to a spreadsheet when you use the Ctrl~ command on a PC?
calculates the values in formulas
autofits the columns and rows
displays the formulas
nothing
Every formula starts with what?
=
+
-
( )
What tool allows you to capture the formatting in one location and easily format other cells the same way?
copy and paste
cut and paste
format painter
alignment tool
If the following was entered into a cell, what would appear in that cell? sum(A1:B3)
the sum of A1 through B3
sum(A1:B3)
nothing
What is the name of the bar above the worksheet that always shows the content of a cell as is denoted by the symbol fx?
cell bar
formula bar
status bar
name box
What is the difference in the following numbers: 1/3, .33, 33%
the value
the format
the function
Which page orientation makes the sides longer than the top and bottom?
landscape
portrait
fixed
variable
If you selected (A1:B5) what is this called?
row
column
cell range
cell grouping
If you click a number at the left of an Excel spreadsheet, what have you done?
selected a cell
selected a range of cells
selected a row of data
selected a column of data
To exit an active formula, you always click out of the current cell?
True
False
