BUS 1350 Exam 1 2025

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 BUS 1350 BUS 1350 BUS 1350 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 Wrap text - -forces the text to move down to the next line in the active cell rather than being truncated How to insert a line break - -alt enter Numbers align on which side of the cell - -the right How many digits converts to scientific notation - -over 15 digits BUS 1350 BUS 1350 If a value is too long for the width of the column, it will not spill over like the text does because you cannot truncate numbers, instead it converts to - -#### How to fix ### - -widen the column using one of the three ways described before How to build a formula - -type = then using point method click on the cells you want in the formula or simply type it Where is the argument of a formula - -between parenthesis What is the purpose of the fill handle - -faster way to copy in excel Instead of using the backspace key, what key should you use - -delete What is the difference between highlighting with a fat mouse pointer and filling with skinny mouse pointer - -filling with the skinny mouse pointer is a auto fill which will copy whatever is in the cell Using the fat mouse pointer will allow you to select cells How to display a number as text - -click on the cell, in the numbers group go to the drop down menu, click text The number will now start at the left of the cell How does excel handle dates - -when you type in a date, it immediately reformats it as a serial number from january 1st 1900 Change the number part on the home ribbon to general to see the number of days Dates align on which side of the cell - -the right How to merge cells - -select all cells you want to merge together then click merge and center in the alignment tab under the home ribbon How to hide a column or row - -right click on that column or row and click hide How to insert or delete rows and columns - -right click and click insert or delete What is autofill - -this is when you drag the skinny cross down to fill What is autofit - -a feature that automatically resizes text as it is typed so that it fits within a placeholder. What is autocomplete - -automatic filling of text For example if you have typed baylor multiple times, then when you type ba, "ylor" will automatically show up and you can simply click enter instead of having to type the whole word BUS 1350 BUS 1350 Where is the quick access toolbar - -top left corner to the right of the redo button It looks like a line on top of an arrow Count function - -counts the number of cells in a range that contain numbers Counta function - -counts the number of cells in a range that are not empty Countblank function - -counts the number of blank cell