stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Duplicate of Microsoft Excel Flashcards | StudBud
Explore
/
Duplicate of Microsoft Excel
Duplicate of Microsoft Excel
22 terms
·
StudBud Administration
·
18 plays
Basic skills in Microsoft Excel
Flashcards
22 cards
F
Practice quiz
P
Host live
L
Questions
22
Answers
1
When the cursor looks like this, actions can you take?
Select a row or column.
If you click and hold you can move the cell contents.
Select cells.
Change size of a row or column.
2
How can you view the page layout to easily change margins, add headers, page numbers?
Find the right ribbon tab at the top of the screen.
Minimize the window.
Wear glasses.
bottom right corner of the screen: Page Layout icon
3
Once you copy a cell dashes blink around the cell. How can you make that stop?
Sit and wait and sometimes it will stop by itself.
That never happens in Excel.
Esc (Escape key top left on keyboard)
Hit your computer.
4
What sign must you always have first when entering a formula?
@
#
&
=
5
What is a sparkline?
An indicator that there is a fault in your formula
A burst of electricity that blows up your computer
Tiny chart/graph in a single cell
animated blinking around a cell
6
When the cursor looks like this, what actions can you take?
Change size of a row or column.
If you click and hold you can move the cell contents.
Select cells.
Select a row or column.
7
When the cursor looks like this, what actions can you take?
Select cells.
If you click and hold you can move the cell contents.
Change size of a row or column.
Select a row or column.
8
What is the tiny green square at the bottom right of a selected cell for?
Fill handle: autofit the cell size
help
Fill handle: copies formulas or text
cell comments
9
What is the advantage of using cell references (like B3) instead of values?
If any cells change, it automatically updates
It makes you smarter
There is no advantage.
It prevents Excel from freezing
10
What is the section of the screen circled in red indicating?
The formula bar.
The cell name that is currently selected.
The place to rest your cursor when it feels tired.
The function tool.
11
In math, you would frequently call this picture a graph. What would it be called in Excel?
scale
flyer
chart
wingman
12
Which signs are used for multiplication and division?
+ -
&^
()
* /
13
What is the ribbon tab and group for changing the color choices for tables and charts?
Page Layout/Themes
View/Color Wheel
File/Info
Home/Fonts
14
What is the section of the screen circled in red indicating?
The cell name that is currently selected.
The place to rest your cursor when it feels tired.
The formula bar.
The function tool.
15
How is an Excel "workbook" different than an Excel "sheet"?
Sheets are the different pages in a workbook.
A workbook can contain multiple sheets.
The sheet is when it's printed.
Sheets are the tabs at the bottom of the workbook.
16
What are spreadsheets used for?
stories
posters
data
journals
17
What is the section of the screen circled in red indicating?
The cell name that is currently selected.
The place to rest your cursor when it feels tired.
The formula bar.
The insert function icon.
18
What is the section of the screen circled in red indicating?
Quick Access Toolbar
Select all
Cell Name
The insert function icon.
19
When the cursor looks like this, what actions can you take?
Change size of a row or column.
Select a row or column.
Select cells.
If you click and hold you can move the cell contents.
20
What ribbon tab would you select to add a chart or sparkline?
View
Data
Home
Insert
21
What is the section of the screen circled in red indicating?
Cell Name
Select all
The insert function icon.
Quick Access Toolbar
22
Why is the cell showing all the # signs?
You have too many digits in the cell.
You need to expand the row.
You need to expand the column.
It's referring to a social network.