Have an account?
Skip to Content
Introducing new Paper mode
No student devices needed. Know more
20 questions
Show Answers
See Preview
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
Every formula starts with what?
=
+
-
( )
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
Where are the two places to find the autosum feature?
Home ribbon
Insert ribbon
Function ribbon
Formulas ribbon
- Multiple ChoicePlease save your changes before editing any questions.
To exit an active formula, you always click out of the current cell?
True
False
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
If you change the value in a cell then the associated graph will NOT change.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
Select all of the following that are available under the Autosum button:
sum
minimum
average
maximum
division
- Multiple ChoicePlease save your changes before editing any questions.
What are the two (2) ways to display a spreadsheet in Microsoft Excel?
fixed
value
variable
formula
- Multiple ChoicePlease save your changes before editing any questions.
If you center or merge and center it does exactly the same thing.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
What is the difference in the following numbers: 1/3, .33, 33%
the value
the format
the function
- Multiple ChoicePlease save your changes before editing any questions.
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
- Multiple ChoicePlease save your changes before editing any questions.
Which page orientation makes the sides longer than the top and bottom?
landscape
portrait
fixed
variable
- Multiple ChoicePlease save your changes before editing any questions.
Margins are the white space on the spreadsheet where nothing prints.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
If you selected (A1:B5) what is this called?
row
column
cell range
cell grouping
- Multiple ChoicePlease save your changes before editing any questions.
To arrange data in alphabetical or numerical order is what?
coding
sorting
graphing
grouping