stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Excel Test Review Flashcards | StudBud
Explore
/
Excel Test Review
Excel Test Review
20 terms
·
StudBud Administration
·
180 plays
#excel
Flashcards
20 cards
F
Practice quiz
P
Host live
L
Questions
20
Answers
1
What is the intersection of a column or row in a worksheet or table called?
Worksheet
Formula
Fork
Cell
2
In the following which mathematic function will happen first: =(B1+B2) / B4
Its too hard even for Excel
Multiplication then Division
Addition then Division
Division then Addition
3
What in Excel looks like a folder tab and displays the name of a worksheet
Function
Sheet Tab
Workbook
Active Cell
4
AutoFit changes the column width or row height for the tallest or longest entry in either.
False
That takes a tailor
True
5
Speed/Flash Fill enters text based on patterns it finds in the previous entry
False
True
6
_____ combines cells of rows and/or columns in the selected range
Merge Across
Merge Cells
Merge and Center
Merge Build
7
The formula bar is located where?
Down the street by Sheri's
On the Page Layout View
Below the ribbons & above the worksheet grid
In Document Properties
8
What is a single sheet within a workbook containing data called?
A Formula
The Page Layout
A Document
A Worksheet/Spreadsheet
9
If you are trying to total up a range of cells, what function would you use?
SUM
MAX
AVERAGE
MIN
10
AZ" is an example of a _____??
Row Heading
Cell Reference
Name Box
Column Heading
11
To go back to the A Column in the same row from anywhere in the spreadsheet press ______?
Ctrl+Home
Home
Shift-Tab
Enter
12
What must every formula begin with?
Multiplication
Function
Equal Sign
Comma
13
One of the Benefits of Live Preview is ______
to see and evaluate formats as you develop the worksheet
it makes all of the changes then saves it
it broadcasts your spreadsheet on the internet
it allows you to track changes in the document
14
When entered, Dates are ______ aligned in the cell not matter the format?
Center
Left
Top
Right
15
Formatting will change the appearance of the data; it does not effect the data itself.
False
True
16
In Excel, the characters
+
,
-
,
*
,
/
are generally found in _______?
the English Language
Pivot Tables
Conditional Formatting
Arithmetic Formulas
17
Italic, Bold, and Underline cannot be done using keyboard shortcuts.
You have to have a mouse
False
Character Settings
True
18
The small square at the bottom-right corner of a cell is known as?
Active Cell
Chart Title
Cell Range
Fill Handle
19
AutoFill and FlashFill perform the same function in Excel
False
True
20
Conditional format can only show a negative number as Red.
Only on Game Day
False
True
