stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Word and Excel Final Review Flashcards | StudBud
Explore
/
Word and Excel Final Review
Word and Excel Final Review
27 terms
·
StudBud Administration
·
42 plays
Review for Word and Excel for the Final Exam.
Flashcards
27 cards
F
Practice quiz
P
Host live
L
Questions
27
Answers
1
Excel - There is usually only one way to do most commands in Excel.
True
False
2
Excel - what is the default number of decimal places when you change a cell to a number format?
there is no default
1
0
2
3
A series of rows and columns with related data that is managed independently from other data is
a picture
a table
Only used in Word
unnecessary in Excel
4
Excel - C10 or E3 is an example of a location on a spreadsheet, also know as the
Range
Formula
Auto Fill
Cell Address
5
Which number format will add decimals, thousands separators, and dollar signs?
Number
Currency
Percentage
The default is dollar signs, comma, and 2 decimals
6
Hitting the tab key will move your cursor to the cell to the right.
True
False
7
Descending order means lowest to highest.
False
True
8
Landscape orientation will print your page....
With a picture of the sun
Wider than taller (higher)
Taller (higher) than wider
With a portrait of George Washington on it.
9
The process of arranging data in a specific order based on values in each field is called?
Average
Sorting
Maximum
Autofill
10
A mathematical function that contains cell address and mathematical operations is called a
equation
cell address
formula
function
11
Excel - When your cursor is a __________, you will be "auto-filling" cells.
a small black plus sign
a large white plus sign
an arrow
a capital "I"
12
Excel - holding down "Shift" and using your arrow keys will select cells.
False
True
13
Which of the choices is NOT a way to change the width of a column in Excel?
Home Tab, Alignment group, right align button
double click the right side of the column heading
Click and drag the right side of the column heading
Home Tab, Cells group, format button, column width, key in..
14
This indicates the data is longer than the width of the cell.
you can't read all the words
Questions marks
A series of hashtags, (aka number signs or pound signs)
The words wrap in the cell
15
Excel - Excel is a great way to keep track of how much money you spend each month.
True
False
16
A vertical group of cells (a row) in a worksheet is identified by on or more letters.
False
True
17
Excel - To add a list of numbers, you can type in a formula. What symbol starts all formulas?
a capital letter
a plus sign
an equal sign
a back slash
18
The Merge and Center command will either combine multiple cells OR center text.
True
False
19
Excel - You can not sort data once you type it in.
False
True
20
The title bar displays the name of the workbook.
False
True
21
The legend is a label that identifies the different data in a chart.
True
False
22
What is the line or box that frames a cell?
Footer
Border
Header
Sort
23
An Excel file can contain many sheets.
True
False
24
Excel - When your cursor is__________, you can select data for formatting.
an arrow
A small black plus sign
A large white plus sign
a capital "I"
25
To make one cell out of several highlighted cells and then center the content is
right aligned
text wrap
merge and center
cut and paste
26
Excel - this increases the size of a cell from right to left
row height
column width
right align
font size
27
The name of a cell (cell address) contains both the column and row reference.
True
False