BUS 1350 Exam 1 Questions with Correct Answers 100% Verified by Experts| 2025/2026
Latest Update
Ribbon on the top of the workbook
Files, Home, Insert, Page Layout, Formulas...
Tabs and Contextual Tabs contain commands specific to whatever object you are currently
working on
Dialog Box Launcher 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 Control C
Shortcut to select all objects in a range Control A
Shortcut to Paste Control V
Shortcut to Cut Control X
Shortcut to save Control S
Shortcut to Print Control P
Shortcut to undo Control Z
Shortcut to open Excel Help Window F1
,Shortcut to open the Go To Dialog Box F5
Shortcut to Edit a Cell F2
SUM Function Alt =
Excel is a Workbook
Excel contains multiple Worksheets
Cell intersection of a row and a column
each cell has its own name or cell address
how to know when you are on an active cell it is highlighted or outlines
it is the insertion point
Which ribbon contains the Function Library Formula Ribbon
Formula Bar shows you contents of cell before the calculation was made
Name Box reflects current location and can take you to a symbol
Range 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 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 right click it and click rename
Worksheet views 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 text
values (constant)
formulas (functions)
text aligns on which side of the cell the left
4 ways to edit a cell 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 the cell will cut off the word if it overlaps the space provided
3 ways to widen a column move mouse pointer onto dividing line between columns and
drag
double click dividing line for auto-fit
right click column and specify column width
Latest Update
Ribbon on the top of the workbook
Files, Home, Insert, Page Layout, Formulas...
Tabs and Contextual Tabs contain commands specific to whatever object you are currently
working on
Dialog Box Launcher 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 Control C
Shortcut to select all objects in a range Control A
Shortcut to Paste Control V
Shortcut to Cut Control X
Shortcut to save Control S
Shortcut to Print Control P
Shortcut to undo Control Z
Shortcut to open Excel Help Window F1
,Shortcut to open the Go To Dialog Box F5
Shortcut to Edit a Cell F2
SUM Function Alt =
Excel is a Workbook
Excel contains multiple Worksheets
Cell intersection of a row and a column
each cell has its own name or cell address
how to know when you are on an active cell it is highlighted or outlines
it is the insertion point
Which ribbon contains the Function Library Formula Ribbon
Formula Bar shows you contents of cell before the calculation was made
Name Box reflects current location and can take you to a symbol
Range 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 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 right click it and click rename
Worksheet views 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 text
values (constant)
formulas (functions)
text aligns on which side of the cell the left
4 ways to edit a cell 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 the cell will cut off the word if it overlaps the space provided
3 ways to widen a column move mouse pointer onto dividing line between columns and
drag
double click dividing line for auto-fit
right click column and specify column width
