BUS 1350 EXAM 1 QUESTIONS &
VERIFIED ANSWERS RATED 100%
CORRECT
Ribbon - Correct Answer ✔✔ on the top of the workbook
Files, Home, Insert, Page Layout, Formulas...
Tabs and Contextual Tabs - Correct Answer ✔✔ contain commands specific to
whatever object you are currently working on
Dialog Box Launcher - Correct Answer ✔✔ A small arrow in the lower-right corner of the
group
this provides more options related to the group on the ribbon
Shortcut to copy - Correct Answer ✔✔ Control C
Shortcut to select all objects in a range - Correct Answer ✔✔ Control A
Shortcut to Paste - Correct Answer ✔✔ Control V
Shortcut to Cut - Correct Answer ✔✔ Control X
Shortcut to save - Correct Answer ✔✔ Control S
Shortcut to Print - Correct Answer ✔✔ Control P
Shortcut to undo - Correct Answer ✔✔ Control Z
Shortcut to open Excel Help Window - Correct Answer ✔✔ F1
Shortcut to open the Go To Dialog Box - Correct Answer ✔✔ F5
Shortcut to Edit a Cell - Correct Answer ✔✔ F2
SUM Function - Correct Answer ✔✔ Alt =
Excel is a - Correct Answer ✔✔ Workbook
Excel contains multiple - Correct Answer ✔✔ Worksheets
Cell - Correct Answer ✔✔ intersection of a row and a column
, each cell has its own name or - Correct Answer ✔✔ cell address
how to know when you are on an active cell - Correct Answer ✔✔ it is highlighted or
outlines
it is the insertion point
Which ribbon contains the Function Library - Correct Answer ✔✔ Formula Ribbon
Formula Bar - Correct Answer ✔✔ shows you contents of cell before the calculation
was made
Name Box - Correct Answer ✔✔ reflects current location and can take you to a symbol
Range - Correct Answer ✔✔ selecting a group of cells at one time
symbol is a colon (E5:E10)
you can make a range using the name box and name it to make it easier to access
Fill handle - Correct Answer ✔✔ The small black square in the lower right corner of a
selected cell
it allows you to fill the formula or number in the active cell either up, down, to the left, or
to the right
To rename a worksheet - Correct Answer ✔✔ right click it and click rename
Worksheet views - Correct Answer ✔✔ Normal, Page Layout, Page Break and Custom
View
all found in the bottom right of the workbook
different values that can go into a cell - Correct Answer ✔✔ text
values (constant)
formulas (functions)
text aligns on which side of the cell - Correct Answer ✔✔ the left
4 ways to edit a cell - Correct Answer ✔✔ make it an active cell and type over old text
edit in formula bar
double click cell to move the insertion point into the text
use F2 function key to edit
Truncated Text - Correct Answer ✔✔ the cell will cut off the word if it overlaps the space
provided
3 ways to widen a column - Correct Answer ✔✔ move mouse pointer onto dividing line
between columns and drag
double click dividing line for auto-fit
right click column and specify column width
VERIFIED ANSWERS RATED 100%
CORRECT
Ribbon - Correct Answer ✔✔ on the top of the workbook
Files, Home, Insert, Page Layout, Formulas...
Tabs and Contextual Tabs - Correct Answer ✔✔ contain commands specific to
whatever object you are currently working on
Dialog Box Launcher - Correct Answer ✔✔ A small arrow in the lower-right corner of the
group
this provides more options related to the group on the ribbon
Shortcut to copy - Correct Answer ✔✔ Control C
Shortcut to select all objects in a range - Correct Answer ✔✔ Control A
Shortcut to Paste - Correct Answer ✔✔ Control V
Shortcut to Cut - Correct Answer ✔✔ Control X
Shortcut to save - Correct Answer ✔✔ Control S
Shortcut to Print - Correct Answer ✔✔ Control P
Shortcut to undo - Correct Answer ✔✔ Control Z
Shortcut to open Excel Help Window - Correct Answer ✔✔ F1
Shortcut to open the Go To Dialog Box - Correct Answer ✔✔ F5
Shortcut to Edit a Cell - Correct Answer ✔✔ F2
SUM Function - Correct Answer ✔✔ Alt =
Excel is a - Correct Answer ✔✔ Workbook
Excel contains multiple - Correct Answer ✔✔ Worksheets
Cell - Correct Answer ✔✔ intersection of a row and a column
, each cell has its own name or - Correct Answer ✔✔ cell address
how to know when you are on an active cell - Correct Answer ✔✔ it is highlighted or
outlines
it is the insertion point
Which ribbon contains the Function Library - Correct Answer ✔✔ Formula Ribbon
Formula Bar - Correct Answer ✔✔ shows you contents of cell before the calculation
was made
Name Box - Correct Answer ✔✔ reflects current location and can take you to a symbol
Range - Correct Answer ✔✔ selecting a group of cells at one time
symbol is a colon (E5:E10)
you can make a range using the name box and name it to make it easier to access
Fill handle - Correct Answer ✔✔ The small black square in the lower right corner of a
selected cell
it allows you to fill the formula or number in the active cell either up, down, to the left, or
to the right
To rename a worksheet - Correct Answer ✔✔ right click it and click rename
Worksheet views - Correct Answer ✔✔ Normal, Page Layout, Page Break and Custom
View
all found in the bottom right of the workbook
different values that can go into a cell - Correct Answer ✔✔ text
values (constant)
formulas (functions)
text aligns on which side of the cell - Correct Answer ✔✔ the left
4 ways to edit a cell - Correct Answer ✔✔ make it an active cell and type over old text
edit in formula bar
double click cell to move the insertion point into the text
use F2 function key to edit
Truncated Text - Correct Answer ✔✔ the cell will cut off the word if it overlaps the space
provided
3 ways to widen a column - Correct Answer ✔✔ move mouse pointer onto dividing line
between columns and drag
double click dividing line for auto-fit
right click column and specify column width
