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