stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Ms. Barnes Excel - lent Game!! Flashcards | StudBud
Explore
/
Ms. Barnes Excel - lent Game!!
Ms. Barnes Excel - lent Game!!
25 terms
·
StudBud Administration
·
214 plays
Excel review.
Flashcards
25 cards
F
Practice quiz
P
Host live
L
Questions
25
Answers
1
How are individual rows identified on a worksheet?
by numbers
by different colors
by letters
by bold borders
2
This function is used to merge a group of adjacent cells.
auto fill
merge & center
conditional formatting
spell check
3
Which symbol is inserted before a formula is entered into a cell?
/
;
=
:
4
The _____ feature enables you to create a series of entries down a column or across a row.
auto fill
templates
copy
clear
5
Change the ____ for a worksheet on the sheet tab to describe its contents.
theme
color
name
value
6
A double underline style is often used to indicate...
emphasis
a change in font size
a problem with the worksheet
a total in accounting statements
7
This function allows for more than one line of text within a cell.
auto abbreviate
wrap text
hitting the enter key
none of the above
8
A mathematical statement used to find a value is
a formula
an average
a function
a filter
9
What button selects the entire page?
Triangle in top left corner of the worksheet.
Page Layout
None of the above
View
10
Why would a cell display ####?
Column width not wide enough for the data.
Excel is unable to calculate the answer.
There is an error in the formula.
It's trying to send out a tweet.
11
If you want to alphabetize your data use
auto sum
conditional formatting
sort and filter
cell style
12
Which numeric formula has been applied to $12.50?
General
percentage
Number
Currency
13
What is an Excel file called?
a numerical analysis
workbook/worksheet
spreadsheet
a grid iron
14
What displays the cell reference of the active cell?
Mail box
P.O. Box
Name box
Layout
15
What is the order of operations that Excel will follow for calculations?
PEMDAS
EMDASP
MADSEP
DASMEP
16
A selection of 2 or more cells is called
a block
adjacent cells
a range
a pair
17
An active cell is displayed by
blinking dotted line
a fill handle
red font
a bold border
18
A cell reference contains
location
a letter and a number
a glowing recommendation
mathematical formula
19
What key allows you to select multiple items?
Esc
Alt
Shift
Ctrl
20
To change the height of a row
go to page layout
right click and select row height
click format and then row height
Both 1 and 2
21
What value would be calculated by Excel for =5+10/5?
7
5
3
10
22
A predefined set of colors, fonts and effects is called
page setup
design layout
a theme
format painter
23
The
fx
button on the ribbon includes
a selection of functions (max, min, avg...)
files recently used
none of the above
tools to fix errors
24
If you accidentally delete a row, column or data you should
ask Ms. Barnes for help
save your work
hit the undo button on the quick access toolbar
start over
25
Info stored in a worksheet
categorized as either label, value or date/time is called
numbers
Data
formatting
cell styles